138+ DBMS MCQ Test and Online Quiz

1. In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,'Joey',2000);

table
values
from
relation

2. For what purpose the DML is provided?

Addition of new structure in the database
Manipulation & processing of the database
Definition of the physical structure of the database system
All of the above

3. The term "ODBC" stands for_____

Oral database connectivity
Oracle database connectivity
Open database connectivity
Object database connectivity

4. The architecture of a database can be viewed as the ________

a) One level
b) Two-level
c) Three-level
d) Four level

5. In the relation model, the relation are generally termed as ________

Tuples
Attributes
Rows
Tables

6. The Database Management Query language is generally designed for the _____

Support end-users who use English like commands
Specifying the structure of the database
Support in the development of the complex applications software
All of the above

7. Which of the following keys is generally used to represents the relationships between the tables?

a) Primary key
b) Foreign key
c) Secondary key
d) None of the above

8. Which of the following levels is considered as the level closed to the end-users?

Internal Level
External Level
Conceptual Level
Physical Level

9. What is the full form of ESE and PA component in GTU syllabus

End Semester Examination
Final Exam component
Performance Analysis
Progressive Assessment

10. Identify book author for DBMS subject for practical

Ivan Byross
C J Date
Martin Gruber
Navathe

11. Information is processed data?

True
False

12. Identify Correct year for first database application launched

2002
1995
1991
None of these

13. DBMS is multi user system?

True
False

14. Choose popular DBMS system

M-SQL
Oracle
DB10
None

15. Identify correct options related to types of DBMS

Hierarchical
Network
Relational
Object Oriented

16. Database is a collection of related data which represents some aspects of real world

True
False

17. DBMS is a software package designed to define, manipulate , retrieve and manage data in a database.

Yes
No

18. Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

1-iii,2-i,3-ii,4-iv
1-iii,2-ii,3-iv,4-i
1-ii,2-iii,3-iv,4-i
1-i,2-iii,3-ii,4-iv

19. In existing table, ALTER TABLE statement is used to

Add columns
Add constraints
Delete columns
Delete constrains
All the above

20. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;
DELETE TABLE table_name;
DROP TABLE table_name;
None

21. Correct syntax query syntax to drop a column from a table is

DELETE COLUMN column_name;
DROP COLUMN column_name;
ALTER TABLE table_name DROP COLUMN column_name;
None is correct.

22. Which command is used for removing a table and all its data from the database:

Create command
Drop table command
Alter table command
All of the mentioned

23. Which Symbol means "All"

*
&
%
!

24. Which is the correct query to delete the rows of employees whose exp is less than 10.

DELETE * FROM EMP WHERE EXP<10;
DELETE FROM EMP;
DELETE FROM EMP WHERE EXP<10;
DELETE FROM EMP WHERE EXP>10;

25. How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

select first_name,last_name,hire_date, from employee;
select first_name,last_name and hire_date from employees;
Select first_name,last_name& hire_date from employees;
select first_name,last_name,hire_date from employees;

26. SELECT statement is a ...............in SQL

Data Control Language(DCL)
Transcation Control language(TCL)
Data Manipulation language(DML)
Data Definition language(DDL)

27. What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;

Missing an AND
Table name
Capitalize action
None of these

28. SELECT * FROM cars WHERE Doors > 3would return how many records?

1
2
3
4

29. SELECT * FROM Students WHERE Gender="Female" AND Class=2.2 would return how many records?

1
2
3
4

30. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

31. If you were wanting to filter data, which clause would you use?

Where
Order by
From
Select

32. Which SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

33. Here which of the following displays the unique values of the column?SELECT ________ dept_nameFROM instructor;

from
like
unique
distinct

34. SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.

Dept_name
Employee
“Comp Sci”
From

35. The __ clause allows us to select only those rows in the result relation of the clause that satisfy a specified predicate.

Where, from
From, select
Select, from
From, where

36. What is a good primary key to use for a Product table?

Weight
Product Code
Name
Colour

37. Intersection of rows and columns is called ..........

Table
Row
Column
Cell

38. ER Diagram stands for

Entity Relation Diagram
Entity Relationship Database
Entity Relationship Diagram
Entity Relation Database

39. An/a ......... shows the relationship among entity sets.

Flowchart
Table
Relational model
ER diagram

40. An/A ........ describes the structure of a database with the help of a diagram,

Network model
ER model
Relational model
Hierarchical model

41. ........... represents Entity sets.

Square
Circle
Rectangle
Oval

42. An ER diagram has ....... main components

One
Three
Five
Seven

43. A ......... is a data model in which the data are organized into a tree-like structure.

Network model
ER model
Hierarchical model
Relational model

44. What is an example of a paper database?

A map
Student folder in the office
Snapchat

45. Which data type collect whole numbers?

Float
Integer
Text
Date/Time

46. What is the name of the Table in the diagram?

Table1
Customers
New
Customer

47. Which of the following is NOT a purpose of database?

To collect records
To store records
To perform calculations
To create a letter

48. Which data type would we use to show Mariah's birthday?

Floating
Integer
Boolean
Date/Time

49. The primary key is a __________ that uniquely identifies a record.

table
field
row
column

50. Which entity would you NOT see in a bookstore database?

Books
Authors
Date published
Employees

DBMS MCQ Computer Science

About DBMS

DBMS MCQ

1. In the given query which of the keyword has to be inserted?

2. For what purpose the DML is provided?

3. The term "ODBC" stands for_____

4. The architecture of a database can be viewed as the ________

5. In the relation model, the relation are generally termed as ________

6. The Database Management Query language is generally designed for the _____

7. Which of the following keys is generally used to represents the relationships between the tables?

8. Which of the following levels is considered as the level closed to the end-users?

9. What is the full form of ESE and PA component in GTU syllabus

10. Identify book author for DBMS subject for practical

11. Information is processed data?

12. Identify Correct year for first database application launched

13. DBMS is multi user system?

14. Choose popular DBMS system

15. Identify correct options related to types of DBMS

16. Database is a collection of related data which represents some aspects of real world

17. DBMS is a software package designed to define, manipulate , retrieve and manage data in a database.

18. Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

19. In existing table, ALTER TABLE statement is used to

20. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

21. Correct syntax query syntax to drop a column from a table is

22. Which command is used for removing a table and all its data from the database:

23. Which Symbol means "All"

24. Which is the correct query to delete the rows of employees whose exp is less than 10.

25. How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

26. SELECT statement is a ...............in SQL

27. What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;

28. SELECT * FROM cars WHERE Doors > 3would return how many records?

29. SELECT * FROM Students WHERE Gender="Female" AND Class=2.2 would return how many records?

30. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

31. If you were wanting to filter data, which clause would you use?

32. Which SQL statement would add a record to the database?

33. Here which of the following displays the unique values of the column?SELECT ________ dept_nameFROM instructor;

34. SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.

35. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

36. What is a good primary key to use for a Product table?

37. Intersection of rows and columns is called ..........

38. ER Diagram stands for

39. An/a ......... shows the relationship among entity sets.

40. An/A ........ describes the structure of a database with the help of a diagram,

41. ........... represents Entity sets.

42. An ER diagram has ....... main components

43. A ......... is a data model in which the data are organized into a tree-like structure.

44. What is an example of a paper database?

45. Which data type collect whole numbers?

46. What is the name of the Table in the diagram?

47. Which of the following is NOT a purpose of database?

48. Which data type would we use to show Mariah's birthday?

49. The primary key is a __________ that uniquely identifies a record.

50. Which entity would you NOT see in a bookstore database?

Enjoyed the Quiz. Share this with friends

Comments

Add Your Review

Book Now & Get 50% Discount

Advertisement

Quick Contact to Help?

Related MCQ's

Laravel MCQ 80 Questions

React JS MCQ 37 Questions

AngularJs MCQ 93 Questions

Node js MCQ 57 Questions

Angular 2 MCQ 0 Questions

Subscribe to Newsletter!

Computer Science

Science

Commerce

Mathematics

Aptitude

General Knowledge

35. The __ clause allows us to select only those rows in the result relation of the clause that satisfy a specified predicate.