NEW QUESTION 1
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.
Which of the following is true regarding your recovery?

• A. You will need to open the database with the resetlogs command.
• B. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C. You will use the resetlogs version of the create controlfile command.
• D. You will use the noresetlogs version of the create controlfile command.
• E. You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

Answer: D

Explanation: Refer to here
CREATE CONTROLFILE Using NORESETLOGS Example
The following CREATE CONTROLFILE statement is generated by an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement for a database with Oracle managed data files and redo log files: CREATE CONTROLFILE

C:UsersalboDesktop1-1.jpg

NEW QUESTION 2
The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:

• A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
• B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
• C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
• D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

Answer: AD

Explanation: Using Oracle Flashback Transaction Query with Oracle Flashback Version Query (link) The query uses Oracle Flashback Version Query pseudocolumns:
SELECT versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN, versions_operation OPERATION, empname, salary
FROM emp
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
WHERE empno = 111; Results are similar to:

C:UsersalboDesktop1-1.jpg 3 rows selected.
The results table rows are in descending chronological order.
✑ The third row corresponds to the version of the row in the table emp that was inserted in the table when the table was created.
✑ The second row corresponds to the row in emp that the erroneous transaction
deleted.
✑ The first row corresponds to the version of the row in emp that was reinserted with a new employee name.

NEW QUESTION 3
Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

• A. restore controlfile
• B. restore database
• C. restore spfile
• D. recover database
• E. alter database open
• F. alter database open resetlogs
• G. b, a, c, d, e
• H. a, c, b, d, f
• I. c, a, b, d, e
• J. c, a, b, d, f
• K. e, a, b, d, c

Answer: D

NEW QUESTION 4
Which of the following is a benefit of ASM fast disk resync?

• A. Failed disks are taken offline immediately but are not dropped.
• B. Disk data is never lost.
• C. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
• D. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
• E. Hot spare disks are automatically configured and added to the disk group.

Answer: A

Explanation: ASM Fast Mirror Resync

NEW QUESTION 5
What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?

• A. It improves resync operations.
• B. This feature enables much faster file opens.
• C. It improves performance as fewer extent pointers are needed in the shared pool.
• D. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Explanation: Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from an extent that is closest to the node, even if that extent is a secondary extent. In other words, you can configure Oracle ASM to read from a secondary extent if that extent is closer to the node instead of Oracle ASM reading from the primary copy which might be farther from the node. Using the preferred read failure groups feature is most useful in extended clusters.

NEW QUESTION 6
In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

• A. VARCHAR2
• B. CHAR
• C. NVARCHAR2
• D. CLOB
• E. LONG

Answer: C

NEW QUESTION 7
If a backup set is expired, what can you do to correct the problem?

• A. Change the retention criteria.
• B. Make the lost backup set pieces available to RMAN again.
• C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
• D. Nothin
• E. The backup set piece is lost forever.
• F. Call Oracle support, their assistance is required.

Answer: B

NEW QUESTION 8
Which of the following statements is true regarding the VERSIONS BETWEEN clause?

• A. The VERSIONS BETWEEN clause may be used in DML statements.
• B. The VERSIONS BETWEEN clause may be used in DDL statements.
• C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Answer: C

NEW QUESTION 9
If a job references a schedule that has been disabled, what will be the result?

• A. The job will be automatically disabled.
• B. The job will never execute.
• C. The job will attempt to execute but will fail.
• D. The job will inherit the DEFAULT_SCHEDULE schedule.
• E. A schedule object cannot be disabled.

Answer: E

NEW QUESTION 10
Which package provides API's for the SQL Tuning Advisor?

• A. DBMS_MONITOR
• B. DBMS_STATS
• C. DBMS_SQLTUNE
• D. DBMS_ADVISOR

Answer: C

Explanation: View the Exhibit 1.
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US."
View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table.
What can you do to make the optimizer detect the actual selectivity? desc-customers_obe (exhibit):

C:UsersalboDesktop1-1.jpg
sql-select-customers_obe (exhibit):

C:UsersalboDesktop1-1.jpg
A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
B. Set the STATISTICS_LEVEL parameter to TYPICAL.
C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE. Answer: C
Real example refer to here. Determining Single Column Statistics
A good example of correlated or related columns are the country_id and cust_state_province columns in the CUSTOMERS_OBE table. When the value of cust_state_province is 'CA' , the value of country_id is 'US'. There is a skew in the data in these two columns, which means the majority of rows in the table have the values 'CA' and 'US'. Both the relationship between the columns and the skew in the data make it difficult for the optimizer to calculate the selectivity or cardinality of these columns correctly when they are used together in a query. Extended statistics should help in this situation.

NEW QUESTION 11
Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)

• A. Make sure your replay database has the same structure as the capture database, except without data.
• B. Make sure the replay and capture databases are similar in data content.
• C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.
• D. Start the capture database in UNRESTRICTED mode, then start the capture.
• E. Define inclusion and exclusion filters.

Answer: BC

NEW QUESTION 12
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

• A. It can be used to back up all data on ASM disks.
• B. It can be used to recover the damaged ASM disk group along with the data.
• C. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
• D. It can be used to re-create the ASM disk group with its attributes.

Answer: CD

NEW QUESTION 13
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?

• A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
• B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
• C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
• D. There is no ASM_POWER_LIMIT setting used in ASM.
• E. None of the above

Answer: C

NEW QUESTION 14
If a log file becomes corrupted, it may cause the database to stale. How would you correct such a situation?

• A. Recover the online redo log from backup.
• B. Delete and re-create the log file.
• C. Use the ALTER DATABASE CLEAR LOGFILE command to clear the log file.
• D. Shut down the database and restart it.
• E. Shut down the database and then mount i
• F. Clear the log file with the ALTER DATABASE CLEAR LOGFILE command and then restart the database with ALTER DATABASE OPEN RESETLOGS.

Answer: C

Explanation: If you don't use the ALTER DATABASE CLEAR LOGFILE command to clear log online, after the database restarted, the log file will be INVALID.
So the simple way is to clear the log file directly.

NEW QUESTION 15
What is the danger associated with stopping a running job by using the STOP_JOB procedure?

• A. The job will need to be reenabled before it will execute again.
• B. The job may hold locks on objects referenced within it.
• C. All jobs within the job group will also be stopped.
• D. The job may leave data in an inconsistent state.
• E. There is no danger in using the STOP_JOB procedure.

Answer: D

NEW QUESTION 16
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:
1. Put the tablespaces in backup mode.
2. Back up the datafiles for all tablespaces.
3. Take the tablespaces out of backup mode.
4. Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?

• A. The plan will work as is.
• B. The plan needs to be modified to allow for an archive-log switch after step 3.
• C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
• D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
• E. The plan cannot work as presented.

Answer: B

Explanation: Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will be useless.

NEW QUESTION 17
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

• A. set SHARED_POOL_SIZE to zero
• B. set STATISTICS_LEVEL to BASIC
• C. set SGA_TARGET to a non-zero value
• D. set DB_CACHE_SIZE to a non-zero value
• E. set STATISTICS_LEVEL to TYPICAL or ALL

Answer: AC

NEW QUESTION 18
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

• A. ALTER DATABASE FLASHBACK ON;
• B. GRANT SELECT ANY TRANSACTION TO scott;
• C. GRANT EXECUTE ON dbms_flashback TO scott;
• D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
• E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
• F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Answer: BCDF

NEW QUESTION 19
Note the following parameters settings in your database:

You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?

• A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
• B. It will be successful only if the memory is available from the auto tuned components
• C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
• D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated withinSGA_MAX_SIZE

Answer: D

Explanation: This is an actually mathematic question.

NEW QUESTION 20
Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?

• A. CREATE_MAPPING_PRIORITY
• B. SET_MAPPING_PRIORITY
• C. SET_MAPPING_ORDER
• D. PRIORITIZE_MAPPING_ORDER
• E. This functionality is not available through the DBMS_RESOURCE_MANAGER package.

Answer: B