By which of the following background processes are the contents of redo log buffer transferred periodically from memory to the online redo log files on disk?

Which of the following is composed of one or more datafiles on disks?

Which of the following caches is managed using the least recently used algorithm?

Which of the following options of STARTUP command starts up the database using the static non default attribute file to startup the database?

When any changes are made to the database such as updates to data or creating or dropping database objects, the changes are recorded to the which of the following files first?

By which of the following background processes are the contents of the database buffer cache written to data files on disk?

In which of the following options of SHUTDOWN command does the oracle server wait for all currently connected users to disconnect their session?

In which of the following files is the database responsible for validating user credentials?

In which of the following pools are the sizes of the library cache and the data dictionary cache not set individually and automatically determined by the oracle server?

When a user process is terminated abnormally, which of the following background processes cleans up the resources that were held by the user process?

Which of the following files contains all the data of the database that the users of the database save and retrieve?

Which of the following options of the STARTUP command can be used to abort the running instance and perform a normal startup?

In which of the following options of the SHUTDOWN command does the oracle server automatically roll back all currently active transactions?

A copy of the which of the following files resides on at least three different physical disks?

Which of the following files is used for complete recovery up to the point of failure?