Oracle Database 12c: Admin, Install and Upgrade Accelerated Quiz Questions and Answers

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert. What is the outcome? (Choose the best answer.)

Answer :
  • It generates an error because the warning threshold cannot exceed 100%.

Which area of PGA stores binding variables and run-time buffers information?

Answer :
  • Private SQL area

Which option is used to perform tablespace creation

Answer :
  • Create tablespace tbs datafile '/u01/app/oracle/oradata/prod/tbs01.dbf'

Which statement is true about datafile

Answer :
  • Datafile is a physical file

Which statement is true about CDB

Answer :
  • CDB database is a container database

Which statement is true regarding datafile movement

Answer :
  • alter database move datafile '/u01/app/oracle/users01.dbf' to '/u01/app/oracle/oradata/orcl/users01.dbf';

Oracle database’s design is also called as_______.

Answer :
  • Database Schema

Which prefixes are available to Oracle triggers?

Answer :
  • Both :new and :old

What Oracle backup and recover file contains user and system data?

Answer :
  • Datafile

Which of the following scenarios ends an Oracle transaction?

Answer :
  • All of the mentioned