You can add a row using SQL in a database with which of the following?
Select an option to see the answer and solution.
Database · all questionsIntroduction to SQL
Introduction to SQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
69
Questions
1/4
Page
Pick an option on a question to see the right answer and solution.
The command to remove rows from a table 'CUSTOMER' is:
Select an option to see the answer and solution.
The SQL WHERE clause:
Select an option to see the answer and solution.
Which of the following is the original purpose of SQL?
Select an option to see the answer and solution.
The wildcard in a WHERE clause is useful when?
Select an option to see the answer and solution.
A view is which of the following?
Select an option to see the answer and solution.
The command to eliminate a table from a database is:
Select an option to see the answer and solution.
ON UPDATE CASCADE ensures which of the following?
Select an option to see the answer and solution.
SQL data definition commands make up a(n) ________ .
Select an option to see the answer and solution.
Which of the following is valid SQL for an Index?
Select an option to see the answer and solution.
The SQL keyword(s) ________ is used with wildcards.
Select an option to see the answer and solution.
Which of the following is the correct order of keywords for SQL SELECT statements?
Select an option to see the answer and solution.
A subquery in an SQL SELECT statement is enclosed in:
Select an option to see the answer and solution.
The result of a SQL SELECT statement is a(n) ________ .
Select an option to see the answer and solution.
Which of the following are the five built-in functions provided by SQL?
Select an option to see the answer and solution.
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Select an option to see the answer and solution.
The HAVING clause does which of the following?
Select an option to see the answer and solution.
The SQL -92 wildcards are ____ and ____ .
Select an option to see the answer and solution.
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Select an option to see the answer and solution.
The benefits of a standard relational language include which of the following?
Select an option to see the answer and solution.