1z0-082 Practice Test

1z0-082 Practice Test practice questions, page 7 of 7, with answer review and explanations.

Question 31

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which four actions can HR perform? (Choose four.)

  1. Revoke the CREATE SESSION privilege from other users
  2. Revoke the CREATE SESSION privilege from user HR
  3. Log in to the database instance
  4. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
  5. Execute DDL statements in the HR schema
  6. Execute DML statements in the HR schema

Question 32

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

  1. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
  2. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
  3. The HAVING clause can be used with aggregating functions in subqueries
  4. The WHERE clause can be used to exclude rows before dividing them into groups
  5. The WHERE clause can be used to exclude rows after dividing them into groups

Question 33

Which two statements are true about UNDO and REDO? (Choose two.)

  1. The generation of UNDO generates REDO
  2. DML modifies Oracle database objects and only generates UNDO
  3. The generation of REDO generates UNDO
  4. DML modifies Oracle database objects and only generates REDO
  5. DML modifies Oracle database objects and generates UNDO and REDO

Question 34

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

  1. as SCOTT in DALLAS_DB
  2. as SCOTT in BOSTON_DB
  3. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
  4. as SYS in both the databases
  5. as SCOTT in both the databases

Question 35

Which three statements are true about the DESCRIBE command? (Choose three.)

  1. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
  2. It can be used from SQL Developer
  3. It displays the NOT NULL constraint for any columns that have that constraint
  4. It can be used to display the structure of an existing view
  5. It displays all constraints that are defined for each column
  6. It can be used only from SQL*Plus