You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database：
1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur（）
A.7， 1， 5， 2， 3， 6， 4
B.1， 2， 3，7， 5， 6， 4
C.7， 1， 4， 5， 2， 3， 6
D.1， 7， 5， 4， 2， 3， 6
您可能感兴趣的试卷
你可能感兴趣的试题
The instance abnormally terminates because of a power outage.
Which statement is true about redo log filesduring instance recovery（）
A.Inactive and current redo log files are required to accomplish recovery.
B.Online and archived redo log files are required to accomplish instance recovery.
C.All redo log entries after the last checkpoint are applied from redo log files to data files.
D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
Examine the command：
SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；
Which statementdescribes the effect of the above command（）
A.Automatic statistics collection is stopped for the CUSTOMERS table.
B.Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C.Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D.Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
You are installing Oracle Database 11g on a machine. When you run the installer， the Oracle Universal Installer（OUI） shows the message that says one of the product-specific prerequisite checks has failed：Checking available swap space requirements ...Expected result： 1512MBActual Result： 1018MB
Check complete. The overall result of this check is： Failed <<<< Problem： The system does not have therequired swap space.
What happens to the installation in this situation（）
A.It can be continued.
B.It resizes the swap space automatically when you proceed further.
C.It can be continued， but the instance cannot be started without increasing the swap space.
D.It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI）
prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.
Which statement is true in this case（）
A.The ORACLE_BASE parameter is not set.
B.The installation is being performed by the root user.
C.The operating system group that will be specified should have root user as its member.
D.The installation is being performed without the "Create Starter Database" option selected.
E.The operating system group that will be specified must have permission to write to the inventory directory
You want to create a role to meet these requirements：
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
method would you use to restrict enabling of such roles（）
A.Create the role with external authentication.
B.Create the role as a secure application role.
C.Create the role as a password-protected role.
D.Create a role and use Fine-Grained Access Control （FGAC） to secure the role
You have executed this command to change the size of the database buffer cache：
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582；
System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE
------------------- ----------- ------------------ db_cache_size big integer 4194304
Why is the value set to 4194304 and not to 2516582（）
A.Because 4194304 is the granule size
B.Because 4194304 is the standard block size
C.Because 4194304 is the largest nonstandard block size defined in the database
D.Because 4194304 is the total size of data already available in the database buffer cache
You notice that the performance of the database has degraded because of frequent checkpoints.
Which twoactions resolve the issue（）
A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.
Examine the command：
SQL> ALTER USER skd ACCOUNT LOCK；
Which two statements are true after the command is executed（）
A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user， on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in
You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.
Which option of IMPDP would you use to accomplish this task（）
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is trueabout the output of the command（）
A.The backup piece is expired as the new backup is available.
B.The backup piece is expired because the operating-system file was not found.
C.The backup piece is expired because the retention period for the backup has expired.
D.The backup piece is expired because the backup set to which it belongs is not complete
最新试题
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error（）
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95Which background process is responsible for issuing alerts when the threshold is crossed（）
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（）
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
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（）
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）
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（）
Which statements regarding the server parameter file （SPFILE） are true（）
Which statements are true regarding a tablespace（）
Which statements are true regarding listeners（）