A.You can add SQL test cases to the incident package.
B.You can add or remove the trace files to the package.
C.You cannot create an incremental incident package when the physical files are purged from the ADR.
D.You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
您可能感兴趣的试卷
你可能感兴趣的试题
You want to check the details of few errors that users have reported. You search for the alert log file andexecute few commands to find the location of the alert log file. View the Exhibit and check the commandsexecuted.
What is the location of the alert_orcl.log file()
A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.
Which is the most effectivemethod to access this data in your database()
A.Use the database link.
B.Use the SQL*Loader utility.
C.Use the Oracle Data Pump utility.
D.Create an external table and leave the data in the flat file
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation()
A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction
Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2. The SKD user creates a table.
3. The SKD user grants the CREATE TABLE system privilege to the HR user.
4. The HR user creates a table.
5. The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 isperformed()
A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain, but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
A.The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D.The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1
View the Exhibit and identify the component marked with a question mark.()
A.Checkpoint (CKPT)
B.Process Monitor (PMON)
C.Archiver Processes (ARCn)
D.Recoverer Process (RECO)
E.Memory Manager process (MMAN)
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0
Which two will be the implications of these values in your database()
A.The SGA advisor will be disabled.
B.The MTTR advisor will be disabled.
C.Automatic checkpoint tuning will be disabled.
D.Checkpoint information will not be written to the alert log file.
View the Exhibit to observe the roles assigned to the SL_REP user.
Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user()
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()
A.The backup will consist of used data blocks only.
B.The database must be shut down to accomplish the backup.
C.The backup can be accomplished without shutting down the database.
D.The backup will contain all database files that have never been backed up
View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the userSKD by executing the command:
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;
Which statement is true about the user SKD afterhe/she is granted this role()
A.The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it.
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privilegesfrom them
最新试题
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements aretrue regarding the above command()
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:ERROR at line 1:ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario()
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
Identify the situations in which you use the alert log file in your database to check the detail.()
Which statement is true about loading data using the conventional path of SQL*Loader()
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command()