QUESTION 42 In which three situations does a new transaction always start? (Choose three.)

QUESTION 45 Which three statements are true about pfiles, spfiles or both?

QUESTION 46 Which four statements are true about database instance behavior?

QUESTION 48 .A PFILE exists for your database . You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance. You plan to use the ALTER SYSTEM command. Which two methods can be used?

QUESTION 51 Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

QUESTION 52 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=immediate Are you sure you wish to stop the job ([yes]/ no) : yes Which two statements are true about the job? ( Choose two. )

QUESTION 53 In one of your databases , you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform? (Choose three .)

QUESTION 54 Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? ( Choose two. )

QUESTION 55 Choose two . Which two statements are true about UNDO and REDO?

QUESTION 57 Which three statements are true about the DESCRIBE command? (Choose three .)

QUESTION 58 Examine the description of the CUSTOMERS table: For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?

QUESTION 59 The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE Column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two .)

QUESTION 60 Which three are types of segments in an Oracle Database? (Choose three .)

QUESTION 61 Which two statements are true about the results of using the INTERSECT operator in compound queries? ( Choose two. )

QUESTION 63 Which two statements are true about single row functions? (Choose two.)