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"?
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 "FirstName" is "Peter" and the "LastName" is "Jackson"?
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"?
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"?
With SQL, how can you insert a new record into the "Persons" table?
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
With SQL, how can you return the number of records in the "Persons" table?
What is the most common type of join?
Which operator is used to select values within a range?
The NOT NULL constraint enforces a column to not accept null values.
Which operator is used to search for a specified pattern in a column?
Which SQL statement is used to create a table in a database?
Pick out Which is not the type of SQL statement?
Among the below commands, Which is not DDL command?
Among the below commands, Which is DDL command?
What is the meaning of DDL in SQL?
What is the meaning of DML in SQL?
What is the meaning of DCL in SQL?
Among the below commands, Which is DML command?
Among the below commands, Which is not DML command?
What is the meaning of TCS in SQL?
Among the below commands, Which is TCS command?
Among the below commands, Which is not TCS command?
What is the meaning of SCS in SQL?
Among the below commands, Which is the SCS command?
Among the below commands, Which is not SCS command?
What is the use of Data manipulation Language(DML) in SQL?
What is the use of Data Definition Language(DDL) in SQL?
What is the use of Data Control Language(DCL) in SQL?
What is the use of the Transaction Control Statement(TCS) in SQL?
What is the use of Session Control Statement(SCS) in SQL?
Which is not the properties of a transaction in SQL?
What are the properties of a transaction in SQL?
What is the use of Full Join in SQL?
What is the use of Cross Join in SQL?
What is a View in SQL?
What is a trigger in SQL?
Which is not an event to fire trigger in SQL?