Tag Archives: ocp

Q42 Which three statements are true regarding indexes?

Q42 Which three statements are true regarding indexes? (Choose three.) (A). A UNIQUE index can...

Q41 An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table

Q41 An Oracle database session has an uncommitted transaction in progress which updated 5000 rows...

Q40 Which two statements are true about single row functions?

Q40 Which two statements are true about single row functions? A) MOD : returns the...

Q39 Which two statements are true about single row functions?

Q39 Which two statements are true about single row functions? (Choose two.) (A). MOD :...

Q38 A database is configured to use automatic undo management with temporary undo enabled

Q38 A database is configured to use automatic undo management with temporary undo enabled. An...

Q37 Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances?

Q37 Which three statements are true about advanced connection options supported by Oracle Net for...

Q36 Your database instance was shut down normally and then started in NOMOUNT state

Q36 Your database instance was shut down normally and then started in NOMOUNT state. You...

Q35 Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Q35 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) (A)....

Q34 Which three statements are true about the Automatic Diagnostic Repository (ADR)?

Q34 Which three statements are true about the Automatic Diagnostic Repository (ADR)? (A). It Is...

Q33 Which two statements are true about a self join?

  Q33 Which two statements are true about a self join? A. It can be...

Q32 Which three statements are true about a self join?

Q32 Which three statements are true about a self join? (Choose three.) (A). The ON...

Q31 Which three statements are true about external tables in Oracle 18c and later releases?

Q31 Which three statements are true about external tables in Oracle 18c and later releases?...