최신Oracle Database SQL - 1z1-071무료샘플문제

A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

B. The CURRENT_TIMESTAMP function returns data without time zone information.

C. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.

D. A TIMESTAMP data type column contains information about year, month, and day.

E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

A. SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), `Ongoing') FROM programs

B. SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;

C. SELECT NVL (MONTHS_BETWEEN (start_date, end_date), `Ongoing') FROM programs;

D. SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;

A. Both foreign key constraint definitions must be removed from the CREATE TABLE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

B. The MGR column in the DEPT table will not be able to contain NULL values.

C. The CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all three statements to execute successfully.

D. The DEPTNO column in the EMP table will be able to contain NULL values.

E. All three statements execute successfully in the order shown.

F. The DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement, and be added with an ALTER TABLE statement once both tables are created, for the two CREATE statements to execute successfully in the order shown.
TABLE

A. It would execute and restrict modifications to the columns specified in the SELECT statement.

B. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

C. It would not execute because two tables cannot be referenced in a single UPDATE statement.

D. It would not execute because a SELECT statement cannot be used in place of a table name.

A. Only the first query gives the correct result

B. Only the second query gives the correct result

C. Both execute successfully and give the same result

D. Both execute successfully but do not give the required result

A. The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

B. The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.

C. The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.

D. The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.

A. The subquery and main query must retrieve date from the same table.

B. A subquery can have more than one main query

C. A Main query can have many subqueries.

D. The subquery and main query can retrieve data from different tables.

E. Multiple columns or expressions can be compared between the subquery and main query.

F. Only one column or expression can be compared between the subquery and main query.

A. It executes successfully but does not return the correct result.

B. It generates an error because TO_CHAR should be replaced with TO_DATE.

C. It executes successfully and returns the correct result.

D. It generates an error because fm and double quotation marks should not be used in the format string.

E. It generates an error because rrrr should be replaced by rr in the format string.

A. DELETE can be used to remove rows from multiple tables in one statement.

B. DELETE can be used to remove rows from only one table in one statement.

C. DELETE can be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.

D. DELETE can be used to remove data from specific columns as well as complete rows.

E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule.

A.

B.

C.

D.

E.

F.

A. In the second column, 'c' indicates a check constraint.

B. The STATUS column indicates whether the table is currently in use.

C. The R_CONSTRAINT_NAME column contains an alternative name for the constraint.

D. The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.

A. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.

B. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.

C. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

D. Each Data Definition Language (DDL) statement executed forms a single transaction.

A. They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

B. The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.

C. They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

A. an error

B. 3 rows

C. 6 rows

D. 0 rows

E. 1 row

F. 8 rows