Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 151:

  Which two statements are true about a common user? (Choose two.)

  A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
  B. A common user with the create user privilege can create other common users, as well as local users.
  C. A common user can be granted only a common role.
  D. A common user can have a local schema in a PDB.
  E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
  B. A common user with the create user privilege can create other common users, as well as local users.
  D. A common user can have a local schema in a PDB.

• Question 152:

  Examine the following set of RMAN commands: Which statement is true about the RMAN run block execution?

  

  A. The script is executed and both DC1 and CH1 channels are used for script execution.
  B. The execution of the script fails because multiple channels cannot exist simultaneously.
  C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
  D. The new channel, CH1, is ignored because a channel has been configured already.
  C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

• Question 153:

  Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

  A. Use PDB$SEED for creating a PDB.
  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
  C. Clone an existing PDB.
  D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
  E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.
  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
  C. Clone an existing PDB.
  D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.

• Question 154:

  You have a production Oracle 12c database running on a host.

  You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c

  database.

  The steps in random order:

  1.

  Create directory structures similar to the production database on all new machines.

  2.

  Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3.

  Create a database clone template for the database.

  4.

  Run the Database Configuration Assistant (DBCA) to create the database.

  5.

  Run OUI in graphical mode on each machine.

  6.

  Run OUI in silent mode using the OUI response file.

  Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

  A. 2, 1, 6, and 4
  B. 2, 3, and 6
  C. 3, 1, 5, and 6
  D. 2, 3, 1, and 6
  E. 1, 5, and 4
  D. 2, 3, 1, and 6

• Question 155:

  Which four actions are possible during an Online Datafile Move operation? (Choose four.)

  A. Creating and dropping tables in the datafile being moved
  B. Performing file shrink of the data file being moved
  C. Querying tables in the datafile being moved
  D. Performing Block Media Recovery for a data block in the datafile being moved
  E. Flashing back the database
  F. Executing DML statements on objects stored in the datafile being moved
  A. Creating and dropping tables in the datafile being moved
  C. Querying tables in the datafile being moved
  D. Performing Block Media Recovery for a data block in the datafile being moved
  F. Executing DML statements on objects stored in the datafile being moved

• Question 156:

  One of your database suffered an instance failure.

  At the next startup, from which point in the redo logs does instance recovery begin?

  A. from a point corresponding to the most recent successful transaction commit
  B. from a point corresponding to the most recent log instance checkpoint
  C. from a point corresponding to the most recent incremental checkpoint
  D. from a point corresponding to the most recent checkpoint of any kind
  E. from a point corresponding to the most recent log switch checkpoint
  A. from a point corresponding to the most recent successful transaction commit

• Question 157:

  A user issues a query on the sales table and receives the following error: ERROR at line 1:

  ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status

  Which two actions would you take to recover the temporary tablespace? (Choose two.)

  A. Drop the tenp01.dbf file, and then re-create the temp file.
  B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
  C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
  D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
  E. Create a new temporary tablespace and assign it as the default to the user.
  B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
  E. Create a new temporary tablespace and assign it as the default to the user.

• Question 158:

  Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

  A. maximum undo per consumer group
  B. maximum idle time for a session in a PDB
  C. parallel server limit
  D. CPU
  E. maximum number of sessions for a PDB
  C. parallel server limit
  D. CPU

• Question 159:

  The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps:

  1.

  Set the evolve task parameters.

  2.

  Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

  3.

  Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

  4.

  Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

  5.

  Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

  A. 2, 4, 5
  B. 2, 1, 4, 3, 5
  C. 1, 2, 3, 4, 5
  D. 1, 2, 4, 5
  B. 2, 1, 4, 3, 5

• Question 160:

  You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task:

  1.

  Place all user-defined tablespaces in read-only mode on the source database.

  2.

  Use the RMAN convert command to convert data files to the target platform's endian format, if required.

  3.

  Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=Y.

  4.

  Transport the data files for all the user-defined tablespaces.

  5.

  Transport the export dump file to the target database.

  6.

  Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.

  7.

  Perform an import on the target database by using the full and TRANSPORT_DATAFILES parameters. Identify the minimum required steps in the correct order.

  A. 1, 3, 5, 4, 2, and 7
  B. 1, 2, 4, 6, 5, 3 and 7
  C. 2, 4, 5, 3 and 7
  D. 1, 4, 5, 2 and 6
  E. 3, 5, 4, 2, and 7
  A. 1, 3, 5, 4, 2, and 7