Tag Archives: true

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 »

Which four statements are true regarding primary and foreign key constraints and the effect they can

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.) A. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted B. A table can have only one primary… Read More »

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… Read More »

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.) A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ C. Sequence ORD_SEQ is guaranteed not… Read More »

Which two statements are true about the PMON background process? (Choose two.)

Which two statements are true about the PMON background process? (Choose two.) A. It registers database services with all local and remote listeners known to the database instance B. It frees resources held by abnormally terminated processes C. It records checkpoint information in the control file D. It frees unused temporary segments E. It kills sessions that exceed… Read More »

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?(Choose two.) A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row… Read More »