多选题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 

题目
多选题
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）.

相似考题

1.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

2.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.

3.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.

4.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

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“多选题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 ”相关问题

  • 第1题：

    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.

    正确答案:B,D

  • 第2题：

    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."

    正确答案:A,E

  • 第3题：

    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.

    正确答案:B

  • 第4题：

    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.

    正确答案:A,E

  • 第5题：

    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.

    正确答案:D

  • 第6题：

    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.

    正确答案:A,E

  • 第7题：

    多选题
    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 EMP table that was dropped by mistake from the database will be restored.

    C

    The changes made to the EMP table since the specified time will be undone.

    D

    The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.

    E

    The FLASHBACK TABLE statement will be executed within a single transaction.

    F

    The list of transactions that have modified the EMP table since the specified time will be displayed.


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

  • 第8题：

    多选题
    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.


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

  • 第9题：

    多选题
    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.


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

  • 第10题：

    多选题
    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.


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

  • 第11题：

    多选题
    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.


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

  • 第12题：

    多选题
    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.


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

  • 第13题：

    Which syntax turns an existing constraint on?（）

    • A、ALTER TABLE table_name ENABLE constraint_name;
    • B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
    • C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
    • D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

    正确答案:C

  • 第14题：

    As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

    • A、A leaf will be marked as invalid.
    • B、An update in a leaf row takes place.
    • C、The index will be updated automatically at commit.
    • D、A leaf row in the index will be deleted and inserted.
    • E、The index becomes invalid when you make any updates.

    正确答案:D

  • 第15题：

    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）.

    正确答案:A,E

  • 第16题：

    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.

    正确答案:C

  • 第17题：

    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."

    正确答案:A,E

  • 第18题：

    多选题
    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 of trailing characters (or both) from a character string.

    F

    NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.

    G

    NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.


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

  • 第19题：

    单选题
    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.


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

  • 第20题：

    多选题
    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）.


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

  • 第21题：

    单选题
    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.


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

  • 第22题：

    多选题
    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.


    正确答案： A,E
    解析： 暂无解析

  • 第23题：

    单选题
    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 A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


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

  • 第24题：

    单选题
    As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
    A

    A leaf will be marked as invalid.

    B

    An update in a leaf row takes place.

    C

    The index will be updated automatically at commit.

    D

    A leaf row in the index will be deleted and inserted.

    E

    The index becomes invalid when you make any updates.


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

相关内容