单项选择题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

A.increase the undo retention
B.create more undo segments
C.create another undo tablespace
D.increase the size of the undo tablespace

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

A.user tables
B.view segment
C.table segment
D.data dictionary
E.object segment
F.performance tables

点击查看答案
2.单项选择题

You manually create an additional listener process，L1，for databases PROD， 
PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1 
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait... 
TNSLSNR for Linux： Version 10.1.0.2.0 - Production 
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on：
（ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899）） 
TNS-12542： TNS：address already in use TNS-12560： 
TNS：protocol adapter error TNS-00512： Address already in use 
Linux Error： 98： Address already in use 
Listener failed to start. See the error message（s） above... 
What action would you take to overcome this error without disrupting any existing database communications？（）

A.stop and restart the listener process
B.set the TNS_ADMIN environmental variable
C.stop all running listener processes and restart the listener process
D.change the port number to an unused port number and restart the listener process
E.change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

点击查看答案
3.单项选择题In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）

A.%t_%s.dbf
B.arch_%t.arc
C.arch_%d.arc
D.arch_%t_%d.arc
E.arch_%d_%s_.dbf
F.arch_%t_%s_%r.arc

点击查看答案
4.单项选择题Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

A.The operation would fail if tbs_1 were a read-only tablespace.
B.The operation would fail if tbs_1 were a read/write tablespace.
C.The operation would fail if tbs_1 were the default tablespace for the database.
D.If the above operation were successful， media recovery would be required to bring the tablespace online.
E.If the above operation were successful， instance recovery would be required to bring the tablespace online.

点击查看答案
5.多项选择题

The following are the details of your database：Instance name：test 
Host name ： tech1.us.oracle.com IP address：145.33.230.186
Enterprise Manager Console HTTP Port number：5500 
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. 
Which two URLs would you use to access the Database Control？（）

A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em

点击查看答案
6.单项选择题

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

点击查看答案
7.多项选择题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.

点击查看答案
8.单项选择题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.

点击查看答案
9.多项选择题

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

点击查看答案
10.单项选择题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

点击查看答案

最新试题

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 user receives the following error while executing a query：ORA­01555：snapshot too oldWhich two options can be the solutions to avoid such errors in future？（）

题型：多项选择题

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？（）

题型：单项选择题

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？（）

题型：单项选择题

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 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？（）

题型：多项选择题

You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error：  ORA-01081： cannot start - already running ORACLE - shut it down first  Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）

题型：单项选择题

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？（）

题型：单项选择题

Which three statements are true regarding the logical structure of the Oracle database？（）

题型：多项选择题

According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

题型：单项选择题