The INSERT, UPDATE, and DELETE object privileges can be applied to tables and views. True/False
True
A role can be created with the CREATE ROLE command.
True/False
True
Object privileges allow users to perform DML operations on the data contained within database objects.
True/False
True
The DEFAULT ROLE option of the ALTER USER command can be used to assign a default role to an existing user.
True/False
True
User names can consist of up to 30 characters and include the _, #, and $ symbols.
True/False
True
Even if users are authenticated by the operating system, the users are still required to have valid Oracle12c accounts to access the database.
True/False
True
The WITH ADMIN OPTION is required to enable the user to grant the specified object privileges to other users.
True/False
False
The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.
True/False
True
An object privilege cannot be granted to a role with the WITH GRANT OPTION.
True/False
True
A role can be removed from the database with the DELETE ROLE command.
True/False
False
If a date column is being used for comparison against the search condition, the search condition is enclosed in double quotation marks.
True/False
False
The < symbol is used to search for records containing a value that is less than or equal to the stated search condition.
True/False
False
When two conditions are joined by the AND keyword, both conditions must be FALSE for a record to be included in the results.
True/False
False
The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern.
True/False
False
Using the OR logical operator to combine search conditions based upon the same column is the same as using the IN comparison operator.
True/False
True
The <>, !=, or ^= operators can be used to search for values that are not equivalent to the specified search condition.
True/False
True
The IN comparison operator is used when searching for a pattern of characters. True/False
False
When using a search pattern, a(n) ? symbol is used to indicate exactly one character in that position.
True/False
False
A NULL value is the same as a blank space. True/False
False
A greater than or equal to comparison is indicated by the symbols =>.
True/False
False
A(n) outer join can be created by not including a joining condition in a SELECT statement.
True/False
False
The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.
True/False
False
The ON clause can be used only if the tables being joined have a common column with the same name.
True/False
False
The number of joining conditions required to join tables is always one less than the number of tables being joined.
True/False
True
A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.
True/False
False
A column qualifier is separated from the column name with a colon.
True/False
False
A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause. True/False
False
When combining the results of two SELECT statements with the MINUS keyword, duplicate rows are suppressed in the results.
True/False
False
The outer join operator is placed on the side of the joining condition that references the table containing the deficient rows.
True/False
True
When a self-join is created, each copy of the table must be assigned a table alias.
True/False
True
The INSTR function is used to return a portion of a character string.
True/False
False
Any of the single-row functions covered in this chapter can be used with the DUAL table.
True/False