#71. A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends? (Choose two.)
#77. You are preparing to create the PROD database and are configuring to use Oracle Managed Files (OMF). You set these initialization parameters before database creation: DB_CREATE_FILE_DEST = '/u01/oradata/' DB_CREATE_LOG_DEST_1 = '/u02/oradata/' DB_CREATE_LOG_DEST_2 = '/u03/oradata/' Which statement about the PROD database is true?
#79. You notified users that a power outage would occur at 9:00 am and the database would be shut down prior to the outage. Most users have voluntarily logged off, but a few users are still connected. You need to shut down the database without waiting for the current sessions and transactions to end, but want to force a checkpoint and close the database files. Which SHUTDOWN statement should you use?
#80. The default location for the HR database initialization files contains these files: init.ora spfile.ora initHR.ora spfileHR.ora Which file will the Oracle server attempt to read first when you start up the database without specifying an initialization file?