Ch. 2 Flashcards
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
PUBID
A(n) ____ has a predefined meaning in Oracle11g
KEYWORD
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?
, (COMMA)
Which of the following types of columns will automatically left-align the column heading when it is displayed?
a. Character
b. Numeric
c. Date
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?
a. desc
b. AS
c. FROM
d. none of the above
b. AS
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
FROM
Which of the following commands is used to issue a query?
SELECT
Combining the contents of two or more columns is known as ____.
concatenation
What is the Command to view all the columns of a table?
SELECT *
FROM tablename;
What is the command to view one column of a table?
SELECT columnname
FROM tablename;
What is the command to view multiple columns of a table?
SELECT columnname,
columnname,…
FROM tablename;
What is the command to asign an alias to a column during display?
SELECT coulnmnname AS alias
FROM tablename;
or
SELECT title titles
FROM books;
What is the command to eliminate duplication in ouput?
SELECT DISTINCT columname
FROM tablename;
or
SELECT UNIQUE columname
FROM tablename;
What is the command to perform concatenation of column contents during display?
SELECT columnname || columnname
FROM tablename;
What is the command to view the structure of a table?
DESCRIBE tablename
________ clause identify the columns for etrieval in a SELECT command.
SELECT
_______ clause indentify the table containing selected columns.
FROM
_____ preserve spaces, symbols, or letter case in an output column alias.
” “
____ combine display of content from multiple columns into a single column.
|| (concatenation)
_____ 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?
SELECT table_name
FROM user_tables;
