单项选择题

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.
Which action would you consider to overcome the performance degradation？（）

A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which three statements are true regarding the logical structure of the Oracle database？（）

A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.

点击查看答案
2.多项选择题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
D.The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

点击查看答案
3.多项选择题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table

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

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

点击查看答案
5.单项选择题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.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

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

A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual

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

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

A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer

点击查看答案
8.单项选择题One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

A.execute the command， ALTER SESSION KILL ..， to kill the blocking session
B.execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
C.execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
D.execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
E.execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

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

A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH

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

While setting up the database for your production environment， you want to create a user with following requirements.  
1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.  
2.The user should be able to use 10MB of space in the tablespace TBS1.  
3.The user must change the password immediately after logging in for the first time.  
Which three options of the CREATE USER command would you use to achieve this objective？（）

A.profile
B.account lock
C.account unlock
D.password expire
E.quota 10MB on TBS1
F.password never expire
G.default tablespace TBS1
H.quota unlimited on TBS1
I.temporary tablespace TEMP
J.temporary tablespace SYSTEM

点击查看答案

最新试题

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）

题型：单项选择题

You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

题型：多项选择题

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting？（）

题型：单项选择题

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 execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command？（）

题型：单项选择题

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

题型：多项选择题

Which two are valid locking levels that are used by transactions in an Oracle database？（）

题型：多项选择题

While setting up the database for your production environment， you want to create a user with following requirements.  1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.  2.The user should be able to use 10MB of space in the tablespace TBS1.  3.The user must change the password immediately after logging in for the first time.  Which three options of the CREATE USER command would you use to achieve this objective？（）

题型：多项选择题

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.Which action would you consider to overcome the performance degradation？（）

题型：单项选择题

The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）

题型：单项选择题