databases Online Quiz - 168
|Description: databases Online Quiz - 168|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which three are the physical structures that constiture the Oracle database ? (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)
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)
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?