Oracle 8 DBA MCQs
Oracle 8 DBA MCQs
Our experts have gathered these Oracle 8 DBA MCQs through research, and we hope that you will be able to see how much knowledge base you have for the subject of Oracle 8 DBA by answering these 50+ multiple-choice questions.
Get started now by scrolling down!
1: Which file contains the configuration information for Oracle Connection Manager?
A. listener.ora
B. sqlnet.ora
C. tnsnames.ora
D. cman.ora
E. cmanager.ora
2: Which of the following is true with regard to Incremental and Cumulative export?
A. They can only be performed when you are performing a Full database export.
B. They only export the changed rows of the tables.
C. An Incremental export always generates a larger export dump file than a Cumulative export.
D. If your backup strategy includes both Cumulative exports and Incremental exports, then you should perform Cumulative exports more frequently than Incremental exports.
E. Your backup strategy can include Cumulative exports or Incremental exports but not both.
3: How is the passwords file created in Oracle?
A. It is automatically created when you run the Create Database command.
B. You can create it using the Orapwd utility.
C. You can create it using the Oradim utility.
D. You can create it using either the Orapwd utility or the Oradim utility.
E. You can create it using the Create Passwordfile command.
4: Which package is required for manipulating Snapshots?
A. DBMS_SNP.
B. DBMS_SNAPSHOT.
C. DBMS_JOB.
D. DBMS_SNP_JOBL.
E. DBMS_SNPJOB.
5: Which of the following statements is true with regard to the Process Global Area(PGA)?
A. There is one PGA for each Oracle instance running on the server.
B. There is one PGA for each User process.
C. There is one PGA for each Server process.
D. The PGA is contained within the SGA.
E. The PGA does not exist in Parallel Server configuration.
6: Which command will you use to mount the database in parallel mode?
A. startup mount mode=parallel.
B. startup mount dbmode=parallel.
C. startup mount parallel.
D. startup mount parallelmode.
E. startup mount mode=p.
7: Which of the following statements is true with regard to Clusters in Oracle?
A. A Hash Cluster occupies less space than a Table Cluster.
B. Indexes can be stored in an Index Cluster.
C. A Hash Cluster uses a hashing function to locate the rows which results in faster retrieval of data and it can only store tables.
D. A Hash Cluster can contain Indexes and Tables.
E. A Hash Cluster uses a hashing function to locate the rows. It can store Tables aswell as Indexes.
8: Which files are used to configure SQL*Net or Net8 on an Oracle client machine?
A. sqlnet.ora and tnsnames.ora.
B. sqlnet.ora, listener.ora and tnsnames.ora.
C. tnsnames.ora.
D. tnsnames.ora and cman.ora.
E. tnsnames.ora, sqlnet.ora and mts.ora.
9: If the Oracle Parallel Query Option is installed and configured, how do you specify that a SQL query should be parallelized?
A. You don't need to do anything, all queries are automatically parallelized.
B. All join operations are automatically parallelized.
C. All queries containing Group By and Order By are automatically parallelized.
D. You have to specify the /* parallel */ optimizer hint in the query.
E. None of the above.
10: 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?
A. Drop each index using the Drop Index command and then recreate it by specifying the Tablespace clause in the Create Index command.
B. Export all the objects from the database using the Indexfile option of the Export utility and then use the Import utility.
C. Use the Alter Index command.
D. Use the Alter Table command.
E. None of the above.
11: How do you configure Multiple Protocol Support in Oracle.
A. By configuring Oracle Connection Manager.
B. By configuring Oracle Names Server.
C. By configuring Oracle Security Server.
D. By configuring Multi-Threaded Server.
E. None of the above.
12: You grant the DBA role to user Jack using the With Admin Option clause. Which of the following is true?
A. Jack can perform all DBA operations and also startup and shutdown the database.
B. Jack cannot further grant the DBA role to any other user.
C. Jack can grant the DBA role to any other user, but if you revoke the DBA role from Jack, it is also revoked from all those users to whom he had further granted it.
D. Jack can grant the DBA role to any other user, but if you revoke the DBA role from Jack, it is not revoked from all those users to whom he had further granted it.
E. None of the above.
13: Which package is required for writing Dynamic SQL code?
A. DBMS_PKG.
B. DBMS_SQL.
C. DBMS_DYN_SQL.
D. DBMS_DYNSQL.
E. DBMS_CODE.
14: What are the requirements if you want to perform Hot Backups of your Oracle database?
A. Nothing.
B. The ARCH process must be running.
C. The database must be in Archivelog mode.
D. The database must be in Archivelog mode and the ARCH process must be running.
E. You cannot perform Hot Backups of an Oracle Database
15: Which files are used to configure SQL*Net or Net8 on an Oracle Server?
A. sqlnet.ora, listener.ora and mts.ora.
B. sqlnet.ora, listener.ora and tnsnames.ora.
C. listener.ora and tnsnames.ora.
D. listener.ora and mts.ora.
E. listener.ora.
16: The SQL*Loader utility can be run in several modes. Which of the following are they?
A. Insert, Replace
B. Append, Replace
C. Insert, Append, Replace
D. Insert, Replace, Truncate
E. Insert, Append, Replace, Truncate
17: How can you rename the System tablespace?
A. By using the Alter Database command.
B. By using the Alter System command.
C. By using the Create Controlfile command.
D. It can be done through Oracle Enterprise Manager.
E. You cannot rename the system tablespace.
18: Which command is used to force a logfile switch?
A. Alter database force logfile switch.
B. Alter system switch logfile.
C. Alter system switch logfile force.
D. Alter database switch logfile force.
E. Alter database logfile switch.
19: How does Oracle allocate transactions to Rollback segments?
A. Transactions are allocated to all RBS including the System RBS in a round robin manner.
B. Transactions are allocated to all RBS excluding the System RBS in a round robin manner. System is exclusively used for transactions involving objects of the data dictionary.
C. Transactions are allocated to all RBS excluding the System RBS according to the transaction volumes - the least burdened RBS is allocated the next transaction. System is exclusively used for transactions involving objects of the data dictionary.
D. Transactions are allocated to all RBS including the System RBS according to the transaction volumes - the least burdened RBS is allocated the next transaction.
E. None of the above.
20: What happens when you issue the Create Database command?
A. A database is created consisting of the System tablespace and a single rollback segment also named System. The database is automatically mounted and opened.
B. A database is created consisting of the System tablespace and a single rollback segment also named System. The database is automatically mounted and opened and the data dictionary is also automatically created.
C. A database is created consisting of the System tablespace and a single rollback segment also named System. The database is not mounted.
D. A database is created consisting of the System tablespace and any other tablespaces that you specify in the Create command. A single rollback segment is also created named System. The database is automatically mounted and opened.
E. None of the above.
21: What is the purpose of assigning passwords to Roles?
A. The password is not relevent in currently available versions of Oracle.
B. A user cannot enable the role without specifying the password.
C. A database administrator or operator cannot grant this role to any user if he doesn't know the password.
D. This feature has no purpose.
E. None of the above.
22: Which of the following network protocols are supported by SQL*Net and Net8?
A. NetBUI, TCP/IP, IPX/SPX, Namedpipes
B. TCP/IP, IPX/SPX, Namedpipes
C. NetBUI, TCP/IP, IPX/SPX
D. NetBUI, TCP/IP, Namedpipes
E. NetBUI, TCP/IP, IPX/SPX, Namedpipes, Appletalk
23: What is the LCK process responsible for?
A. Deadlock resolution.
B. Managing locking between instances in a Parallel Server environment.
C. Managing table locks
D. Managing row locks.
E. Managing locking in a distributed database environment.
24: Which of the following statements is true with regard row chaining in Oracle?
A. It is less likely to occur if the Oracle block size is large.
B. It is less likely to occur if the Oracle block size is small.
C. It can be brought down by increasing the value of Pctfree.
D. It can be brought down by decreasing the value of Pctfree.
E. It can be brought down by decreasing the value of Pctfree and using a larger block size.
25: Which of the following statements is true with regard to Incremental and Cumulative exports?
A. They are the same.
B. Cumulative will export only those objects that have changed since the last Incremental export.
C. Incremental will export only those objects that have changed since the last Incremental export.
D. Cumulative will export only those objects that have changed since the last Complete or Cumulative export.
E. Incremental will export only those objects that have changed since the last Complete or Incremental export.
26: Which SQL script is executed to set up the procedural option?
A. catproc.sql
B. catalog.sql
C. proc.sql
D. procbuild.sql
E. buildproc.sql
27: Which command is used to enable a role?
A. Alter session enable role.
B. Alter session set role.
C. Alter session role.
D. Alter user enable role.
E. None of the above.
28: What is the difference between public and private rollback segments?
A. Public rollback segments are shared by all instances whereas private rollback segments are available to only a particular instance.
B. Private rollback segments are offline when the database is started unless you specify the Rollback_segments parameter in the initialization file.
C. By default, the Create Rollback Segment command creates private rollback segments.
D. All of the above.
E. None of the above.
29: What is Oracle Parallel Query Option?
A. It allows multiple SQL queries to be processed at the same time in a multi-user environment.
B. It allows a single SQL query to be broken down into parts which are then executed in parallel in a multi-CPU environment.
C. It allows multiple SQL queries to be processed by different CPUs in a multi-CPU environment.
D. It allows users to select rows from two or more tables by joining them. Without it, joins are not possible.
E. None of the above.
30: Which of the following statements is true with regard to SQL*Loader?
A. The discard file contains those records that could not be loaded because they violated integrity constraints of the table.
B. The bad file contains those records that could not be loaded because they violated integrity constraints of the table.
C. The discard file contains those records that could not be loaded because they didn't satisfy the conditions specified in the control file.
D. The discard file contains those records that didn't conform to the format specifications given in the control file.
E. None of the above.
31: Which of the following statements is true with regard row migration in Oracle?
A. It can be brought down by decreasing the value of Pctfree.
B. It can be brought down by increasing the value of Pctfree.
C. It can be brought down by decreasing the value of Pctused.
D. It can be brought down by increasing the value of Pctused.
E. It can be brought down by increasing the value of Pctfree and also Pctused.
32: Which of the following statements is true with regard to Exporting and Importing in Oracle?
A. The export utility can generate output in several different formats and it is therefore very useful for porting data to non-Oracle databases.
B. The import utility can read files of several different formats and is therefore very useful for porting data to Oracle from non-Oracle databases.
C. Only the Import Utility can read an export dump file that has been generated by the Export utility.
D. Only tables and thier data can be exported, other database objects cannot.
E. Only the database administrator is allowed to import and export data.
33: What is the Oracle passwords file used for?
A. Storing the passwords of all the users in the database.
B. Storing the password of the Internal user.
C. Storing the passwords of all the users who have been granted the Sysoper and Sysdba roles.
D. Storing the passwords of all the Sysoper and Sysdba users aswell as Internal.
E. None of the above.
34: Is Internal the only user who can startup and shutdown the database?
A. Yes.
B. No, Sys can also startup and shutdown the database.
C. No, Sys and System can also startup and shutdown the database.
D. No, any user who has been granted the Sysdba role can also startup and shutdown the database.
E. No, any user who has been granted the Start Database and Stop Database privileges can startup and shutdown the database.
35: What does the Startup Force command do?
A. It first performs a normal shutdown and then starts a fresh instance and opens the database.
B. It first performs an immediate shutdown and then starts a fresh instance and opens the database.
C. It first aborts the current instance and then starts a fresh instance and opens the database.
D. It opens the database without performing instance recovery when you open the database after a media failure.
E. None of the above.
36: Which command can be used to force a checkpoint?
A. Alter system checkpoint.
B. Alter system force checkpoint.
C. Alter database force checkpoint.
D. Alter session force checkpoint.
E. Alter database checkpoint.
37: How do you change the password of the Internal user?
A. You cannot change it.
B. You must edit the password file.
C. You can change it using the Alter User command.
D. You can change it using the Orapwd utility.
E. You can change it using either the Orapwd utility or the Oradim utility.
38: How can you integrate non-Oracle databases into an Oracle distributed database?
A. It cannot be done.
B. Using Oracle Connection Manager.
C. Net8 and SQL*Net have built-in support for non-Oracle databases.
D. Using Transparent Gateways.
E. None of the above.
39: Which of the following statements is true with regard to SQL*Loader?
A. The data and control information can both be stored in the control file.
B. The data and control information can both be stored in the input data file.
C. The data and control information must be stored in separate files.
D. Loading is possible without specifying a control file.
E. None of the above.
40: When is the Startup Mount command issued?
A. When performing Instance Recovery.
B. When performing Media Recovery.
C. When taking a backup of the database.
D. When creating new control files.
E. When performing Media Recovery aswell as when creating new control files.
41: Which of the following statements is true with regard to the Shutdown command in Oracle?
A. Instance Recovery is required if the Shutdown Abort command is issued but not if the Shutdown Immediate command is issued.
B. Media Recovery is required if the Shutdown Abort command is issued.
C. Instance Recovery is required if either the Shutdown Immediate command or the Shutdown Abort command is issued.
D. Shutdown immediate will close the database and terminate the instance after performing a checkpoint.
E. None of the above.
42: 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?
A. The SGA will be smaller in MTS because some information is moved out to the PGAs.
B. The SGA will be larger in MTS and the PGAs will be smaller.
C. Both the SGA and the PGAs will be smaller in MTS.
D. The PGAs are non-existent in MTS.
E. MTS and Dedicated Servers do not influence the size of the SGA or PGAs in any way.
43: What does the Startup Restrict command do?
A. It opens the database but only Sys, System users can connect to it.
B. It opens the database but only users who have been granted the Restricted Session privilege can connect to it.
C. It opens the database but DML operations cannot be performed.
D. It opens the database but DDL operations cannot be performed.
E. It opens the database but objects are not allowed to be created in the System tablespace.
44: Which of the following statements is true with regard to the export dump file generated by the Oracle Export utility?
A. It is in readable text format.
B. It cannot be imported into another database.
C. It can be used for porting data to Microsoft SQL Server.
D. It is always required when media recovery is to be performed.
E. It can be imported by a user other than the one who exported it.
45: What is the primary reason behind computing statistics for a table using the Analyze Table command?
A. So that the user gets to know about the storage requirements etc about his/her tables.
B. The statistics are required by the cost based optimizer.
C. The statistics are required by the rule based optimizer.
D. The statistics are required by the parser while processing queries.
E. None of the above.
46: What restrictions exist when you try to drop a tablespace?
A. You cannot drop a tablespace with active rollback segments.
B. You cannot drop a tablespace with active temporary segments.
C. You cannot drop the system tablespace.
D. You cannot drop a tablespace if a user has locked one of the rows in it.
E. You cannot drop a tablespace with active rollback segments nor can you drop the system tablespace.
47: Which command is used to drop a tablespace which contains some objects.
A. Drop tablespace.
B. Drop tablespace cascade.
C. Drop tablespace including contents.
D. You must first drop all the objects before dropping the tablespace.
E. None of the above.
48: In order to implement the Oracle Multi-Threaded Server(MTS), which files must you configure?
A. listener.ora.
B. listener.ora and mts.ora.
C. listener.ora and the initialization parameter file.
D. listener.ora and cman.ora.
E. listener.ora, cman.ora and the initialization parameter file.
49: If Oracle Parallel Query Option is installed, which Oracle background process handles Parallel queries?
A. SMON.
B. LCK.
C. Dedicated Servers and Shared Servers.
D. Parallel Query Servers.
E. Dispatcher.
50: What does TNS stand for?
A. Transparent Network Stack.
B. Transparent Network Socket.
C. Transparent Network Substrate.
D. Transport Network Socket
E. Transparent Namedpipe Stack.
List of Oracle 8 DBA MCQs Mult...
Available in:
Oracle 8 DBA MCQs
