Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 201:

  You ran this command on a source database:

  $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept

  On the target database, you run this command:

  $> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept

  Which two statements are true? (Choose two.)

  A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view
  B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view
  C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter
  D. The impdp operation creates EMP_DEPT as a table
  E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.
  F. The impdp operation creates EMP_DEPT as a view
  D. The impdp operation creates EMP_DEPT as a table
  E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.

• Question 202:

  Examine this parameter:

  

  Now examine this statement which executes successfully in an Oracle Database version 12c or later.

  CREATE TABLESPACE data_olap;

  Which two are true about this tablespace and its attributes? (Choose two.)

  A. The datafile that is created is not auto extensible.
  B. The tablespace is a dictionary managed tablespace.
  C. The datafile has an Oracle generated name.
  D. The tablespace is created with manual segment space management.
  E. The initial datafile size is 100MB.
  B. The tablespace is a dictionary managed tablespace.
  E. The initial datafile size is 100MB.

  ---

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CREATE-TABLESPACE.html#GUID-51F07BF5-EFAF-4910-9040-C473B86A8BF9

• Question 203:

  Which task is performed by a background process in a database instance?

  A. Connecting between a client process and a dispatcher
  B. Executing PL/SQL code
  C. Creating dedicated server connections
  D. Copying online redo log files to offline storage
  D. Copying online redo log files to offline storage

• Question 204:

  You must track all transactions that modify certain tables in the sales schema for at least three years.

  Automatic undo management is enabled for the database with a retention of one day.

  Which two must you do to track the transactions? (Choose two.)

  A. Enable supplemental logging for the database.
  B. Specify undo retention guarantee for the database.
  C. Create a Flashback Data Archive in the tablespace where the tables are stored.
  D. Create a Flashback Data Archive in any suitable tablespace.
  E. Enable Flashback Data Archiving for the tables that require tracking.
  D. Create a Flashback Data Archive in any suitable tablespace.
  E. Enable Flashback Data Archiving for the tables that require tracking.

  ---

  E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.

  D: Creating a Flashback Data Archive / Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following: Name of the Flashback Data Archive Name of the first tablespace of the Flashback Data Archive (Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace / Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years: CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;

• Question 205:

  You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:

  SQL > @utlrp.sql

  Which two actions does the script perform? (Choose two.)

  A. Parallel compilation of only the stored PL/SQL code
  B. Sequential recompilation of only the stored PL/SQL code
  C. Parallel recompilation of any stored PL/SQL code
  D. Sequential recompilation of any stored PL/SQL code
  E. Parallel recompilation of Java code
  F. Sequential recompilation of Java code
  C. Parallel recompilation of any stored PL/SQL code
  E. Parallel recompilation of Java code

  ---

  utlrp.sql and utlprp.sql

  The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/

  admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of

  parallelism as follows.

  0 - The level of parallelism is derived based on the CPU_COUNT parameter.

  1 - The recompilation is run serially, one object at a time.

  N - The recompilation is run in parallel with "N" number of threads.

  Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.

• Question 206:

  You install Oracle Grid Infrastructure for a standalone server.

  Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

  A. A pre-existing Oracle Net Listener
  B. Oracle Notification services
  C. A pre-existing database
  D. A pre-existing Oracle management agent
  E. Oracle CSSD service
  B. Oracle Notification services
  E. Oracle CSSD service

  ---

  References: https://docs.oracle.com/database/121/LADBI/oraclerestart.htm#LADBI999

• Question 207:

  Which three statements are true about space usage alerts? (Choose three.)

  A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
  B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
  C. Database alerts can provide warnings about low space availability at both tablespace and segment levels.
  D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
  E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
  A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
  D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
  E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

  ---

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120

• Question 208:

  You configure your database Instance to support shared server connections.

  Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)

  A. User session data
  B. Stack space
  C. Private SQL area
  D. Location of the runtime area for DML and DDL Statements
  E. Location of a part of the runtime area for SELECT statements
  A. User session data
  C. Private SQL area

  ---

  A: PGA itself is subdivided. The UGA (User Global Area) contains session state information, including stuff like package-level variables, cursor state, etc. Note that, with shared server, the UGA is in the SGA. It has to be, because shared server means that the session state needs to be accessible to all server processes, as any one of them could be assigned a particular session. However, with dedicated server (which likely what you're using), the UGA is allocated in the PGA.

  C: The Location of a private SQL area depends on the type of connection established for a session. If a session is connected through a dedicated server, private SQL areas are located in the server process' PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA.

  Note:

  *

  System global area (SGA)

  The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored

  in the SGA include cached data blocks and shared SQL areas.

  *

  Program global area (PGA)

  A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total memory used by all individual PGAs is known as the total instance PGA memory, and the collection of individual PGAs is referred to as the total instance PGA, or just instance PGA. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.

• Question 209:

  You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this? (Choose two.)

  A. Create a file watcher
  B. Create a bulk loader watcher
  C. Create a light weight job for bulk insert
  D. Create an event-based job for bulk insert
  E. Create a job chain with a step for bulk insert
  A. Create a file watcher
  D. Create an event-based job for bulk insert

• Question 210:

  Which three statements are true about server-generated alerts? (Choose three.)

  A. Server-generated alerts notify administrators of problems that cannot be resolved automatically.
  B. Alerts are not issued for locally managed read-only tablespaces.
  C. Response actions cannot be specified for server-generated alerts.
  D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view.
  E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.
  A. Server-generated alerts notify administrators of problems that cannot be resolved automatically.
  B. Alerts are not issued for locally managed read-only tablespaces.
  E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.

  ---

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120