100% Free Oracle 1z0-082 Exam Sample Questions | Verified By Experts

SAMPLE QUESTIONS:

Question No. 1

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?

A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B. SELECT &col1, &col2FROM &&tableWHERE &condition;

C. SELECT &col1, &col2FROM “&table”WHERE &condition;

D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

Question No. 2

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. External table files can be used for other external tables in a different database

B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

D. They cannot be partitioned

E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

F. They support UPDATEs but not INSERTs and DELETEs

Answer: A, B, F

Question No. 3

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

B. The data dictionary is created and maintained by the database administrator

C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

D. Base tables can be queried directly

E. It is owned by the SYSTEM user

F. Usernames of all users including database administrators are stored in the data dictionary

Answer: C, D, F

Question No. 4

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

A. Revoke the CREATE SESSION privilege from other users

B. Revoke the CREATE SESSION privilege from user HR

C. Log in to the database instance

D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E. Execute DDL statements in the HR schema

F. Execute DML statements in the HR schema

Answer: A, D, E

Question No. 5

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A. Duplicates are eliminated automatically by the UNION ALL operator

B. The number of columns selected in each SELECT statement must be identical

C. The names of columns selected in each SELECT statement must be identical

D. The output is sorted by the UNION ALL operator

E. NULLS are not ignored during duplicate checking

Answer: B, E

FOR MORE INFORMATION

VISIT NOW:

https://www.dumpspass4sure.com/oracle/1z0-082-dumps.html