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?

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?

Which of the following constitute the logical components of the Oracle database?

While preparing to create a database, you must ensure that there is sufficient disk space for the database files. When you calculate the space requirements, you may need to multiplex some of the files. Which of the following types of files would you plan to multiplex?

Which of the following storage structures provides a way to manually store the rows (from more than one table) in the same data block?

Which of the following constraint states prevents new data (that violates the constraint) from entering into the table, but allows invalid data to exist in the table?

The constraints for which Indexes are created by default are:

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?

When is SGA created in an Oracle database environment?

You have a database with DB_NAME set to STUD and ORACLE_SID set to STUD. These files are in default location for the initialization files: -init.ora -initSTUD.ora -spfile.ora -spfileSTUD.ora The database is started with the command: SQL> startup Which of the following options contain the correct names and sequence of the initialization files that Oracle Server attempts to read?

The information for a dynamic performance view is gathered from the control file.