Database MCQ Number 00865

Database MCQ Set 1

1. What is the use of Library cache?
a) Contains User information, such as user privileges
b) Used to store shared SQL
c) Log of changes made to the database
d) All of the Mentioned

2. Which processes is an instance made of Oracle?
a) Oracle background processes
b) Memory processes
c) Data processes
d) All of the Mentioned

3. Which of the following segment is destroyed when the SQL statement is finished?
a) Data Segment
b) Object Segment
c) Temporary Segment
d) All of the Mentioned

4. What is the use of an index?
a) Retrieve data more quickly and efficiently
b) Related data requires much less I/O overhead if accessed simultaneously
c) Simplify the user’s perception of data access
d) All of the Mentioned

5. Which of the following components comprise an Oracle architecture?
a) Database related background processes
b) Tablespaces
c) Datafiles
d) All of the Mentioned

6. What is the use of extent in Oracle?
a) Stores user data within the database
b) Stores rollback information used when data must be rolled back
c) Minimize the amount of wasted (empty) storage
d) None of the Mentioned

7. Which area of PGA stores binding variables and run-time buffers information?
a) SQL area
b) Private SQL area
c) Stack space
d) Session area

8. The ______ contains a set of tables and views that Oracle uses as a reference to the database.
a) PGA
b) Library cache
c) Data dictionary
d) SGA

9. In Oracle, which of below are types of segments?
a) Permanent Segment
b) Object Segment
c) Data Segment
d) All of the Mentioned

10. The redo log buffer and Shared pool are elements of?
a) PGA
b) Buffer cache
c) PGA and Buffer cache
d) SGA

Database MCQ Set 2

1. A collection of data designed to be used by different people is called a/an
a) Organization
b) Database
c) Relationship
d) Schema

2. Which of the following is the oldest database model?
a) Relational
b) Deductive
c) Physical
d) Network

3. Which of the following is the process of selecting the data storage and data access characteristics of the database?
a) Logical database design
b) Physical database design
c) Testing and performance tuning
d) Evaluation and selecting

4. The relationship between DEPARTMENT and EMPLOYEE is a
a) One-to-one relationship
b) One-to-many relationship
c) Many-to-many relationship
d) Many-to-one relationship

5. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
a) Consistent state
b) Inconsistent state
c) Durable state
d) Atomic state

6. When an entity instance must be a member of only one sub-type, it is which of the following?
a) Disjoint with total specialization
b) Disjoint with partial specialization
c) Overlap with total specialization
d) Overlap with partial specialization

7. A supertype/subtype hierarchy is which of the following?
a) Each subtype has only one attribute
b) Each supertype has only one attribute
c) Each subtype has only one supertype
d) Each supertype has only one subtype

8. Which of the following statements concerning business rules is true?
a) It should be complex
b) It should not be convertible to computer code
c) It may include restrictions
d) All of the Mentioned

9. Use of a supertype/subtype relationship is necessary when which of the following exists?
a) An instance of a subtype participates in a relationship that is unique to that subtype
b) An instance of a subtype participates in a relationship that is the same as the other subtypes
c) Attributes apply to all of the instances of an entity type
d) No attributes apply to any of the instances of an entity type

10. Which of the following is not one of the three ways to classify an action assertion?
a) Condition
b) Integrity Control
c) Authorization
d) Enabler

Database MCQ Set 3

1. In an E-R diagram an entity set is represent by a
a) Rectangle
b) Ellipse
c) Diamond box
d) Circle

2. A relational database developer refers to a record as
a) A criteria
b) A relation
c) A tuple
d) An attribute

3. The relational model feature is that there
a) is no need for primary key data
b) is much more data independence than some other database models
c) are explicit relationships among records
d) are tables with many dimensions

4. E-R model uses this symbol to represent weak entity set ?
a) Dotted rectangle
b) Diamond
c) Doubly outlined rectangle
d) None of the Mentioned

5. Which of the following is record based logical model?
a) Network Model
b) Object oriented model
c) E-R Model
d) None of the Mentioned

6. A _____ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
a) First
b) Second
c) Third
d) Fourth

7. Identify the criteria for designing database from the point of view of user
a) No redundancy
b) No inapplicable attributes
c) Uniformity in naming & definitions of the data items
d) All of the Mentioned

8. The relational model is based on the concept that data is organized and stored in two-dimensional tables called _______
a) Fields
b) Records
c) Relations
d) Keys

9. An aggregation association is drawn using which symbol:
a) a line which loops back onto the same table
b) small closed diamond at the end of a line connecting two tables
c) small open diamond at the end of a line connecting two tables
d) small triangle at the end of a line connecting the aggregated item and multiple component items

10. An n-array relationship is drawn using which symbol:
a) A diamond
b) A line with arrows showing direction
c) A line without arrows showing direction
d) A rectangle

Database MCQ Set 4

1. A BI reporting system does not _______
a) Create meaningful information
b) Deliver information to users on a timely basis
c) Use statistical procedures to predict future events
d) Use disparate data sources

2. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?
a) Dirty data
b) Inconsistent data
c) Too much data
d) Non-integrated data

3. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
a) Push
b) Pull
c) RFM
d) OLAP

4. Business Intelligence (BI) reporting systems cannot do which of the following operations?
a) Filter data
b) Group data
c) Modify data
d) Both filter and group data

5. Which of the following is not a component of a data warehouse?
a) Data extraction/cleaning/preparation programs
b) Data warehouse data
c) Data metadata
d) None of the Mentioned

6. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
a) Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row
b) Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column
c) Three rows have the values Brown, NULL, and Blue in the same column
d) One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column

7. The wildcard in a WHERE clause is useful when?
a) An exact match is necessary in a SELECT statement
b) An exact match is not possible in a SELECT statement
c) An exact match is necessary in a CREATE statement
d) An exact match is not possible in a CREATE statement

8. The benefits of a standard relational language include which of the following ?
a) Reduced training costs
b) Increased dependence on a single vendor
c) Applications are not needed
d) All of the Mentioned

9. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
a) SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
b) SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
c) SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
d) SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

10. There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed:

SQL> UPDATE dept SET deptno=80 WHERE dname='SALES';

The UPDATE statement above waits to complete the execution. Investigations reveal the following facts:
– The UPDATE statement is waiting to acquire a lock
– There is referential integrity constraint between the DEPT and EMP table
– Department number 30 represents the SALES department
– The EMP table is updated in the second session as follows:

SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30;

Which action would you perform to avoid waiting in the first session ?
a) Drop any existing index on the EMP table
b) Drop any existing index on the DEPT table
c) Create an index on the deptno column of the EMP table
d) Create an index on the deptno column of the DEPT table

Database MCQ Set 5

1. The Oracle environment of database is called as _____
a) Database Schema
b) Database Instances
c) Data Structure
d) All of the Mentioned

2. Which is the smallest unit of storage in an Oracle database?
a) Data Block
b) Segment
c) Extent
d) Data File

3. Collection of information stored in database at particular instance of time is called as ______
a) Instance of Database
b) Objects in Databases
c) Data structure
d) Database Schema

4. Oracle database’s design is also called as_______
a) Database Abstraction
b) Database Instance
c) Database Schema
d) None of the Mentioned

5. What are the valid Oracle database schemas?
a) Logical Schema
b) Physical Schema
c) Logical and Physical Schema
d) None of the Mentioned

6. What do the schema objects comprise of?
a) Table
b) Index
c) Cluster
d) All of the Mentioned

7. Map entities, attributes and relations in Oracle is represented by_____
a) Conceptual Schema
b) Logical Schema
c) Physical Schema
d) All of the Mentioned

8. Modification schema of oracle database in one level without affecting the schema in high level is called as _______
a) Data Migration
b) Data Isolation
c) Data Independence
d) Data Abstraction

9. A ___ is used to logically group data together
a) Database
b) Tablespace
c) Datafiles
d) Object

10. A _______ is a set of tables physically stored together as one table that shares a common column
a) Index
b) Object
c) Datafiles
d) Cluster

Database MCQ Set 6

1. Oracle server configuration is dedicated for
a) One server process – Many user processes
b) Many server processes – One user process
c) One server process – One user process
d) Many server processes – Many user processes

2. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
a) $$dbtime$$
b) $$time$$
c) $$datetime$$
d) None of the Mentioned

3. You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?
a) Increase the size of the redo log files
b) Decrease the number of redo log members
c) Set LOG_CHECKPOINT_TO_ALERT to TRUE
d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

Property                  Description
Parameter type            :Integer
Default value             :0
Modifiable                :ALTER SYSTEM
Range of values           :0 to 3600 seconds
Basic                     :No
Real Application Clusters :Multiple instances can have different values, 
                           and you can change the values at run-time.

4. Which statement is correct regarding undo management?
a) The database can have more than one undo tablespaces
b) The undo data must be purged manually when the transaction is over
c) The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF
d) Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL

5. Which operations can be performed using the Data Recovery Ad-visor?
a) Diagnosing data failure
b) It is a percentage of rows in which the statistics are collected incrementally for partitions
c) Presenting appropriate repair options
d) Generating reports for possible causes of failure

6. A user receives the following error while executing a query:
ORA-01555: snapshot too old
Predict one way to avoid such errors in near future.
a) Increase the size of redo log files
b) Increase the size of the undo tablespace
c) Increase the size of the Database Buffer Cache
d) Increase the size of the default temporary tablespace

7. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.
a) Set the TRACE_ENABLED parameter to TRUE
b) Set the threshold for the Current Logons Count metric
c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
d) Set the SESSIONS_PER_USER limit in the profiles used by users

8. While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:

 ORA-04031: unable to allocate 4000 bytes of shared memory 

On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.

a) Set the PRE_PAGE_SGA parameter to TRUE
b) Set the LOCK_SGA initialization parameter to TRUE
c) Implement Automatic Shared Memory Management
d) Set the SGA_TARGET initialization parameter to zero

9. You created a new user on the database by executing the following command:

SQL> CREATE USER user01 IDENTIFIED BY user01 
DEFAULT TABLESPACE users 
TEMPORARY TABLESPACE temp; 
Then you granted the following privileges to user01 by executing the following command: 
SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; 

Which of the following is true in this scenario?
a) The user can not create tables
b) The user can create tables
c) The user cannot query any tables
d) None of the Mentioned

10. Examine the following settings for the initialization parameters:

MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M 
SGA_TARGET=300M 
PGA_AGGREGATE_TARGET=70M

Which statement is true about the memory management for the newly started database instance?
a) MEMORY_TARGET defines the maximum limit for SGA_TARGET
b) SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M
c) The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET
d) SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively

Database MCQ Set 7

1. A table is in BCNF if it is in 3NF and if every determinant is a _____ key.
a) Dependent
b) Normal
c) Candidate
d) Both Normal and Candidate

2. The _____ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
a) Third
b) Fourth
c) Fifth
d) Sixth

3. A table is in 3NF if it is in 2NF and if it has no ______
a) Functional Dependencies
b) Transitive Dependencies
c) Trivial Functional Dependency
d) Multivalued Dependencies

4. Every constraint on the table is a logical consequence of the table’s
a) Fourth normal form
b) Fifth normal form
c) Domain/key normal form
d) None of the Mentioned

5. A _____ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
a) Multivalued Dependencies
b) Join Dependency
c) Trivial Functional Dependency
d) Transitive Dependencies

6. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the ___ key.
a) Candidate
b) Join
c) Functional
d) None of the Mentioned

7. Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
a) Accupressure
b) Decomposition
c) Precomposition
d) Both Decomposition and Precomposition

8. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
a) A -> B
b) A -> C
c) A -> (B,C)
d) (B,C) -> A

9. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
a) Transitive Dependency
b) Insertion Anomaly
c) Referential Integrity Constraint
d) Normal Form

10. Which of the following is not a restriction for a table to be a relation?
a) The cells of the table must contain a single value
b) All of the entries in any column must be of the same kind
c) The columns must be ordered
d) No two rows in a table may be identical

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.

• Website
• Twitter
• Facebook