| 1: | You are the new DBA onsite, and you need to find the name and location of your control files. Which of the following is not a location in which you can find that information? |
| 2: | User Michael has INSERT privileges on the GL_RECORDS table. What will Michael notice first when you revoke this privilege? A. All the records inserted by the user will be removed from the database. B. The user will be removed from the database. C. The user will no longer be able to create tables. D. The user will not be able insert any more information into the GL_RECORDS table.
|
| 3: | The location and size of all the indexes in your database can be found in which data dictionary view? A. USER_INDEXES B. USER_SEGMENTS C. DBA_INDEXES D. DBA_OBJECTS E. None of the above
|
| 4: | What single profile areas can be used to control resource usage of the others? |
| 5: | You are assigning a default role for users. Which of the following is not an acceptable method for assigning a default role? A. ALTER USER DEFAULT ROLE NONE EXCEPT mydefaultrole; B. ALTER USER DEFAULT ROLE ALL; C. ALTER USER DEFAULT ROLE NONE; D. ALTER USER DEFAULT ROLE ALL EXCEPT ALL EXCEPT mydefaultrole;
|
| 6: | You have a database with automatic archiving of redo logs enabled. All your redo log files are on the same physical disk. Where might you find conflicts occurring with background process? A. PMON and SMON B. DBWR and LGWR C. ARCH and LGWR D. LGWR and PMON
|
| 7: | In which of the following tablespaces would you find the data dictionary information? A. SYS tablespace B. SYSTEM tablespace C. Dictionary tablespace D. UNDO tablespace
|
| 8: | You are the new DBA, and you need to reorganize one of your tablespaces. What privilege will you need to log on to the database when the database is up and open but not available to users? A. CREATE SESSION B. CONNECT C. RESOURCE D. RESTRICTED SESSION
|
| 9: | You need to do maintenance on a table in a dictionary managed tablespace. You need to alter the initial segment size for a given table. Which of the following keywords would have to be used to accomplish this feat? A. ALTER TABLE B. RESIZE C. DROP TABLE D. COALESCE
|
| 10: | Examine the following statement: CREATE TABLE friends (friend_id NUMBER (5), Flast_name VARCHAR2(45), Ffirst_name VARCHAR2 (45), Street_addr1 VARCHAR2(60), Street_addr2 VARCHAR2 (60), Fcity VARCHAR2 (45), Vstate CHAR(2), Vzip VARCHAR215) CONSTRAINT pk_friend primary_key (friend_id)) TABLESPACE mydata1 EXTENT MANAGEMENT LOCAL;
What is wrong with this statement? A. There are too many columns. B. The primary key is declared incorrectly. C. The storage clause is wrong. D. You have to declare an index tablespace for the primary key index.
|
| 11: | Which is not an appropriate storage parameter for indexes? A. TABLESPACE B. OPTIMAL C. INITIAL D. PCTINCREASE
|
| 12: | You are working on determining how Oracle processes user statements. SQL and PL/SQL statements' parse information is stored in which of the following memory areas? A. Row cache B. Buffer cache C. Library cache D. Dictionary cache
|
| 13: | Information from the buffer cache is saved back to disk in all the following situations except one. In which situation does this not occur? |
| 14: | You have just created your first new database. Which two scripts do you need to run to create your data dictionary structures and the Oracle supplied packages? A. catalog.sql B. utlrp.sql C. catproc.sql D. utlpwdmg.sql
|
| 15: | You created a new user in your database. You instruct the user with the ID and password necessary to log on, but he still complains that he is getting errors stating that there are insufficient privileges. Which of the following would you do? A. GRANT CREATE TABLE to the user. B. Unlock the user's account. C. Reset the user's password. D. GRANT CONNECT to the user.
|
| 16: | You enabled auditing in the database with the following statement: AUDIT UPDATE, DELETE ON GL.GL_RECORDS BY ACCESS WHEN NOT SUCCESSFUL;
Which describes how Oracle will now audit data? A. All successful inserts on the table will be recorded. B. All unsuccessful inserts on the table will be recorded. C. All successful updates and deletes will be recorded. D. All unsuccessful updates and deletes will be recorded.
|
| 17: | You issue the following statement: DROP PROFILE developer_profile;
This profile was granted to several users in the active database. What will happen to these users? A. All users who had the profile will no longer be able to log on to the database. B. All users who had the profile no longer have any profile. C. All users who had the profile now have the DEFAULT profile. D. You cannot drop the profile as long as there are users to whom it is assigned.
|
| 18: | You need to restart your database. At 4:30 p.m., you issue the SHUTDOWN command. After two hours, the database is still in the process of shutting down. Which of the following commands did you most likely issue to initiate the shutdown? |
| 19: | You need to see the initialization parameter settings for your Oracle 9i database. Which of the following choices is not a method used to obtain this information? A. Check the spfile.ora. B. Use OEM Instance Manager. C. Issue SELECT * FROM V$PARAMETER; in SQL*Plus. D. Issue SELECT * FROM DBA_PARAMETERS; in SQL*Plus.
|
| 20: | You have been instructed to set up auditing on the invoice entry system. The requirement is that whenever the invoice status changes to paid, an entry is entered into the payment table. Which of the following represents the best way to perform this auditing? A. Statement auditing B. Object auditing C. Access auditing D. Value-based auditing
|
| 21: | When a user issues a COMMIT statement in his session, which of the following will not occur? [check all that apply] A. Acquired lock on the table or row is released. B. Redo entry generated for committed transaction. C. Cached data saved immediately to disk. D. All users can see alterations made to the data.
|
| 22: | Which of the following is not a valid segment type in Oracle 9i? A. Sequence segment B. Data segment C. Temporary segment D. Undo segment
|
| 23: | Where would you find the amount of free space available in a tablespace? A. DBA_TABLESPACE B. DBA_FREE_SPACE C. V$FREE_SPACE D. V$TABLESPACE
|
| 24: | Which of the following describes what happens after the listener process detects a user trying to connect to the database with dedicated servers being used? A. The listener will spawn a new server process. B. The listener will pass the request to a dispatcher. C. The listener will pass the request to the LGWR process. D. The listener will pass the request to the DBWn process.
|
| 25: | Which of the following choices correctly identifies exactly when Oracle reads the init.ora file? A. When the instance is started B. When the database is started C. When the database is opened D. When the database is shut down
|
| 26: | You have decided to use Oracle Managed File Systems. You have issued a CREATE TABLESPACE command. Which of the following parameters tell you where Oracle placed the data file that it associated with the new tablespace? |
| 27: | You have determined that you need to shut down your database quickly. Which of the following commands would you use to accomplish this if you were prepared to allow Oracle to perform instance recovery when you started back up? |
| 28: | If you want to use Oracle Managed File Systems to handle the locations of redo logs, minimally, what is the number of destinations you need to specify for the associated parameter in the init.ora file? |
| 29: | You are preparing to manually create an Oracle 9i database. Which of the following parameters must be changed in the new copy of your init<SID>.ora file to create a database that will not interfere with any existing databases on the host machine? A. DB_BLOCK_SIZE B. CONTROL_FILES C. SHARED_POOL_SIZE D. MAX_DATAFILES
|
| 30: | You are using DBCA to configure a database. Which of the following terms refers to the DBCA object on which you can base your configuration settings? A. Template B. Clone C. Copy D. CP
|
| 31: | When configuring new profiles in your database, which of the following is not an area on which you can specify a resource profile? |
| 32: | Which of the following alterable characteristics can a user change by herself? A. DEFAULT TABLESPACE B. IDENTIFIED BY C. TEMPORARY TABLESPACE D. QUOTA
|
| 33: | To attach an additional role to a user, which command is most appropriate? A. ALTER USER B. ALTER SYSTEM C. ALTER ROLE D. GRANT
|
| 34: | Which of the following requires the use of undo segments? [check all that apply] A. INSERT B. UPDATE C. DELETE D. SELECT
|
| 35: | You are attempting to clear an unarchived redo log file. To do this, you are attempting to manually cause a log switch. Which of the following statements will accomplish this? |
| 36: | Which of the following statements is available for the ALTER USER but not for the CREATE USER statement. A. IDENTIFIED BY B. TEMPORARY TABLESPACE C. DEFAULT ROLE D. PROFILE
|
| 37: | You have already defined your national character set in your database to be English. Some of the fields in our tables contain German characters. To ensure that you can sort the fields containing these characters correctly, the following parameters should be set: A. NLS_DATE_FORMAT B. NLS_SORT_ORDER C. NLS_TERRITORY D. NLS_SORT
|
| 38: | You are maintaining a database in multiple countries in multiple languages. To help you to determine what the date conventions are for the database in any given country, you might be able to query which of the following data dictionary views? A. V$NLS_DATE B. DBA_DATE_FORMAT C. NLS_DATE_FORMAT D. V$NLS_PARAMETERS
|
| 39: | You need to remove a column from a table in your database, and the column has considerable data in it. Which of the following best provides a means by which you can accomplish this if your primary objective is to remove the column quickly and not necessarily free up any of the used space? A. ALTER TABLE DROP COLUMN B. ALTER TABLE MODIFY COLUMN C. ALTER TABLE RENAME COLUMN D. ALTER TABLE SET UNUSED COLUMN
|
| 40: | You are using locally managed tablespaces; how does Oracle implement this? A. Using a bitmap in the space header segment B. Using the data dictionary locally C. Using an independent flat file in the file system D. Using special information in the data dictionary that only that table can get to
|
| 41: | You issued the following statement on a database where the standard block size is 4K. CREATE TABLESPACE myindexes DATAFILEDatafile '/oracle/data/indexes01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50k ONLINE;
How many blocks will each bit represent in the bitmap area of the locally managed data files? |
| 42: | Which pair of words completes the following statement? When the STARTUP NOMOUNT command is issued, the Oracle instance is _____________, and the Oracle database is ______________? |
| 43: | You are creating a new control file to replace ones that have been deleted. Which of the following commands is the appropriate way to start the database? A. STARTUP NOMOUNT B. STARTUP READ-ONLY C. STARTUP OPEN D. STARTUP
|
| 44: | What two tools can be used for starting up and shutting down the Oracle instance and database? [select two] A. SQL*Plus B. Server Manager C. Enterprise Manager D. PL/SQL
|
| 45: | 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
|
| 46: | 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
|
| 47: | Who owns the data dictionary? A. Oracle B. SYS C. The DBA D. SYSTEM
|
| 48: | At what point does the CKPT process write data blocks to the data files? [select all that apply] A. Whenever LOG_CHECKPOINT_INTERVAL parameter tells it to. B. Whenever LOG_CHECKPOINT_TIMEOUT tells it to. C. Whenever there is a log switch. D. CKPT doesn't write anything out to files; it tells the other processes to do that.
|
| 49: | User crystal has had the following ALTER USER statement run against her userid: ALTER USER crystal QUOTA MYDATA 0K QUOTA MYDATA2 100M;
As soon as the command has finished, crystal attempts to add data to her address table that already existed in MYDATA and was at an extent barrier. What is the effect of the insert? A. Because the table already existed, the insert was successful. B. The table was automatically moved when the ALTER USER command was run, so the insert was successful. C. The table still exists in the MYDATA tablespace but cannot be added to because the quota is now 0. D. The table has been dropped as a side effect of the ALTER USER command, so the insert was unsuccessful.
|
| 50: | Which statement is true about segments? A. Each table has its own segment. B. A segment is created every time an extent is created, extended, or altered. C. An index segment is created every time a table is created. D. A segment is deleted whenever a table is truncated.
|
| 51: | When is the SGA created in an Oracle instance? A. When the database is created B. When the instance is opened C. When the user process is started D. When a server process is started
|
| 52: | You have been monitoring the usage of an index that you believe to be underused on a table. You find that the index is used extensively but only during the first week of the month, when Accounting is running month-end processing. The rest of the month, the index is used only rarely despite the fact that it is an actively updated table. What could you do to speed up processing during the majority of the month, yet allow queries to run as rapidly as possible during the month-end processing? A. Drop the index; it is obviously only used 25% of the time. B. Move the index to another tablespace. C. Drop the index after the month-end processing and rebuild it right before the next month-end processing. D. Rebuild the index immediately before the month-end processing.
|
| 53: | Which statements are true in relation to the number of indexes on a table? [select all that apply] A. Every column ID in a table that is subject to update will see update performance improve with the addition of at least one index on the column. B. Every column that participates in a query should have an index. C. There is a limit of 32 indexes on a table. D. There is a limit of 32 columns in an index. E. Columns that are often queried as part of a where clause are good candidates for an index.
|
| 54: | After running ANALYZE INDEX claim_id_idx VALIDATE STRUCTURE, you query the INDEX_STATS view and learn that you have a rather high ratio of deleted leaf rows (DEL_LF_ROWS) to leaf rows (LF_ROWS). In fact, the ratio ends up being almost 40%. You decide that you need to reorganize the index to free up some of the extra space but that the space should remain allocated to the index so that it can be reused for new entries. Which command or commands would allow you to perform this task while maintaining the minimum impact on the users who are running queries on the system? [select all that apply] |
| 55: | To determine which roles are available in the database, use the __________ view, and to determine which system privileges have been granted to a role, use the ___________ view. A. DBA_ROLES, DBA_SYS_PRIVS B. DBA_ROLES, DBA_SYSTEM_PRIVS C. SESSION_ROLES, DBA_SYS_PRIVS D. DBA_ROLES, DBA_TAB_PRIVS
|
| 56: | Which predefined role is useful for database administrators because it requires having all the administrative privileges needed to maintain the entire database? A. DBA B. SYSTEM C. SYSOPER D. RESOURCE
|
| 57: | You create a role called developer and grant CREATE TABLE and SELECT ANY TABLE to that role. Then you grant the role to user Lynn. Lynn then logs in to the database. What is true about Lynn's ability to manipulate tables in the database? A. She can create and select from tables immediately after she logs in. B. She can create and select from tables after she logs out and back in. C. She has to have DEVELOPER deliberately set as her default role before she can manipulate tables. D. She has to have CREATE TABLE and SELECT ANY TABLE granted to her directly before she can manipulate tables.
|
| 58: | Which privilege enables a user to create a foreign key relationship on another user's table? A. CREATE INDEX B. CREATE ANY INDEX C. REFERENCES D. CREATE ANY KEY
|
| 59: | Which of the following statements is true to enable auditing in the database? A. To set up auditing in Oracle, the AUDIT_TRAIL initialization parameter must be set to DB or OS. B. To set up auditing in Oracle, the BEGIN_AUDIT initialization parameter must be set to trUE. C. To set up auditing in Oracle, the AUDIT_TRAIL initialization parameter must be set to NONE. D. To set up auditing in Oracle, the AUDITING initialization parameter must be set to TRUE.
|
| 60: | Your company has decided to implement a password expiration plan. What parameter do you need to set to cause all passwords to expire every 60 days? |
