Oracle Database 11g: New Features for Administrators
Question No: 91
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RC011. You executed the following commands:
RMANgt; CONNECT CATALOG rco11/password@catdb
RMANgt; IMPORT CATALOG rcat1 0/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)
They import all metadata from the RCAT10 catalog.
They unregister the database from the RCAT10 catalog.
They do not register the databases registered in the RCAT10 catalog.
They register all databases registered in the RCAT10 catalog.
Question No: 92
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
failures because a data file is renamed by error
failures when no standby database is configured
failures that require no archive logs to be applied for recovery
failures due to loss of connectivity-for example, an unplugged disk cable
Question No: 93
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name.
Which authentication method would be used first?
authentication by password file
authentication by using certificates over SSL
authentication by using the Oracle Internet Directory
authentication by using the local OS of the database server
Question No: 94
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES) IS
avgsal NUMBER(6); BEGIN
SELECT AVG(SAU\RY)INTO avgsal FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal; END get_dept_avg;
Which statement is true regarding the above function?
The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
If the function execution results in an unhandled exception, the exception result is also stored in the cache.
Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
Question No: 95
View the Exhibit exhibit1 to examine the series of SQL commands.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?
The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
Question No: 96
You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE,
enddate DATE, class CHAR(20))
ON COMMIT DELETE ROWS TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)
It stores only the temporary table but not its indexes.
It stores both the temporary table as well as its indexes.
It must be a nondefault temporary tablespace for the database.
It can be a default or nondefault temporary tablespace for the database.
It must be the default temporary tablespace of the user who issues the command.
Question No: 97
Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)
It repairs blocks that have read disk I/O errors
It checks whether the alias metadata directory and the file directory are linked correctly.
It repairs blocks by always reading them from the mirror copy and writing them to the original location.
It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Question No: 98
Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)
Diagnose and repair a data file corruption offline.
Diagnose and repair a data file corruption online.
Diagnose and repair failures on a standby database.
Recover from failures in the Real Application Cluster (RAC) environment.
Question No: 99
Evaluate the following block of code
acl =gt; lmycompany-com-permissions.xmll1 principal =gt; #39;ACCTJvlGR1,
is_grant =gt; TRUE, privilege =gt; #39;connect#39;);
acl =gt; #39;mycompany-com-permissions.xml#39;, host =gt; quot;.mycompany.com#39;);
What is the outcome of the above code?
It produces an error because a fully qualified host name needs to be specified.
It produces an error because the range of ports associated with the hosts has not been specified.
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
Question No: 100
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?
The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|