Tag Archives: ocp

Q30 Which three statements are true about inner and outer joins?

Q30 Which three statements are true about inner and outer joins? (Choose three.) (A). A...

Q29 Examine this description of the books table containing 100 rows

Q29 Examine this description of the books table containing 100 rows: Now examine this sequence...

Q28 Which two statements are true about GLOBAL TEMPORARY TABLES?

Q28 Which two statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows...

Q27 Which three statements are true about GLOBAL TEMPORARY TABLES?

Q27 Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.) (A). A TRUNCATE...

Q26 Which two statements are true regarding the UNION and UNION ALL operators?

Q26 Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)...

Q25 Which two tasks can you perform using DBCA for databases?

Q25 Which two tasks can you perform using DBCA for databases? (Choose two.) (A). Configure...

Q24 Which two statements are true about the PMON background process?

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

Q23 Which two statements are true about the PMON background process?

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

Q22 Which two statements are true about the job?

Q22 You execute this command: During the export operation, you detach from the job by...

Q21 You have been tasked to create a table for a banking application

Q21 You have been tasked to create a table for a banking application. One of...

Q20 Which two are true about data type conversions involving these columns in query expressions?

Q20 The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE...

Q19 You want to display the first name and due amount as 5% of their credit limit

Q19 Examine the description of the CUSTOMERS table: For customers whose income level has a...