A. Both CASE and DECODE are functions.
B. AIl conditions evaluated using DECODE can also be evaluated using CASE.
C. DECODE is a function and CASE is not.
D. CASE is a function and DECODE is not.
E. All conditions evaluated using CASE can also be evaluated using DECODE.
F. Neither CASE nor DECODE is a function.
A. An index is created automatically in the MANAGER column.
B. The DEPTNO column in the EMP table can contain the value 1.
C. The COMMISSION column can contain negative values .
D. The MANAGER column is a foreign key referencing the EMPNO column.
E. The DNAME column has a unique constraint.
F. The SALARY column must have a value .
G. The DEPTNO column in the EMP table can contain NULLS .
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. It always retains the space used by the removed rows.
B. A FLASHBACK TABLE statement can be used to retrieve the deleted data.
C. It retains the integrity constraints defined on the table.
D. It retains the indexes defined on the table.
E. A ROLLBACK statement can be used to retrieve the deleted data.
F. It drops any triggers defined on the table.
A. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date
B. PROMO_BEGIN_DATE-5 will return a date.
C. TO_NUMBER(PROMO_BEGIN_DATE)-5 will return number
D. PROMO_BEGIN_DATE-SYSDATE will return a number.
E. PROMO_BEGIN_DATE-SYSDATE will return an error.
A. table1 join table2 using (column1, column2)
B. table1 join table2 on (table1.column between table2.column] and table2.column2)
C. tablet join table2 ON (table1.column = table2.column) where table2.column LIKE 'A'
D. table1 join table2 ON (table1.column >= table2.column)
E. table1 natural JOIN table2
A. SELCECT last_namo, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp FROM employees
B. SECECT last_namo, (menthy_salary + monthly_commission_pct) * 12 AS annual_comp FROM employees;
C. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * NVL (monthly_commission_pct, 0)) AS annual_comp FROM employees
D. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * monthly_commission_pct) AS annual_comp FROM employees
A.
B.
C.
D.
A. The on clause can be used.
B. The query must use two different aliases for the table.
C. The on clause must be used.
D. It must be an equijoin.
E. It must be an inner join.
F. It can be an outer join.
A. An & prefix to an undefined substitution variable, which is referenced twice in the same query, will prompt for a value twice .
B. & can prefix a substitution variable name only in queries. DML
C. An && prefix to an undefined substitution variable, which is referenced multiple times in multiple queries, will prompt for a value once per query.
D. The && prefix will not prompt for a value even if the substitution variable is not previously defined in the session.
E. Both & and && can prefix a substitution variable name in queries and DML statements.
A. Rolling back to a SAVEPOINT can undo a DELETE statement
B. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement.
C. Only one SAVEPOINT may be issued in a transaction.
D. Rolling back to a SAVEPOINT can undo a TRUNCATE statement.
E. A SAVEPOINT does not issue a COMMIT
A. Data consistency is not guaranteed after a rollback.
B. Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.
C. The ROLLBACK statement does not release locks resulting from table updates.
D. If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .
E. A transaction interrupted by a system failure is automatically rolled back.
A. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.
B. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
C. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column
D. It can only be used for NUMBER data types.
E. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.
A. SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')FROM DUAL
B. SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE=AMERICAN' ) FROM DUAL;
C. SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI')) FROM DUAL;
D. SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI')) FROM DUAL
E. SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE = AMERICAN') FROM DUAL;
