IBPS IT SO DBMS MCQs Set 3

DBMS IT SO MCQs Set 3

1. DBMS is a collection of ………….. that enables user to create and maintain a database.
A) Keys
B) Translators
C) Program
D) Language Activity
Ans: C

2. In a relational schema, each tuple is divided into fields called 
A) Relations
B) Domains
C) Queries
D) All of the above
Ans: B

3. In an ER model, ……………. is described in the database by storing its data.
A) Entity
B) Attribute
C) Relationship
D) Notation
Ans: A

4. DFD stands for
A) Data Flow Document
B) Data File Diagram
C) Data Flow Diagram
D) Non of the above
Ans: C

5. A top-to-bottom relationship among the items in a database is established by a 
A) Hierarchical schema
B) Network schema
C) Relational Schema
D) All of the above
Ans: A

6. ……………… table store information about database or about the system.
A) SQL
B) Nested
C) System
D) None of these
Ans: C


7. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
A) Instance 
B) Schema
c) Program
D) Super Key
Ans: B

8. ……………… clause is an additional filter that is applied to the result.
A) Select
B) Group-by
C) Having
D) Order by
Ans: C

9. 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) All of the above
B


10. ………………… is a full form of SQL.
A) Standard query language
B) Sequential query language
C) Structured query language
D) Server side query language
Ans: C

11) A relational database developer refers to a record as 
A. a criteria
B. a relation
C. a tuple
D. an attribute
Ans: C

12) .......... keyword is used to find the number of values in a column.
A. TOTAL
B. COUNT
C. ADD
D. SUM
Ans: B


13) 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
Ans: C

14) The collection of information stored in a database at a particular moment is called as ......
A. schema
B. instance of the database
C. data domain
D. independence
Ans: B


15) 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 
Ans:  D

16) A ......... is used to define overall design of the database
A. schema
B. application program
C. data definition language
D. code
Ans: A


17) Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none of the above
Ans: C

18) Grant and revoke are ....... statements.
A. DDL
B. TCL 
C. DCL
D. DML
Ans: C

19) DBMS helps achieve
A. Data independence 
B. Centralized control of data
C. Neither A nor B
D. Both A and B 
Ans: D

20) .......... command can be used to modify a column in a table
A. alter
B. update
C. set
D. create
Ans: A

31. The candidate key is that you choose to identify each row uniquely is called ……………..

A) Alternate Key

B) Primary Key

C) Foreign Key

D) None of the above

Ans:B

2. …………….. is used to determine whether of a table contains duplicate rows.

A) Unique predicate

B) Like Predicate

C) Null predicate

D) In predicate

Ans:A

3. To eliminate duplicate rows ……………… is used

A) NODUPLICATE

B) ELIMINATE

C) DISTINCT

D) None of these

Ans:C

4. State true or false

i) A candidate key is a minimal super key.

ii) A candidate key can also refer to as surrogate key.

A) i-true, ii-false

B) i-false, ii-true

C) i-true, ii-true

D) i-false, ii-false

Ans:C

5. DCL stands for

A) Data Control Language

B) Data Console Language

C) Data Console Level

D) Data Control Level

Ans:A

6. …………………… is the process of organizing data into related tables.

A) Normalization

B) Generalization

C) Specialization

D) None of the above

Ans:A

7. A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

A) Weak entity

B) Strong entity

C) Non attributes entity

D) Dependent entity

Ans:A

8. …………….. is the complex search criteria in the where clause.

A) Sub string

B) Drop Table

C) Predict

D) Predicate

Ans:D

9. ………………… is preferred method for enforcing data integrity

A) Constraints

B) Stored Procedure

C) Triggers

D) Cursors

Ans:A

10. The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ………………..

A) Degree, Cardinality

B) Cardinality, Degree

C) Rows, Columns

D) Columns, Rows

Ans:B

11) The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

A. Procedural DML

B. Non-Procedural DML

C. Procedural DDL

D. Non-Procedural DDL

Ans:B

12) Which two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

Ans:C

13) The database schema is written in

A. HLL

B. DML

C. DDL

D. DCL

Ans:C

14) 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. sub schema

Ans:D

15) 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

Ans:B

16) 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. The data dictionary is a tool used exclusively by the database administrator.

Ans:B

17) Which of the following are the properties of entities?

A. Groups

B. Table

C. Attributes

D. Switchboards

Ans:C

18) Which database level is closest to the users?

A. External

B. Internal

C. Physical

D. Conceptual

Ans:A

19) Which are the two ways in which entities can participate in a relationship?

A. Passive and active

B. Total and partial

C. Simple and Complex

D. All of the above

Ans:B

20) ........ data type can store unstructured data

A. RAW

B. CHAR

C. NUMERIC

D. VARCHAR

Ans:A

IBPS IT SO DBMS MCQs Set 2

DBMS MCQs

1. Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a:

A) data dictionary
B) database management system (DBMS)
C) decision support system
 D) relational database
Ans:( B )

2. The modern database report writer:

A) is a career path that focuses on creating, managing and supporting the reports generated from databases
B) provide limited control over how information is displayed and reported.
C) provides the tools for database designer to display information in the desired format
D)provides the tools for the database administrator to monitor and report on database use and activity
Ans:( C )

3. The separation of the data definition from the program is known as:

A) data dictionary
B) data independence
C) data integrity
 D) referential integrity
Ans:( B )

4. In the client / server model, the database:

A) is downloaded to the client upon request
 B) is shared by both the client and server
C) resides on the client side
D) resides on the server side
Ans:( D )

5. The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of 'database' system?

A) Hierarchical
B) Network  
C) Object oriented
 D) Relational
Ans:( A )

6. The database design that consists of multiple tables that are linked together through matching data stored in each table is called a:

A) Hierarchical database
B) Network database
 C) Object oriented database
  D) Relational database
Ans:( D )

7. What is the main limitation of Hierarchical Databases?

A) Limited capacity (unable to hold much data)
 B) Limited flexibility in accessing data
 C) Overhead associated with maintaining indexes
D) The performance of the database is poor
Ans:( B )

8. An abstract data type is used to:

A) link data from remote databases
B) prevent users from getting to database security information
 C) provide a conceptual view of the data so it is easier to understand
D) store complex data structure to represent the properties of objects
Ans:( D )

9. One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.

A) analysis phase
B) feasibility study
C) investigation stage
 D) system design
Ans:( B )

10. Which component of the database management system (DBMS) most affects the ability to handle large problems (scalability)?

A) Data Storage Subsystem
B) Database Engine
C) Query Processor
 D) Security Subsystem
Ans:( B )

11. The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is:

A) OODB incorporates methods in with the definition of the data structure, while RDB does not B) OODB supports multiple objects in the same database while RDB only supports a single table per database
C) RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships to be defined between objects
D) RDB supports indexes, while OODB does not support indexes
Ans:( A )

12. Which of the following items is not the advantage of a DBMS?

A) Improved ability to enforce standards
 B) Improved data consistency
 C) Local control over the data
D) Minimal data redundancy
Ans:( C )

13. The predominant way of storing data today is using which type of database models?

A) Hierarchical
 B) Network
 C) Object oriented
 D) Relational
Ans:( D )

14. Two different terms are used to describe the characteristics of interest for an entity. They are attributes and:

A) classes
 B) entities
C) properties
D) traits
Ans:( C )

15. When building a database, the data dealing with an entity is modeled as a:

A) attribute
 B) class
C) object
D) table
Ans:( B )

16. Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated.

A) Class Diagram
B) Data Diagram
C) Object Diagram
D) Table Relationship Diagram
Ans:( A )

17. In relational database model, after conceptually designing your database, the information contained in a single class would be stored in a:

A) database
B) field
C) property
D) table
Ans:( D )

18. The property (or set of properties) that uniquely defines each row in a table is called the:

A) identifier
B) index
C) primary key
 D) symmetric key
Ans:( C )

19. Business rules can be represented in the database through:

A) associations (or relationships)
B) attributes
C) properties
D) secondary keys
Ans:( A )

20. The association role defines:

A) how tables are related in the database
B) the relationship between the class diagram and the tables in the database
C) the tables that each attribute is contained
D) which attribute is the table's primary key
Ans:( A )

21. The purpose of an N-Ary association is:

A) to capture a parent-child relationship
B) to deal with one to many relationships
C) to deal with relationships that involve more than two tables
D) to represent an inheritance relationship
Ans:( C )

22. A composition 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
Ans:( B )

23. A reflexive 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
Ans:( A )

24. Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model that a class may have multiple pre-requisites?

A) aggregation association
B) generalization association
C) n-ary association
D) reflexive association
Ans:( D )

25. Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model degree requirements (i.e., required number of courses in humanity, science, math, etc)?

A) composition association   B) generalization association   C) n-ary association   D) reflexive association
Ans:( A )

26. Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model that a course has an assigned instructor, Teaching Assistants, a classroom, meeting time slot, and class roster?

A) aggregation association
B) generalization association
C) n-ary association
D) reflexive association
Ans:( C )

27. What is the most appropriate special association that indicates that multiple textbooks make up a course required reading list?

A) aggregation association
B) generalization association
 C) n-ary association
 D) reflexive association
Ans:( C )

28. What is the special association that indicates that one object can be broken down into multiple special cases?

A) composition association
B) generalization association
C) n-ary association
D) reflexive association
Ans:( B )

29. The ability to define common properties or functions in the higher class and then modify them in the lower classes is called:

A) Inheritance
B) Polymorphism
C) Reflexive
D) Transformance
Ans:( B )

30. A reflexive association is one where one class is:

A) broken down into special cases
B) combined with multiple other classes
C) combined with one other class
D) linked back to itself
Ans:( D )

IBPS IT SO DBMS 100 MCQs

100 DBMS MCQs

Q.1 In the relational modes, cardinality is termed as:
 (A) Number of tuples.
(B) Number of attributes.
(C) Number of tables.
 (D) Number of constraints.
Ans: A

Q.2 Relational calculus is a
(A) Procedural language.
(B) Non- Procedural language.
 (C) Data definition language.
 (D) High level language.
 Ans: B

 Q.3 The view of total database content is
 (A) Conceptual view.
(B) Internal view.
(C) External view.
(D) Physical View.
 Ans: A

Q.4 Cartesian product in relational algebra is
 (A) a Unary operator.
(B) a Binary operator.
(C) a Ternary operator.
(D) not defined.
Ans: B Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)

 Q.5 DML is provided for
(A) Description of logical structure of database.
(B) Addition of new structures in the database system.
 (C) Manipulation & processing of database.
(D) Definition of physical structure of database system.
Ans: C DML is provided for manipulation & processing of database

 Q.6 ‘AS’ clause is used in SQL for
(A) Selection operation.
 (B) Rename operation.
(C) Join operation.
 (D) Projection operation.
Ans: B ‘AS’ clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

 Q.7 ODBC stands for
 (A) Object Database Connectivity.
(B) Oral Database Connectivity.
(C) Oracle Database Connectivity.
 (D) Open Database Connectivity.
 Ans: D

Q.8 Architecture of the database can be viewed as
 (A) two levels.
(B) four levels.
(C) three levels.
(D) one level.
Ans: C

Q.9 In a relational model, relations are termed as
(A) Tuples.
 (B) Attributes
(C) Tables.
(D) Rows.
Ans:c

Q.10 The database schema is written in
 (A) HLL
 (B) DML
 (C) DDL
 (D) DCL
 Ans: C

Q.11 In the architecture of a database system external level is the
(A) physical level.
(B) logical level.
(C) conceptual level
 (D) view level.
Ans: D

 Q.12 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.
 Ans: B

Q.13 In a Hierarchical model records are organized as
(A) Graph.
(B) List.
(C) Links
. (D) Tree.
Ans: D

Q.14 In an E-R diagram attributes are represented by
(A) rectangle.
 (B) square.
 (C) ellipse.
(D) triangle.
Ans: C

Q.15 In case of entity integrity, the primary key may be
(A) not Null
(B) Null
(C) both Null & not Null.
 (D) any value.
Ans: A

 Q.16 In tuple relational calculus P1 ®P2 is equivalent to
(A) ¬P1 Ú P2
 (B) P1 Ú P2
(C) P1 Ù P2
 (D) P1 Ù¬P2
Ans: A In tuple relational calculus P1 P2 is equivalent to ¬P1 Ú P2.

 Q.17 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
Ans: A

Q.18 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)
Ans: A

 Q.19 Related fields in a database are grouped to form a
(A) data file.
 (B) data record.
(C) menu.
(D) bank.
Ans: B Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

 Q.20 The database environment has all of the following components except:
 (A) users
. (B) separate files
. (C) database.
 (D) database administrator.
 Ans: A

 Q.21 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.
Ans: B

Q.22 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) sub schema.
Ans: D

Q.23 In an E-R diagram an entity set is represent by a
 (A) rectangle.
(B) ellipse.
(C) diamond box.
 (D) circle.
Ans: A

 Q.24 A report generator is used to
(A) update files.
(B) print files on paper.
(C) data entry.
 (D) delete files.
 Ans: B

 Q.25 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.
Ans: D

Q.26 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.
 Ans: B

Q.27 A relational database developer refers to a record as
 (A) a criteria.
(B) a relation.
 (C) a tuple.
(D) an attribute.
Ans: C

Q.28 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.
 Ans: B

 Q.29 Conceptual design
 (A) is a documentation technique.
(B) needs data volume and processing frequencies to determine the size of the database.
 (C) involves modelling independent of the DBMS.
 (D) is designing the relational model
 Ans:C

Q.30 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.
Ans: A A method in which records are physically stored in a specified order according to a key field in each record is hash. (In hash method, a hash function is performed on the key value to determine the unique physical address of the record to store or retrieve)

 Q.31 A subschema expresses
 (A) the logical view.
 (B) the physical view.
(C) the external view.
 (D) all of the above.
Ans: C A subschema expresses the external view. (External schemas are called also called as subschemas)

Q.32 Count function in SQL returns the number of
(A) values.
(B) distinct values.
 (C) groups.
(D) columns. Ans: A Count function in SQL returns the number of values. (Count function counts all the not null values in the specific column. If we want to count only distinct values than the DISTINCT keyword is also to be used)

Q.33 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) The data dictionary is a tool used exclusively by the database administrator.
 Ans: B

Q.34 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.
 Ans: C

 Q.35 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.
Ans: D

Q.36 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.
Ans: C

 Q.37 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.
Ans: B

Q.38 The method of access which uses key trAnsformation is known as
(A) direct.
 (B) hash.
(C) random.
(D) sequential.
Ans: B

Q.39 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).
 Ans: D both (B) and (C)

Q.40 The statement in SQL which allows to change the definition of a table is
(A) Alter.
(B) Update.
 (C) Create.
 (D) select.
Ans: A

Q.41 E-R model uses this symbol to represent weak entity set ?
(A) Dotted rectangle.
 (B) Diamond
 (C) Doubly outlined rectangle
(D) None of these
Ans: C

Q.42 SET concept is used in :
 (A) Network Model
 (B) Hierarchical Model
(C) Relational Model
(D) None of these
Ans: A

Q.43 Relational Algebra is
(A) Data Definition Language .
 (B) Meta Language
 (C) Procedural query Language
(D) None of the above
Ans: C

Q.44 Key to represent relationship between tables is called
(A) Primary key
 (B) Secondary Key DMBS Ojbective Type Questions - Akhil Arora for more materials visit us at www.Gr8AmbitionZ.com Gr8AmbitionZ.com
 (C) Foreign Key
(D) None of these
 Ans: C

Q.45 _______ produces the relation that has attributes of R1 and R2
(A) Cartesian product
(B) Difference
(C) Intersection
(D) Product
Ans: A

 Q.46 The file organization that provides very fast access to any arbitrary record of a file is
 (A) Ordered file
 (B) Unordered file
 (C) Hashed file
(D) B-tree
Ans: C

Q.47 DBMS helps achieve
(A) Data independence
 (B) Centralized control of data
(C) Neither (A) nor (B)
 (D) both (A) and (B)
 Ans: D

Q.48 Which of the following are the properties of entities?
(A) Groups
(B) Table
(C) Attributes
 (D) Switchboards
 Ans: C

Q.49 In a relation
(A) Ordering of rows is immaterial
(B) No two rows are identical
 (C) (A) and (B) both are true
(D) None of these.
Ans: C

Q.50 Which of the following is correct:
 (A) a SQL query automatically eliminates duplicates.
(B) SQL permits attribute names to be repeated in the same relation.
(C) a SQL query will not work if there are no indexes on the relations
 (D) None of these
Ans: D

Q.51 It is better to use files than a DBMS when there are
(A) Stringent real-time requirements.
(B) Multiple users wish to access the data.
 (C) Complex relationships among data.
(D) All of the above.
Ans: B

Q.52 The conceptual model is
(A) dependent on hardware.
(B) dependent on software.
(C) dependent on both hardware and software .
(D) independent of both hardware and software.
 Ans: D

Q.53 What is a relationship called when it is maintained between two entities?
(A) Unary
(B) Binary
 (C) Ternary
(D) Quaternary
Ans: B

Q.54 Which of the following operation is used if we are interested in only certain columns of a table? (A) PROJECTION
 (B) SELECTION
(C) UNION
(D) JOIN
Ans: A

Q.55 Which of the following is a valid SQL type?
(A) CHARACTER
(B) NUMERIC
 (C) FLOAT
(D) All of the above
 Ans: D

Q.56 The RDBMS terminology for a row is
(A) tuple.
(B) relation.
 (C) attribute.
 D) degree.
Ans: A

Q.57 Which of the following operations need the participating relations to be union compatible?
(A) UNION
(B) INTERSECTION
(C) DIFFERENCEqq
(D) All of the above
Ans: D

Q.58 The full form of DDL is
 (A Dynamic Data Language
(B) Detailed Data Language
 (C) Data Definition Language
 (D) Data Derivation Language
Ans: C

Q.59 Which of the following is an advantage of view?
(A) Data security
(B) Derived columns
(C) Hiding of complex queries
(D) All of the above
Ans: D

Q.60 Which of the following is a legal expression in SQL?
(A) SELECT NULL FROM EMPLOYEE;
(B) SELECT NAME FROM EMPLOYEE;
(C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
 (D) None of the above
Ans: B

Q.61 The users who use easy-to-use menu are called
(A) Sophisticated end users.
 (B) Naïve users.
 (C) Stand-alone users.
 (D) Casual end users.
Ans: B

Q.62 Which database level is closest to the users?
 (A) External
(B) Internal
(C) Physical
 (D) Conceptual
Ans: A

Q.63 Which are the two ways in which entities can participate in a relationship?
(A) Passive and active
(B) Total and partial
(C) Simple and Complex
 (D) All of the above
 Ans: B

Q.64 The result of the UNION operation between R1 and R2 is a relation that includes
(A) all the tuples of R1
(B) all the tuples of R2
 (C) all the tuples of R1 and R2
 (D) all the tuples of R1 and R2 which have common columns
 Ans: D

Q.65 Which of the following is a comparison operator in SQL?
 (A) =
(B) LIKE
(C) BETWEEN
 (D) All of the above
Ans: D

Q.66 A set of possible data values is called
(A) attribute.
 (B) degree.
(C) tuple.
(D) domain.
Ans: D

Q.67 Which of the operations constitute a basic set of operations for manipulating relational data? (A) Predicate calculus
 (B) Relational calculus
(C) Relational algebra
(D) None of the above
Ans:C

Q.68 Which of the following is another name for weak entity?
(A) Child
(B) Owner
(C) Dominant
(D) All of the above
 Ans: A

 Q.69 Which of the following database object does not physically exist?
(A) base table
(B) index
(C) view
 (D) none of the above
Ans: C

Q.70 NULL is
(A) the same as 0 for integer
(B) the same as blank for character
(C) the same as 0 for integer and blank for character
 (D) not a value
Ans: D

Q.71 Which of the following is record based logical model? DMBS Ojbective Type Questions - Akhil Arora for more materials visit us at www.Gr8AmbitionZ.com Gr8AmbitionZ.com
 (A) Network Model
(B) Object oriented model
(C) E-R Model
 (D) None of these
Ans: A

Q.72 A data dictionary is a special file that contains:
(A) The name of all fields in all files.
(B) The width of all fields in all files.
 (C) The data type of all fields in all files.
(D) All of the above.
Ans: D

 Q.73 A file manipulation command that extracts some of the records from a file is called
(A) SELECT
 (B) PROJECT
 (C) JOIN
(D) PRODUCT
Ans: A

 Q.74 The physical location of a record is determined by a mathematical formula that trAnsforms a file key into a record location is :
(A) B-Tree File
(B) Hashed File
(C) Indexed File
 (D) Sequential file.
 Ans: B

 Q.75 Using Relational Algebra the query that finds customers, who have a balance of over 1000 is (A) PCustomer_name(s balance >1000(Deposit))
 (B) s Customer_name(Pbalance >1000(Deposit))
 (C) PCustomer_name(s balance >1000(Borrow))
(D) s Customer_name(Pbalance >1000(Borrow))
Ans: A D

Q.76 A primary key is combined with a foreign key creates
 (A) Parent-Child relation ship between the tables that connect them.
(B) Many to many relationship between the tables that connect them.
(C) Network model between the tables that connect them.
(D) None of the above.
Ans: A

 Q.77 In E-R Diagram derived attribute are represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
 (D) Triangle
 Ans B

Q.78 Cross Product is a:
 (A) Unary Operator
 (B) Ternary Operator
(C) Binary Operator
 (D) Not an operator
Ans: C

 Q.79 An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true?
(A) A is a candidate key
 (B) A is not a candidate key
 (C) A is a primary Key
(D) Both (A) and (C)
Ans: B

Q.80 Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:
 (A) mn
 (B) m+n
(C) (m+n)/2
(D) 2(m+n)
Ans: A

 Q.81 The natural join is equal to :
 (A) Cartesian Product
 (B) Combination of Union and Cartesian product
(C) Combination of selection and Cartesian product
(D) Combination of projection and Cartesian product
 Ans: D

Q.82 Which one of the following is not true for a view:
(A) View is derived from other tables.
(B) View is a virtual table.
(C) A view definition is permanently stored as part of the database.
 (D) View never contains derived columns.
 Ans: C

 Q.83 A primary key if combined with a foreign key creates
(A) Parent-Child relationship between the tables that connect them.
(B) Many to many relationship between the tables that connect them.
 (C) Network model between the tables that connect them.
 (D) None of the above.
Ans: A

 Q.84 In E-R Diagram relationship type is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
 (D) Diamond
Ans: D

Q.85 Hierarchical model is also called
(A) Tree structure
(B) Plex Structure
 (C) Normalize Structure
 (D) Table Structure
Ans: A

Q.86 To delete a particular column in a relation the command used is:
(A) UPDATE
(B) DROP
(C) ALTER
(D) DELETE
Ans: C

Q.87 The ______ operator is used to compare a value to a list of literals values that have been specified.
(A) BETWEEN
(B) ANY
(C) IN
(D) ALL
 Ans: A

Q.88 A logical schema
A) is the entire database
 B) is a standard way of organizing information into a accessible part
 C) describe how data is actually stored on disk
D) none of these
Ans: D

Q.89 A B-tree of order m has maximum of _____________ children
(A) m
 (B) m+1
(C) m-1
(D) m/2
Ans: A

Q.90 _____________ function divides one numeric expression by another and returns the remainder. (A) POWER (
B) MOD
 (C) ROUND
 (D) REMAINDER
 Ans: B

 Q.91 A data manipulation command the combines the records from one or more tables is called
 (A) SELECT
 (B) PROJECT
(C) JOIN
(D) PRODUCT
 Ans: C

Q.92 In E-R diagram generalization is represented by
 (A) Ellipse
 (B) Dashed ellipse
 (C) Rectangle
 (D) Triangle
Ans: D

Q.93 _________ is a virtual table that draws its data from the result of an SQL SELECT statement. (A) View
 (B) Synonym
 (C) Sequence
 (D) TrAnsaction
 Ans: A
Q.94 The method of access which uses key trAnsformation is known as
(A) Direct
(B) Hash
 (C) Random
(D) Sequential
Ans: B

Q.95 A table joined with itself is called
(A) Join
(B) Self Join
(C) Outer Join
(D) Equi Join
 Ans: B

Q.96 _________ data type can store unstructured data
(A) RAW
 (B) CHAR
(C) NUMERIC
(D) VARCHAR
Ans: A

Q.97. Which of the following statements is not correct?

A) A primary goal of a database system is to share data with multiple users  

B) It is possible to change a method or property inherited from a higher level class

C) While companies collect data all the time, the structure of the data changes very often.   

D) In a client / server environment, data independence causes client side applications to be essentially independent of the database stored on the server side.
Ans:C

Q.98. Which of the following statements is not correct?

A) Data Normalization is the process of defining the table structure   

B) The purpose of class diagrams is to model the interrelationships between the different classes in the database   

C) Individual objects are stored as rows in a table   

D) Properties of an object are stored as columns in a table.
Ans:A

Q.99 Which of the following statements is not correct?

A) The primary key must be unique for a given table   

B) Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required   

C) Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required   

D) Most databases allow multiple records that are identical (i.e., records that have the same values for all properties).
Ans: B

Q.100 Which of the following statements is not correct?

A) All many-to-many relationships must be converted to a set of one-to-many relationships by adding a new entity   

B) In a one-to-one relationship between two classes, the two classes are generally described by one table in relational database model   

C) Encapsulation provides some security and control features   

D) Propertiesand functions can be protected from other areas of the applications
Ans: B