Oracle 1z0-082 Practice Exam Questions

Oracle 1z0-082 Sample Question Answers

Question # 1

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR. h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

A. to_numberipromo_begin_date) - s will return a number. 
B. PROMO_ BEGIN_DATE - sysdate will return a number. 
C. PROMO_ BEGIN_DATE - sysdate will return an error. 
D. PROMO_ BEGIN_DATE - 5 will return a date. 
E. TO_date(PROMO_ BEGIN_DATE * 5| will return a date. 

Show Answer

Question # 2

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

A. Data Definition Language (DDL) statements 
B. non-default database parameters
C. block corruption errors 
D. deadlock errors 
E. session logins and logouts 

Show Answer

Question # 3

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

A. the first column in the first select of the compound query 
B. the first varchab2 column in the first select of the compound query 
C. the first number column in the first select of the compound query 
D. the first number or varchar2 column in the last select of the compound query 
E. the first column in the last select of the compound query 

Show Answer

Question # 4

Which three statements are true about Deferred Segment Creation in Oracle databases?

A. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces. 
B. Sessions may dynamically switch back and forth from deferred to immediate segment creation. 
C. It Is the default behavior for tables and indexes.
D. It is supported for SYS-owned tables contained in locally managed tablespaces. 
E. Indexes inherit the deferred or immediate segment creation attribute from their parent table 

Show Answer

Question # 5

Which two statements are true about Oracle synonyms?

A. A synonym has an object number. 
B. A synonym can be created on an object in a package. 
C. A synonym can have a synonym. 
D. All private synonym names must be unique in the database. 
E. Any user can create a PUBLIC synonym. 

Show Answer

Question # 6

Which two statements are true about Enterprise Manager (EM) Express? 

A. You can use a single instance of EM Express to manage multiple database running on the same server. 
B. EM Express uses a separate repository database to store target database metadata. 
C. By default, EM express is available for a database after database creation using DBCA. 
D. You can shut down a database instance using EM Express. 
E. You cannot start up a database instance using EM Express.

Show Answer

Question # 7

Which two statements are true about the Oracle Data Dictionary? 

A. It is owned by the sys user. 
B. Data dictionary base tables can be queried directly. 
C. It is owned by the system user. 
D. Data dictionary views are always created with queries that join two or more base tables. 
E. All data dictionary view joins base tables to dynamic performance views. 

Show Answer

Question # 8

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week. Which query can be used?

A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees; 
B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees; 
C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees; 
D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees; 

Show Answer

Question # 9

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. dump files 
B. control files 
C. password files 
D. bad files 
E. input files 

Show Answer

Question # 10

Which compression method is recommended for Direct-Path Insert operations? 

A. COLUMN STORE COMPRESS BASIC 
B. COLUMN STORE COMPRESS ADVANCED 
C. RON STORE COMPRESS BASIC 
D. ROW STORE COMPRESS ADVANCED 

Show Answer