SQL Quiz | Software Testing Material

The AND operator displays a record if all the conditions separated by AND are TRUE

Which SQL statement is used to remove rows from a table?

Which SQL statement is used to modify the existing records in a table?

Which of the following is not a Data Definition Language (DDL) statement?

The table rows are also known as

What is the keyword you use to group the result by a column's values?

The table columns are also known as

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

Which statement is correct

Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns

Which SQL statement is used to delete complete data from an existing table & table structure from the database?

Which type of database management system represents relations using tables?

Subqueries can be nested multiple times

Which of the following is not a RDBMS?

Which SQL statement is used to return only different values?

Which function returns the difference between two dates

A NULL value is different than a zero value or a field that contains spaces

Which of the following is not an SQL Aggregate function

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

What does SQL stand for?

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

Which SQL statement is used to insert new rows of data to a table in a database

The OR operator displays a record if any of the conditions separated by OR is TRUE

Which of the following is not a part of SQL

Which of the following keyword you use to modify the existing value in an UPDATE query?

The result of a SELECT statement can contain duplicate rows

Which SQL keyword you use to merge two tables based on a matching column?

The UNION operator is used to

The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column