From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective?()
第1题:
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
第2题:
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 the TS_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?()
第3题:
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?()
A.A
B.B
C.C
D.D
第4题:
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()
第5题:
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?()
第6题:
In which scenario do you use the Flashback Database feature?()
第7题:
For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()
第8题:
From the V$SESSION_LONGOPS view, you find that some of the database users have long/x7frunning queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()
第9题:
You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()
第10题:
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace: 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery: Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery: Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery: Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen?()