Tag Archives: 1Z0082

Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements execute successfully?

Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. ‘DUES AMOUNT’ FROM transactions; B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. “DUES” FROM transactions;SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 D. transactions;SELECT… Read More »

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) A. External table files can be used for other external tables in a different database B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table C. The ORACLE_DATAPUMP access driver can be used to… Read More »

Which three statements are true about inner and outer joins? (Choose three.)

Which three statements are true about inner and outer joins? (Choose three.) A. A full outer join returns matched and unmatched rows B. An inner join returns matched rows C. Outer joins can only be used between two tables per query D. A full outer join must use Oracle syntax E. Outer joins can be used when there… Read More »

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.Which query can be used? A. SELECT… Read More »

Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase

Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.) A. The Oracle join syntax supports creation of a Cartesian product of two tables B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax C. The SQL:1999 compliant ANSI join syntax supports natural joins D. The SQL:1999 compliant ANSI… Read More »

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause B. Only… Read More »

Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this sequence of

Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.) A. The first ROLLBACK command restores the 101 rows that were… Read More »

Which three statements are true about single-row functions? (Choose three.)

Which three statements are true about single-row functions? (Choose three.) A. They return a single result row per table B. The argument can be a column name, variable, literal or an expression C. They can accept only one argument D. They can be nested to any level E. The data type returned can be different from the data… Read More »