Which process is responsible for writing the contents of database buffers to data files?
http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254
(see database writer process (DBW))
Which type of information is included in dynamic performance views?
1 - System and session parameters
2 - Memory usage and allocation
3 - File states (including RMAN backup files)
4 - Progress of jobs and tasks
5 - SQL execution
6 - Statistics and metrics
http://docs.oracle.com/cd/E16655_01/server.121/e17633/datadict.htm#CNCPT1213 (overview of dynamic performance views)
Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you recommend?
An Oracle instance is a combination of______.
http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch9.htm#o instance
You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm
Submit Cancel