Based upon the contents of the BOOKS table, which of the following columns will be displayed with a right-aligned column heading?
Contents of the BOOKS table
A(n) ____ has a predefined meaning in Oracle11g
If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols?
Which of the following types of columns will automatically left-align the column heading when it is displayed?
d. Both a and c
d. Both a and c
Which of the following keywords can be used to indicate that a column alias should be included in the results?
d. none of the above
A string literal must be enclosed in ____.
single quotation marks (' ')
To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause
Which of the following commands is used to issue a query?
Combining the contents of two or more columns is known as ____.
What is the Command to view all the columns of a table?
What is the command to view one column of a table?
What is the command to view multiple columns of a table?
What is the command to asign an alias to a column during display?
SELECT coulnmnname AS alias
SELECT title titles
What is the command to eliminate duplication in ouput?
SELECT DISTINCT columname
SELECT UNIQUE columname
What is the command to perform concatenation of column contents during display?
SELECT columnname || columnname
What is the command to view the structure of a table?
________ clause identify the columns for etrieval in a SELECT command.
_______ clause indentify the table containing selected columns.
_____ preserve spaces, symbols, or letter case in an output column alias.
____ combine display of content from multiple columns into a single column.
_____ indicate the exact set of characters, including spaces, to be displayed.
' ' (string literal)
What is the command that lists the name of all tables in the current account?