Oracle 10g Database Administration MCQ Questions Answers

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

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

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

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

5. 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?

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

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

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

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

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

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

12. What are the functions of an ASM instance?

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

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

15. 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?

16. 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?

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

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

19. 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?

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

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

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

23. ASM disk groups provide:

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

25. 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?

26. Which commands are used to apply incremental backups?

27. The initialization parameter UNDO_RETENTION is used:

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

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

30. Which statements are correct about an ASM instance?

31. 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?

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

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

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

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

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

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

38. The SQL Access Advisor is managed:

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

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

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

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

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

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

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

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

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

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

49. 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?

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

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

52. 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

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

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

55. What is meant 'short selling'?

56. What is the primary goal of technical analysis?

57. What is an 'option spread'?

58. What is an options contract?

59. Which situation has the least risk?

60. What does heavy volume trading indicate?

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

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

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

64. How is risk measured?

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

66. What is a 'put'?

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

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

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

70. How would an options investor diversify their portfolio?

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

72. What is a sideways chart?

73. What is the offset to limiting downside?

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

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

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

77. What is the 'expiration date'?

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

79. What is a covered call?

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

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

82. What is a 'strangle'?

83. What is a 'call'?

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

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

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

87. What is portfolio management?

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

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

90. What is the purpose of candlestick charting?

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

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

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

94. Which one would technical analysis include?

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

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

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

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

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

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