Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Question No: 71
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges?
Create the create_test procedure with definer#39;s rights.
Grant the execute privilege to users with grant option on the create_test procedure.
Create the create_test procedure with invoker#39;s rights.
Create the create_test procedure as part of a package and grant users the execute privilege on the package.
Question No: 72
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE鈥SID = [oracle] ? cdb1
The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
$ rman target /
Recovery Manager : Release 184.108.40.206.2 – production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327) RMANgt;SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
It succeeds and displays all the tablespaces that belong to the root database.
It fails and returns an error because a connection is not made by using the sysdba privilege.
It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Question No: 73
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user.
The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
RKANgt; CONNECT CATALOG rci2c/passI2c@catdbi2c
RKANgt; IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?
It fails because the target database and recovery catalog database are of different versions.
It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
It succeeds but the database is not automatically registered in the rc:2c catalog.
It fails because RMAN is not connected to the target database with r3:T=:42324:.
Question No: 74
You notice a performance change in your production Oracle 12c database. You want to knowwhich change caused this performance difference.
Which method or feature should you use?
Compare Period ADDM report
AWR Compare Period report
Active Session History (ASH) report
taking a new snapshot and comparing it with a preserved snapshot
Question No: 75
Examine the RMAN command:
RMANgt; SET ENCRYPTION IDENTIFIEDBY lt;passwordgt; ON FOR ALL TABLESPACES; RMANgt; BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
Answer: A Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password -encrypted backups)
Question No: 76
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
whenthe duplicate … from active database command contains the section size clause
when you perform active database duplication on a database with flashback disabled
when you specify set encryption before the duplicate … from active database command
when the number of auxiliary channels allocated is equal to or greater than the number of target channels
when you perform active database duplication on a database that has read- onlytablespaces
Question No: 77
For which two requirements would you use the Database Resource Manager?
limiting the CPU used per database call
specifying the maximum number of concurrent sessions allowed for a user
specifying the amount of private space a session can allocate in the shared pool of the SGA
limiting the degree of parallelism of operations performed by a user or group of users
specifying an idle time limit that applies to sessions that are idle and blocking other sessions
Question No: 78
You are administering a multitenant container database (CDB) cdb1. Examine the command and itsoutput:
db_create_file_deststring db_file_name_convertstring db_filesinteger200
You verify that sufficient disk space is available and that nofile currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb#39; location.
You plan to create a new pluggable database (PDB) by using the command: SQLgt;CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password ROLES=(dba)
DATAFILE#39; /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND ON
PATK_PREFIX=#39;/u01/app/oracle/oradata/cdb1/SALESPDB#39;; Which statement is true?
SALESPDB is created and is in mount state.
PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
SALESPDB is created and is in read/write mode.
PDB creation fails because a defaulttemporary tablespace is not defined for SALESPDB.
Question No: 79
Which two statements are true about Flashback Version Query?
The result of a query can be used as part of a DML statement.
It can be used to create views.
It can be used only if Flashback Data Archive is enabled for a table.
It retrieves all versions of rows that exist in a time interval, including the start time and end time.
It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
Question No: 80
You execute the RMAN commands:
RMANgt; BACKUP VALIDATE DATABASE; RMANgt; RECOVER CORRUPTION LIST;
Which task is performed by these commands?
Corrupted blocks, if any, are repaired in the backup created.
Only those data files that have corrupted blocks are backed up.
Corrupted blocks in the data files are checked and repaired before performing the database backup.
The database is checked for physicallycorrupt blocks and any corrupted blocks are repaired.
Explanation: When you run BACKUP VALIDATE, RMAN reads the files to be backed up in their entirety, as it does during a real backup. RMAN does not, however, actually produce any backup sets or image copies.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|