Chapter 7 & 8

  1. A password cannot be assigned to a role, only to a user.
    True/False
    False
  2. A user can be granted both system and object privileges in the same GRANT command.
    True/False
    False
  3. Both system and object privileges can be granted with the GRANT command.
    True/False
    True
  4. A role can be removed from the database with the DELETE ROLE command.
    True/False
    False
  5. A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.
    True/False
    True
  6. All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view.
    True/False
    True
  7. The REVOKE command can be used to revoke a role from a user or another role. 
    True/False
    True
  8. Object privileges allow users to perform DML operations on the data contained within database objects.
    True/False
    True
  9. 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
    False
  10. The PASS IS clause of the CREATE USER command indicates the password assigned to a user.
    True/False
    False
  11. A(n) group is a collection of privileges that can be granted to users.
    True/False
    False
  12. All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.
    True/False
    True
  13. The first column listed in an ORDER BY clause is considered the primary sort.
    True/False
    True
  14. The first column listed in an ORDER BY clause is considered the primary sort.
    True/False
    True
  15. 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
  16. By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.
    True/False
    True
  17. The BETWEEN...AND comparison operator can be used to specify a range of values as a search condition.
    True/False
    True
  18. 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
    False
  19. The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.
    True/False
    True
  20. 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
  21. To indicate that data should be sorted in descending order, use the DESC keyword.
    True/False
    True
  22. Logical operators are evaluated in the order of NOT, AND, and OR.
    True/False
    True
  23. Logical operators are evaluated in the order of NOT, AND, and OR.
    True/False
    False
  24. Oracle12c is case sensitive when comparing data to a search condition.
    True/False
    True
  25. A greater than or equal to comparison is indicated by the symbols =>.
    True/False
    False
  26. 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;
    • B. REVOKE SELECT ON orders
    •     FROM rthomas;
  27. 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;
    • D. CREATE USER username
    •     IDENTIFIED BY password;
  28. 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;
  29. Which of the following are examples of object privileges?



    A. SELECT and UPDATE
  30. 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;
    • D. ALTER ROLE rolename
    •     IDENTIFIED BY password;
  31. Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?



    B. REFERENCES
  32. 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;
    • B. REVOKE objectprivilege ON
    •     objectname FROM username;
  33. 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?



    C. authentication
  34. Which of the following statements about granting object privileges is incorrect?



    D. The FROM clause is used to identify the password of the user to which the privilege(s) applies.
  35. Which of the following statements about granting system privileges is incorrect?



    C. 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.
  36. Which of the following SQL statements will create a new role named PRCLERK?




        SELECT ANY TABLE PRIVILEGE;
    D. CREATE ROLE prclerk;
  37. Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?



    C. ALTER USER rthomas PASSWORD EXPIRE;
  38. The ____ keywords are used to grant object privileges to users and roles.



    A. GRANT...ON...TO
  39. To instruct Oracle12c to sort data in descending order, enter ____ after the column name in the WHERE clause.



    C. DESC
  40. When sorting the results in ascending order, which of the following values will be presented last in the output?



    A. NULL
  41. 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# = 1007;
  42. 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
    D. both b and c
  43. Which of the following operators can be used to combine search conditions?



    A. AND
  44. The order in which NULL values appear in the results can be overridden by which of the following keywords?



    D. both a and b
  45. Which of the following queries will display all orders placed in the month of March?



    A. SELECT * FROM orders WHERE orderdate LIKE '%Mar%';
  46. 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?



    B. SELECT * FROM books WHERE pubid = 1;
  47. If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.



    B. single quotation marks (' ')
  48. 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?



    D. none of the above
  49. Which of the following operators is used when the criteria is based upon a search pattern?



    C. LIKE
  50. 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
Author
Lencha
ID
325784
Card Set
Chapter 7 & 8
Description
Chapter 7 & 8
Updated