DBMS - SQL MCQ

Database

Title
To define what columns should be displayed in an SQL SELECT statement:
SQL can be used to:
The SQL statement that queries or reads data from a table is ________
The SQL keyword BETWEEN is used:
A subquery in an SQL SELECT statement:
________ was adopted as a national standard by ANSI in 1992
SQL is
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Which of the following SQL statements are helpful in database redesign?
What SQL command can be used to delete columns from a table?
Which SQL-92 standard SQL command can be used to change a table name?
How can you find rows that do not match some specified condition?
A regular subquery can be processed:
What SQL command can be used to add columns to a table?
The EXISTS keyword will be true if:
Changing cardinalities in a database is:
The NOT EXISTS keyword will be true if:
To drop a column that is used as a foreign key, first:
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Which is not true of a correlated subquery?

Questions

Views

Best Answers

Points