Tuesday, 24 November 2015

IBPS Bank Jobs Exam SO (IT officer) Expected DBMS 20 MCQs Quiz - 43

1.  In the E-R diagrams, the term cardinality is a synonym for the term ?
(a) Attribute
(b) Degree
(c) Entities
(d) Cartesian
2. TRUNCATE statement in SQL is a  ?
(a) DML statement
(b) DDL statement
(c) DCL statement
(d) None of above

3.The default date format in SQL is ?
(b) DD-MM-YY
(d) MM-DD-YY

4. The master list of an indexed file ?
(a) Is sorted in ascending order
(b) contains only a list of keys and record numbers
(c) has a number assigned to each record
(d) Both B and C

5. A condition that led to the development of database was ?
(a) A demand for more data to support information needs
(b) An increase in the amount of data handled by organizations
(c) The poliferation of data files
(d) All of above

6. Information can be transferred between the DBMS and a ?
(a) Spreadsheet program
(b) Word processor program
(c) Graphics programs
(d) All of above

7. A second Normal form does not permit …… dependency between a non prime attribute and the relation key ?
(a) Partial
(b) Multi
(c) Functional
(d) Valued

8. A relation scheme is in ….. if it is in the 1NF and if all non prime attributes are fully functionally dependent on the relation key ?
(a) First Normal Form
(b) Second Normal Form
(c) Boyce Codd Normal Form
(d) Fourth Normal Form

9. In a Third Normal Form relation, every ……attribute is non – transitively and fully dependent on  the every candidate key ?
(a) Prime
(b) Non Prime
(c) Unique
(d) None of these

10. In relational schema, each tuple is divided into fields called ?
(a) Relations
(b) Domains
(c) Queries
(d) All of above

11. 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 above

12. Administrate supervision of database activity is the responsibility of ?
(a) Database administrator
(b) DP Manager
(c) DB Manager
(d) DP Administration

13. All aggregate functions except _____ ignore null values in their input collection.
(a) Count(attribute)
(b) Count(*)
(c) Avg
(d) Sum

14. A Boolean data type that can take values true, false, and________ .
(a) 1
(b) 0
(c) Null
(d) Unknown

15. Select count (____ ID)
from teaches
where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
(a) Distinct
(b) Count
(c) Avg
(d) Primary key

16. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.
(a) Catalogs, schemas
(b) Schemas, catalogs
(c) Environment, schemas
(d) Schemas, Environment

17. Which of the following statements creates a new table temp instructor that has the same schema as instructor.
(a) create table temp_instructor;
(b) Create table temp_instructor like instructor;
(c) Create Table as temp_instructor;
(d) Create table like temp_instructor;

18. What are the ways of dealing with deadlock ?
(a) Deadlock prevention
(b) Deadlock recovery
(c) Deadlock detection
(d) All of the mentioned

19. When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is
(a) Wait-die
(b) Wait-wound
(c) Wound-wait
(d) Wait

20. Which of these is returned by operators &, ?
(a) Integer
(b) Boolean
(c) Character
(d) Float

Read More Meritmock Free IBPS Notes and Quiz : 

1 comment:

  1. Excellent work.
    A good collection of questions.