Related Questions

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A True
B False
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
A The multivalue, multicolumn problem
B The inconsistent values problem
C The missing values problem
D The general-purpose remarks column problem
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
A SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
B SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
C SELECT NAME IN CUSTOMER WHERE STATE = 'V';
D SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
The SQL statement that queries or reads data from a table is --
A SELECT
B READ
C QUERY
D None of the above
The result of a SQL SELECT statement is a __ .
A report
B form
C file
D table
To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.
A ONLY
B DISTINCT
C UNIQUE
D SINGLE
The SQL statement that queries or reads data from a table is____
A Select
B READ
C QUERY
D None of the above
When using the SQL INSERT statement:
A rows cannot be copied in mass from one table to another only.
B rows can be modified according to criteria only.
C rows can either be inserted into a table one at a time or in groups.
D rows can be inserted into a table only one at a time only.
SQL*Plus will finish the statement and execute it when the user types in this:
A A left slash ( ) followed by .
B A colon ( : ) followed by .
C A semicolon ( ; ) followed by .
D A period ( . ) followed by .

Next steps