You&ensp;find&ensp;today’s&ensp;...

单项选择题 You find today’s performance of your production database to be the best ever.
Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

A.A
B.B
C.C
D.D
E.E

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）

A.Use only the first address.
B.Try one address，selected at random.
C.Try each address，in order，until one succeeds.
D.Try each address，randomly，until one succeeds.

点击查看答案

2.单项选择题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？（）

A.SMON would automatically restore the lost file.
B.You would need to restore the whole database from the last backup.
C.You would need to restore the file from the last full database backup.
D.You would need to use flashback technology to restore the lost redo log member.
E.You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
F.You would need to restore the missing log file by copying one of the remaining files from the same group.

点击查看答案

3.多项选择题 You decided to increase the value for the SHARED_SERVERS parameter by using the following command：
SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；
Which three values can be specified for the SCOPE clause？（）

A.ALL
B.PFILE
C.BOTH
D.NONE
E.SPFILE
F.MEMORY
G.INSTANCE
H.DATABASE

点击查看答案

4.单项选择题You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）

A.Oracle Management Agent
B.Enterprise Manager with Grid Control
C.Enterprise Manager with Database Control
D.Operating System Socket for incoming requests
E.Real Application Cluster （RAC） with three instances
F.Enterprise Manager with Generic Database Management

点击查看答案

5.单项选择题You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）

A.SQL script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script

点击查看答案

6.多项选择题 Exhibit：
View the Exhibit to see the data in the emp table.
You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？（）

A.No index would be created or used in this case.
B.A unique index on the empno column would be created.
C.A CHECK constraint would be enforced on the empno column.
D.A NOT NULL constraint would be enforced on the empno column.
E.A bitmap unique index would be created on the empno column.

点击查看答案

7.多项选择题 You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

A.set PCTFREE and PCTUSED to 50
B.specify extent allocation as Uniform
C.specify extent allocation as Automatic
D.create the tablespace as bigfile tablespace
E.create the tablespace as smallfile tablespace
F.set segment space management to Automatic
G.use the RESIZE clause while creating the tablespace

点击查看答案

8.单项选择题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

A.flash back the database
B.perform point-in-time recovery
C.perform a full database recovery
D.drop and re-create the tablespace
E.use Recovery Manager （RMAN） to recover the database

点击查看答案

9.多项选择题 our database is in the MOUNT state and you execute the following command to open it：
ALTER DATABASE OPEN
What two actions are performed as a result of this command？（）

A.All control files are opened.
B.All redo log files are opened
C.The password file is opened.
D.The parameter file is opened.
E.All online data files are opened.

点击查看答案

10.单项选择题Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener， database， and the configuration of the application. How would you avoid this scenario？（）

A.lock the listener
B.hide the listener
C.create multiple listeners
D.run listener on a remote client
E.set a password for the listener
F.store listener.ora in a non-default location

点击查看答案