DBMS MCQs


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






  2. How many primary key can a table in database have?


    3. a. Only one

    b. At least one

    c. More than one

    d. Any number of




    b. At least one






  3. Abbreviate ACID.


    4. 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






  4. Data items are composed of data elements.


    5. a. True

    b. False




    b. False






  5. What is a degree of relation?


    6. 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






  6. Under which category do the commands CREATE and ALTER belong to?


    7. a. DML

    b. DDL

    c. UML

    d. None of the above.




    b. DDL






  7. Database: A condition that led to the development of database was


    8. 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






  8. Which is not a function of aggregate function?


    9. a. Count

    b. Avg

    c. Create

    d. Max




    c. Create






  9. In second normal form __________.


    10. 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.






  10. Primitive operations common to all record management system include ?


    11. a. Print

    b. Sort

    c. Look up

    d. All of above




    c. Look up






  11. An unnormalized relation contains values?


    12. a. Atomic

    b. Non-Atomic

    c. Classified

    d. None of these




    c. Classified






  12. The view of total database content is


    13. a. Conceptual view

    b. Internal view

    c. External view

    d. Physical View




    a. Conceptual view






  13. Which is the major data structure used in RDBMS?


    14. a. Tree

    b. Stacks

    c. Graph

    d. Array




    d. Array






  14. In the relational model, cardinality is termed as:


    15. (A) Number of tuples

    (B) Number of attributes

    (C) Number of tables

    (D) Number of constraints




    (A) Number of tuples






  15. Relational calculus is a ________.


    16. (A) Procedural language

    (B) Non- Procedural language

    (C) Data definition language

    (D) High-level language




    (B) Non- Procedural language






  16. The view of total database content is


    17. (A) Conceptual view

    (B) Internal view

    (C) External view

    (D) Physical View




    (A) Conceptual view






  17. DML is provided for


    18. (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






  18. 'AS' clause is used in SQL for


    19. (A) Selection operation

    (B) Rename operation

    (C) Join operation

    (D) Projection operation




    (B) Rename operation






  19. ODBC stands for


    20. (A) Object Database Connectivity

    (B) Oral Database Connectivity

    (C) Oracle Database Connectivity

    (D) Open Database Connectivity




    (D) Open Database Connectivity






  20. Architecture of the database can be viewed as


    21. (A) two levels

    (B) four levels

    (C) three levels

    (D) one level




    (C) three levels






  21. In a relational model, relations are termed as


    22. (A) Tuples

    (B) Attributes

    (c) Tables

    (D) Rows




    (c) Tables






  22. The database schema is written in


    23. (A) HLL

    (B) DML

    (C) DDL

    (D) DCL




    (C) DDL






  23. In the architecture of a database system external level is the


    24. (A) physical level

    (B) logical level

    (C) conceptual level

    (D) view level




    (D) view level






  24. An entity set that does not have sufficient attributes to form a primary key is a


    25. (A) strong entity set

    (B) weak entity set

    (C) simple entity set

    (D) primary entity set




    (B) weak entity set






  25. In Hierarchical model records are organized as


    26. (A) Graph

    (B) List

    (C) Links

    (D) Tree




    (D) Tree






  26. In an E-R diagram attributes are represented by


    27. (A) rectangle

    (B) square

    (C) ellipse

    (D) triangle




    (C) ellipse






  27. In case of entity integrity, the primary key may be


    28. (A) not Null

    (B) Null

    (C) both Null & not Null

    (D) any value




    (A) not Null






  28. The language used in application programs to request data from the DBMS is referred to as the


    29. (A) DML

    (B) DDL

    (C) VDL

    (D) sDL




    (A) DML






  29. A logical schema


    30. (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)






  30. Related fields in a database are grouped to form a


    31. (A) data file

    (B) data record

    (C) menu

    (D) bank




    (B) data record






  31. The database environment has all of the following components except:


    32. (A) users

    (B) separate files

    (C) database

    (D) database administrator




    (A) users






  32. which of the following is a component of a database?


    33. (a) Hardware

    (b) Software

    (c) Data and Database Access Language

    (d) All of above




    (d) All of above






  33. which of the following command is a type of data definition language command?


    34. (a) CREATE, ALTER, DROP, and TRUNCATE

    (b) DELETE, UPDATE, CREATE

    (c) CREATE, UPDATE, DELETE

    (d) None




    (a) CREATE, ALTER, DROP, and TRUNCATE






  34. the ability to query data as well as insert, delete and alter tuples is offered by


    35. (a) DML

    (b) DDL

    (c) Both a and b

    (d) None of above




    (a) DML






  35. which of the following refers to the number of tuples in a relation?


    36. (a) Cardinality

    (b) Column

    (c) None of Above

    (d) Entity




    (a) Cardinality





  36. Rows of a relation are known as the


    37. (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"



Comments

Post a Comment

Popular posts from this blog

Formal and informal Letter writing MCQs

Image
Formal and informal Letter writing MCQs Formal and informal Letter writing MCQs 'With love' is used in which part of an informal letter? (a) Heading (b) Opening (c) Closing (d) Body Answer (c) Closing How would you address the receipient of an informal letter ? (a) Dear Mr. (b) My Dear (c) Dear Sir/Madam (d) HelÄ[Madam. Answer (b) My Dear In order to have the desired effect on the recipient what should letter be ? (a) The proper (b) To the point and relevant (c) Grammatically correct (d) All of the above A...
Read more

Reading Skills MCQs

Image
Reading Skills MCQs ________ is a complex cognitive process ot decodıng symbols to derive meaning. (a) Writing (b) Listening (c) Reading (d) Speaking Answer (c) Reading Reading is a complex negotiation between the text and the reader is the definition given by ________. (a) Weaver, 1988 (b) Francis Bacon, 1986 (c) Wilson, 1987 (d) Chomsky, 1966 Answer (a) Weaver, 1988 Reading Skills varies from person to person according to their _______ and _______. (a) Linguistic competence and future knowledge (b) Present knowledge and...
Read more

Literary Criticism MCQs with Answers

Image
Literary Criticism MCQs with Answers Aristotle and plato belonged to ________ Phase of criticism. (a) Greco-Roman (b) Hellenistic (c) Renaissance (d) Romantic Answer (b) Hellenistic "SYMPOSIUM" WAS WRITTEN BY (a) Greco-Roman (b) Hellenistic (c) Renaissance (d) Romantic Answer (b) Hellenistic Who proposed that poets should be Banished from ideal republic. (a) Aristotle (b) Plato (c) Socrates (d) Dr. Johnson Answer (b) Plato ACCORDING TO PLATO, WHAT IS THE MORAL PURPOSE OFART? (a) To connect human beings with a higher ideal (b) To entertain those who enjoy it (c...
Read more