CET_TARDE - MTA Database - E_COMANDS

Please wait - loading…

Question 1 of 43

Click on each orange point and select the correct answer.

You have the following table:

Explanation

Question 2 of 43

You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much time to return data. You need to improve the performance of
the query. Which item should you add to the Salary column?

Select one of the following:

Non-null constraint
Default constraint
Index
Foreign key

Explanation

Question 3 of 43

This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes,
triggers, constraints, and permission specifications for those tables.
Instructions: Review the underlined text. If it makes the statement correct, select “No
change is needed.” If the statement is incorrect, select the answer choice that makes the
statement correct:

Select one of the following:

No change is needed
DROP TABLE
TRUNCATE TABLE
ALTER TABLE

Explanation

Question 4 of 43

You have a table named Employee that includes four columns. You execute the following statement:
SELECT * FROM Employee
Which columns are returned?

Select one of the following:

all columns
only the last column
only the first column
only the first and last columns

Explanation

Question 5 of 43

Which keyword must be included in a create view statement?

Select one of the following:

WHERE
ORDER BY
UPDATE
SELECT

Explanation

Question 6 of 43

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*) FROM Product WHERE Quantity > 18

What is the value returned by this statement?

Select one of the following:

Explanation

Question 7 of 43

You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student’s first name in the table?

Select one of the following:

UPDATE
CHANGE
SELECT
INSERT

Explanation

Question 8 of 43

Which keyword would you use in a select statement to return rows that meet a specific condition?

Select one of the following:

WHERE
UNION
ORDER BY
FROM

Explanation

Question 9 of 43

You have the following table definition:
CREATE TABLE Product (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER)

The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

Select one of the following:

Explanation

Question 10 of 43

You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee,

Department This type of operation is called a/an:

Select one of the following:

Intersection
Outer join
Equi-join
Cartesian product

Explanation

Question 11 of 43

You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?

Select one of the following:

READ
SELECT
OUTPUT
GET

Explanation

Question 12 of 43

which command used to removes all rows from a table without logging the individual row deletions.

Select one of the following:

DROP TABLE
TRUNCATE TABLE
CREATE TABLE
ALTER TABLE

Explanation

Question 13 of 43

You need to delete a database table. Which data definition language (DDL) keyword should you use?

Select one of the following:

ALTER
DELETE
DROP
TRUNCATE

Explanation

Question 14 of 43

You need to rename a column in a database table. Which data definition language (DDL)
statement should you use?

Select one of the following:

ALTER
INSERT
CREATE
UPDATE

Explanation

Question 15 of 43

What are three valid data manipulation language (DML) commands? (Choose three.)

Select one or more of the following:

INSERT
COMMIT
DELETE
OUTPUT
UPDATE

Explanation

Question 16 of 43

You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?

Select one of the following:

READ
SELECT
OUTPUT
GET

Explanation

Question 17 of 43

17. You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)

The Road table contains the following data:

You execute the following statement:
INSERT INTO Road VALUES (1234, 36)

What is the result?

Select one of the following:

an error stating that NULL values are not allowed
a new row in the table
an error stating that duplicate IDs are not allowed
a syntax error

Explanation

Question 18 of 43

You need to enable a new employee to authenticate to your database. Which command should you use?

Select one of the following:

ALLOW USER
CREATE USER
ADD USER
INSERT USER
ALTER USER

Explanation

Question 19 of 43

This question requires that you evaluate the underlined text to determine if it is correct.
Create a query that returns a set of table data by using the UPDATE statement.
Instructions: Review the underlined text. If it makes the statement correct, select “No
change is needed.” If the statement is incorrect, select the answer choice that makes the
statement correct.

Select one of the following:

No change is needed
INSERT
REPLACE
SELECT

Explanation

Question 20 of 43

You accept an IT internship at a local charity. The charity asks you to keep a record of its
volunteers by using a database table named Volunteer. The table has the following
columns and rows:

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 21 of 43

You have a table that contains product IDs and product names. You need to write an
UPDATE statement to change the name of a specific product to glass. What should you
include in the update statement?

Select one of the following:

SET ProduetName = ‘glass’
LET ProduetName = ‘glass’
EXEC ProduetName = ‘glass’
ASSIGN ProduetName = ‘glass’

Explanation

Question 22 of 43

You have a table of products with fields for ProductID, Name, and Price. You need to write
an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?

Select one of the following:

THAT
WHERE
GROUP BY
HAVING

Explanation

Question 23 of 43

You need to list the name and price of each product, sorted by price from highest to lowest.
Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 24 of 43

You have a table named Customer. You need to add a new column named District. Which
statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 25 of 43

You need to remove a view named EmployeeView from your database. Which statement
should you use?

Select one of the following:

DELETE VIEW EmployeeView
DELETE EmployeeView
DROP EmployeeView
DROP VIEW EmployeeView

Explanation

Question 26 of 43

On which database structure does an update statement operate?

Select one of the following:

Table
User
Trigger
Role

Explanation

Question 27 of 43

You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 28 of 43

You execute the following statement:

SELECT DepartamentName
FROM Departament
WHERE DepartamentID =
(SELECT DepartamentID
FROM Employee
WHERE EmployeeID = 1234

This statement is an example of a/an:

Select one of the following:

Subquery
Union
Outer join
Cartesian product

Explanation

Question 29 of 43

Which command should you use to add a column to an existing table?

Select one of the following:

MODIFY
ALTER
UPDATE
INSERT
CHANGE

Explanation

Question 30 of 43

Which keyword can be used in a create table statement?

Select one of the following:

ORDER BY
DISTINCT
GROUP BY
UNIQUE

Explanation

Question 31 of 43

Which statement creates a composite key?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 32 of 43

You are creating a database object named Student to store the following data:

Which syntax should you use to create the object?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 33 of 43

You have a database table named SongInformation as defined below:

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 34 of 43

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer. When volunteers ask to be removed from mailing lists, the table must be updated. You need to use a transaction to ensure that the database has data integrity and referential integrity. Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 35 of 43

You have a database table that contains the following columns:

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

Select one or more of the following:

Option A
Option B
Option C
Option D

Explanation

Question 36 of 43

You have the database table named Cars as defined below:

How many rows are returned by the SQL statement?

Select one of the following:

Explanation

Question 37 of 43

Your database contains a table named Customer. You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 38 of 43

You have the following table definition:
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))

You need to insert a new product. The product’s name is Plate and the product’s ID is 12345. Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 39 of 43

Which statement deletes the rows where the employee’s phone number is not entered?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 40 of 43

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126. Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D
Option E

Explanation

Question 41 of 43

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement:
INSERT INTO Product VALUES (3296, ‘Table’, 4444)

What is the result?

Select one of the following:

a foreign key constraint violation
a syntax error
a new row in the Product table
a primary key constraint violation
a new row in the Category table

Explanation

Question 42 of 43

You have a table named Employee that includes the following columns:
EmployeeID
Smp1oyeeName
Which statement should you use to return the number of rows in the table?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Question 43 of 43

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to 43.
Which statement should you use?

Select one of the following:

Option A
Option B
Option C
Option D

Explanation

Check answer

["https://examtimeassets.s3.amazonaws.com/uploads/media/image/10634162/desktop_5e8fe9c3-209f-4bb6-afd4-7079c7d8fb14.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639149/desktop_860028c5-4066-4f18-91a7-5bd1759d418a.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639183/desktop_7822c5a1-dcba-402f-9556-d99643a973f6.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639290/desktop_6aadbe39-df4d-41b5-bc8b-9f706033f672.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639335/desktop_b27fea9a-f71d-490c-8e1c-7326e1ec27d8.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639390/desktop_6c0e1d1b-a17b-41bb-9aa1-f17020bfac03.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639472/desktop_ee3ce5a6-474d-42ee-ac56-69afb032049e.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639509/desktop_fa62603f-9e5d-47fe-a59b-8f44b47dd0c3.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639588/desktop_665b584f-79c8-4570-bdaa-9c2496ab2d15.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639610/desktop_4c1a2fa8-b02f-4434-9ef9-bd43dd9597fd.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639638/desktop_f0ea1039-5592-48fe-aabd-f3956c5d647a.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639657/desktop_ae3226bd-2c89-40bd-836c-5701b8b8faed.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639671/desktop_6acf49cf-ee20-421a-b294-5efa047e8da6.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639701/desktop_192264af-fd4a-4198-b505-02ef2a9fff25.JPG","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639722/desktop_cf9d16dd-5957-4572-8f24-36b655f93c29.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639744/desktop_c5f6da34-66a6-4f72-8583-6b768963fd9c.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639791/desktop_6106ac0d-3502-44cb-ad1a-6b05b488a020.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639841/desktop_9725d326-32ec-4b6f-83f8-5673cfd96527.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639862/desktop_e5222b8b-5a2a-4fad-a8c5-36d85d4e8932.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639901/desktop_191ce213-f608-47a7-aff6-fc7eadad7a54.jpg","https://examtimeassets.s3.amazonaws.com/uploads/media/image/10639915/desktop_8efbd363-00f2-4606-ba0e-7ea4c6c76383.jpg"]

	Created by Hawerth Castro about 9 years ago

Database Quizzes preparing to certification

CET_TARDE - MTA Database - E_COMANDS

Question 1 of 43

Click on each orange point and select the correct answer.

You have the following table:

Explanation

Question 2 of 43

You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the performance of the query. Which item should you add to the Salary column?

Select one of the following:

Explanation

Question 3 of 43

Select one of the following:

Explanation

Question 4 of 43

You have a table named Employee that includes four columns. You execute the following statement: SELECT * FROM Employee Which columns are returned?

Select one of the following:

Explanation

Question 5 of 43

Which keyword must be included in a create view statement?

Select one of the following:

Explanation

Question 6 of 43

The Product table contains the following data. You execute the following statement: SELECT COUNT(*) FROM Product WHERE Quantity > 18 What is the value returned by this statement?

Select one of the following:

Explanation

Question 7 of 43

You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student’s first name in the table?

Select one of the following:

Explanation

Question 8 of 43

Which keyword would you use in a select statement to return rows that meet a specific condition?

Select one of the following:

Explanation

Question 9 of 43

You have the following table definition: CREATE TABLE Product (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER) The Product table contains the following data. You execute the following statement: SELECT Name FROM Product WHERE Quantity IS NOT NULL How many rows are returned?

Select one of the following:

Explanation

Question 10 of 43

You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department This type of operation is called a/an:

Select one of the following:

Explanation

Question 11 of 43

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

Select one of the following:

Explanation

Question 12 of 43

which command used to removes all rows from a table without logging the individual row deletions.

Select one of the following:

Explanation

Question 13 of 43

You need to delete a database table. Which data definition language (DDL) keyword should you use?

Select one of the following:

Explanation

Question 14 of 43

You need to rename a column in a database table. Which data definition language (DDL) statement should you use?

Select one of the following:

Explanation

Question 15 of 43

What are three valid data manipulation language (DML) commands? (Choose three.)

Select one or more of the following:

Explanation

Question 16 of 43

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

Select one of the following:

Explanation

Question 17 of 43

17. You have the following table definition: CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL) The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36) What is the result?

Select one of the following:

Explanation

Question 18 of 43

You need to enable a new employee to authenticate to your database. Which command should you use?

Select one of the following:

Explanation

Question 19 of 43

Select one of the following:

Explanation

Question 20 of 43

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer. The table has the following columns and rows:

Select one of the following:

Explanation

You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much time to return data. You need to improve the performance of
the query. Which item should you add to the Salary column?

You have a table named Employee that includes four columns. You execute the following statement:
SELECT * FROM Employee
Which columns are returned?

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*) FROM Product WHERE Quantity > 18

What is the value returned by this statement?

You have the following table definition:
CREATE TABLE Product (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER)

The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee,

Department This type of operation is called a/an:

You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?

You need to rename a column in a database table. Which data definition language (DDL)
statement should you use?

You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?

17. You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)

The Road table contains the following data:

You execute the following statement:
INSERT INTO Road VALUES (1234, 36)

What is the result?

You accept an IT internship at a local charity. The charity asks you to keep a record of its
volunteers by using a database table named Volunteer. The table has the following
columns and rows:

You have a table that contains product IDs and product names. You need to write an
UPDATE statement to change the name of a specific product to glass. What should you
include in the update statement?

You have a table of products with fields for ProductID, Name, and Price. You need to write
an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?

You need to list the name and price of each product, sorted by price from highest to lowest.
Which statement should you use?

You have a table named Customer. You need to add a new column named District. Which
statement should you use?

You need to remove a view named EmployeeView from your database. Which statement
should you use?

You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?

You execute the following statement:

SELECT DepartamentName
FROM Departament
WHERE DepartamentID =
(SELECT DepartamentID
FROM Employee
WHERE EmployeeID = 1234

This statement is an example of a/an:

You are creating a database object named Student to store the following data:

Which syntax should you use to create the object?

You have a database table that contains the following columns:

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

You have the database table named Cars as defined below:

How many rows are returned by the SQL statement?

Your database contains a table named Customer. You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?