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

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

相似考题

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

3.Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?A.SELECT TABLE(EMPLIST()) FROM EMPLOYEEB.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

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

更多“多选题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 ”相关问题

  • 第1题：

    Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

    • A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
    • B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
    • C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
    • D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

    正确答案:D

  • 第2题：

    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

  • 第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题：

    Which two statements about subqueries are true?（）

    • A、A single row subquery can retrieve data from only one table.
    • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
    • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
    • D、A single row subquery can retrieve data from more than one table.
    • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
    • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    正确答案:B,D

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    多选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements about subqueries are true? （）
    A

    A single row subquery can retrieve data from only one table.

    B

    A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

    C

    A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.

    D

    A single row subquery can retrieve data from more than one table.

    E

    A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    F

    A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.


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

  • 第10题：

    多选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


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

  • 第13题：

    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

    • A、 William used the Flashback Version Query feature.
    • B、 William issued the CROSSCHECK command at the RMAN prompt.
    • C、 William viewed the alert log file.
    • D、 William used the Flashback Table feature.

    正确答案:A

  • 第14题：

    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

  • 第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题：

    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

  • 第17题：

    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

  • 第18题：

    多选题
    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
    解析： 暂无解析

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true about Oracle Managed Files (OMF)?（）
    A

    OMF cannot be used in a database that already has data files created with user-specified directions.

    B

    The file system directions that are specified by OMF parameters are created automatically.

    C

    OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

    D

    OMF automatically creates unique file names for table spaces and control files.

    E

    OMF may affect the location of the redo log files and archived log files.


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

  • 第24题：

    单选题
    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）
    A

     William used the Flashback Version Query feature.

    B

     William issued the CROSSCHECK command at the RMAN prompt.

    C

     William viewed the alert log file.

    D

     William used the Flashback Table feature.


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

相关内容