oracle dba quiz

1. You are working in an organization which is situated in many countries. You maintain databases in multiple countries in multiple languages. To determine the date conventions for a database in a particular country, you might use which of the following database views?

2. You are performing the steps that will create your Oracle data dictionary. The objects in the Oracle data dictionary are part of which of the following schemas?

3. After creating a new user for your Oracle database, a user still complains he or she cannot log in because of insufficient privileges errors. Which of the following actions should you take?

4. On an Oracle server installation, which of the following reorganizations of your indexes would be appropriate in order to improve performance of queries on tables containing all words in the dictionary starting with the letter 'S'?

5. A organization is taking online backups of the database, with the database operating in ARCHIVELOG mode. Due to a media failure they lost the SYSTEM tablespace data files. What must they do to recover the data files?

6. A disk crashes that contains the only copies of all four of your online redo log files. How would you alter your Oracle database to prevent this from causing much damage in the future?

7. You are about to drop a tablespace. Which of the following statements can be used for dropping tablespaces that contain parent tables in foreign key relationships?

8. As the DBA, you are attempting to limit user's misuse of Oracle's ability to use host machine resources. Which of the following features of the Oracle database is useful for this purpose?

9. During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?

10. You issue the alter tablespace read only command against an Oracle database. Which of the following choices best describes what happens next?

11. Which one of the following statements is incorrect with respect to RMAN's CROSSCHECK command?

12. Which one of the following statements is true while taking tablespace backups using RMAN?

13. Which of the following is the init.ora parameter that indicates the size of each buffer in the buffer cache?

14. Records from the data dictionary information are stored in which of the following database memory areas?

15. We are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?

16. Which one of the following RMAN commands is equivalent to the SQL statement ALTER DATABASE RENAME FILE ?

17. Information in the buffer cache is saved back to disk in each of the following situations except one. In which situation does this not occur?

18. You need to remove a column from the database. Which of the following choices best identifies how to do so if your objective is to quickly execute the task without necessarily freeing up space in your tablespace?

19. You are running Oracle in America in support of a financial analysis project for the government of Egypt. In order to produce reports that display money amounts as Egyptian pounds, rather than dollars, which of the following initialization parameters would be useful?

20. You are defining storage for various segment types in the Oracle database. Which of the following is not a valid type of segment in Oracle?

21. You are implementing control file multiplexing. Which of the following choices identifies how Oracle knows the locations of the control files it is supposed to maintain?

22. The best choice for decreasing size requirements for tables that need only be accessed via the primary key in oracle is which of the following?

23. Session information when dedicated servers are being used is stored where in the Oracle database?

24. You are trying to find the ALERT file on a host machine for a database (11g and below) you have never administered before. Which of the following initialization parameters is used to identify the location of the ALERT file?

25. Which one of the following RMAN views must you query to view the code of an existing stored script in the recovery catalog?

26. You alter a tablespace’ s default storage settings in the Oracle database to increase the size of initial extents. Which of the following choices identifies when the change will take effect for tables that already exist in that tablespace?

27. You are using locally managed tablespaces in Oracle. Which of the following choices best describes the way Oracle implements this feature in the database?

28. You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources?

29. When choosing a character set and national character set, which of the following factors should not enter into consideration?

30. Which of the following choices lists an alter user option that can be executed by the user herself or himself?

31. You issue the following statement in Oracle:
CREATE UNIQUE BITMAP INDEX empl_lastname_indx_01
ON employee (lastname ASC);
What is wrong with this statement for dictionary-managed tablespaces?

32. You attempt to issue the alter tablespace rename datafile command in the Oracle database. Which of the following choices indicates a step that must take place after this command is issued?

33. If you wished to make it so that every user in Oracle could have only one connection to the database at a time, which of the following choices identifies how you would do it?

34. Which one of the following statements is incorrect about direct-path insert operations?

35. Which of the following operations do not require Oracle to store information in an undo segment as part of the transaction?

36. Which of the following clauses in a create user statement restricts the number of tables a user can add to a tablespace?

37. You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?

38. A User accidentally drops a very critical table. What kind of failure just occurred?

39. When we issue the commit statement in the session, which of the following things will not occur?

40. Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?