DBMS MCQ | Database Management System MCQs for Freshers

Posted on: | By: – Comments Off

Database Management System MCQs

Top 50 DBMS mcq questions and answers focuses on all areas of Database Management System subject covering all the topics in Database Management System.

 

1) A change in the order of the tables given in a query will have an impact in the final result-set of the query.

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

2) A collection of related data fields is called a ____.

  1. byte
  2. record
  3. character
  4. bit

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

3) A DBMS is a(n) ____.

  1. interface between the database and application programs
  2. data repository
  3. knowledge base
  4. unique group of records

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

4) A FLAT FILE database management system is

  1. A database design that only has one table in it
  2. A DBMS that can only have simple data tables in it
  3. A DBMS that can only have one table in it
  4. A DBMS that contains records that have a large number of fields in them

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

5) A primary Key column should have

  1. Unique values but can contain NULL
  2. Unique values and can’t contain NULL
  3. May not contain Unique values but shouldn’t have NULL
  4. May not contain Unique values and can contain NULL.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

6) A Table

  1. Can only store data of one type
  2. Consists of Alphanumeric data
  3. Consists of Rows and Columns
  4. Cannot be empty

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

7) A table can have only one PRIMARY KEY

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

8) A table can’t have more than one UNIQUE KEY

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

9) Ability of a computer system or a database to operate efficiently with larger quantities of data is called

  1. Linearity
  2. Feasibility
  3. Scalability
  4. Efficiency

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

10) All the locks are released when

  1. we issue a commit statement
  2. when we issue a rollback statement
  3. both a and B are true
  4. none of them is true

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

11) An Empty string and null are both the same

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

12) Can you use select in FROM clause of SQL select ?

  1. YES
  2. NO

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

13) Column alias cant be used in which clause

  1. Select
  2. where
  3. Order by
  4. none

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

14) Commit command is used to make the changes permanent in the table

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

15) Consider the table (STUDREC). Which of the following statements will list columns INIT, SNAME, GENDER and KIDS (in that order) for all students who have more then 1 child.

  1. SELECT init, sname, gender, kids FROM studrec WHERE kids <1;
  2. SELECT init, sname, gender, kids FROM studrec WHERE kids >1;
  3. SELECT init, sname, gender, kids FROM studrec WHERE kids >’1′;
  4. SELECT init sname, gender, kids FROM studrec WHERE kids >1;

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

16) CREATE TABLE statement is used to create

  1. Both relational table and object table
  2. Only relational table
  3. Only object table
  4. XML Table

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

17) CREATE TABLE table_name(column_name CHAR);                                                                             The above SQL statement will create table table_name

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

18) Database schema is implemented from

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. Metadata model

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

19) DBMS is the acronym for

  1. Directory Base Management System
  2. Database Master System
  3. Data Basic Management System
  4. Database Management System

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

20) Describe the use of %ROWTYPE in PL/SQL ?

  1. It allows you to associates a variable with a single column type
  2. It allows you to associate a variable with an entire table row
  3. It allows you to associate a variable with an entire table column
  4. Both A and C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

21) Distinct Keyword is used for

  1. Selecting all duplicate rows
  2. Eliminating all duplicate rows from the output
  3. Both A & B
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

22) Domain is

  1. Number of attributes
  2. Tuple
  3. A pool of values from which specific attributes of specific relations draw their values
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

23) Foreign Key

  1. may contain NULL
  2. has unique values
  3. Either A or B
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

24) GROUP BY SQL clause

  1. Uniquely lists the aggregated
  2. items in the SELECT list
  3. Uniquely lists the unaggregated
  4. items in the SELECT list
  5. Nonuniquely lists the unaggregated
  6. items in the SELECT list
  7. Nonuniquely lists the aggregated
  8. items in the SELECT list

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

25) How does a database store data about its tables?

  1. By a data dictionary
  2. By entity modeling
  3. By normalization
  4. By relationships

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

26) IF I want to store true / false in sql values from my frontend which data type should I use at the best level in terms of minimum storage?

  1. Char
  2. Varchar
  3. Bit
  4. Int

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

27) In Ascending order sort null values appear in the bottom of the result set

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

28) In the relational database terminology, a table is synonymous with:

  1. A column
  2. A row
  3. An attribute
  4. A relation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

29) Insert, Drop table are examples of which SQL type?

  1. DML
  2. DDL
  3. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

30) Managing data security involves

  1. Data Classification
  2. Encryption
  3. Data Governance
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

31) One of the goals of a DBMS is to increase data redundancy thereby making it less vulnerable to hackers.

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

32) Rollback is used to reach the previous committed state

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

33) SELECT * FROM R1 LEFT [OUTER] JOIN R2 ON R1.field = R2.field

– returns additional rows from?

  1. R1
  2. R2
  3. Both
  4. Neither

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

34) select, update are examples of which SQL type

  1. DML
  2. DDL
  3. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

35) SQL stands for

  1. Sequential Question Language
  2. Structured Query Language
  3. Structured Question Language
  4. Sequential Query Language

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

36) Table partitioning splits the storage of a table into smaller individual units.

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

 

 

37) To improve performance, all tables in the data warehouse should be indexed.

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

38) Union All returns

  1. All rows selected by either query
  2. All rows selected by either query and including duplicates
  3. All distinct rows selected by both queries
  4. All rows selected by the first query but not the seconds

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

39) Unique Constraint enforces

  1. single number value to be entered
  2. single character to be entered
  3. multiple values in set of columns
  4. uniqueness of the values
  5. in a set of columns

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

40) User-Defined Integrity enforces

  1. null constraints
  2. some specific business
  3. rules
  4. check constraints
  5. entity integrity

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

41) What is a formal way to express data relationships to a database management system?

  1. Attributes
  2. Entity identifier
  3. Data model
  4. Entity-relationship diagram

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

42) What is Database ?

  1. A known fact that can be recorded and that have implicit meaning
  2. The data is perceived by the user as tables
  3. It is designed, built, and populated with data for a specific purpose
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

43) What is the default ordering of an ORDER BY clause in a SELECT statement?

  1. Descending
  2. Ascending

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

44) Which clause limits the rows selected in a query?

  1. Order By
  2. Where
  3. Select
  4. From

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

45) Which is a feature of RDBMS?

  1. Create multiple tables and enter data into them
  2. Interactive Query language
  3. All of these
  4. Retrieval of data stored in more than on table

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

46) Which of the following are elements of SQL?

  1. Data Control Language
  2. Data Definition Language
  3. Data Manipulation Language
  4. All of these

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

 

 

47) Which of the following statements does not apply to relational databases?

  1. Relational databases are simple to understand
  2. Tables are one of the basic components of relational databases
  3. Relational databases have a strong procedural orientation
  4. Relational databases have a strong mathematical foundation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

48) Which one is DDL command?

  1. Insert
  2. Update
  3. Drop
  4. Select

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

 

49) Which part of the following SQL is responsible for not returning the expected output? Select * from emp where comm = null order by ename;

  1. order by clause should appear before where clause
  2. where comm = null
  3. we cant use select * here
  4. No error

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

 

 

50) Why is denormalization beneficial to read operations?

  1. Indexes are sorted.
  2. Disk I/O is reduced.
  3. complex joins is avoided
  4. Easy Data flow

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

 

51) DML is provided for

  1. Description of logical structure of database
  2. Addition of new structures in the database system
  3. Manipulation & processing of database
  4. Definition of physical structure of database system

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]