Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 141:

  You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.

  You execute the following command on the PRODDB database server: What should you do to resolve the error?

  

  A. Add network_link = devdb.us.oracle.com.
  B. Add the SYSTEM user to the schemas option.
  C. Change the dumpfile option value to [email protected].
  D. Replace the schemas option with network_1ink = devdb.us.oracle.com.
  E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.
  E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.

• Question 142:

  Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later.

  What must you do to achieve this?

  A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.
  B. Create a baseline on a pair of snapshots that span the peak load period.
  C. Generate Active Session History reports for the peak load period.
  D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.
  B. Create a baseline on a pair of snapshots that span the peak load period.

• Question 143:

  In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.

  Which statement is true?

  A. The CDB must be open.
  B. The CDB must be in the mount stage.
  C. The CDB must be in the nomount stage.
  D. Alt existing PDBs must be closed.
  A. The CDB must be open.

  ---

  * Creating a PDB

  Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing

  no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather,

  it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

• Question 144:

  Which statement is true regarding the startup of a database instance?

  A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.
  B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
  C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.
  D. Media recovery is required when the database is shut down by using either the immediate option or the abort option.
  E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.
  E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

  ---

  References: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm

• Question 145:

  You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

  Applications will connect to the database via a middle tier.

  The number of concurrent user connections will be high.

  The database will have mixed workload, with the execution of complex BI queries scheduled at night.

  Which DBCA option must you choose to create the database?

  A. a General Purpose database template with default memory allocation
  B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
  C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
  D. a default database configuration
  C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

  ---

  References:

• Question 146:

  A database runs in NOARCHIVELOG mode.

  Backup scheduling for this database must be automated before upgrading to a new version of the database.

  Which two tools or utilities can do this? (Choose two.)

  A. Oracle Enterprise Manager Database Express (EM Express)
  B. Database Upgrade Assistant (DBUA)
  C. SQL Developer
  D. Database Configuration Assistant (DBCA)
  E. Oracle Enterprise Manager Cloud Control
  A. Oracle Enterprise Manager Database Express (EM Express)
  B. Database Upgrade Assistant (DBUA)

• Question 147:

  Examine the command to perform a data pump export operation on a source database:

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

  On the target database, you execute the data pump import command:

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

  Which three statements are true? (Choose three.)

  A. The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
  B. The impdp operation creates the view and dependent objects.
  C. All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.
  D. Objects dependent on the EMP_DEPT view are exported.
  E. The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump file.
  A. The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
  D. Objects dependent on the EMP_DEPT view are exported.
  E. The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump file.

• Question 148:

  Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

  A. User Global Area
  B. Program Global Area
  C. SQL Query Result Cache
  D. PL/SQL Function Result Cache
  A. User Global Area

• Question 149:

  In your production database, data manipulation language (DML) operations are executed on the SALES table.

  You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep

  track of both the old data and new data in the table long with the user information.

  What action would you take to achieve this task?

  A. Apply fine-grained auditing.
  B. Implement value-based auditing.
  C. Impose standard database auditing to audit object privileges.
  D. Impose standard database auditing to audit SQL statements.
  B. Implement value-based auditing.

• Question 150:

  Which two statements are true about variable extent size support for large ASM files? (Choose two.)

  A. The metadata used to track extents in SGA is reduced.
  B. Rebalance operations are completed faster than with a fixed extent size
  C. An ASM Instance automatically allocates an appropriate extent size.
  D. Resync operations are completed faster when a disk comes online after being taken offline.
  E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
  A. The metadata used to track extents in SGA is reduced.
  C. An ASM Instance automatically allocates an appropriate extent size.

  ---

  A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases (A), and improve performance for file create and open operations.

  C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size. Note:

  *

  The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.

  *

  The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher.