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： nam

题目

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

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

第1题

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.

点击查看答案
第2题

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.

点击查看答案
第3题

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.

点击查看答案
第4题

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.

点击查看答案
第5题

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

点击查看答案
第6题

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.

点击查看答案
第7题

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.

点击查看答案

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： nam

题目

参考答案和解析

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

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容