A Company shifts all its branches to one office building, so the very large EMPLOYEES table no longer requires the BUILDING_LOCATION column. The DBA decides to drop that column using the syntax given below:

ALTER TABLE hr.employees

DROP COLUMN building_location

CASCADE CONSTRAINTS;

Dropping this column has turned out to be time consuming and at the same time it requires a large amount of undo space.

What should a DBA do to minimize the problem regarding time and undo space consumption?

The constraints for which Indexes are created by default are:

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?

Examine the following syntax: CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx; What type of Index does this syntax create?

Your database is in ARCHIVELOG mode. Which of the following must be true before the Log Writer (LGWR) can reuse a filled online redo log file?

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?