You started your database with the following command:

STARTUP PFILE=initSAMPLE.ora

One of the values in the initSAMPLE.ora parameter file is:

LOG_ARCHIVE_START=false

While your database is open, you issue the following command to start the Archiver process:

ALTER SYSTEM ARCHIVE LOG START;

You shut down your database to take the back up and restart it, using the initSAMPLE.ora parameter file again. On checking the status of the Archiver, you find that it is disabled.

Why is the Archiver disabled?

Miller is an Administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile (as illustrated below), he receives an error message (shown below): SQL> drop profile SYS.DEFAULT; drop profile SYS.DEFAULT * ERROR at line 1: ORA-00950: invalid DROP option Which of the following options best explains this error?

You are creating a new database. You do NOT want users to use the SYSTEM tablespace for sorting operations.

You just issued the STARTUP command. Which of the following files is checked to determine the state of the database?

What provides for recovery of data that has not been written to the data files prior to a failure?

When does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group?

When is SGA created in an Oracle database environment?

Which of the following helps determine the initial size of a Tablespace?

Examine the following SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will have a uniform size of 1 MB?

Which of the following tables help build scalable applications and also proves to be useful for large tables that can be queried or manipulated using several processes concurrently?

You need to create an index on the ITEM table, which is 10 GB in size. You want your index to be spread across many tablespaces, decrease contention for index lookup, and increase scalability and manageability. Which of the following types of indexes would be the best for this table?