Tag Archives: Choose

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The number, but not names, of columns must be identical for all SELECT statements in the query. B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by… 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 »

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 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 »

Which three are true about the Oracle Optimizer? (Choose three.)

Which three are true about the Oracle Optimizer? (Choose three.) A. It determines the optimal table join order and method. B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary. C. It can re-optimize execution plans after previous executions detect suboptimal plans. D. It… Read More »

Which two statements are true about the rules of precedence for operators? (Choose two.)

Which two statements are true about the rules of precedence for operators? (Choose two.) A. The concatenation operator | | is always evaluated before addition and subtraction in an expression B. NULLS influence the precedence of operators in an expression C. The + binary operator has the highest precedence in an expression in a SQL statement D. Arithmetic… Read More »