Oracle 8 DBA MCQ Questions Answers

1. Which networking feature is not supported by Oracle?

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

3. How can you rename a User in Oracle?

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

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

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

7. What does TNS stand for?

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

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

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

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

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

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

14. What does the Startup Restrict command do?

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

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

17. When is the Startup Mount command issued?

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

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

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

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

22. What does the Startup Force command do?

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

24. What is the Oracle passwords file used for?

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

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

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

28. What is Oracle Parallel Query Option?

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

30. Which command is used to enable a role?

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

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

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

34. What is the LCK process responsible for?

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

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

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

38. How does Oracle allocate transactions to Rollback segments?

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

40. How can you rename the System tablespace?

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

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

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

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

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

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

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

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

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

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

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

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

53. Which package is required for manipulating Snapshots?

54. How is the passwords file created in Oracle?

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

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