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 »
In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must be the value of the SERVICE_NAMES parameter on the client side B. It must be… Read More »
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 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.) 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 »
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 second ROLLBACK command undoes the insert B. The first… Read More »
You execute this query:SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”fmMonth rrrr’)What is the result? A. It executes successfully but does not return any result B. It returns the date for the last Monday of the current month C. It generates an error D. It returns the date for the first Monday of the next month Correct Answer: D
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.) 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 »
You execute this command:During the export operation, you detach from the job by using CTRL+C and then execute this command:Export> STOP_JOB=immediateAre you sure you wish to stop the job ([yes]/no): yesWhich two statements are true about the job? (Choose two.) A. You can no longer monitor it B. You can reattach to it and monitor it C. It… Read More »