Tag Archives: ocp

Q78 Which three statements are true about Oracle synonyms?

Q78 Which three statements are true about Oracle synonyms? (Choose three.) (A). A synonym cannot...

Q77 In which three situations does a new transaction always start?

Q77 In which three situations does a new transaction always start? (Choose three.) (A). when...

Q76 Which two statements are true about substitution variables?

Q76 Which two statements are true about substitution variables? (A). A substitution variable prefixed with...

Q75 In your data center, Oracle Managed Files (OMF) is used for all databases

Q75 In your data center, Oracle Managed Files (OMF) is used for all databases. All...

Q74 Which three statements are true about sequences in a single instance Oracle database?

Q74 Which three statements are true about sequences in a single instance Oracle database? (A)....

Q73 The stores table has a column START_DATE of data type DATE

Q73 The stores table has a column START_DATE of data type DATE, containing the date...

Q72 Examine the description of the employees table

Q72 Examine the description of the employees table: Which query requires explicit data type conversion?...

Q71 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations

Q71 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations....

Q70 While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system

Q70 While one of your databases was in mount state, the datafiles were renamed because...

Q69 You must create a tablespace of non-standard block size in a new file system and plan to use this command

Q69 You must create a tablespace of non-standard block size in a new file system...

Q68 Which three activities are recorded in the database alert log?

Q68 Which three activities are recorded in the database alert log? (Choose three.) (A). Data...

Q67 Which three statements are true about dropping and unused columns in an Oracle database?

Q67 Which three statements are true about dropping and unused columns in an Oracle database?...