Tag Archives: statements

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) C. A TIMESTAMP data type column contains information about year, month,… 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. They cannot be partitioned B. The ORACLE_DATAPUMP 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 load data into a database from an external table D.… Read More »

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 »

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 »

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 »