as3

1.

1 point

QUESTION 501
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?
(Choose two.)

The plan baselines can be evolved over time to produce better performance.

The newly generated plans are directly placed into the SQL plan baseline without being verified.

The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

2.

1 point

QUESTION 477
The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between
each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The
BOOKINGS
table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is
accessible in
24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS
table

Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially

Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command

Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command

3.

1 point

QUESTION 499
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

4.

1 point

QUESTION 523
Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?

only encryption and compression settings for all SecureFile LOBs

only encryption and deduplication settings for only SecureFile CLOBs

deduplication, encryption, and compression settings for all SecureFile LOBs

deduplication, encryption, and compression settings only for SecureFile CLOBs

5.

1 point

QUESTION 509
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

It returns space usage of only BasicFile LOB chunks.

It returns space usage of only SecureFile LOB chunks.

It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

6.

1 point

QUESTION 493
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.

7.

1 point

QUESTION 494
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?

Segment Advisor

SQL Access Advisor

Undo Advisor

SQL Tuning Advisor

8.

1 point

QUESTION 500
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the
PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?

1, 4, 5, 2, 3

1, 4, 3, 2, 5

4, 5, 2, 3, 1

2, 3, 4, 5, 1

1, 4, 2, 3, 5

9.

1 point

QUESTION 506
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. 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 RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

The scripts in the RCO11 catalog are overwritten.

RMAN renames the local stored scripts in the RCO11 catalog.

The RMAN session in which the command is executed aborts.

RMAN renames the global scripts that are imported from the RCAT10 catalog.

10.

1 point

QUESTION 495
Which statement about using RMAN stored scripts is true?

To create and execute an RMAN stored script, you must use a recovery catalog.

When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

11.

1 point

QUESTION 503
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one
redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?

ALTER DATABASE DROP LOGFILE GROUP 1;

ALTER DATABASE CLEAR LOGFILE GROUP 1;

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

12.

1 point

QUESTION 488
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity?

ASM_POWER_LIMIT

ASM_DISKSTRING

ASM_DISKGROUPS

INSTANCE_TYPE

13.

1 point

QUESTION 512
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.
After some days, you want to change the status of the database backup and you issued the following
command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?

The backup is deleted.

The backup is marked unavailable.

The backup overrides the backup retention policy.

the backup becomes eligible for deletion according to the existing retention policy

14.

1 point

QUESTION 481
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user
managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?

You must have change tracking enabled in your database

Your database must be running in NOARCHIVELOG mode

To back up a tablespace, it must be in backup mode

To back up a tablespace, it must first be taken offline

15.

1 point

QUESTION 517
The INV_HISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition
by range (inv_date) interval (numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than (to_date('01-01-2006','dd-
mm-yyyy')));
The following data has been inserted into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-
mar-2006 4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006'))
INTO PARTITION sys_py;
What would be the outcome of this command?

It executes successfully, and the transition point is set to '1-apr-2006'.

It executes successfully, and the transition point is set to '15-apr-2006'.

It produces an error because the partitions specified for merging are not adjacent.

It produces an error because the date values specified in the merge do not match the date values stored in the table.

16.

1 point

QUESTION 507
You need to configure fine-grained access control to external network resources from within your database.
Youcreate an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

It is a list of remote database links stored in the XML file that are available to the users of the database.

It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.

It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

17.

1 point

QUESTION 490
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

ORACLE_BASE should be set explicitly.

An Oracle base should have only one Oracle home created in it.

Flash recovery area and data file location should be on separate disks.

Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

18.

1 point

QUESTION 519
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?

It remains valid.

It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.

It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.

It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

19.

1 point

QUESTION 480
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
View exhibit

The COMMIT order in the captured workload is preserved during replay.

The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

20.

1 point

QUESTION 496
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?

to minimize plan regression due to the use of a new optimizer version

to completely avoid the use of new plans generated by a new optimizer version

to prevent plan capturing when the SQL statement is executed after the database upgrade

to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

21.

1 point

QUESTION 508
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

It cannot be done in parallel.

It can be done at the table level or partition level.

It does not require additional storage because the operation is done online.

Local and global indexes are maintained automatically during the operation.

22.

1 point

QUESTION 486
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

All archived redo log files backed up at least twice to tape are deleted.

All archived redo log files backed up at least once to tape are eligible for deletion.

All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

23.

1 point

QUESTION 483
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270MWhich two statements are true regarding these parameters after the database instance is restarted? (Choose
two.)

The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

24.

1 point

QUESTION 484
Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products (product_id NUMBER(3) PRIMARY KEY, product_desc VARCHAR2(25), qty
NUMBER(8,2), rate NUMBER(10,2), total_value AS ( qty * rate)) PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000), PARTITION p2 VALUES LESS THAN
(150000), PARTITION p3 VALUES LESS THAN (MAXVALUE)) COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?

It executes successfully but partition pruning cannot happen for this partition key.

It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

25.

1 point

QUESTION 521
You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.
What are the prerequisites for performing the active database duplication? (Choose all that apply.)

The source database backup must be copied over the net for test database.

The source database must be run in ARCHIVELOG mode if the database is open.

The source database must be shut down cleanly if the database is in mounted state.

A net service name should be set up and a listener configured with the target as well as the source database.

26.

1 point

QUESTION 516
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time
Recovery (TSPITR). But before you start the recovery, you queried theTS_PITR_OBJECTS_TO_BE_DROPPED
view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.
You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?

Perform Export before TSPITR and Import after TSPITR

Move objects to another schema that has the same tablespace assigned

Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

27.

1 point

QUESTION 522
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS tableusing the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?

disabling the index

making the index invisible

making the index unusable

using the MONITORING USAGE clause for the index

28.

1 point

QUESTION 479
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?
(Choose all that apply.)

generating the SQL profile

testing and accepting the SQL profile

generating a list of candidate SQLs for tuning

adding tuned SQL plans into the SQL plan baseline

tuning each SQL statement in the order of importance

generating baselines that include candidate SQLs for tuning

29.

1 point

QUESTION 504
Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)

a job

a program

a schedule

a PL/SQL procedure

30.

1 point

QUESTION 515
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?

They execute and create a virtual catalog for pre-Oracle 11g clients.

They produce an error because PROD1 and PROD2 databases belong to the older version.

They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

They produce an error because you need to connect to the target database to execute this packaged procedure.

31.

1 point

QUESTION 510
Consider the following scenario for your database:-Backup optimization is enabled in RMAN.
The recovery window is set to 7 days in RMAN.
The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?

The RMAN backup fails because the TOOLS tablespace is read-only

The RMAN skips the backup of the tablespace because backup optimization is enabled

The RMAN makes backup because optimization can be enabled only for backups to disk

The RMAN makes the backup because no backup of the tablespace exists within the seven day window

32.

1 point

QUESTION 485
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.
What is the reason for this error?
View exhibit

Another repair session is running concurrently.

The failure ID has not been mentioned in the command for data file 5.

There are new failures recorded in the Automatic Diagnostic Repository (ADR).

The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

33.

1 point

QUESTION 502
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

The collection level for the AWR should be set to BASIC.

The moving window size must be less than Undo Retention.

The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.

The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

34.

1 point

QUESTION 514
Which two statements are true regarding hot patching? (Choose two.)

It requires relinking of the Oracle binary.

It does not require database instance shutdown.

It can detect conflicts between two online patches.

It is available for installing all patches on all platforms.

It works only in a single database instance environment.

35.

1 point

QUESTION 487
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?

The LOB values are automatically compressed.

The LOB values are cached by default in the buffer cache.

The LOB values are automatically stored in encrypted mode.

All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

36.

1 point

QUESTION 520
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.
Which two statements are true based on the output? (Choose two.)
View exhibit

An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error

A user belonging to DSS_QUERIES can log in to a new session but the session will be queued

The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management

The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention

37.

1 point

QUESTION 476
The following command is executed to create the baseline template:
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4',
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

It creates a baseline template that never expires.

It produces an error because no snapshot information is provided to create the baseline.

It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

38.

1 point

QUESTION 505
Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)

Health Check was performed manually.

Health Check was performed to check the disk image block corruptions.

Health Check was performed to check interblock and intersegment corruption.

Health Check was performed to verify the integrity of database files and report failures.

Health Check was performed by the Health Monitor automatically in response to a critical error.

39.

1 point

QUESTION 491
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

The data is decrypted during SORT and JOIN operations.

The data remains encrypted when it is read into memory.

The data remains encrypted when it is stored in the redo logs.

The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

40.

1 point

QUESTION 492
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc.
Which two statements are true regarding this oranfstab file? (Choose two.)

Its entries are specific to a single database.

It contains file systems that have been mounted by Direct NFS.

It is globally available to all Oracle 11g databases on the machine.

It contains file systems that have been mounted by the kernel NFS system.

41.

1 point

QUESTION 518
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?

Add a finding directive for the ADDM task.

Add a segment directive for the ADDM task.

Add a parameter directive for the ADDM task.

Disable the Segment Advisor from the Automatic Maintenance Task.

42.

1 point

QUESTION 478
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.

43.

1 point

QUESTION 498
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

It updates the existing SQL profiles with current statistics.

It makes the statistics information available to GATHER_STATS_JOB.

It initiates the statistics collection process by running GATHER_STATS_JOB.

It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

44.

1 point

QUESTION 525
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

Drop the table.

Partition the table

Truncate the table.

Add a column to the table.

Rename a column in the table.

45.

1 point

QUESTION 513
View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?
View exhibit

because AWR baseline is not enabled

because Current Open Cursors Count is not a basic metric

because the STATISTICS_LEVEL parameter is set to BASIC

because the AWR baseline is a system-defined moving window baseline

46.

1 point

QUESTION 489
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan toduplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?

It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

47.

1 point

QUESTION 511
View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric?
View exhibit

Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.

The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.

Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.

The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

48.

1 point

QUESTION 497
View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?
View exhibit

The index is not used by the optimizer but is maintained during DML operations.

The index is not used by the optimizer and is not maintained during DML operations.

The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.

The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

49.

1 point

QUESTION 524
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

ADR diagnostic files

all the optimizer statistics

initialization parameter settings

PL/SQL functions, procedures, and packages

the table and index definitions and actual data

50.

1 point

QUESTION 482
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization
parameter is
set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the
COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

The ASM-preferred mirror read feature is enabled.

The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

The ASM disk is dropped immediately from a disk group when it becomes unavailable.

The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.