Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 81:

  Examine this command:

  

  Which two statements are true?

  A. Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
  B. DML may be performed on tables with one or more extents in this data file during the execution of this command.
  C. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
  D. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
  E. Tables with one or more extents in this data file may be queried during the execution of this command.
  B. DML may be performed on tables with one or more extents in this data file during the execution of this command.
  E. Tables with one or more extents in this data file may be queried during the execution of this command.

• Question 82:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
  B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
  C. It supports diagnostics for Automatic Storage Management (ASM)
  D. It supports diagnostics for Oracle Clusterware
  E. It is held inside an Oracle database schema
  C. It supports diagnostics for Automatic Storage Management (ASM)
  D. It supports diagnostics for Oracle Clusterware

  ---

  Explanation/Reference:

  The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR.

  https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260

• Question 83:

  Which three statements are true about single-row functions? (Choose three.)

  A. They can be used only in the WHERE clause of a SELECT statement
  B. The argument can be a column name, variable, literal or an expression
  C. The data type returned can be different from the data type of the argument
  D. They can be nested to any level
  E. They can accept only one argument
  F. They return a single result row per table
  B. The argument can be a column name, variable, literal or an expression
  C. The data type returned can be different from the data type of the argument
  D. They can be nested to any level

  ---

  Explanation/Reference:

  https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm

• Question 84:

  Examine this command:

  SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

  Which two statements are true?

  A. The high-water mark (HWM) of ORDERS is adjusted.
  B. Only queries are allowed on ORDERS while the shrink is executing.
  C. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
  D. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
  E. Dependent indexes become UNUSABLE.
  F. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
  C. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
  D. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

  ---

  Explanation/Reference:

• Question 85:

  Which two statements are true about the rules of precedence for operators? (Choose two.)

  A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
  B. NULLS influence the precedence of operators in an expression
  C. The + binary operator has the highest precedence in an expression in a SQL statement
  D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
  E. Multiple parentheses can be used to override the default precedence of operators in an expression
  D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
  E. Multiple parentheses can be used to override the default precedence of operators in an expression

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm

  https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm

  Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

• Question 86:

  Examine this SQL statement:

  SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30

  Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

  A. ORDER BY "Last Name"
  B. ORDER BY 2, 1
  C. ORDER BY 2, cust_id
  D. ORDER BY CUST_NO
  E. ORDER BY "CUST_NO"
  A. ORDER BY "Last Name"
  B. ORDER BY 2, 1
  C. ORDER BY 2, cust_id

• Question 87:

  Examine the description of the CUSTOMERS table:

  

  For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?

  A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;
  B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
  C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level NULLAND due_amount NULL;
  D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;
  E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
  E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

• Question 88:

  Which two statements are true about the PMON background process? (Choose two.)

  A. It registers database services with all local and remote listeners known to the database instance.
  B. It rolls back transactions when a process fails.
  C. It records checkpoint information in the control file.
  D. It frees unused temporary segments.
  E. It frees resources held by abnormally terminated processes.
  B. It rolls back transactions when a process fails.
  E. It frees resources held by abnormally terminated processes.

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm

• Question 89:

  Which three statements are true about views in an Oracle database? (Choose three.)

  A. Views can be updated without the need to re-grant privileges on the view
  B. Tables in the defining query of a view must always exist in order to create the view
  C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
  D. Data Manipulation Language (DML) can always be used on views
  E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
  F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
  G. The WITH CHECK clause prevents certain rows from being updated or inserted
  A. Views can be updated without the need to re-grant privileges on the view
  F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
  G. The WITH CHECK clause prevents certain rows from being updated or inserted

  ---

  Explanation/Reference:

• Question 90:

  Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

  A. Local naming can be used if Connect-Time Failover is required.
  B. A client can connect to an Oracle database instance even If no client side network admin has been configured.
  C. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
  D. Local Naming requires setting the TNS_ADMIN environment variable on the client side.
  E. Directory Naming can be used if Connect-Time Failover is required.
  F. Easy Connect supports TCP/IP and SSL.
  A. Local naming can be used if Connect-Time Failover is required.
  B. A client can connect to an Oracle database instance even If no client side network admin has been configured.
  E. Directory Naming can be used if Connect-Time Failover is required.

  ---

  Explanation/Reference: