Tag Archives: ocp

Q138 Examine the description of the BOOKS table

Q138 Examine the description of the BOOKS table: The table has 100 rows. Examine this...

Q137 The status column contains the values ‘in stock’ or ‘out of stock’ for each row

Q137 Examine the description of the PRODUCT_STATUS table: The status column contains the values ‘in...

Q136 Which two statements are true about Database Instances and Real Application Clusters (RAC)

Q136 Which two statements are true about Database Instances and Real Application Clusters (RAC)? (A)....

Q135 Which two are true about a SQL statement using SET operators such as UNION?

Q135 Which two are true about a SQL statement using SET operators such as UNION?...

Q134 In one of your databases, user KING is: Not a DBA user An operating system (OS) user

Q134 In one of your databases, user KING is: Not a DBA user An operating...

Q133 Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

Q133 Which two statements are true about undo segments and the use of undo by...

Q132 Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

Q132 Which three statements are true about undo segments and the use of undo by...

Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE

Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has...

Q130 Which two queries execute successfully?

Q130 Which two queries execute successfully? A. SELECT NULLIF(NULL, 100) FROM DUAL; B. SELECT NULLIF(100,...

Q129 Which two statements are true about time zones, date data types, and timestamp data type in an Oracle database?

Q129 Which two statements are true about time zones, date data types, and timestamp data...

Q128 Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

Q128 Which three statements are true about time zones, date data types, and timestamp data...

Q127 Which three statements are true about views in an Oracle database?

Q127 Which three statements are true about views in an Oracle database? (Choose three.) (A)....

Q126 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE

Q126 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data...

Q125 Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

Q125 Evaluate these commands which execute successfully: Which two statements are true about the ORD_ITEMS...

Q124 Which three statements are true about using SQL*Plus?

Q124 Which three statements are true about using SQL*Plus? (A). It has its own commands...

Q123 You want to display details of all customers who reside in cities starting with the letter D

Q123 Examine the description of the CUSTOMERS table: You want to display details of all...

Q122 Which two actions can you perform using DBCA for an existing database?

Q122 Which two actions can you perform using DBCA for an existing database? (A). Create...

Q121 The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?

Q121 The sales table has columns prod_id and quantity_sold of data type number In two...

Q120 Which two statements are true about trace files produced by the Oracle Database server?

Q120 Which two statements are true about trace files produced by the Oracle Database server?...

Q119 Which two statements are true about the DUAL table?

Q119 Which two statements are true about the DUAL table? (Choose two.) (A). It can...