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 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）.
相关考题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
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
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?（）A. The index remains invisible.B. The index is not updated by the DML statements on the indexed table.C. The index automatically becomes visible in order to have it updated by DML on the table.D. The index becomes unusable but the table is updated by the DML.E. The index is updated by the DML on the table.
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.B. The statement returns an error at the SELECT clause.C. The statement returns an error at the WHERE clause.D. The statement returns an error at the ORDER BY clause.
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.
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."
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.
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.
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 AVG(subj1) AND subj2 AVG(subj2) ORDER BY total_marks; What is the result of the SELECT statement?（）A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.B、The statement returns an error at the SELECT clause.C、The statement returns an error at the WHERE clause.D、The statement returns an error at the ORDER BY clause.
You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）A、A trigger in each form. B、A subprogram in each form. C、A stored subprogram in the database. D、A subprogram in a library that is attached to each form.
Which four statements correctly describe functions that are available in SQL? （）A、INSTR returns the numeric position of a named character.B、NVL2 returns the first non-null expression in the expression list.C、TRUNCATE rounds the column, expression, or value to n decimal places.D、DECODE translates an expression after comparing it to each search value.E、TRIM trims the heading or trailing characters (or both) from a character string.F、NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.G、NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
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."
What is true regarding subqueries?（）A、The inner query always sorts the results of the outer query.B、The outer query always sorts the results of the inner query.C、The outer query must return a value to the inner query.D、The inner query returns a value to the outer query.E、The inner query must always return a value or the outer query will give an error.
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the 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.
单选题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.
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
多选题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）.
多选题Which four statements correctly describe functions that are available in SQL? （）AINSTR returns the numeric position of a named character.BNVL2 returns the first non-null expression in the expression list.CTRUNCATE rounds the column, expression, or value to n decimal places.DDECODE translates an expression after comparing it to each search value.ETRIM trims the heading or trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.GNULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
单选题You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）AA trigger in each form. BA subprogram in each form. CA stored subprogram in the database. DA subprogram in a library that is attached to each form.
多选题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.
单选题What is true regarding subqueries?（）AThe inner query always sorts the results of the outer query.BThe outer query always sorts the results of the inner query.CThe outer query must return a value to the inner query.DThe inner query returns a value to the outer query.EThe inner query must always return a value or the outer query will give an error.
多选题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.
单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）A Exhibit AB Exhibit BC The query returns no rowsD The query fails because the outer query is retrieving more than one columnE The query fails because both the inner and outer queries are retrieving data from the same table.
单选题Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 AVG(subj1) AND subj2 AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement? （）AThe statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.BThe statement returns an error at the SELECT clause.CThe statement returns an error at the WHERE clause.DThe statement returns an error at the ORDER BY clause.
单选题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?（）AOne of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.BOne of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.CBoth the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.DNone of the tables are recovered from the Recycle Bin, and the statement returns an error.