Oracle 10g Database Administration MCQs
Oracle 10g Database Administration MCQs
These Oracle 10g Database Administration multiple-choice questions and their answers will help you strengthen your grip on the subject of Oracle 10g Database Administration. You can prepare for an upcoming exam or job interview with these 100+ Oracle 10g Database Administration MCQs.
So scroll down and start answering.
1: Which data dictionary view shows the available free space in a certain tablespace?
A. DBA_EXTENTS
B. V$FREESPACE
C. DBA_FREE_SPACE
D. DBA_TABLESPACFS
2: User Smith created indexes on some tables owned by user John. The following has to be displayed:
1.Index names
2.Index types
Which data dictionary view(s) should be queried?
A. DBA_INDEXES only
B. DBA_IND_COLUMNS only
C. DBA_INDEXES and DBA_USERS
D. DBA_IND COLUMNS and DBA_USERS
3: Which conditions among the following must be met, if the tablespace is to be made read only?
A. The tablespace must contain an active rollback segments
B. The tablespace must be online
C. The tablespace must not contain any active rollback segments
D. The tablespace must not be involved in an open backup
E. The tablespace must be involved in an open backup
4: When is SGA created in an Oracle database environment?
A. When the database is created
B. When the instance is started
C. When the database is mounted
D. When a user process is started
5: What do ASM disk groups provide?
A. Redundancy through striping
B. Performance through mirroring
C. Redundancy through mirroring
D. Performance through striping
6: When a deadlock shutdown is detected by Oracle, where is the trace file generated?
A. SQL_TRACE
B. TRACE_DEST
C. USER_DUMP_DEST
D. CORE_DUMP_DEST
7: Where is the free space managed, for a tablespace created with automatic segment-space management?
A. In the extent
B. In the control file
C. In the data dictionary
D. In the undo tablespace
8: Which statement is valid regarding index clusters?
A. Index clusters can only be used for tables with low cardinality columns
B. Index clusters are generally well suited for tables that have many full table scans
C. Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys
D. A cluster index always takes up much more storage space than a normal index for the same set of key values
9: Where can a SQL Tuning Set(STS) be created from?
A. Several SQLs statements from the AWR
B. One or more other STSs
C. A single SQL statement
D. Only the most high-load SQL statements in the database
10: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?
A. SYSTEM, SYSAUX, and UNDOTBS
B. SYSTEM and UNDOTBS
C. SYSAUX and UNDOTBS
D. SYSTEM and SYSAUX
11: For which two tasks would it be best not to use the utility SQL*Loader?
A. When loading selected rows into each table
B. When loading data from an export dump file
C. When loading data from disk, tape, or named pipes
D. When data is not being inserted from a flat file
12: Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?
A. Oracle no longer performs any checkpoint for the online datafiles in the tablespace
B. Oracle performs a checkpoint for all online datafiles in the tablespace
C. Oracle does not ensure that all files are written
D. The offline files may require media recovery before the tablespace is brought online
E. The offline files may require media recovery after the tablespace is brought online
13: What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?
A. Global statistics only
B. Global and partition statistics only
C. Global, partition, and subpartition statistics
D. No partitioned table statistics
14: Which of the following conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?
A. The datafile must be taken offline before renaming
B. The database must be open
C. When only a single datafile is to be renamed
D. When only a single datafile on the same drive is to be renamed
15: A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?
A. BLOCKS
B. PCT_FREE
C. NEXT_EXTENT
D. PCT_INCREASE
16: How can the SQL Access Advisor be managed?
A. Through the DBMS_SQLTUNE package
B. Through the DBMS_ADVISOR package
C. Through the SQL_TUNE package
D. Through the DBA_ADVISOR package
17: If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
A. Always
B. Only if the automatic backup using the OEM is configured
C. Only if user-managed backups is configured
D. Only if the database is run in the archive log mode
18: Which command would revoke the ROLE_DATA role from all users?
A. REVOKE role_data FROM ALL;
B. REVOKE role_data FROM PUBLIC;
C. REVOKE role_data FROM default;
D. REVOKE role_data FROM ALL_USERS
19: Which of the following is a new initialization parameter for Oracle Database 10g?
A. UNDO_SUPPRESS_ERRORS
B. PARALLEL_AUTOMATIC_TUNING
C. RESUMABLE_TIMEOUT
D. SHARED_SERVER
20: Which three statements among the following are true about rebuilding indexes?
A. The ALTER INDEX REBUILD command is used to change the storage characteristics of an index
B. Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature
C. Oracle8i allows for the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table
D. When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild itself
21: Which of the following are considered types of segments?
A. Only LOBS
B. Only nested tables
C. Only index-organized tables
D. Only LOBS and index-organized tables
E. Nested tables, LOBS, index-organized tables, and boot straps
22: Examine the following SQL statement:
CREATE TABLESPACE userdata
DATAFILE "/oracle/oradata/userdata_0l.dbf" SIZE 100M
LOCALLY MANAGED UNIFORM SIZE 1M
AUTOMATIC SEGMENT SPACE MANAGEMENT;
Which part of the tablespace will be of a uniform size of 1 MB?
A. Extent
B. Segment
C. Oracle block
D. Operating system block
23: What are the two main advantages of using bitmap indexes?
A. Bitmap indexes use less storage space
B. Bitmap indexes are easy to maintain when DML statements are issued
C. Bitmap segments are updated upon COMMIT, at the end of the transaction
D. Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators
24: What does the RMAN CATALOG command do?
A. Helps create image copies of datafiles
B. Helps create image copies of current control files
C. Helps catalog any new files that aren't a part of the recovery catalog
D. Helps catalog only the old files
25: How is the SQL profile used?
A. In the tuning mode of the optimizer only
B. In the normal mode of the optimizer
C. In neither the tuning nor the normal mode of the optimizer
D. Along with existing statistics, to get better SQL execution plans
26: Which of the following commands are used to copy ASM files?
A. RMAN commands
B. OMF commands
C. Operating system commands
D. Logical Volume Manager commands
27: What will happen if the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup?
A. The instance will not start
B. SGA_TARGET will become equal to the SGA_MAX_SIZE value
C. The database will ignore the SGA_TARGET parameter
D. SGA_MAX_SIZE is automatically raised, so it is equal to the SGA_TARGET value
28: What does the ARBn background process do in an ASM instance?
A. Coordinates disk activity
B. Performs disk rebalance work
C. Coordinates disk rebalance work
D. Manages the RBAL process
29: When there is a monotonically increasing sequence number as an indexed column, which of the following is true?
A. Hash-partitioned global indexes are useful
B. Range-partitioned global indexes are better
C. Hash-partitioned local indexes are better
D. Range-partitioned local indexes are better
30: Consider this SQL statement:
UPDATE employees SET first_name = "John"
WHERE emp_id = 1009;
COMMIT;
What happens when a user issues the COMMIT in the above SQL statement?
A. The server process places the commit record in the redo log buffer
B. Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files
C. The user process notifies the server process that the transaction is complete
D. The user process notifies the server process that the resource locks can be released
31: Which of the following commands must be used to apply incremental backups?
A. RECOVER BACKUP OF DATABASE
B. RECOVER DATAFILE
C. RECOVER COPY OF DATAFILE
D. RECOVER COPY OF DATABASE
32: To grant a system privilege with the GRANT statement, one should:
A. Have been granted the GRANT ROLE PRIVILEGE system privilege
B. Have been granted the system privilege with the ADMIN OPTION
C. Have been granted the GRANT ANY PRIVILEGE system privilege
D. Have been granted the system privilege with the GRANT OPTION
33: For what purpose is the initialization parameter UNDO_RETENTION used?
A. To specify the length of time Oracle must retain undo data in the undo tablespace
B. To specify the length of time Oracle must retain undo data in the flash recovery area
C. To specify the length of time Oracle must retain undo data in the data files
D. To specify the length of time Oracle will retain undo data in the flashback database logs
34: Which three out of the following are the physical structures that constitute the Oracle database?
A. Segment
B. Data file
C. Log file
D. Tablespace
E. Control file
35: Which view provides the names of all the data dictionary views?
A. DBA_NAMES
B. DBA_TABLES
C. DICTIONARY
D. DBA_DICTIONARY
36: Which of the following is true when John uses the RESETLOGS option?
A. He doesn't need to back up the database
B. He must back up the database right away
C. He can use archive redo logs from an older incarnation of the database
D. He can't use archive redo logs from an older incarnation of the database
37: Which data dictionary view should be used to get a list of object privileges for all database users?
A. DBA_TAB_PRIVS
B. ALL_TAB_PRIVS
C. USER_TAB_PRIVS
D. ALL_TAB_PRIVS_MADE
38: Which of the following helps the user identify his statement in the DBA_TUNE_MVIEW view?
A. The STATEMENT variable
B. The STATEMENT_ID column
C. The VIEW_ID column
D. The TASK_NAME variable
39: Which three major tuning areas does OEM Database Control provide information about?
A. Most-used objects
B. Top SQL statements
C. Memory usage
D. Top sessions affecting the instance
E. CPU and wait classes
40: Which of the following would technical analysis include?
A. Company financials
B. Market statistics
C. Stock pricing
D. Currency
41: How often would an active options trader perform technical analysis?
A. Once per month
B. It is an ongoing process performed during the hours after each day's activity.
C. Never. It does not apply to options.
D. Possibly weekly
42: What is the ideal number of portfolios for an experienced trader?
A. 1
B. 5
C. 20
D. 100
43: What is the most classic type of options trading?
A. Using sophisticated techniques such as Iron Condor
B. Short selling stocks
C. Buying call options and selling after an increase in value
D. Selling naked call options
44: What is the purpose of candlestick charting?
A. It tells the user exactly when to buy.
B. It gives the trader something to do in their spare time.
C. It is required in order to trade stock options.
D. A lot of price information such as open, close, high and low can be relayed in a graph.
45: How does the "Iron Condor" technique limit the downside?
A. The shorted options all have the same strike prices.
B. It is another term for short selling stock.
C. The shorted options have different strike prices, creating a stagger.
D. It involves selling calls while buying calls at the same time.
46: Which of the following would be a good example of risk mitigation?
A. Purchasing only small cap stocks
B. Purchasing stock options in three industries
C. Purchasing stock options all in one industry
D. Purchasing only options on blue chip stocks
47: What is portfolio management?
A. Having a suite of investments to reach a goal while minimizing risk
B. Buying shares all in one industry
C. Actively trading stocks in your portfolio
D. Selling off securities which are not performing
48: Why is it important to manage risk when trading stock options?
A. Because it is a good general policy
B. Because it guarantees no losses
C. Because it is required by tax law
D. Because of the risky nature of stock options
49: What would be the risk tolerance level of a retired government worker in general?
A. High
B. Moderate
C. Varies indefinitely
D. Low
50: Why would someone sell call options on a security they own?
A. Because they believe the price will rise
B. Because they don't really own the security
C. Because they are writing naked calls
D. Because they believe the security price will fall, creating profit from the calls
List of Oracle 10g Database Ad...
Available in:
Oracle 10g Database Administration MCQs
Вопросы по администрированию баз данных Oracle 10g на русском языке
Preguntas de administración de base de datos Oracle 10g en idiomas español
Oracle 10g データベース管理に関する日本語での質問
Domande sull'amministrazione del database Oracle 10g in lingua italiana
Questions d'administration de la base de données Oracle 10g en français
Dúvidas de Administração do Oracle 10g Database em Português
Fragen zur Oracle 10g-Datenbankverwaltung in deutscher Sprache
中文（简体）语言的 Oracle 10g 数据库管理问题
أسئلة إدارة قاعدة بيانات Oracle 10g باللغات العربية
Soal Oracle 10g Database Administration bahasa Indonesia
Türkçe dillerde Oracle 10g Veritabanı Yönetimi soruları
