databases Online Quiz - 169
|Description: databases Online Quiz - 169|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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?
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)
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)
what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)