1Z0-062 Oracle Exam Questions and Free Practice Test

Question 85

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

A. The PDB must be open in read-only mode.

B. The PDB must be in mount state.

C. The PDB must be unplugged.

D. The PDB data files are always removed from disk.

E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Correct Answer:BC
References: http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658

Question 86

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

C. Install Oracle HTTP Server.

D. Configure at least one dispatcher for the TCP/IP protocol.

E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Expres

Correct Answer:BD

Question 87

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

A. The ORACLE_BASE base parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that is specified should have the root user as its member.

D. The operating system group that is specified must have permission to write to the inventory directory.

Correct Answer:D
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.

Question 88

SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table:
1Z0-062 dumps exhibit
Which three actions can be taken to enable the user to insert data? (Choose three.)

A. altering the data file associated with the SMD tablespace to grow automatically

B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file

C. changing segment space management for the SMD tablespace to automatic

D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size

E. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size

Correct Answer:ABD

Question 89

Which three statements are true about adaptive SQL plan management? (Choose three.)

A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

C. It adds new, bettor plans automatically as fixed plans to the baseline.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Correct Answer:ADE
With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non- accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a
persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
Note:
* The optimizer is able to adapt plans on the fly by predetermining multiple subplans for portions of the plan.
* Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final plan decision for a statement until execution time. The optimizer instruments its chosen plan (the default plan) with statistics collectors so that it can detect at runtime, if its cardinality estimates differ greatly from the actual number of rows seen by the operations in the plan. If there is a significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance on the first execution of a SQL statement.

Question 90

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 fil

Correct Answer:ADE

START 1Z0-062 EXAM