Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 1:

  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%)
  A. WHERE UPPER (SUBSTR (cust_name, INSTR (cust_name, ' ') + 1)) LIKE UPPER ('MC%')
  D. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') +1)) LIKE 'Mc%'

  ---

  explanation:

  Explanation/Reference:

• Question 2:

  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.
  A. All indexes defined on HR.EMPLOYEES are dropped
  C. The HR.EMPLOYEES table may be moved to the recycle bin.
  E. All constraints defined on HR.EMPLOYEES are dropped.

  ---

  explanation:

  Explanation/Reference:

• Question 3:

  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.
  D. Execute the SET VERIFY ON command before executing the query.
  F. Use the define command before executing the query.

  ---

  explanation:

  Explanation/Reference:

• Question 4:

  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.
  D. Column aliases can be used in the ORDER BY clause.
  E. In a character sort, the values are case-sensitive.

  ---

  explanation:

  Explanation/Reference:

• 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.
  C. It creates a master table to store details of the export operation.
  D. It creates dump files for the entire database.

  ---

  explanation:

  Explanation/Reference:

• Question 6:

  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.
  B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment.
  D. Undo segments can extend when a transaction fills the last extent of the undo segment.

  ---

  explanation:

  Explanation/Reference:

• Question 7:

  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
  A. subquery
  B. self join

  ---

  explanation:

  Explanation/Reference:

• Question 8:

  Examine the description of the PRODUCT_INFORMATION table:

  

  Which query retrieves the number of products with a null list price?

  A. SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;
  B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
  C. SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;
  D. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
  B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

  ---

  explanation:

  Explanation/Reference:

• Question 9:

  Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)

  A. A user's session may be suspended and resumed multiple times.
  B. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
  C. All sessions must have the same timeout value when waiting for resumable space allocations.
  D. Resumable space allocation is only possible with locally managed tablespaces.
  E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.
  F. Resumable space allocation may be enabled for some sessions and not others.
  A. A user's session may be suspended and resumed multiple times.
  E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.
  F. Resumable space allocation may be enabled for some sessions and not others.

  ---

  explanation:

  Explanation/Reference:

• 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.
  B. An update to a table can result in no updates to any of the table's indexes.
  D. An update to a table can result in updates to any or all of the table's indexes.

  ---

  explanation:

  Explanation/Reference: