Chapter 7 & 8

A password cannot be assigned to a role, only to a user.
True/False
True False

A user can be granted both system and object privileges in the same GRANT command.
True/False
True False

Both system and object privileges can be granted with the GRANT command.
True/False
True False

A role can be removed from the database with the DELETE ROLE command.
True/False
True False

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.
True/False
True False

All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view.
True/False
True False

The REVOKE command can be used to revoke a role from a user or another role. 
True/False
True False

Object privileges allow users to perform DML operations on the data contained within database objects.
True/False
True False

The CHANGE PASSWORD option can be used to force a user to change the user password at the time of the next login.
True/False
True False

The PASS IS clause of the CREATE USER command indicates the password assigned to a user.
True/False
True False

A(n) group is a collection of privileges that can be granted to users.
True/False
True False

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.
True/False
True False

The first column listed in an ORDER BY clause is considered the primary sort.
True/False
True False

The first column listed in an ORDER BY clause is considered the primary sort.
True/False
True False

Although Oracle12c is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data
contained in a database table.
True/False
True False

By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.
True/False
True False

The BETWEEN...AND comparison operator can be used to specify a range of values as a search condition.
True/False
True False

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.
True/False
True False

The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.
True/False
True False

When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as TRUE to be included in the query results.
True/False
True False

To indicate that data should be sorted in descending order, use the DESC keyword.
True/False
True False

Logical operators are evaluated in the order of NOT, AND, and OR.
True/False
True False

Logical operators are evaluated in the order of NOT, AND, and OR.
True/False
True False

Oracle12c is case sensitive when comparing data to a search condition.
True/False
True False

A greater than or equal to comparison is indicated by the symbols =>.
True/False
True False

Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?
A. REVOKE SELECT
    FROM rthomas;
B. REVOKE SELECT ON orders
    FROM rthomas;
C. REVOKE SELECT FOR orders
    FROM rthomas;
D. UNGRANT SELECT
    FROM rthomas;

Which of the following commands is used to establish a user account?
A. CREATE NEW USER username
    IDENTIFIED BY password;
B. CREATE USERNAME username
    IDENTITY password;
C. CREATE USER username
    PASSWORD password;
D. CREATE USER username
    IDENTIFIED BY password;

Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?
A. GRANT SELECT ON orders TO PUBLIC;
B. GRANT SELECT ON orders TO EVERYONE;
C. GRANT SELECT ON orders TO *;
D. none of the above

Which of the following are examples of object privileges?
A. SELECT and UPDATE
B. CREATE USER and CREATE TABLE
C. UPDATE ANY TABLE and ALTER ANY TABLE
D. all of the above

Which of the following will add a password to a role?
A. ALTER USER username
    SET ROLE rolename;
B. ALTER ROLE rolename
    SET USER username
C. ALTER USER username
    PASSWORD password;
D. ALTER ROLE rolename
    IDENTIFIED BY password;

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?
A. FOREIGN KEY
B. REFERENCES
C. SELECT 
D. none of the above

Which of the following will revoke a user's object privileges?
A. REVOKE objectprivilege ON
    OBJECT objectname FROM username;
B. REVOKE objectprivilege ON
    objectname FROM username;
C. REVOKE objectprivilege ON
    objectname FOR username;
D. DROP objectprivilege ON
    objectname FROM username;

Which of the following refers to the process of ensuring that individuals trying to access the system are who they say they are, thus preventing them from illegally accessing data?
A. authorization
B. individualization
C. authentication
D. accreditation

Which of the following statements about granting object privileges is incorrect?
A. The WITH GRANT OPTION gives the user the ability to grant the same object privileges to other users.
B. The FROM clause is used to identify the password of the user to which the privilege(s) applies.
C. The TO clause identifies the user or role receiving the privilege.
D. The grantor has a choice to either grant individual privileges, or to use the ALL keyword in the GRANT clause.

Which of the following statements about granting system privileges is incorrect?
A. The user(s) or role(s) receiving the system privilege is identified in the TO clause.
B. WITH EXCLUSIVE MODE is used to forbid any user not identified in the TO clause from granting the system privilege(s) to any other database users.
C. WITH ADMIN OPTION is used to allow any user or role identified in the TO clause to grant the system privilege(s) to any other database users.
D. The system privilege being assigned is identified in the GRANT clause.

Which of the following SQL statements will create a new role named PRCLERK?
A. CREATE prclerk;
B. CREATE ROLE prclerk ON payroll;
C. CREATE ROLE prclerk WITH
D. CREATE ROLE prclerk;
    SELECT ANY TABLE PRIVILEGE;

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?
A. ALTER USER rthomas CHANGE PASSWORD;
B. ALTER USER rthomas UPDATE PASSWORD; 
C. ALTER USER rthomas PASSWORD EXPIRE;
D. ALTER USER rthomas EXPIRE PASSWORD;

The ____ keywords are used to grant object privileges to users and roles.
A. GRANT...FOR...TO
B. GRANT...WITH...TO
C. GRANT...ON...TO
D. CREATE...WITH...TO

To instruct Oracle12c to sort data in descending order, enter ____ after the column name in the WHERE clause.
A. D
B. DES
C. DESC
D. none of the above

When sorting the results in ascending order, which of the following values will be presented last in the output?
A. date
B. NULL
C. character
D. numeric

Based upon the contents of the ORDERS table in the accompanying figure, which
of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?
A. SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1_7%;
B. SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1007;
C. SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE 1_7%;
D. SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';

Based upon the contents of the ORDERS table in the accompanying figure, which
of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?
A. SELECT * FROM orders
WHERE shipdate <= '04-APR-03' AND shipdate >= '05-APR-03';
B. SELECT * FROM orders
WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03';
C. SELECT * FROM orders
WHERE shipdate >= ‘04-APR-03’ AND shipdate <= ‘05-APR-03’;
D. both b and c

Which of the following operators can be used to combine search conditions?
A. AND
B. =
C. IS NOT NULL
D. none of the above

The order in which NULL values appear in the results can be overridden by which of the following keywords?
A. NULLS FIRST
B. NULLS LAST
C. NSEQ
D. both a and b

Which of the following queries will display all orders placed in the month of March?
A. SELECT * FROM orders WHERE orderdate LIKE '%Mar%';
B. SELECT * FROM orders WHERE orderdate LIKE '_Mar_';
C. SELECT * FROM orders WHERE orderdate LIKE "%Mar%";
D. none of the above

Based upon the contents of the BOOKS table in the accompanying figure, which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?
A. SELECT * FROM books WHERE pubid LIKE "1";
B. SELECT * FROM books WHERE pubid = 1;
C. SELECT * FROM books WHERE pubid > 1;
D. both a and b

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.
A. double quotation marks (" ")
B. single quotation marks (' ')
C. parentheses ( )
D. none of the above

Based upon the contents of the ORDERS table in the accompanying figure, which
of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?
A. SELECT * FROM orders WHERE shipdate = NULL;
B. SELECT * FROM orders WHERE shipdate > NULL;
C. SELECT * FROM orders WHERE shipdate LIKE 'NULL';
D. none of the above

Which of the following operators is used when the criteria is based upon a search pattern?
A. BETWEEN...AND
B. IS NULL
C. AND
D. LIKE

Which of the following search conditions can be used to identify records that have data stored in a column named ColB?
A. ColB IS NOT NULL
B. ColB ^= NULL
C. ColB != NULL
D. all of the above