Oracle Certified 1Z0-082 Dumps Questions Valid 1Z0-082 Materials [Q54-Q72]

Q54. Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

Q55. Which three activities are recorded in the database alert log? (Choose three.)

Q56. Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Q57. In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

Q58. Which two statements are true about interval data types?

Q59. You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

Q60. View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

Q61. Which two actions can you perform using DBCA for an existing database?

Q62. What is true about non-equijoin statement performance? (Choose two.)

Q63. Which three statements are true about a self join? (Choose three.)

Q64. Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Q65. You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

Q66. Which two statements are true about Enterprise Manager Database Express? (Choose two.)

Q67. Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?
A)


C)

D)

E)

Q68. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Q69. What is true about non-equijoin statement performance? (Choose two.)

Q70. Which two statements are true about the SET VERIFY ON command? (Choose two.)

Q71. Which two functions are performed by a listener?

Q72. What two are benefits of Data Pump? (Choose two.)