DBMS MCQ Solved Paper for SBI Clerk
Thursday 9th of March 2023
Sharing is caring
1. A data type or format is specified for each _________
A. Relation
B. Tuple
C. Database
D. Domain
Answer : B
A. Relation
B. Tuple
C. Database
D. Domain
Answer : B
2. Relational Algebra does not have
A. Selection operator.
B. Projection operator.
C. Aggregation operators.
D. Division operator.
Answer : C
A. Selection operator.
B. Projection operator.
C. Aggregation operators.
D. Division operator.
Answer : C
3. What is data integrity?
A. It is the data contained in database that is non redundant.
B. It is the data contained in database that is accurate and consistent.
C. It is the data contained in database that is secured.
D. It is the data contained in database that is shared.
Answer : B
A. It is the data contained in database that is non redundant.
B. It is the data contained in database that is accurate and consistent.
C. It is the data contained in database that is secured.
D. It is the data contained in database that is shared.
Answer : B
4. The data models defined by ANSI/SPARC architecture are
A. Conceptual, physical and internal
B. Conceptual, view and external
C. Logical, physical and internal
D. Logical, physical and view
Answer : D
A. Conceptual, physical and internal
B. Conceptual, view and external
C. Logical, physical and internal
D. Logical, physical and view
Answer : D
5. Which of the following addressing modes permits relocation without any change over in the code?
A. Indirect addressing
B. Indexed addressing
C. PC relative addressing
D. Base register addressing
Answer : B
A. Indirect addressing
B. Indexed addressing
C. PC relative addressing
D. Base register addressing
Answer : B
6. Which of the following is not a property of transactions?
A. Atomicity
B. Concurrency
C. Isolation
D. Durability
Answer : B
A. Atomicity
B. Concurrency
C. Isolation
D. Durability
Answer : B
7. Which of the following ensures the atomicity of the transaction?
A. Transaction management component of DBMS
B. Application Programmer
C. Concurrency control component of DBMS
D. Recovery management component of DBMS
Answer : A
A. Transaction management component of DBMS
B. Application Programmer
C. Concurrency control component of DBMS
D. Recovery management component of DBMS
Answer : A
8. As per equivalence rules for query transformation, selection operation distributes over
A. Union.
B. Set difference.
C. Intersection.
D. All of the above.
Answer : D
A. Union.
B. Set difference.
C. Intersection.
D. All of the above.
Answer : D
9. Maximum height of a B+ tree of order m with n key values is
A. Logm(n)
B. (m+n)/2
C. Logm/2(m+n)
D. None of these
Answer : D
A. Logm(n)
B. (m+n)/2
C. Logm/2(m+n)
D. None of these
Answer : D
10. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
A. 2NF
B. 3NF
C. BCNF
D. 1NF
Answer : B
A. 2NF
B. 3NF
C. BCNF
D. 1NF
Answer : B
11. The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
A. Similarity
B. Granularity
C. Dimensionality
D. Arity
Answer : B
A. Similarity
B. Granularity
C. Dimensionality
D. Arity
Answer : B
12. The normal form that is not necessarily dependency preserving is
A. 2NF
B. 3NF
C. BCNF
D. 4NF
Answer : A
A. 2NF
B. 3NF
C. BCNF
D. 4NF
Answer : A
13. Which of the following is not a characteristic of a relational database model?
A. Table
B. Tree like structure
C. Complex logical relationship
D. Records
Answer : B
A. Table
B. Tree like structure
C. Complex logical relationship
D. Records
Answer : B
14. Precedence graphs help to find a
A. Serializable schedule.
B. Recoverable schedule.
C. Deadlock free schedule.
D. Cascadeless schedule.
Answer : A
A. Serializable schedule.
B. Recoverable schedule.
C. Deadlock free schedule.
D. Cascadeless schedule.
Answer : A
15. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
Answer : A
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
Answer : A
16. The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
A. Schema
B. Tuple
C. Domain
D. Relational
Answer : C
A. Schema
B. Tuple
C. Domain
D. Relational
Answer : C
17. It is an abstraction through which relationships are treated as higher level entities
A. Generalization.
B. Specialization.
C. Aggregation.
D. Inheritance.
Answer : C
A. Generalization.
B. Specialization.
C. Aggregation.
D. Inheritance.
Answer : C
18. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
A. Star
B. llustar
C. SQL
D. Cygnus
Answer : B
A. Star
B. llustar
C. SQL
D. Cygnus
Answer : B
19. ______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
A. Domain Integrity Constraints
B. Referential Integrity Constraints
C. Domain Constraints
D. Entity Integrity Constraints
Answer : B
A. Domain Integrity Constraints
B. Referential Integrity Constraints
C. Domain Constraints
D. Entity Integrity Constraints
Answer : B
20. 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
Answer : B
A. schema
B. instance of the database
C. data domain
D. independence
Answer : B
21. 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
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
22. Drop Table cannot be used to drop a table referenced by a ______ constraint.
A. Primary Key
B. Local Key
C. Foreign Key
D. Composite Key
Answer : C
A. Primary Key
B. Local Key
C. Foreign Key
D. Composite Key
Answer : C
23. Shadow paging has
A. no redo
B. no undo
C. redo but no undo
D. neither redo nor undo
Answer : A
A. no redo
B. no undo
C. redo but no undo
D. neither redo nor undo
Answer : A
24. The clause alter table in SQL can be used to
A. add an attribute
B. delete an attribute
C. alter the default values of an attribute
D. all of the above
Answer : D
A. add an attribute
B. delete an attribute
C. alter the default values of an attribute
D. all of the above
Answer : D
25. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
A. Operationally, if Y is deleted, so is X
B. existence is dependent on Y.
C. Operationally, if X is deleted, so is Y.
D. Operationally, if X is deleted, & remains the same.
Answer : C
A. Operationally, if Y is deleted, so is X
B. existence is dependent on Y.
C. Operationally, if X is deleted, so is Y.
D. Operationally, if X is deleted, & remains the same.
Answer : C
26. Processed data is called _____
A. Raw data
B. Source
C. Information
D. Useful data
Answer : C
A. Raw data
B. Source
C. Information
D. Useful data
Answer : C
27. In SQL, testing whether a subquery is empty is done using
A. DISTINCT
B. UNIQUE
C. NULL
D. EXISTS
Answer : D
A. DISTINCT
B. UNIQUE
C. NULL
D. EXISTS
Answer : D
28. Which of the following is not a consequence of concurrent operations?
A. Lost update problem.
B. Update anomaly.
C. Unrepeatable read.
D. Dirty read.
Answer : B
A. Lost update problem.
B. Update anomaly.
C. Unrepeatable read.
D. Dirty read.
Answer : B
29. The normalization was first proposed by .
A. Code
B. Codd
C. Boyce Codd
D. Boyce
Answer : B
A. Code
B. Codd
C. Boyce Codd
D. Boyce
Answer : B
30. For correct behaviour during recovery, undo and redo operation must be
A. Commutative
B. Associative
C. idempotent
D. distributive
Answer : C
A. Commutative
B. Associative
C. idempotent
D. distributive
Answer : C
31. Union operator is a :
A. Unary Operator
B. Ternary Operator
C. Binary Operator
D. Not an operator
Answer : C
A. Unary Operator
B. Ternary Operator
C. Binary Operator
D. Not an operator
Answer : C
32. A ______ module is typically designed so that it will run on a user workstation or personal computer.
A. Software
B. Server
C. Program
D. Client
Answer : D
A. Software
B. Server
C. Program
D. Client
Answer : D
33. The _______ is a set of programs to use and / or modify this data.
A. DBMS
B. System
C. Program
D. Software
Answer : A
A. DBMS
B. System
C. Program
D. Software
Answer : A
34. In E-R Diagram total participation is represented by
A. Double lines
B. Single line
C. Dashed lines
D. Triangle
Answer : A
A. Double lines
B. Single line
C. Dashed lines
D. Triangle
Answer : A
35. If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
A. M:N
B. M:1
C.
D. 1:M
Answer : C
A. M:N
B. M:1
C.
D. 1:M
Answer : C
36. 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
Answer : A
A. Hierarchical schema
B. Network schema
C. Relational Schema
D. All of the above
Answer : A
37. Which of the following is not a logical database structure?
A. Chain
B. Network
C. Tree
D. Relational
Answer : A
A. Chain
B. Network
C. Tree
D. Relational
Answer : A
38. 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
A. DISTINCT
B. NO DUPLICATE
C. UNIQUE
D. None of the above
Answer : C
39. The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
Answer : C
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
Answer : C
40. Relational Algebra is
A. Data Definition Language .
B. Meta Language
C. Procedural query Language
D. None of the above
Answer : C
A. Data Definition Language .
B. Meta Language
C. Procedural query Language
D. None of the above
Answer : C
41. 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
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
42. Grant and revoke are _____ statements.
A. TCL
B. DCL
C. DDL
D. DML
Answer : B
A. TCL
B. DCL
C. DDL
D. DML
Answer : B
43. A relational database developer refers to a record as
A. an attribute
B. a tuple
C. a criteria
D. a relation
Answer : B
A. an attribute
B. a tuple
C. a criteria
D. a relation
Answer : B
44. 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
A. Fields
B. Records
C. Relations
D. Keys
Answer : C
45. 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
A. Hierarchic Standard Access Method
B. Hierarchic Sequential Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
Answer : B
46. ………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database
B. Multiple databases
C. Top-down approach
D. None of the above
Answer : B
A. Single global database
B. Multiple databases
C. Top-down approach
D. None of the above
Answer : B
47. Which two files are used during operation of the DBMS?
A. Query languages and utilities
B. DML and query lnguage
C. Data dictionary and transaction log
D. Data dictionary and query language
Answer : C
A. Query languages and utilities
B. DML and query lnguage
C. Data dictionary and transaction log
D. Data dictionary and query language
Answer : C
48. 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
A. None
B. Multi
C. Single
D. Concurrent
Answer : C
49. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
A. Direct
B. Indirect
C. Existence
D. No
Answer : C
A. Direct
B. Indirect
C. Existence
D. No
Answer : C
50. The middleware databases in which the business rules act are applicable to _______ tier architectures
A. Single
B. Three
C. Two
D. None
Answer : B
A. Single
B. Three
C. Two
D. None
Answer : B
Sharing is caring
Related Post
FCI Recruitment - Selenium automation 1000+ MCQ [Solved] PDF Download
Industrial Engineering & Production Management Test MCQ Solved Paper for LIC ADO
RBI Grade B officer - Animal Kingdom 1000+ MCQ [Solved] PDF Download
Cell - the unit of life 1000+ MCQ with answer for RBI Assistant
1000+ Current Affairs October 2022 MCQ for UPSC IES [Solved]
1000+ Visual Basic .NET MCQ for UPSC CSE [Solved]