搜题

【单选题】

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.<br /> The table does not have a primary key and is used by an OLTP application.<br /> Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）

A、Oracle Data Pump.

B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

D、Online Table Redefinition.

E、Edition-Based Table Redefinition.

查看正确答案

更多“ Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.<br /> The table does not have a primary key and is used by an OLTP application.<br /> Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）”相关的问题

第1题

[单选题] Which describes the default behavior when you create a table?（）

A、The table is accessible to all users. B、Tables are created in the public schema. C、Tables are created in your schema. D、Tables are created in the DBA schema. E、You must specify the schema when the table is created.

点击查看答案

第2题

[单选题] Which describes the default behavior when you create a table? （）

点击查看答案

第3题

[多选题] Which two statements are true with respect to the maintenance window? （）

A、A DBA can enable or disable an individual task in all maintenance windows. B、A DBA cannot change the duration of the maintenance window after it is created. C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours. D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

点击查看答案

第4题

[] You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table structure according to the application requirements. However， you want to keep track of the ALTER TABLE commands being executed by developers， so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information？（） You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table stru

A、A.DBA_AUDIT_TRAIL B、B.DBA_AUDIT_SESSION C、C.DBA_FGA_AUDIT_TRAIL D、D.DBA_COMMON_AUDIT_TRAIL

点击查看答案

第5题

[] Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）

A、A. The incident metadata is purged when the problem is resolved and the DBA closes the SR B、B.The incident files and dumps are not retained in the ADR for the manually created incidents C、C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR D、D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month

点击查看答案

第6题

[] View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（） View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command: SQL> SELECT reason,metric_value FROM dba_outst

A、A.An Automatic Workload Repository snapshot has been taken recently. B、B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY. C、C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY. D、D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but notthe threshold alerts related to instance metrics

点击查看答案

第7题

[单选题] Which view will you use to view information regarding the jobs that are currently running in a database？（）

A、DBA_SCHEDULER_RUNNING_JOBS B、DBA_SCHEDULER_JOB_RUN_DETAILS C、DBA_SCHEDULER_JOBS D、DBA_SCHEDULER_JOB_LOG

点击查看答案

第8题

[单选题] You are docking a vessel．Wind and current are most favorable when they are（）.

A、crossing your course in the same direction B、crossing your course in opposite directions C、parallel to the pier from ahead D、setting you on the pier

点击查看答案

第9题

[单选题] View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command： SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output（）

A、An Automatic Workload Repository snapshot has been taken recently. B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY. C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY. D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

点击查看答案

第10题

[单选题] Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）

A、The sessions are able to perform only queries. B、The sessions are not affected and continue to function normally. C、The sessions are terminated and the active transactions are rolled back. D、The sessions are not allowed to perform any operations till the listener is started

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服