In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accide

题目

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）

  • A、Complete Recovery with online redo log
  • B、Complete Recovery with archived redo log
  • C、Tablespace Point-in-Time Recovery (TSPITR)
  • D、Incomplete Recovery with system change number (SCN)
相似考题

1. In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A、export and import the mapping tableB、drop and re­create the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table

2. You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

3. You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A、Restore the backup control file and open the database with RESETLOGS option.B、Perform point-in-time recovery because flashback cannot be performed again on this tableC、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

4. On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）A、It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.B、It fails because no SQL *Loader data file location is specified.C、It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.D、It fails because no SQL *Loader control file location is specified.

参考答案和解析
正确答案:C
更多“In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which acciden”相关问题

  • 第1题：

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

    • A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
    • B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
    • C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
    • D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
    • E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

    正确答案:A

  • 第2题：

    Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

    • A、 Drop and re-create the inbox.
    • B、 Coalesce the ORDERS_IND index.
    • C、 Coalesce the INDEXES tablespace.
    • D、 Drop and re-create the ORDERS table.
    • E、 Rebuild the index online and move it to another tablespace.

    正确答案:B,E

  • 第3题：

    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

    • A、The tablespace TBS1 is full.
    • B、The user is not the owner of the SYSTEM tablespace.
    • C、The user does not have quota on the TBS1 tablespace.
    • D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
    • E、The user does not have sufficient privileges to create table on the default permanent tablespace.

    正确答案:C

  • 第4题：

    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

    • A、use the ROLLBACK command with SCN 663571
    • B、perform Flashback Transaction Query with SCN 663571
    • C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
    • D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    正确答案:D

  • 第5题：

    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

    • A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
    • B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

    正确答案:C

  • 第6题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

    export and import the mapping table

    B

    drop and re-create the mapping table

    C

    truncate the mapping table and reinsert the values

    D

    use the ALTER TABLE···REBUILD command to defragment the mapping table


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

     Export and import the mapping table.

    B

     Drop and re-create the mapping table.

    C

     Truncate the mapping table and reinsert the values.

    D

     Use the ALTER TABLE .. REBUILD command to defragment the mapping table.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
    A

     Use ROLLBACK command with SCN 663571.

    B

     Perform Flashback Transaction Query with SCN 663571.

    C

     Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

    D

     Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）
    A

     Complete Recovery with online redo log

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


    正确答案： D
    解析： 暂无解析

  • 第10题：

    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

    • A、The database instance is not available.
    • B、The ALTER TABLE command does not have WAIT option
    • C、The table or a row in the table is currently locked by another user session.
    • D、The database instance is busy processing other user sessions commands.
    • E、The CUSTOMERS table has no long running query active at the time when this request is made.
    • F、The server process executing the ALTER TABLE command is busy with another command execution

    正确答案:C

  • 第11题：

    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

    正确答案:C

  • 第12题：

    Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES  While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.  Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

    • A、drop and re-create the index
    • B、coalesce the ORDERS_IND index
    • C、coalesce the INDEXES tablespace
    • D、drop and re-create the ORDERS table
    • E、rebuild the index online and move it to another tablespace

    正确答案:B,E

  • 第13题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第14题：

    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）

    • A、It fails with a "Resource Busy" error.
    • B、It deletes the rows successfully because the table is locked in SHARE mode.
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第15题：

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


    正确答案： C,B
    解析： 暂无解析

  • 第16题：

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： B
    解析： 暂无解析

  • 第17题：

    单选题
    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）
    A

    It fails with a Resource Busy error.

    B

    It deletes the rows successfully because the table is locked in SHARE mode.

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： C
    解析： 暂无解析

相关内容