Question 1

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

technology databases

SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC

Answer

Correct Option: C

Question 2

Which SQL keyword is used to sort the result-set?

technology databases

SORT
SORT BY
ORDER
ORDER BY

Answer

Correct Option: D

Question 3

Which SQL statement is used to return only different values?

technology databases

SELECT UNIQUE
SELECT DISTINCT
SELECT DIFFERENT
SELECT SAME

Answer

Correct Option: B

Question 4

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

technology databases

SELECT LastName>'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT * FROM Persons WHERE LastName IN 'Hansen' AND 'Pettersen'

Answer

Correct Option: C

Question 5

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

technology databases

SELECT FirstName='Peter', LastName='Jackson' FROM Persons
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT WHERE FirstName='Peter' AND LastName='Jackson' FROM Persons

Answer

Correct Option: B

Question 6

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

technology databases

True
False

Answer

Correct Option: A

Question 7

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

technology databases

SELECT * FROM Persons WHERE FirstName='%a%'
SELECT * FROM Persons WHERE FirstName='a_'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName LIKE '%a'

Answer

Correct Option: C

Question 8

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

technology databases

SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName<>'Peter'

Answer

Correct Option: A

Question 9

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

technology databases

SELECT *.Persons
SELECT Persons
SELECT * FROM Persons
SELECT [all] FROM Persons

Answer

Correct Option: C

Question 10

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

technology databases

SELECT Persons.FirstName
EXTRACT FirstName FROM Persons
SELECT FirstName FROM Persons
SELECT FROM FirstName IN Persons

Answer

Correct Option: C

Question 11

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

technology databases

ADD NEW
ADD RECORD
INSERT NEW
INSERT INTO

Answer

Correct Option: D

Question 12

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

technology databases

REMOVE
COLLAPSE
DELETE
REMOVE ALL

Answer

Correct Option: C

Question 13

Which SQL statement is used to update data in a database?

technology databases

UPDATE
MODIFY
SAVE AS
SAVE

Answer

Correct Option: A

Question 14

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

technology databases

FETCH
GET
SELECT
EXTRACT

Answer

Correct Option: C

Question 15

What does SQL stand for?

technology databases

Structured Question Language
Strong Question Language
Structured Query Language
Structured Query Limited

Answer

Correct Option: C

Question 16

More indexes on a table is always better for faster queries

technology databases

True
False

Answer

Correct Option: B

Question 17

Which of the below statement is worth creating an index

technology databases

The table is small
The columns are often used as a condition in the query
Most queries are expected to retrieve more than 2 to 4 percent of the rows in the table
The table is updated frequently

Answer

Correct Option: B

Question 18

A function-based index is an index based on expressions

technology databases

True
False

Answer

Correct Option: A

Question 19

If a table is dropped, which of the following statement is true.

technology databases

indexes and sequences are automatically dropped, but views and constraints remain
views and indexes are automatically dropped, but constraints and sequences remain
indexes and constraints are automatically dropped, but views and sequences remain
views and sequences are automatically dropped, but indexes and constraints remain

Answer

Correct Option: C

Question 20

To drop an index, we must be the owner of the index or have the ______ privilege.

technology databases

DROP ANY INDEX
DROP ALL INDEX
REMOVE ANY INDEX
REMOVE ALL INDEX

Answer

Correct Option: A

Description: You will be asked a question for SQL statement, Choose appropriate answer from the options.
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases sql

Identify the SQL Statements

Find more quizzes from top tags