A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
您可能感兴趣的试卷
你可能感兴趣的试题
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.
Which two statements are true in this scenario？（）
A.The instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup.
A.The backup is similar to image copy.
B.The backup contains all used data blocks.
C.The backup contains only unused data blocks.
D.The backup contains all data blocks changed since the last incremental level 1 backup.
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.
What action would you take to achieve this？（）
A.Use the Database Resource Manager.
B.Set the limits in the profiles used by users.
C.Modify the SESSIONS initialization parameter.
D.Set the warning threshold for the Current Logons Count metric.
A.by using the SQL access advisor
B.by using the Automatic Workload Repository report
C.by running the Automatic Database Diagnostic Monitor （ADDM）
D.by using the Automatic Workload Repository Compare Period report
E.by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.
What action would you take to achieve this task？（）
A.Set the STATISTICS_LEVEL initialization parameter to ALL.
B.Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.
C.Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
A.The optimizer statistics are collected automatically.
B.Only the timed operating system （OS） statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
A.when performing export and import using Oracle Data Pump
B.when performing backup and recovery operations using Oracle Recovery Manager
C.when performing batch processing and bulk loading operation in a data warehouse environment
D.in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance？（）
A.The sessions are able to perform only queries.
B.The sessions are not affected and continue to function normally.
C.The active transactions are rolled back and the sessions get terminated.
D.The sessions are not allowed to perform any operations till the listener is started.
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database：
REMOTE_OS_AUTHENT = TRUE
What could have been the reason to set this parameter as TRUE？（）
A.to enable operating system authentication for a remote client
B.to restrict the scope of administration to identical operating systems
C.to allow the start up and shut down of the database from a remote client
D.to enable the administration of the operating system from a remote client
E.to disable the administration of the operating system from a remote client
A.More than one database is to be registered with the listener.
B.The users will connect the database by using the host naming method.
C.The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D.The database that is to be registered with the listener is configured in shared server mode.
E.The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
最新试题
According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（）
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）