网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Identify the two situations in which you use the alert log file in your database to check the details.（）
- A、Running a query on a table returns "ORA-600： Internal Error."
- B、Inserting a value in a table returns "ORA-01722： invalid number."
- C、Creating a table returns "ORA-00955： name is already used by an existing object."
- D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
- E、Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."
参考答案
更多 “Identify the two situations in which you use the alert log file in your database to check the details.（）A、Running a query on a table returns "ORA-600： Internal Error."B、Inserting a value in a table returns "ORA-01722： invalid number."C、Creating a table returns "ORA-00955： name is already used by an existing object."D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E、Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."” 相关考题
考题
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter
考题
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
考题
Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)
A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.
考题
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
考题
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORYB、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY tableC、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary tableD、Set binlog_format=MIXED with the – replicate-ignore-temp-table optionE、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
考题
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.
考题
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 recreate the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table
考题
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）A、The FLASHBACK TABLE statement will not be written to the alert log file.B、The changes made to the EMP table since the specified time will be undone.C、The EMP table that was dropped by mistake from the database will be restored.D、The FLASHBACK TABLE statement will be executed within a single transaction.E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. F、The list of transactions that have modified the EMP table since the specified time will be displayed.
考题
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
考题
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.
考题
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A、Check the alert log fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter
考题
Identify the two situations in which the alert log file is updated with details. （）A、Running a query on a table returns "ORA-600： Internal Error."B、Inserting a value in a table returns "ORA-01722： invalid number."C、Creating a table returns "ORA-00955： name is already used by an existing object."D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."E、Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
考题
Identify two situations in which the alert log file is updated.（）A、Running a query on a table returns ORA-600: Internal Error.B、Inserting a value into a table returns ORA-01722: invalid number.C、Creating a table returns ORA-00955: name us already in used by an existing objects.D、Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.E、Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
考题
Identify two situations in which you can use Data Recovery Advisor for recovery.（） A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.
考题
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）A、CHECKB、UNIQUEC、NOT NULLD、PRIMARY KEYE、FOREIGN KEY
考题
Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)A、The user has dropped an important table that needs to be recovered.B、The database files are corrupted when the database is open.C、You are not able to start up the database instance because the required database files are missing.D、The archived log files are missing for which backup is not available.
考题
Identify the situations in which you use the alert log file in your database to check the detail.（）A、Running a query on a table returns "ORA-600： Internal Error."B、Inserting a value in a table returns "ORA-01722： invalid number."C、Creating a table returns "ORA-00955： name is already used by an existing object."D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."E、Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."
考题
单选题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 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
考题
多选题You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe EMP table that was dropped by mistake from the database will be restored.CThe changes made to the EMP table since the specified time will be undone.DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.EThe FLASHBACK TABLE statement will be executed within a single transaction.FThe list of transactions that have modified the EMP table since the specified time will be displayed.
考题
多选题Identify the two situations in which the alert log file is updated with details. （）ARunning a query on a table returns ORA-600： Internal Error.BInserting a value in a table returns ORA-01722： invalid number.CCreating a table returns ORA-00955： name is already used by an existing object.DInserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.ERebuilding an index using ALTER INDEX ...REBUILD fails with an error ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
考题
单选题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.
考题
多选题Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
考题
多选题Identify the two situations in which you use the alert log file in your database to check the details.（）ARunning a query on a table returns ORA-600： Internal Error.BInserting a value in a table returns ORA-01722： invalid number.CCreating a table returns ORA-00955： name is already used by an existing object.DInserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.EInserting a row in a table returns ORA-00060： deadlock detected while waiting for resource.
考题
多选题Identify the situations in which you use the alert log file in your database to check the detail.（）ARunning a query on a table returns ORA-600： Internal Error.BInserting a value in a table returns ORA-01722： invalid number.CCreating a table returns ORA-00955： name is already used by an existing object.DInserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.EInserting a row in a table returns ORA-00060： deadlock detected while waiting for resource.
考题
多选题Identify two situations in which the alert log file is updated.（）ARunning a query on a table returns ORA-600: Internal Error.BInserting a value into a table returns ORA-01722: invalid number.CCreating a table returns ORA-00955: name us already in used by an existing objects.DInserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.ERebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
考题
多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
考题
单选题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.
热门标签
最新试卷
