Oracle Oracle Database 1Z0-082 Questions & Answers

• Question 1:

  You issued this command:

  DROP TABLE hr.employees;

  Which three statements are true? (Choose three.)

  A. All indexes defined on HR.EMPLOYEES are dropped

  B. Synonyms for HR.EMPLOYEES are dropped.

  C. The HR.EMPLOYEES table may be moved to the recycle bin.

  D. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.

  E. All constraints defined on HR.EMPLOYEES are dropped.

  F. Views referencing HR.EMPLOYEES are dropped.

  Correct Answer: ACE

• Question 2:

  Examine the data in the CUST_NAME column of the CUSTOMERS table:

  

  You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result? (Choose two.)

  A. WHERE UPPER (SUBSTR (cust_name, INSTR (cust_name, ' ') + 1)) LIKE UPPER ('MC%')

  B. WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1 ) LIKE 'Mc%' OR 'MC%'

  C. WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') +1) LIKE 'Mc%'

  D. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') +1)) LIKE 'Mc%'

  E. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') +1)) IN (MC%', 'Mc%)

  Correct Answer: AD

• Question 3:

  Examine the description of the CUSTOMERS table: You must determine if any customers' details have been entered more than once using a different CUSTINO, by listing all duplicate names.

  

  Which two methods can you use to get the required result? (Choose two.)

  A. subquery

  B. self join

  C. LEFT OUTER JOIN with self join

  D. RIGHT OUTER JOIN With self join

  E. FULL OUTER JOIN with self join

  Correct Answer: AB

• Question 4:

  Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose two.)

  A. Undo segments can be stored in the SYSAUX tablespace.

  B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment.

  C. A single transaction may use multiple undo segments simultaneously.

  D. Undo segments can extend when a transaction fills the last extent of the undo segment.

  E. Undo segments can be stored in the SYSTEM tablespace.

  Correct Answer: BD

• Question 5:

  DATADIR1 and DATATDIR2 are database directory objects.

  Examine this command:

  [oracle@host01 ~] expdp system/oracle \

  > FULL=y \

  > DUMPFiLe=datadir1:full%U.dmp, datadir2:full2%U.dmp \

  > FILESIZE=2G \

  > PARALLEL=4 \

  > LOGFILE=datadirl:/expfull.log \

  > JOB_NAME=expfull

  Which two statements are true about the expdp operation? (Choose two.)

  A. It fails if the total size of the dump file is more than 2GB.

  B. It starts only when four worker processes are available.

  C. It creates a master table to store details of the export operation.

  D. It creates dump files for the entire database.

  E. It creates dump files only for objects in the SYSTEM schema.

  Correct Answer: CD

• Question 6:

  Which two statements are true about the ORDER BY clause? (Choose two.)

  A. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

  B. Numeric values are displayed in descending order if they have decimal positions.

  C. NULLS are not included in the sort operation.

  D. Column aliases can be used in the ORDER BY clause.

  E. In a character sort, the values are case-sensitive.

  Correct Answer: DE

• Question 7:

  Examine this query:

  

  Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)

  A. Store the query in a script and pass the substitution value to the script when executing it.

  B. Execute the SET verify off command before executing the query.

  C. Use the undefine command before executing the query.

  D. Execute the SET VERIFY ON command before executing the query.

  E. Replace 'and1' with 'andand1' in the query.

  F. Use the define command before executing the query.

  Correct Answer: DF

• Question 8:

  Which two statements are true about views? (Choose two.)

  A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.

  B. The WITH CHECK clause prevents certain rows from being displayed when querying the view.

  C. Views can be updated without the need to re-grant privileges on the view.

  D. A view must only refer to tables in its defining query.

  E. Views can be indexed.

  Correct Answer: AC

• Question 9:

  Examine these statements executed in a single Oracle session:

  

  Which three statements are true? (Choose three.)

  A. The code for pen is 10.

  B. There is no row containing fountain pen.

  C. There is no row containing pen.

  D. The code for fountain pen is 3.

  E. The code for pen is l.

  F. There is no row containing pencil.

  Correct Answer: ADF

• Question 10:

  Which two statements are true regarding indexes? (Choose two.)

  A. A non-unique index can be altered to be unique.

  B. An update to a table can result in no updates to any of the table's indexes.

  C. The RECYCLE BIN never contains indexes.

  D. An update to a table can result in updates to any or all of the table's indexes.

  E. A table belonging to one user cannot have an index that belongs to a different user.

  Correct Answer: BD