General Oracle 8 DBA MCQs

1. Which file contains the configuration information for Oracle Connection Manager?

2. Which one is true with regard to Incremental and Cumulative export?

3. How is the passwords file created in Oracle?

4. Which package is required for manipulating Snapshots?

5. Which statement is true with regard to the Process Global Area(PGA)?

6. Which command will you use to mount the database in parallel mode?

7. Which statement is true with regard to Clusters in Oracle?

8. Which files are used to configure SQL*Net or Net8 on an Oracle client machine?

9. If the Oracle Parallel Query Option is installed and configured, how do you specify that a SQL query should be parallelized?

10. Your database has a tablespace called Data which contains all tables and indexes. For performance reasons, you want to shift all the indexes into a new tablespace called Idx. Which technique will you adopt?

11. How do you configure Multiple Protocol Support in Oracle.

12. You grant the DBA role to user Jack using the With Admin Option clause. Which of the following is true?

13. Which package is required for writing Dynamic SQL code?

14. What are the requirements if you want to perform Hot Backups of your Oracle database?

15. Which files are used to configure SQL*Net or Net8 on an Oracle Server?

16. The SQL*Loader utility can be run in several modes. Which of the following are they?

17. How can you rename the System tablespace?

18. Which command is used to force a logfile switch?

19. How does Oracle allocate transactions to Rollback segments?

20. What happens when you issue the Create Database command?

21. What is the purpose of assigning passwords to Roles?

22. Which network protocols are supported by SQL*Net and Net8?

23. What is the LCK process responsible for?

24. Which statement is true with regard row chaining in Oracle?

25. Which statement is true with regard to Incremental and Cumulative exports?

26. Which SQL script is executed to set up the procedural option?

27. Which command is used to enable a role?

28. What is the difference between public and private rollback segments?

29. What is Oracle Parallel Query Option?

30. Which statement is true with regard to SQL*Loader?

31. Which statement is true with regard row migration in Oracle?

32. Which statement is true with regard to Exporting and Importing in Oracle?

33. What is the Oracle passwords file used for?

34. Is Internal the only user who can startup and shutdown the database?

35. What does the Startup Force command do?

36. Which command can be used to force a checkpoint?

37. How do you change the password of the Internal user?

38. How can you integrate non-Oracle databases into an Oracle distributed database?

39. Which statement is true with regard to SQL*Loader?

40. When is the Startup Mount command issued?

41. Which statement is true with regard to the Shutdown command in Oracle?

42. When you configure MTS on your Oracle server, how does it influence the size of the SGA and the PGAs as compared to Dedicated Servers?

43. What does the Startup Restrict command do?

44. Which statement is true with regard to the export dump file generated by the Oracle Export utility?

45. What is the primary reason behind computing statistics for a table using the Analyze Table command?

46. What restrictions exist when you try to drop a tablespace?

47. Which command is used to drop a tablespace which contains some objects.

48. In order to implement the Oracle Multi-Threaded Server(MTS), which files must you configure?

49. If Oracle Parallel Query Option is installed, which Oracle background process handles Parallel queries?

50. What does TNS stand for?

51. Which SQL script is executed to set up the replication option?

52. Which SQL script is executed to create the data dictionary?

53. You have created a fresh database and along with it, the System tablespace has been created, which contains the System rollback segment. What is the limitation if you don't create any additional rollback segments?

54. How can you rename a User in Oracle?

55. Which operation cannot be performed using SQL*Loader?

56. Which networking feature is not supported by Oracle?