Author Archives: Tran Anh

Q98 Examine this command Which two statements are true?

Q98 Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are...

Q97 Which two statements are true about undo and undo tablespaces?

Q97 Which two statements are true about undo and undo tablespaces? (A). There can be...

Q96 Which four account management capabilities can be configured using Oracle profiles?

Q96 Which four account management capabilities can be configured using Oracle profiles? (Choose four) (A)....

Q95 Which two statements are true about User Authentication in an Oracle Database?

Q95 Which two statements are true about User Authentication in an Oracle Database? (A). Operating...

Q94 You execute this query

Q94 You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is...

Q93 Which three are types of segments in an Oracle Database?

Q93 Which three are types of segments in an Oracle Database? (Choose three.) (A). undo...

Q92 Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

Q92 Which three statements are true about the naming methods and their features supported by...

Q91 Which two statements are true about UNDO and REDO?

Q91 Which two statements are true about UNDO and REDO? (Choose two.) (A). The generation...

Q90 Which compression method is recommended for Direct-Path Insert operations?

Q90 Which compression method is recommended for Direct-Path Insert operations? (A). COLUMN STORE COMPRESS BASIC...

Q89 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

Q89 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks...

Q88 Identify three ORDER BY clauses, any one of which can complete the query successfully

Q88 Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id =...

Q87 Examine the description of the members table

Q87 Examine the description of the members table: Examine the partial query: SELECT city, last_name...