Monday, 23 November 2015

IBPS SO Digest – IT officer Multiple Choice Question and answers papers on Database Quiz - 40

1. Related fields in a database are grouped to form?
(a) Data Fields
(b) Data Record
(c) Menu
(d) Bank
2. Entities having primary key are called?
(a) Primary Entities
(b) Strong Entities
(c) Weak Entities
(d) Primary Key

3. Aggregate functions are functions that take a ___________ as input and return a single value.
(a) Collection of values
(b) Single value
(c) Aggregate value
(d) Both a & b

4. Select __________ from instructor where dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?
(a) Mean(salary)
(b) Avg(salary)
(c) Sum(salary)
(d) Count(salary)

5. Dates must be specified in the format
(a) mm/dd/yy
(b) yyyy/mm/dd
(c) dd/mm/yy
(d) yy/dd/mm

6. An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
(a) Index
(b) Reference
(c) Assertion
(d) Timestamp

7. A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
(a) Idle
(b) Waiting
(c) Deadlock
(d) Ready

8. The deadlock state can be changed back to stable state by using _____________ statement.
(a) Commit
(b) Rollback
(c) Save point
(d) Deadlock

9. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
(a) Candidate key
(b) Sub key
(c) Super key
(d) Foreign key

10. Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
(a) NAME
(b) ID
(c) CITY
(d) CITY , ID

11. A transparent DBMS  ?
(a) Can not hide sensitive information from users
(b) Keep its logical structure hidden from users
(c) Keeps its physical structure hidden from users
(d) Both B and C

12. Primitive operations common to all record management system include ?
(a) Print
(b) Sort
(c) Look up
(d) All of above

13. An unnormalized relation contains values ?
(a) Atomic
(b) Non – Atomic
(c) Classified
(d) None of these

14. A relation scheme is said to be in …… form if the values in the domain of each attribute of the relation are atomic ?
(a) Unnormalized
(b) First Normal
(c) BoyceCODD
(d) None of these

15. A multiple – form file management system  ?
(a) Lets you define different forms for different operations
(b) Lets you create a look up form with an associated read only password to prevent access by unauthorized users.
(c) Both A and B
(d) Allows you to entry data in all the forms

16. Embedded pointer provide ?
(a) A secondary access path
(b) A physical record key
(c) An inverted index
(d) None of above

17. Arrange according to the size
(a) Record, field, byte, bit
(b) Bit, field, byte, record
(c) Field, byte, record, bit
(d) Byte, bit, record, field

18. What type of relationship exists between a Student table and Fees table?
(a) One to one
(b) One to many
(c) Many to many
(d) One to many and many to many

19. Identify the relationship between a Movie table and Stars table:
(a) One to one
(b) One to many
(c) Many to many
(d) None of above

20. What type of relationship exists between a Teacher table and Class table?
(a) One to many
(b) Many to many
(c) One to one
(d) Two to two

No comments:

Post a Comment