As a database administrator you spend a lot of time observin

第1题：

第2题：

How（）time are you going to spend with me?

Amany

Blot

Cmuch

第3题：

第4题：

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

• A、Coalesce the application tables at a regular interval.
• B、Export and Import the application tables a regular interval.
• C、Drop and recreate the application tables at a regular interval.
• D、Move the application tables to a tablespace with less space usage.
• E、Distribute the application tables across multiple tablespaces depending on usage.
• F、Move the application tables to automatic segment space management tablespace.

第5题：

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、Memory Advisors
• B、Segment Advisors
• C、SQL Tuning and Access Advisors
• D、Automated Workload Repository （AWR）
• E、Automatic Database Diagnostic Monitor （ADDM）

第6题：

Many companies spend a lot of money and time（）their trademarks.

Ato register

Bregistering

Cregister

第7题：

How（）time are you going to spend with me?

• A、many
• B、lot
• C、much

第8题：

第9题：

You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）

• A、Enable instance failover
• B、Configure shared server
• C、Enable database failover
• D、Enable connect-time failover
• E、Enable Transparent Application Failover （TAF）

第10题：

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

• A、Use a flashback query to retrieve the rows that were deleted
• B、Useconventialincremental export and then import the affected object
• C、Shutdown the database inNORMALmode and restart the database instance
• D、Use DBMS_META package to reconstruct the object using undo segments
• E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
• F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.