DBMS 1000+ MCQ with answer for IBPS PO

1. A data type or format is specified for each _________
A. Relation
B. Tuple
C. Database
D. Domain
Answer : B

2. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
A. OR
B. AND
C. NOT
D. ALL
Answer : B

3. DBMS is a collection of _____ that enables user to create and maintain a database.
A. Keys
B. Program
C. Translators
D. Language Activity
Answer : B

4. Data items grouped together for storage purposes are called a
A. record
B. string
C. title
D. list
Answer : A

5. Relational Algebra does not have
A. Selection operator.
B. Projection operator.
C. Aggregation operators.
D. Division operator.
Answer : C

6. Tree structures are used to store data in
A. Network model.
B. Relational model.
C. Hierarchical model.
D. File based system.
Answer : C

7. Isolation of the transactions is ensured by
A. Transaction management
B. Application programmer
C. Concurrency control
D. Recovery management
Answer : C

8. Immediate database modification technique uses
A. Both undo and redo.
B. Undo but no redo.
C. Redo but no undo.
D. Neither undo nor redo.
Answer : A

9. 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
Answer : D

10. For using a specific database …………… command is used.
A. use database
B. database name use
C. Both A & B
D. None of them
Answer : A

11. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
A. left outer join
B. right outer join
C. full outer join
D. inner join
Answer : D

12. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
A. distinct values
B. cannot have NULL
C. both (A) & (B)
D. same as primary key
Answer : C

13. The keyword to eliminate duplicate rows from the query result in SQL is
A. DISTINCT
B. NO DUPLICATE
C. UNIQUE
D. None of the above
Answer : C

14. DROP is a statement in SQL.
A. Query
B. Embedded SQL
C. DDL
D. DCL
Answer : C

15. An advantage of views is
A. Data security
B. Derived columns
C. Hiding of complex queries
D. All of the above
Answer : A

16. The values of the attribute describes a particular
A. Entity set
B. File
C. Entity instance
D. Organization
Answer : C

17. ______is a preferred method for enforcing data integrity
A. Constraints
B. Triggers
C. Stored procedure
D. Cursors
Answer : A

18. A _____ is used to define overall design of the database
A. code
B. data definition language
C. application program
D. schema
Answer : D

19. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
A. Primary
B. Foreign
C. Candidate
D. Alternate
Answer : A

20. Change Staff table by removing default of Assistant for position column
A. ALTER TABLE Staff ALTER position DROP DEFAULT;
B. ALTER TABLE Staff ALTER position DEFAULT;
C. ALTER TABLE Staff ALTER DROP DEFAULT;
D. MODIFY Staff ALTER position DROP DEFAULT;
Answer : A

21. A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
A. Database
B. Data
C. Transaction
D. Record
Answer : C

22. The middleware databases in which the business rules act are applicable to _______ tier architectures
A. Single
B. Three
C. Two
D. None
Answer : B

23. If the closure of an attribute set is the entire relation then the attribute set is a
A. superkey
B. candidate key
C. primary key
D. not a key
Answer : A

24. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
A. RAM
B. Flash
C. Hard Disk
D. Secondary
Answer : B

25. E-R Modeling is achieved by using ____ diagrams
A. DFD
B. Flowcharts
C. Gantt Charts
D. E-R
Answer : D

26. The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
Answer : C

27. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A. It will result in a deadlock situation.
B. It will immediately be rejected.
C. It will immediately be granted.
D. It will be granted as soon as it is released by A .
Answer : C

28. Which of the following is not a property of transactions?
A. Atomicity
B. Concurrency
C. Isolation
D. Durability
Answer : B

29. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
A. None
B. Multi
C. Single
D. Concurrent
Answer : C

30. In 2NF
A. No functional dependencies (FDs) exist.
B. No multivalued dependencies (MVDs) exist.
C. No partial FDs exist.
D. No partial MVDs exist.
Answer : C

31. ____ table store information about database or about the system.
A. SQL
B. System
C. Nested
D. None of these
Answer : B

32. When an E-R diagram is mapped to tables, the representation is redundant for
A. weak entity sets
B. weak relationship sets
C. strong entity sets
D. strong relationship sets
Answer : B

33. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
A. Fields
B. Records
C. Relations
D. Keys
Answer : C

34. It is an abstraction through which relationships are treated as higher level entities
A. Generalization.
B. Specialization.
C. Aggregation.
D. Inheritance.
Answer : C

35. Precedence graphs help to find a
A. Serializable schedule.
B. Recoverable schedule.
C. Deadlock free schedule.
D. Cascadeless schedule.
Answer : A

36. The data in the database at a particular moment of time is called the _______
A. Snapshot
B. Dynaset
C. Stateless
D. Stateful
Answer : A

37. An advantage of the database management approach is
A. data redundancy increases
B. data is dependent on programs
C. data is integrated and can be accessed by multiple programs
D. none of the above
Answer : C

38. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
A. m+n and 0
B. m+n and |m-n|
C. mn and 0
D. mn and m+n
Answer : C

39. Dependency preservation is not guaranteed in
A. BCNF
B. 3NF
C. PJNF
D. DKNF
Answer : A

40. Which one is true statement :
A. With finer degree of granularity of locking a high degree of concurrency is possible.
B. Locking prevents non-serializable schedules.
C. Locking cannot take place at field level.
D. An exclusive lock on data item X is granted even if a shared lock is already held on X.
Answer : A

41. What is a disjoint less constraint?
A. It requires that an entity belongs to no more than one level entity set.
B. The same entity may belong to more than one level.
C. The database must contain an unmatched foreign key value.
D. An entity can be joined with another entity in the same level entity set.
Answer : A

42. 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.
Answer : B

43. Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
A. i-only
B. ii-only
C. Both of them
D. None of them
Answer : C

44. A logical schema
A. is the entire database
B. Describes how data is actually stored on disk.
C. is a standard way of organizing information into accessible parts.
D. All of the above
Answer : C

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

46. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
A. 1:1
B. 1: Many
C. Many: One
D. Many : Many
Answer : A

47. HSAM stands for ……….
A. Hierarchic Standard Access Method
B. Hierarchic Sequential Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
Answer : B

48. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
A. SQL server Profile
B. SQL server wizard.
C. SQL server service manager
D. SQL server setup
Answer : C

49. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
A. Functional dependency
B. Multi-valued dependency
C. Transitive dependency
D. Partial dependency
Answer : B

50. The statement that is executed automatically by the system as a side effect of the modification of the database is
A. backup
B. assertion
C. recovery
D. trigger
Answer : D