Multiple Choice Questions (MCQs)
Go To pages -> 0/1/2/3/4/5/6/7
1 A Database Management System (DBMS) is- (A) Collection of interrelated data
- (B) Collection of programs to access data
- (C) Collection of data describing one particular enterprise
- (D) All of the above
2 Which of the following is not a level of data abstraction?
- (A) Physical Level
- (B) Critical Level
- (C) Logical Level
- (D) View Level
3 Disadvantages of File systems to store data is
- (A) Data redundancy and inconsistency
- (B) Difficulty in accessing data
- (C) Data isolation
- (D) All of the above
4 In an Entity-Relationship Diagram Rectangles represents
- (A) Entity sets
- (B) Attributes
- (C) Database
- (D) Tables
5 Which of the following is not a Storage Manager Component?
- (A) Transaction Manager
- (B) Logical Manager
- (C) Buffer Manager
- (D) File Manager
6 Data Manipulation Language enables users to
- (A) Retrieval of information stored in database
- (B) Insertion of new information into the database
- (C) Deletion of information from the database
- (D) All of the above
7 Which of the following is not a Schema?
- (A) Database Schema
- (B) Physical Schema
- (C) Critical Schema
- (D) Logical Schema
8 Which of the following is Database Language?
- (A) Data Definition Language
- (B) Data Manipulation Language
- (C) Query Language
- (D) All of the above
9 Which of the following in not a function of DBA?
- (A) Network Maintenance
- (B) Routine Maintenance
- (C) Schema Definition
- (D) Authorization for data access
10 Which of the following is a Data Model?
- (A) Entity-Relationship model
- (B) Relational data model
- (C) Object-Based data model
- (D) All of the above
11 Which of the following represents a relationship among a set of values?
- (A) A Row
- (B) A Table
- (C) A Field
- (D) A Column
12 Column header is refer as
- (A) Table
- (B) Relation
- (C) Attributes
- (D) Domain
13 A Relation is a
- (A) Subset of a Cartesian product of a list of attributes
- (B) Subset of a Cartesian product of a list of domains
- (C) Subset of a Cartesian product of a list of tuple
- (D) Subset of a Cartesian product of a list of relations
14 In mathematical term Table is referred as
- (A) Relation
- (B) Attribute
- (C) Tuple
- (D) Domain
15 In mathematical term Row is referred as
- (A) Relation
- (B) Attribute
- (C) Tuple
- (D) Domain
16 _______ allow us to identify uniquely a tuple in the relation.
- (A) Super key
- (B) Domain
- (C) Attribute
- (D) Schema
17 Minimal Super keys are called
- (A) Schema keys
- (B) Candidate keys
- (C) Domain keys
- (D) Attribute keys
18 Which of the following is not Modification of the Database?
- (A) Deletion
- (B) Insertion
- (C) Sorting
- (D) Updating
19 Which of the following is Relation-algebra Operation?
- (A) Select
- (B) Union
- (C) Rename
- (D) All of the above
20 Which of the following in not Outer join?
- (A) Left outer join
- (B) Right outer join
- (C) Full outer join
- (D) All of the above
21 Who proposed the relational model?
- (A) Bill Gates
- (B) E.F. Codd
- (C) Herman Hollerith
- (D) Charles Babbage
22 Set of permitted values of each attribute is called
- (A) Domain
- (B) Tuple
- (C) Relation
- (D) Schema
23 Which of the following is true regarding Null Value?
- (A) Null = 0
- (B) Null <0
- (C) Null> 0
- (D) Null<>0
24 Logical design of database is called
- (A) Database Instance
- (B) Database Snapshot
- (C) Database Schema
- (D) All of the above
25 Snapshot of the dta in the database at a given instant of time is called
- (A) Database Schema
- (B) Database Instance
- (C) Database Snapshot
- (D) All of the above
26 Which of the following is not Unary operation?
- (A) Select
- (B) Project
- (C) Rename
- (D) Union
27 Which of the following is not binary operation?
- (A) Union
- (B) Project
- (C) Set Difference
- (D) Cartesian product
28 Which of the following is correct regarding Aggregate functions?
- (A) It takes a list of values and returns a single values as result
- (B) It takes a list of values and returns a list of values as result
- (C) It takes a single value and returns a list of values as result
- (D) It takes a single value and returns a single value as result
29 The Primary key must be
- (A) Non Null
- (B) Unique
- (C) Option A or B
- (D) Option A and B
30 A command to remove a relation from an SQL database
- (A) Delete table
- (B) Drop table
- (C) Erase table
- (D) Alter table
31 Which of the following is not an Aggregate function?
- (A) Min
- (B) Max
- (C) Select
- (D) Avg
32 The attribute that can be divided into other attributes is called
- (A) Simple Attribute
- (B) Composite Attribute
- (C) Multi-valued Attribute
- (D) Derived Attribute
33 In an Entity-Relationship Diagram “Ellipses” represents
- (A) Attributes
- (B) Weak entity set
- (C) Relationship sets
- (D) Multi-valued attributes
34 In an Entity-Relationship Diagram “Diamonds” represents
- (A) Attributes
- (B) Multi-valued attributes
- (C) Weak entity set
- (D) Relationship sets
35 What are ACID properties of Transactions?
- (A) Atomicity, Consistency, Isolation, Database
- (B) Atomicity, Consistency, Isolation, Durability
- (C) Atomicity, Consistency, Inconsistent, Durability
- (D) Automatically, Concurrency, Isolation, Durability
36 If every non-key attribute is functionally dependent on the primary key, the relation will be in
- (A) First Normal Form
- (B) Second Normal Form
- (C) Third Normal Form
- (D) Fourth Formal Form
37 Database locking concept is used to solve the problem of
- (A) Lost Update
- (B) Uncommitted Dependency
- (C) Inconsistent Data
- (D) All of the above
38 UML is stands for
- (A) Universal Modeling Language
- (B) Unified Modeling Language
- (C) United Modeling Language
- (D) Uni Modeling Language
39 Data Manipulation Language (DML) is not to
- (A) Create information table in the Database
- (B) Insertion of new information into the Database
- (C) Deletion of information in the Database
- (D) Modification of information in the Database
40 Which of the following in true regarding Referential Integrity?
- (A) Every primary-key value must match a primary-key value in an associated table
- (B) Every primary-key value must match a foreign-key value in an associated table
- (C) Every foreign-key value must match a primary-key value in an associated table
- (D) Every foreign-key value must match a foreign-key value in an associated table
41 Which of the following option is use to retrieval of data?
- (A) Stack
- (B) Data Structure
- (C) Linked list
- (D) Query
42 ODBC stands for ______
- (A) Offline database connection
- (B) Oriented database connection
- (C) Open database connection
- (D) None of above
43 Which algebra is widely used in DBMS?
- (A) Relational algebra
- (B) Arithmetic algebra
- (C) Both
- (D) None
44 Which of the following is a unary operation?
- (A) Selection operation
- (B) Generalized selection
- (C) Primitive operation
- (D) Projection operation
45 Which SQL Query is use to remove a table and all its data from the database?
- (A) Create Table
- (B) Alter Table
- (C) Drop Table
- (D) None of these
46 In precedence of set operators the expression is evaluated from:
- (A) Left to Left
- (B) Left to Right
- (C) Right to Right
- (D) Right to Left
47 In DBMS FD stands for _______
- (A) Facilitate data
- (B) Functional data
- (C) Facilitate dependency
- (D) Functional dependency
48 How many types of keys in Database Design?
- (A) Candidate key
- (B) Primary key
- (C) Foreign key
- (D) All of these
49 Which of the following is based on Multi Valued Dependency?
- (A) First
- (B) Second
- (C) Third
- (D) Fourth
50 Which of the following is the structure of the Database?
- (A) Table
- (B) Schema
- (C) Relation
- (D) None of these
51 The minimal set of super key is called
- (A) Primary key
- (B) Secondary key
- (C) Candidate key
- (D) Foreign key
52 A relation that has no partial dependencies is in which normal form
- (A) First
- (B) Second
- (C) Third
- (D) BCNF
53 A functional dependency between two or more non-key attributes is called
- (A) Transitive dependency
- (B) Partial transitive dependency
- (C) Functional dependency
- (D) Partial functional dependency
54 A logical description of some portion of database that is required by a user to perform task is called as
- (A) System View
- (B) User View
- (C) Logical View
- (D) Data View
55 ______________ is a classical approach to database design?
- (A) Left – Right approach
- (B) Right – Left approach
- (C) Top – Down approach
- (D) Bottom – Up approach
56 _____________ refers to the correctness and completeness of the data in a database?
- (A) Data security
- (B) Data integrity
- (C) Data constraint
- (D) Data independence
57 A table that displays data redundancies yields ____________ anomalies
- (A) Insertion
- (B) Deletion
- (C) Update
- (D) All of the above
58 A lock that allows concurrent transactions to access different rows of the same table is known as a
- (A) Field-level lock
- (B) Row-level lock
- (C) Table-level lock
- (D) Database-level lock
59 A type of query that is placed within a WHERE or HAVING clause of another query is called
- (A) Super query
- (B) Sub query
- (C) Master query
- (D) Multi-query
60 A transaction completes its execution is said to be
- (A) Saved
- (B) Loaded
- (C) Rolled
- (D) Committed
61 In the relational model, cardinality is termed as:
- (A) A number of tuples
- (B) A number of attributes
- (C) A number of tables
- (D) A number of constraints
62 Relational calculus is a
- (A) Procedural language
- (B) Non-procedural language
- (C) Data definition language.
- (D) High- IeveI language
63 The view of total database content is
- (A) Conceptual view
- (B) Internal view
- (C) External view
- (D) Physical View
64 Cartesian product in relational algebra is
- (A) A Unary operator
- (B) A Binary operator
- (C) A Ternary operator
- (D) Not defined
65 DML is provided for
- (A) Description of the logical structure of a database
- (B) The addition of new structures in the database system
- (C) Manipulation g’ processing of the database
- (D) Definition of a physical structure of the database system
66 ‘AS’ clause is used in SQL for
- (A) Selection operation
- (B) Rename operation
- (C) Join operation
- (D) Projection operation
67 ODBC stands for
- (A) Object Database Connectivity
- (B) Oral Database Connectivity
- (C) Oracle Database Connectivity
- (D) Open Database Connectivity
68 Architecture of the database can be viewed as
- (A) Two levels
- (B) Four levels
- (C) Three levels
- (D) One level
69 In a relational model, relations are termed as
- (A) Tuples
- (B) Attributes
- (C) Ta ales
- (D) Rows
70 The database schema is written in
- (A) HLL
- (B) DML
- (C) DDL
- (D) DCL
71 In the architecture of a database system external level is the
- (A) Physical level
- (B) Logical level
- (C) Conceptual level
- (D) View level
72 An entity set that does not have sufficient attributes to form a primary key is a
- (A) Strong entity set
- (B) Weak entity set
- (C) Simple entity set
- (D) Primary entity set
73 In Hierarchical model records are organized as
- (A) Graph
- (B) List
- (C) Links
- (D) Tree
74 In an E-R diagram attributes are represented by
- (A) Rectangle
- (B) Square
- (C) Ellipse
- (D) Triangle
75 In case of entity integrity, the primary key maybe
- (A) Not Null
- (B) Null
- (C) Both Null & not Null
- (D) Any value
76 The language used in application programs to request data from the DBMS is referred to as the
- (A) DML
- (B) DDL
- (C) VDL
- (D) SDL
77 A logical schema
- (A) Is the entire database
- (B) Is a standard way of organizing information into accessible parts
- (C) Describes how data is actually stored on disk
- (D) Both A and C
78 Related fields in a database are grouped to form a
- (A) Data file
- (B) Data record
- (C) Menu
- (D) Bank
79 The database environment has all of the following components except:
- (A) Users
- (B) Separate files
- (C) Database
- (D) Database administrator
80 The language which has recently become the defacto standard for interfacing application programs with relational database system is
- (A) Oracle
- (B) SQL
- (C) DBase
- (D) 4GL
81 The way a particular application views the data from the database that the application uses is a
- (A) Module
- (B) Relational model
- (C) Schema
- (D) Subschema
82 In an E-R diagram an entity set is represented by a
- (A) Rectangle
- (B) Ellipse
- (C) Diamond box
- (D) Circle
83 A report generator is used to
- (A) Update files
- (B) Print files on paper
- (C) Data entry
- (D) Delete files
84 The property/properties of a database is/are:
- (A) It is an integrated collection of logically related records
- (B) It consolidates separate files into a common pool of data records
- (C) Data stored in a database is independent of the application programs using it
- (D) All of the above
85 The DBMS language component which can be embedded in a program is
- (A) The data definition language (DDL)
- (B) The data manipulation language (DML)
- (C) The database administrator (DBA)
- (D) A query language
86 A relational database developer refers to a record as
- (A) Criteria
- (B) A relation
- (C) A tuple
- (D) An attribute
87 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
88 Conceptual design
- (A) Is a documentation technique
- (B) Needs data volume and processing frequencies to determine the size of the database
- (C) Involves modeling independent of the DBMS
- (D) Is designing the relational model
89 The method in which records are physically stored in a specified order according to a key field in each record is
- (A) Hash
- (B) Direct
- (C) Sequential
- (D) All of the above
90 A subschema expresses
- (A) The logical view
- (B) The physical view
- (C) The external view
- (D) All of the above
91 Count function in SQL returns the number of
- (A) Values
- (B) Distinct values
- (C) Groups
- (D) Columns
92 Which one of the following statements is false?
- (A) The data dictionary is normally maintained by the database administrator
- (B) Data elements in the database can be modified by changing the data dictionary
- (C) The data dictionary contains the name and description of each data element
- (D) A data dictionary is a tool used exclusively by the database administrator
93 An advantage of the database management approach is
- (A) Data is dependent on programs
- (B) Data redundancy increases
- (C) Data is integrated and can be accessed by multiple programs
- (D) None of the above
94 A DBMS query language is designed to
- (A) Support end-users who use English-like commands
- (B) Support in the development of complex applications software
- (C) Specify the structure of a database
- (D) All of the above
95 Transaction processing is associated with everything below except
- (A) Producing detail, summary, or exception reports
- (B) Recording a business activity
- (C) Confirming an action or triggering a response
- (D) Maintaining data
96 It is possible to define a schema completely using
- (A) VDL and DDL
- (B) DDL and DML
- (C) SDL and DDL
- (D) VDL and DML
97 The method of access which uses key transformation is known as
- (A) Direct
- (B) Hash
- (C) Random
- (D) Sequential
98 Data independence means
- (A) Data is defined separately and not included in programs
- (B) Programs are not dependent on the physical attributes of data
- (C) Programs are not dependent on the logical attributes of data
- (D) Both B and C
99 The statement in SQL which allows changing the definition of a table is
- (A) Alter
- (B) Update
- (C) Create
- (D) Select
100 E-R model uses this symbol to represent a weak entity set?
- (A) Dotted rectangle
- (B) Diamond
- (C) Doubly outlined rectangle
- (D) None of these