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
What does SQL stand for?
Which SQL statement is used to update data in a database?
Which SQL statement is used to delete data from a database?
With SQL, how do you select all the columns from a table named "Persons"?
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?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?