单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A The dependent materialized view should have a complete refresh performed after the online table redefinition process.B Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C Referential integrity constraints must be manually enabled after the online table redefinition process.D The materialized log should be dropped before the online table redefinition process.
单选题
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）
A
The dependent materialized view should have a complete refresh performed after the online table redefinition process.
B
Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
C
Referential integrity constraints must be manually enabled after the online table redefinition process.
D
The materialized log should be dropped before the online table redefinition process.
参考解析
解析：
暂无解析
相关考题：
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
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?() A. It cannot be done in parallel.B. It can be done at the table level or partition level.C. It does not require additional storage because the operation is done online.D. Local and global indexes are maintained automatically during the operation.
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
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.The table does not have a primary key and is used by an OLTP application.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.
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?() A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）A、It remains valid.B、It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C、It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D、It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
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 663571B、perform Flashback Transaction Query with SCN 663571C、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
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A、perform point-in-time recoveryB、perform a Flashback Table operation to restore the table to the state it was in two days agoC、perform a Flashback Database operation to restore the database to the state it was in two days agoD、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A、 perform point-in-time recoveryB、 perform a Flashback Table operation to restore the table to the state it was in two days agoC、 perform a Flashback Database operation to restore the database to the state it was in two days agoD、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A、 Create a FOR trigger. B、 Create an INSTEAD OF trigger. C、 Create an AFTER trigger. D、 Create a DDL trigger.
多选题Which three table transformations can be done using online redefinition of tables？（）AABBCCDDEE
单选题Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）A It cannot be done in parallel.B It can be done at the table level or partition level.C It does not require additional storage because the operation is done online.D Local and global indexes are maintained automatically during the operation.
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
单选题Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A Create a FOR trigger. B Create an INSTEAD OF trigger. C Create an AFTER trigger. D Create a DDL trigger.
单选题A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）AIt remains valid.BIt becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.CIt becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.DIt becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
单选题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. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim table.BInvoke the dbms_redefinition.can_redef_table procedure.CInvoke the dbms_redefinition.sync_interim_table procedure.DCreate any triggers， indexes， or constraints on the interim table.ECreate an empty interim table with all the desired characteristics.
单选题You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A perform point-in-time recoveryB perform a Flashback Table operation to restore the table to the state it was in two days agoC perform a Flashback Database operation to restore the database to the state it was in two days agoD perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
单选题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？（）Ause the ROLLBACK command with SCN 663571Bperform Flashback Transaction Query with SCN 663571Cexecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571Dexecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
单选题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?（）ARestore the backup control file and open the database with RESETLOGS option.BPerform point-in-time recovery because flashback cannot be performed again on this tableCExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
单选题Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL SELECT * FROM cust_ord; SELECT * FROM cust_ord * ERROR at line 1： ORA/x7f00942： table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）Aretrieve the table by using the flashback featureBrestore all the data files from last Sunday’s backup， and then perform a timebased recoveryCrestore all the data files from last Sunday’s backup， and then perform a log sequence recoveryDrestore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryErestore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery
单选题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.