Monday, 23 November 2015

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

No comments:

Post a Comment