1.. Oracle manages data in logical units called a..tablespaces b..instances c..blocks 2..The combination of Oracle (background) processes and memory buffers is called an a..Oracle instance. b..oracle terminology. c..database instance 3..Every running Oracle database is linked to an Oracle instance. Moreover, every Oracle database needs its own instance. a..True b..false 4..Every time an Oracle instance is started, a shared memory region called the a..System Global Area (SGA) b..database buffer cache c..shared poll area d..redo log buffer 5..The separate server process created on behalf of each work process is called a a..shadow process. b..row cache c..memory area 6..which process perform various tasks required for the database to function properly a..Oracle background processes b..database background process c..buffer process 7..To accelerate read and write access to data,it is cached in the a..database buffer cache in the SGA. b..data files c..redo log files 8..The Oracle database management system holds the executable SQL statements in the a..shared SQL area b..row cache c..buffer cache 9..The smallest logical unit that Oracle uses for copying data between data files and the buffer cache, as well as for managing data in the cache, is the a..data block. b..table block 10..The size of an Oracle data block is a..8KB b..80KB c..18KB d..88KB 11.. special Oracle background process called the a..database writer . b..log writer c..check point 12..the process of writing all modified buffers in the SGA are written to data files by the database writer is called as a..checkpoint b..redo log writer. 13..To achieve data consistency and read consistency, Oracle maintains redo entries for _______ or redo recovery for _____ to roll back uncommitted transactions. a..redo entries,undo entries b..undo entries,redo entries c..redo entries,redo entries d..undo entries,undo entries 14..Parallel to changes made in data blocks, Oracle shadow processes write redo entries into a..redo log buffer b..online redo buffer c..offline redo buffer 15..the system global area that temporarily records all changes made to the database . The Oracle background process uses a..log writer (LGWR) b..online redo log buffer c..offline redo log buffer 16..When a user commits a transaction, the transaction is assigned a a..system change number (SCN) b..listner indentity number(LIN) c.. 17..When the current online redo log file becomes full, the log writer process closes this file and starts writing into the next one. This is called as a..log switch b..control file c..background checkpoint process 18.. Online redo logs must always be mirrored a..true b..false 19..the process to prevent loss of redo information, it must be copied from online redo log files to a safe location before overwriting. a..archiver (ARC0). 20..System Monitor (SMON) a..Performs recovery at instance startup, if necessary b..Writes alert log information if any other instance process fails c..Cleans up temporary segments that are no longer in use 21..which Stores the logs written by the SAP tool BRARCHIVE a..saparch b..sapbackup c..sapreorg d..sapcheck 22..Stores logs written by the SAP tools BRBACKUP, BRRESTORE, and BRRECOVER a..sapbackup b..saparch c..sapcheck d..sapreorg 23..BRSPACE creates logs for its different functions here a..sapreorg b..sapcheck c..saparch d..sapbackup 24..Oracle Real Application Clusters (RAC) a..Concurrent processing b..Load balancing c..Fast and reliable detection of a node or network failure d..Fast recovery 25..while Changing Oracle environment variables we need to see the consequences a..Check the environment variables set, especially Oracle variables starting with ORA. b..Log on to the database server with the logon information provided by your instructor. c..Change variable ORACLE_HOME to any other path, then call the Oracle tool TNSPING to ping your
Confused? Feel free to ask
Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk
0 comments:
Post a Comment