Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 1:

  You start your database instance in NOMOUNT state. Which two actions are performed?

  A. The control files are opened.
  B. The consistency of the database is checked.
  C. All required background processes are started.
  D. SYS can access the database.
  E. Memory is allocated for the SGA.
  C. All required background processes are started.
  E. Memory is allocated for the SGA.

  ---

  Explanation/Reference:

• Question 2:

  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 3:

  In one of your databases, user KING is:

  1.

  Not a DBA user

  2.

  An operating system (OS) user Examine this command and its output:

  

  What must you do so that KING is authenticated by the OS when connecting to the database instance?

  A. Set OS_AUTHENT_PREFIX to OPS$
  B. Have the OS administrator add KING to the OSDBA group
  C. Grant DBA to KING
  D. Unset REMOTE_LOGIN_PASSWORDFILE
  E. Alter user KING to be IDENTIFIED EXTERNALLY
  E. Alter user KING to be IDENTIFIED EXTERNALLY

  ---

  Explanation/Reference:

  https://oracle-base.com/articles/misc/os-authentication

• Question 4:

  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/Reference:

• Question 5:

  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;
  B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;

  ---

  Explanation/Reference:

  "The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week."

  1 is Sunday in that case.

  ALTER SESSION SET NLS_TERRITORY = "AMERICA";

  SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

  Result = 22-DEC-03 (Monday)

  SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

  Result = 21-DEC-03 (Sunday)

• Question 6:

  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:

• Question 7:

  The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

  A. WHERE MONTHS_BETWEEN(SYSDATE, start_date)
  B. WHERE ADD_MONTHS(start_date, 25)
  C. WHERE TO_NUMBER(start date - SYSDATE)
  D. WHERE MONTHS_BETWEEN(start_date, SYSDATE)
  D. WHERE MONTHS_BETWEEN(start_date, SYSDATE)

• Question 8:

  In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

  The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

  

  Which statement is true?

  A. Dynamic service registration cannot be used for this database instance
  B. The LREG process registers services dynamically with the LISTENER_1 listener
  C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
  D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
  E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
  B. The LREG process registers services dynamically with the LISTENER_1 listener

  ---

  Explanation/Reference:

  The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.

  Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

• Question 9:

  Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

  A. Oracle Managed Files (OMF)
  B. Online table segment shrink
  C. Online index segment shrink
  D. Automatic data file extension (AUTOEXTEND)
  E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
  A. Oracle Managed Files (OMF)
  D. Automatic data file extension (AUTOEXTEND)
  E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

• Question 10:

  Which three statements are true about sequences in a single instance Oracle database?

  A. Sequences can always have gaps.
  B. A sequence can Issue duplicate values.
  C. A sequence's unallocated cached values are lost if the instance shuts down.
  D. Two or more tables cannot have keys generated from the same sequence.
  E. A sequence can only be dropped by a DBA.
  F. A sequence number that was allocated can be rolled back if a transaction fails.
  A. Sequences can always have gaps.
  B. A sequence can Issue duplicate values.
  C. A sequence's unallocated cached values are lost if the instance shuts down.

  ---

  Explanation/Reference: