General Oracle 10g Database Administration MCQs

1. Which data dictionary view shows the available free space in a certain tablespace?

2. User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?

3. Which conditions among the following must be met, if the tablespace is to be made read only?

4. When is SGA created in an Oracle database environment?

5. What do ASM disk groups provide?

6. When a deadlock shutdown is detected by Oracle, where is the trace file generated?

7. Where is the free space managed, for a tablespace created with automatic segment-space management?

8. Which statement is valid regarding index clusters?

9. Where can a SQL Tuning Set(STS) be created from?

10. Which set of tablespaces is mandatory for any Oracle 10g database?

11. For which two tasks would it be best not to use the utility SQL*Loader?

12. Which one is true if the alter tablespace statement is used and the TEMPORARY clause is specified?

13. What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?

14. Which conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?

15. A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

16. How can the SQL Access Advisor be managed?

17. If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?

18. Which command would revoke the ROLE_DATA role from all users?

19. Which one is a new initialization parameter for Oracle Database 10g?

20. Which three statements among the following are true about rebuilding indexes?

21. Which ones are considered types of segments?

22. Examine the following SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

23. What are the two main advantages of using bitmap indexes?

24. What does the RMAN CATALOG command do?

25. How is the SQL profile used?

26. Which commands are used to copy ASM files?

27. What will happen if the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup?

28. What does the ARBn background process do in an ASM instance?

29. When there is a monotonically increasing sequence number as an indexed column, which of the following is true?

30. Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

31. Which command must be used to apply incremental backups?

32. To grant a system privilege with the GRANT statement, one should:

33. For what purpose is the initialization parameter UNDO_RETENTION used?

34. Which three are the physical structures that constitute the Oracle database?

35. Which view provides the names of all the data dictionary views?

36. Which one is true when John uses the RESETLOGS option?

37. Which data dictionary view should be used to get a list of object privileges for all database users?

38. Which one helps the user identify his statement in the DBA_TUNE_MVIEW view?

39. Which three major tuning areas does OEM Database Control provide information about?

40. Which one would technical analysis include?

41. How often would an active options trader perform technical analysis?

42. What is the ideal number of portfolios for an experienced trader?

43. What is the most classic type of options trading?

44. What is the purpose of candlestick charting?

45. How does the 'Iron Condor' technique limit the downside?

46. Which one would be a good example of risk mitigation?

47. What is portfolio management?

48. Why is it important to manage risk when trading stock options?

49. What would be the risk tolerance level of a retired government worker in general?

50. Why would someone sell call options on a security they own?

51. What is a 'call'?

52. What is a 'strangle'?

53. What would an investor who is employing the straddle technique hope to happen?

54. Why would an investor not utilize an options trading strategy?

55. What is a covered call?

56. What is meant by a 'butterfly' trading strategy?

57. What is the 'expiration date'?

58. What does an options trader look for when charting?

59. Which one would not be an example of managing risk?

60. Why might an options trader have portfolios based on expiration?

61. What is the offset to limiting downside?

62. What is a sideways chart?

63. What would an investor using the Black Scholes model be doing?

64. How would an options investor diversify their portfolio?

65. What happens to an investment if risk is mitigated properly?

66. Which one is the least risky investment in options?

67. What does the Monte Carlo method of pricing options attempt to do?

68. What is a 'put'?

69. Why are younger people more apt to take on riskier investments?

70. How is risk measured?

71. What is the relationship between fundamental and technical analyses?

72. Why do investors often expect the beginning of the year stock prices to rise?

73. What is meant by a 'bear market'?

74. What does heavy volume trading indicate?

75. Which situation has the least risk?

76. What is an options contract?

77. What is an 'option spread'?

78. What is the primary goal of technical analysis?

79. What is meant 'short selling'?

80. Which items are stored in the flash recovery area?

81. For which two types of tablespaces can proactive tablespace alerts be set?

82. Which data dictionary view should be queried to find the following information about a user? 1.Whether the user's account has expired 2.The user's default tablespace name 3.The user's profile name

83. Where can the nondefault parameters be found when the instance is started?

84. Who will be the owner of the job, if you create a job in user SCOTT's schema?

85. An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?

86. Which option lists the correct hierarchy of storage structures, from largest to smallest?

87. Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining?

88. What happens once the DBA disables the flash recovery area?

89. What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE?

90. What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?

91. Which graphical DBA administration tool should be used to tune an Oracle database?

92. Which one is mandatory when using the easy connect naming method?

93. Which initialization parameter specifies the location of the alert log file?

94. In an Oracle database environment, SGA is created:

95. Which statements is/are incorrect with regard to CATALOG command in Oracle 10g?

96. The SQL Access Advisor is managed:

97. ______________ is mandatory for using the easy connect naming method.

98. Which type of command is used to move data files between Oracle ASM disk groups?

99. Which statements are correct for using the RESETLOGS option?

100. Which data dictionary views should be used to get a list of object privileges for all the database users?

101. Which tablespace is used as a temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?

102. What is the purpose of the flashback technology in Oracle Database 10g?

103. Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?

104. Which statements are correct about an ASM instance?

105. The utility SQL*Loader should not be used:

106. What are two main advantages of using bitmap indexes?

107. The initialization parameter UNDO_RETENTION is used:

108. Which commands are used to apply incremental backups?

109. Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sam WITH ADMIN OPTION; Which of the following actions is the user SAM able to perform?

110. Where can you find the non-default parameters when the instance is started?

111. ASM disk groups provide:

112. Which one helps you identify your statement in the DBA_TUNE_MVIEW view?

113. Where is the trace file generated when a deadlock shutdown is detected by Oracle?

114. In Oracle 10g, what is the default value for the initialization parameter 'RESUMABLE_TIMEOUT'?

115. What will happen if you set the value of the SGA_TARGET parameter higher than the value of the SGA_MAX_ SIZE parameter at instance startup?

116. What happens when the DBA disables the flash recovery area?

117. Which initialization parameter specifies the location of the alert log file?

118. Consider the following SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

119. You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be queried for the purpose?

120. Which command revokes the ROLE_DATA role from all the users?

121. What is the default value for the OPTIMIZER_MODE initialization parameter?

122. What are the functions of an ASM instance?

123. Which initialization parameters would belong to the basic group of parameters?

124. Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?

125. Which two statements are true about rebuilding an index?

126. Which memory structure contains the information used by the server process to validate user privileges?

127. For which two constraints are indexes created when the constraint is added?

128. Which data dictionary view shows the available free space in a certain tablespace?

129. Examine the SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1MB?

130. Which statement about the LOG_BUFFER initialization parameter is true?

131. What is the priority level for a job in a job class?

132. Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?

133. Which three among the following dynamic performance views obtain information from the control file?