Identify the SQL Statements
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 |
To drop an index, we must be the owner of the index or have the ______ privilege.
If a table is dropped, which of the following statement is true.
A function-based index is an index based on expressions
Which of the below statement is worth creating an index
More indexes on a table is always better for faster queries
What does SQL stand for?
Which SQL statement is used to extract data from a database?
Which SQL statement is used to update data in a database?
Which SQL statement is used to delete data from a database?
Which SQL statement is used to insert new data in a database?
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
With SQL, how do you select all the columns from a table named "Persons"?
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
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
Which SQL statement is used to return only different values?
Which SQL keyword is used to sort the result-set?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?