You noticed that the...

多项选择题X 纠错

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes？（）

A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTE STATISTICS

参考答案：

进入题库练习

多项选择题

You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace.
What methods can you use to recreate the indexes？（）

A.Data Pump
B.SQL scripts
C.SQL*Loader
D.Flashback database
E.Recovery Manager （RMAN） script

点击查看答案进入题库练习

单项选择题

You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this？（）

A.The index tablespace contains bitmap indexes.
B.The index tablespace contains more than one data file.
C.The index tablespace supports only complete recovery.
D.The index tablespace is not a dictionarymanaged tablespace.
E.There is a dependency relationship between a table and its indexes.

点击查看答案进入题库练习

单项选择题

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.
How would you recover the lost redo log member？（）

A.import the database from the last export
B.restore all the members in the group from the last backup
C.drop the lost member from the database， and then add a new member to the group
D.restore all the database files from the backup， and then perform a complete recovery
E.restore all the database files from the backup， and then perform an incomplete recovery

点击查看答案进入题库练习

单项选择题

A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal
*
ERROR at line 1：
ORA01157： cannot identify/lock data file 201 see DBWR trace file
ORA01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’
What is a possible reason？（）

A.The tempfile belonging to the default temporary tablespace is missing.
B.The database is opened in restricted mode， so queries are not allowed.
C.The default temporary tablespace required to execute the query is offline.
D.The default temporary tablespace required to execute the query is dropped.
E.The default temporary tablespace required to execute the query is readonly.

点击查看答案进入题库练习

多项选择题

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A.The database opens normally.
B.The database prompts for a database recovery.
C.The database writer writes to a trace file， indicating that the temporary file is not found.
D.The database gets mounted and throws an error indicating that the temporary file requires recovery.

点击查看答案进入题库练习

单项选择题

While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

A.It would result in an error because the warning threshold cannot be more than the critical threshold.
B.The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C.The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D.Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

点击查看答案进入题库练习

单项选择题

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.
To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

A.disable SQL tracing for theAPPS tablespace
B.disable logging attribute for the APPS tablespace
C.modify the tablespace to be a dictionarymanaged tablespace
D.increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
E.increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

点击查看答案进入题库练习

多项选择题

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

A.the alert log file
B.the core dump files
C.the change tracking file
D.the user session trace files
E.the database audit trail files
F.the background process trace files

点击查看答案进入题库练习

单项选择题

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.
You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.
How do you achieve this objective？（）

A.by setting the SQL_TRACE parameter to FALSE in the parameter file
B.by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C.by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D.by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

点击查看答案进入题库练习

单项选择题

The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）

A.fixed views
B.the alert log file
C.the parameter file
D.the server parameter file
E.dynamic performance views

点击查看答案进入题库练习