Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-062

Free Oracle 1Z0-062 Exam Questions (page: 6)

Page 6 of 87
PDF with 419 Questions

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

  1. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
  2. It fails and reports an error because the CONTAINER=ALL clause is not used.
  3. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
  4. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
  5. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer(s): A

Explanation:

REVOKE ..FROM
If the current container is the root:
/ Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with CONTAINER = ALL.
/ Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.
If you omit this clause, then CONTAINER = CURRENT is the default.



You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

  1. 2, 1, 3, 4, 5, 6
  2. 1, 3, 4, 5, 6, 7
  3. 1, 4, 3, 5, 6, 7
  4. 2, 1, 3, 4, 5, 6, 7
  5. 1, 5, 6, 4, 3, 2

Answer(s): C

Explanation:

1. Set user tablespaces in the source database to READ ONLY.
2. From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:
3. Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.
4. Create a COB on the destination system, including a PDB into which you will import the source database.
5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB Oracle White Paper - Upgrading to Oracle Database 12c -August 2013



The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?

  1. connecting by using an external naming method
  2. connecting by using the easy connect method
  3. creating a service in the database by using the DBMS_SERVICE.CREATE_SERVICE procedure and using this service for creating a local naming service
  4. connecting by using the local naming method with the SERVER = DEDICATED parameter set in the tnsnames.ora file for the net service
  5. connecting by using a directory naming method

Answer(s): D



Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

  1. shutting down the database instance that is being upgraded
  2. executing the catctl.pl script to run the upgrade processes in parallel
  3. running the Pre-Upgrade Information Tool
  4. copying the listener.ora file to the new ORACLE_HOME

Answer(s): C


Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395



Viewing page 6 of 87



Post your Comments and Discuss Oracle 1Z0-062 exam prep with other Community members:

1Z0-062 Exam Discussions & Posts