databases Online Quiz - 169
|Description: databases Online Quiz - 169|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Examine the statement : DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?
A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received an error regarding DISK 3 on your server.This is the location of your data file for the SYSTEM tablespace. Which option is open to you?
Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?
When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.
Which modifier is used to change listener parameters in the Listener Control utility environment?
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?
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 ?
The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?
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 attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
Which three features are provided by Oracle Net Services? (Choose three)
what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)