DBMS MCQs

Table of Contents

DBMS MCQs

  1. Which of the following is an Open Source DBMS?
  2. a. MySQL
    b. Microsoft SQL Server
    c. Microsoft Access
    d. Oracle

    a. MySQL

  3. How many primary key can a table in database have?
  4. a. Only one
    b. At least one
    c. More than one
    d. Any number of

    b. At least one

  5. Abbreviate ACID.
  6. a. Atomicity, Consistency, Isolation, Durability
    b. Atomicity, Concurrency, Isolation, Duplicity
    c. Aggregation, Consistency, Isolation, Durability
    d. Atomicity, Consistency, Identity, Durability

    a. Atomicity, Consistency, Isolation, Durability

  7. Data items are composed of data elements.
  8. a. True
    b. False

    b. False

  9. What is a degree of relation?
  10. a. It is the number of attributes of its relation schema.
    b. The number of relationships with other tables
    c. Number of association among two or more entities
    d. Number of foreign key dependencies

    c. Number of association among two or more entities

  11. Under which category do the commands CREATE and ALTER belong to?
  12. a. DML
    b. DDL
    c. UML
    d. None of the above.

    b. DDL

  13. Database: A condition that led to the development of database was
  14. 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

    d. All of above

  15. Which is not a function of aggregate function?
  16. a. Count
    b. Avg
    c. Create
    d. Max

    c. Create

  17. In second normal form __________.
  18. a. A composite attributes is converted to individual attributes.
    b. Non-key attributes are funetional dependent on key attributes.
    c. The non key attributes functionally dependent on not a part of key attributes.
    d. All the above

    c. The non key attributes functionally dependent on not a part of key attributes.

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

    c. Look up

  21. An unnormalized relation contains values?
  22. a. Atomic
    b. Non-Atomic
    c. Classified
    d. None of these

    c. Classified

  23. The view of total database content is
  24. a. Conceptual view
    b. Internal view
    c. External view
    d. Physical View

    a. Conceptual view

  25. Which is the major data structure used in RDBMS?
  26. a. Tree
    b. Stacks
    c. Graph
    d. Array

    d. Array

  27. In the relational model, cardinality is termed as:
  28. (A) Number of tuples
    (B) Number of attributes
    (C) Number of tables
    (D) Number of constraints

    (A) Number of tuples

  29. Relational calculus is a ________.
  30. (A) Procedural language
    (B) Non- Procedural language
    (C) Data definition language
    (D) High-level language

    (B) Non- Procedural language

  31. The view of total database content is
  32. (A) Conceptual view
    (B) Internal view
    (C) External view
    (D) Physical View

    (A) Conceptual view

  33. DML is provided for
  34. (a) Description of the logical structure of a database
    (b) The addition of new structures in the database system
    (c) Manipulation & processing of database
    (d) Definition of a physical structure of database system

    (c) Manipulation & processing of database

  35. ‘AS’ clause is used in SQL for
  36. (A) Selection operation
    (B) Rename operation
    (C) Join operation
    (D) Projection operation

    (B) Rename operation

  37. ODBC stands for
  38. (A) Object Database Connectivity
    (B) Oral Database Connectivity
    (C) Oracle Database Connectivity
    (D) Open Database Connectivity

    (D) Open Database Connectivity

  39. Architecture of the database can be viewed as
  40. (A) two levels
    (B) four levels
    (C) three levels
    (D) one level

    (C) three levels

  41. In a relational model, relations are termed as
  42. (A) Tuples
    (B) Attributes
    (c) Tables
    (D) Rows

    (c) Tables

  43. The database schema is written in
  44. (A) HLL
    (B) DML
    (C) DDL
    (D) DCL

    (C) DDL

  45. In the architecture of a database system external level is the
  46. (A) physical level
    (B) logical level
    (C) conceptual level
    (D) view level

    (D) view level

  47. An entity set that does not have sufficient attributes to form a primary key is a
  48. (A) strong entity set
    (B) weak entity set
    (C) simple entity set
    (D) primary entity set

    (B) weak entity set

  49. In Hierarchical model records are organized as
  50. (A) Graph
    (B) List
    (C) Links
    (D) Tree

    (D) Tree

  51. In an E-R diagram attributes are represented by
  52. (A) rectangle
    (B) square
    (C) ellipse
    (D) triangle

    (C) ellipse

  53. In case of entity integrity, the primary key may be
  54. (A) not Null
    (B) Null
    (C) both Null & not Null
    (D) any value

    (A) not Null

  55. The language used in application programs to request data from the DBMS is referred to as the
  56. (A) DML
    (B) DDL
    (C) VDL
    (D) sDL

    (A) DML

  57. A logical schema
  58. (A) is the entire database
    (B) is a standard way of organising information into accessible parts
    (C) describes how data is actually stored on disk
    (D) both (A) and (C)

    (D) both (A) and (C)

  59. Related fields in a database are grouped to form a
  60. (A) data file
    (B) data record
    (C) menu
    (D) bank

    (B) data record

  61. The database environment has all of the following components except:
  62. (A) users
    (B) separate files
    (C) database
    (D) database administrator

    (A) users

  63. which of the following is a component of a database?
  64. (a) Hardware
    (b) Software
    (c) Data and Database Access Language
    (d) All of above

    (d) All of above

  65. which of the following command is a type of data definition language command?
  66. (a) CREATE, ALTER, DROP, and TRUNCATE
    (b) DELETE, UPDATE, CREATE
    (c) CREATE, UPDATE, DELETE
    (d) None

    (a) CREATE, ALTER, DROP, and TRUNCATE

  67. the ability to query data as well as insert, delete and alter tuples is offered by
  68. (a) DML
    (b) DDL
    (c) Both a and b
    (d) None of above

    (a) DML

  69. which of the following refers to the number of tuples in a relation?
  70. (a) Cardinality
    (b) Column
    (c) None of Above
    (d) Entity

    (a) Cardinality

  71. Rows of a relation are known as the
  72. (a) column
    (b) rows
    (c) table
    (d) None

    (b) rows

DBMS MCQs
Cover Topics

“DBMS MCQs”,”dbms mcqs with answers”,”dbms mcqs ppsc”,”dbms mcqs for
placement”,”Database Management System MCQ (Multiple Choice Questions)”,”dbms
multiple choice questions with answers pdf”,”Database Management System
MCQs
“,”DBMS Multiple Choice Questions and Answers”,”DBMS MCQ Question Answer”

See also  Functional English Important MCQs