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 |
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
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 all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
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"?
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
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"?