Question 1

Which SQL statement is used to extract data from a database?

Accepted Answer

SELECT

Answer

EXTRACT

Answer

OPEN

Answer

GET

Question 2

Which SQL statement is used to insert new data in a database?

Accepted Answer

INSERT INTO

Answer

ADD NEW

Answer

ADD RECORD

Answer

INSERT NEW

Question 3

With SQL, how do you select all the columns from a table named "Quizzes"?

Accepted Answer

SELECT * FROM Quizzes

Answer

SELECT [all] FROM Quizzes

Answer

SELECT Quizzes

Answer

SELECT *.Quizzes

Question 4

With SQL, how do you select all the records from a table named "Employees" where the value of the column "LastName" is "Ali"?

Accepted Answer

SELECT * FROM Employees WHERE LastName='Ali'

Answer

SELECT * FROM Employees WHERE LastName<>'Ali'

Answer

SELECT [all] FROM Employees WHERE FirstName LIKE 'Ali'

Answer

SELECT [all] FROM Employees WHERE LastName='Ali'

Question 5

Which SQL statement is used to return only different values?

Accepted Answer

SELECT DISTINCT

Answer

SELECT UNIQUE

Answer

SELECT DIFFERENT

Question 6

With SQL, how can you return all the records from a table named "Orders" sorted descending by "Items"?

Accepted Answer

SELECT * FROM Orders ORDER BY Items DESC

Answer

SELECT * FROM Orders SORT 'Items' DESC

Answer

SELECT * FROM Orders ORDER Items DESC

Answer

SELECT * FROM Orders SORT BY 'Items' DESC

Sin título

Preguntas del test (6)