| 1: | Which of the following users would you use to connect to the instance to run the scripts that create the data dictionary in the database? A. SYSTEM B. SYS C. SYSDBA D. INTERNAL
|
| A1: | Answer B is correct. SYS is the user you connect to the database instance with in order to create the data dictionary structures. Answer A is incorrect because SYSTEM does not have, and should not be given, sufficient privileges to run the data dictionary creation scripts. Answer C in incorrect; SYSDBA is a role, not a user. Answer D is incorrect because INTERNAL, although a possible answer in previous releases, has been made obsolete in Oracle 9i. |
| 2: | You are ready to create the data dictionary in your new database. What scripts do you run at the SQL prompt to create the data dictionary structure? [Select all that apply] A. catalog.sql B. data_dictionary.sql C. standard.sql D. catproc.sql E. catldr.sql F. catexp.sql G. cataudit.sql
|
| A2: | Answers A and D are correct. You run catalog.sql and catproc.sql when you need to create the data dictionary in your database. Answer B, data_dictionary.sql, is not a script that is in the Oracle system. Answers C, E, F, and G are incorrect because, although they are run to create the data dictionary tables and views, they are called by catalog.sql to do this. |
| 3: | You are trying to figure out when the best time to create your data dictionary would be. Select the answer that best provides the most appropriate time to create it. A. At the beginning of the CREATE DATABASE script B. After you have created all the user tablespaces and tables in the database so you are sure that you get all that information in the data dictionary C. After database creation and before giving users access to the database D. After database creation and after giving users access to the database
|
| A3: | Answer C is correct. You need to create the data dictionary after the database has been created but before you give users access to the database to make sure that anything that gets created by the users gets created and accounted for correctly. Answer A would be great; that way you always know you have it in place and you haven't forgotten anything. However, you have to have a database created in order to support the data dictionary. Answer B is incorrect because you need to have the data dictionary in place before you start creating other objects in the database. Answer D is incorrect because you could cause issues with your database if you allow users to start to create things and attempt to run transactions in the database before you have created the views and tables that are supposed to be there to help support those actions. |
| 4: | catalog.sql creates what in relation to the data dictionary? |
| A4: | Answer A is correct. catalog.sql creates the tables and views for the data dictionary. Answer B is incorrect because there is nothing really known as the data dictionary catalog. Answer C is incorrect; catproc.sql creates the packages and procedures. Answer D is incorrect; the CREATE DATABASE script creates the system tablespace, which houses the data dictionary. |
| 5: | Which would contain a list of all the objects to which you, as the logged-on normal user, have access? A. DBA_OBJECTS B. ALL_OBJECTS C. USER_OBJECTS D. MY_OBJECTS
|
| A5: | Answer B is correct. ALL_OBJECTS would give you information about all the objects to which you, as the logged-on regular user, have access. Answer A, DBA_OBJECTS, is the DBA-specific view of all the objects in the database and would provide information on all the objects to which the DBA has access (which is all the objects in the database). Answer C is incorrect because USER_OBJECTS would only give you a list of all the objects that you own. Answer D is incorrect because there is no data dictionary view by that name. |
| 6: | What is not a synonym for the DICTIONARY data dictionary view? A. CAT B. CATALOG C. DICT D. DICTION
|
| A6: | Answer D is correct. DICTION is not a synonym for the DICTIONARY view. Answers A, B, and C are not correct because all these are synonyms for DICTIONARY and can be used interchangeably. |
| 7: | Who owns the data dictionary? A. Oracle B. SYS C. The DBA D. SYSTEM
|
| A7: | Answer B is correct. SYS owns the data dictionary. Answer A is incorrect because Oracle is not a privileged user of the database, only the server system that runs the instance. Answer C is incorrect because, although the DBA manages the database, the instance, and by extension the data dictionary, she does not own the data dictionary. Answer D is incorrect because the data dictionary is housed within the SYSTEM tablespace but is not owned by the user SYSTEM. |
| 8: | Which of the following would be a dynamic performance view in the data dictionary? A. V$SESSION B. DBA_PERFORMANCE C. DBA_DATA_FILES D. DBA_EXTENTS
|
| A8: | Answer A is correct. V$SESSION and all the V$ views are dynamic performance views. Answer B, DBA_PERFORMANCE, is not a table or a view in the data dictionary. Answer C, DBA_DATA_FILES, provides you with information on data files in the database but is not dynamic. Answer D, DBA_EXTENTS, provides some information from which you can infer performance information, maybe, but is also not a dynamic view. |
| 9: | Which three views would provide you with information about tables in the database? A. DBA_TABLES B. DBA_TABLESPACES C. V$TABLES D. USER_TABLES E. ALL_TABLES
|
| A9: | Answers A, D, and E are correct. Recall that for every DBA_ view, there is a corresponding ALL_ view and a USER_ view to provide different views on the same information depending on the information needed and the privileges granted. Answer B would provide information about tablespaces but not tables. Answer C, V$TABLE, might be inferred to be a dynamic performance view; however, it isn't a view in the database, and it would not provide information about tables but about their performance. |
| 10: | If you were looking for information on what SQL statements a user was currently running in your database, what view might you look to? A. V$SQLAREA B. DBA_SQL_AREA C. USER_SQL_AREA D. ALL_SQL_AREA
|
| A10: | Answer A is correct; in V$SQLAREA dynamic performance view, you can find currently running SQL statements in the database. Answers B, C, and D are incorrect all for the same reasons. Not only are there no views with these names that point to currently running SQL, even if there were, these types of views are not dynamic views that would capture active information like currently running SQL. |
