Which three are the physical structures that constiture the Oracle database ? (Choose Three)

You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)

Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)

When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)

Which two roles or privileges must you have to export tables owned by another user? (Choose two)

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)

Which two statments regarding the control file and Recover Manager are true ? (Choose two)

Which three features are provided by Oracle Net Services? (Choose three)

What file will give you Oracle instance status information?

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are true ?

Which statement is ture regarding checkpoints and recovery ?

What should you look at to compute the number of undo blocks written per second on disk ?

Which background process reads the redo log buffer and writes it to a file ?

In user-managed backup and recover procedure, how are data files backed up ?

Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?

You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START Starting /mstgelai/oracle/bin/tnslsnr: please wait... System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to... The command completed successfully What is the name of the Listener you started?