Note: Thanks for your visit. We have uploaded all latest Upwork Oracle 10g Test questions. We are trying to solve these questions and answers will be updated soon. For updates, please keep visting this site and also share it with your friends. Thanks & Regards
Where can you find the non default parameters when the instance is started?
a. Alert log
b. Online redo log
c. Archiver redo log
d. SYSTEM user’s trace file
Which of the following views provides the names of all the data dictionary views?
Which of the following constitute the functions of an ASM instance?
a. Managing disk groups and communicating file metadata to the Oracle database using ASM files
b. Managing database files and communicating file metadata to the ASM instance using ASM files
c. Managing disk groups and communicating file metadata to the RMAN
d. Protecting disk groups
Which of the following statements are correct with regard to Rebuilding Indexes?
a. The ALTER INDEX REBUILD command is used to change the storage characteristics of an index
b. Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature
c. One cannot rebuild a bitmap index that is marked INVALID
d. When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild
What are two main advantages of using bitmap indexes?
a. Bitmap indexes use less storage space
b. Bitmap segments are updated upon COMMIT, at the end of the transaction
c. Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators
d. None of the above
What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter (in your initialization file) to TRUE?
a. The TIMED_STATISTICS parameter is set to TRUE
b. The hit percentage in the buffer cache is at least 95%
c. The OPEN_CURSOR parameter is set to at least twice the default value
d. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero
The initialization parameter UNDO_RETENTION is used:
a. To specify the length of time for which Oracle must retain undo data in the undo tablespace
b. To specify the length of time for which Oracle must retain undo data in the flash recovery area
c. To specify the length of time for which Oracle must retain undo data in the data files
d. To specify the length of time for which Oracle will retain undo data in the flashback database logs
ASM disk groups provide:
a. Redundancy through striping
b. Performance through mirroring.
c. Redundancy through mirroring
d. Performance through striping