1z0-071試験無料問題集「Oracle Database SQL 認定」

A. SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

B. SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

C. SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

D. SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

E. SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

A. They have no join condition.

B. They require the NOT EXISTS operator in the join condition.

C. They require table aliases.

D. They require the EXISTS opnrator in the join condition.

E. They can use INNER JOIN and LEFT JOIN.

F. They are always equijoins.

A. They can be used in the clause.

B. They must return a row to prevent errors in the SQL statement.

C. They can be used in the HAVING clause.

D. A SQL statement may have multiple single row subquery blocks.

E. They must be placed on the right side of the comparison operator or condition.

F. They must be placed on the left side of the comparison operator or condition.

A. SELECT emp_ seq . NEXTVAL FROM DUAL;

B. SELECT NEXTVAL FROM emp_ seq;

C. SELECT emp_ seq. CURRVAL FROM DUAL;

D. SELECT CURRVAL FROM emp_ seq;

A. CURRENT DATE

B. SYSDATE

C. CURRENT_ TIMESTAMP

D. LOCALTIMESTAMP

A. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

B. A GLOBAL TEMPORARY TABLE can have only one index.

C. A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.

D. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

E. A GLOBAL TEMPORARY TABLE can have multiple indexes

F. A trigger can be created on a GLOBAL TEMPORARY TABLE

A. 200

B. 150

C. 16

D. 100

E. 160

A. They can return two columns.

B. You can use them as a default value for a column.

C. You cannot correlate them with a table in the parent statement

D. .You must enclose them in parentheses.

E. They can return at most one row.

A. The output is sorted by the UNION ALL operator.

B. NULLS are not ignored during duplicate checking.

C. Duplicates are eliminated automatically by the UNION ALL operator

D. The number of columns selected in each SELECT statement must be identical

E. The names of columns selected in each SELECT statement must be identical.

A. A DDL statement issued by a session with an uncommitted transaction automatically Commits that transaction.

B. DML statements always start new transactions.

C. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

D. A session can see uncommitted updates made by the same user in a different session.

E. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

A. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

B. PRODUCT_NAME cannot contain duplicate values.

C. PRODUCT_ID can be assigned the PEIMARY KEY constraint.

D. EXPIRY_DATE cannot be used in arithmetic expressions.

E. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it

F. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

A. Tables in the defining query of a view must always exist in order to create the view.

B. Views can be indexed.

C. Theethi CHEcK clause prevents certalin rows from being updated or inserted in the underying table through the view.

D. Views can be updated without the need to re-grant privileges on the view.

E. The wITH CHECK clause prevents certain rows from being displayed when querying the view.

A. SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

B. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

C. SELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;

D. SELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;

A. The concatenation operator || is always evaluated before addition and subtraction in an expression.

B. Multiple parentheses can be used to override the default precedence of operators in an expression.

C. The + binary operator has the highest precedence in an expression in a SQL statements.

D. Arithmetic operators with equal precedence are evaluated from left to right within an expression.

E. NULLS influence the precedence of operators in an expression.

A. 

B. 

C. 

D. 

E.