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

Which of the following statements should you use to obtain information about the names, status of the control files?

Which of the following statements is correct with regard to an Oracle instance?

Which of the following options enables you to increase the size of online redo log groups?

Consider the under mentioned syntax, which creates a DEPARTMENT table: CREATE TABLE department (DeptnoNUMBER(4), DnameVARCNAR2(30), mgr NUMBER(6), LocNUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?

Which of the following background processes performs a checkpoint in the database by writing modified blocks from the database buffer cache in SGA to the data files?

Which of the following types of files is a part of the Oracle database?

You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1: ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2 What will be the result?

Which of the following becomes available when an Oracle instance is started?

Which of the following memory areas is not part of SGA?

Examine the following TRUNCATE TABLE command: TRUNCATE TABLE departments; Which of the following statements are correct with regard to this command?