You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

A.Restart the database instance and run the job
B.Truncate the Certkiller STAFF table and run the job
C.Delete all rows from the Certkiller STAFF table and run the job
D.Increase the size of the USERStablespacethe and run the job
E.Increase the size of the database default permanenttablespaceand run the job

你可能感興趣的試題

單項(xiàng)選擇題
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
A.The source PL/SQL code will be stored in native machine code.
B.The source PL/SQL code will be stored in interpreted byte code.
C.The compiled PL/SQL code will be stored in native machine code.
D.The compiled PL/SQL code will be stored in interpreted byte code.
單項(xiàng)選擇題
You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
A.PMON coordinates media recovery.
B.SMON coordinates instance recovery.
C.PMON coordinates instance recovery.
D.Undo Advisor would roll back all uncommitted transactions.
E.SQL*PLUS reports an error with the message asking you to perform instance recovery.

首頁(yè)

題庫(kù)

網(wǎng)課

在線?？?/h3>

桌面端

你可能感興趣的試題

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

你可能感興趣的試題

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）