138+ DBMS MCQ Test and Online Quiz

1. 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’

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

from
like
unique
distinct

3. Collection of information stored in a database at a particular moment is

view
schema
instance
none of the above

4. A DBMS makes it possible for users to:-

CREATE
UPDATE
DELETE
ALL THE ABOVE

5. The term "Data independence" refers to____

Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Both B & C

6. The term "SQL" stands for

Standard query language
Sequential query language
Structured query language
Server-side query language

7. Which one of the following commands is used to restore the database to the last committed state?

Save point
Rollback
Commit
Both A & B

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

9. Which of the following commands is used to save any transaction permanently into the database?

Commit
Rollback
Save point
None of the above

10. Which one of the following refers to the total view of the database content?

Internal view
Physical view
Conceptual view
External view

11. Which one of the following command is used to delete the existing row in a table?

Delete
Update
Insert
None of the above

12. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

Delete
Drop
Remove
All of the above

13. Which of the following is used in the application programs to request data from the database management system?

Data Manipulation language
Data Definition Language
Data Control Language
All of the above

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

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

Internal Level
External Level
Conceptual Level
Physical Level

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

17. Which of the following refers to the number of attributes in a relation?

Degree
Row
Column
All of the above

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

Primary key
Foreign key
Secondary key
None of the above

19. Data redundancy occurs

when the same piece of data exists in multiple places.
when there is mismatch of data.
when there is NULL values.
when there is multiple values for an attribute.

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

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

table
values
from
relation

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

22. Which of the following is the most important feature of DBMS:

Command language like SQL
Ability to back up data
Ease of use
Ability to automate some tasks

23. Which of the following statements contains an error?

Select * from emp where empid = 10003;
Select empid from emp where empid = 10006;
Select empid from emp;
Select empid where empid = 1009 and lastname = ‘GELLER’;

24. Which of the following is NOT Advantages of DBMS

Increased data consistency
Reduced data redundancy
Improved data security
Increase data isolation

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

Add constraints
Delete columns
Delete constrains
All the above

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

27. What is returned by SUBSTR(‘TUTORIALS POINT’, 1, 9)

TUTORIAL
POINT
TUTORIALS
UTORIALS

28. This is an authorization command of SQL

Access
Grant
Allow
None of these

29. Which of the following refers collection of the information stored in a database at a specific time?

Independence
Instance of the database
Schema
Data domain

30. The term "ODBC" stands for_____

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

31. Which of the following is not a DBMS despite having database capabilities:

Microsoft Excel or similar spreadsheets
Oracle
MySQL
Microsoft Access or similar

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

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

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

Tuples
Attributes
Rows
Tables

34. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has spaces and attribute B has spaces .(i.e the total number of utilized space by A,B)

3,20
20,4
3,4
20,20

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

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

37. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

Translators
Programs
Keys
Language activity

38. SELECT * FROM employeeWhat type of statement is this?

integrity constraint
ddl
dml
view

39. Concurrent access by multiple users is not possible by using DBMS

true
false

40. CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this?

view
ddl
dml
tcl

41. A view of database that appears to an application program is known as

schema
subschema
virtual table
none of the above

42. Every Boyee-Codd normal form is in

1NF
2Nf
3NF
all the above

43. Which command is used to remove all rows from a table ?

Delete
Remove
Truncate
Both [A] and [B]

44. A DBMS query language is designed to

Support end users who use English-like commands.
Support in the development of complex applications software.
Specify the structure of a database.
all of the above

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

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

End Semester Examination
Final Exam component
Performance Analysis
Progressive Assessment

47. A database management system (DBMS) is a collection of programs that enables users to

create a database
manipulate a database
both create and manipulate a database
for storing data only

48. A................... is a collection of raw data files stored in the hard-drive

FILE SYSTEM
DATABASE
DBMS
none of the above

49. Data items grouped together for storage purposes are called a :

Record
title
list
string

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

True
False

DBMS MCQ Computer Science

About DBMS

DBMS MCQ

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

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

3. Collection of information stored in a database at a particular moment is

4. A DBMS makes it possible for users to:-

5. The term "Data independence" refers to____

6. The term "SQL" stands for

7. Which one of the following commands is used to restore the database to the last committed state?

8. For what purpose the DML is provided?

9. Which of the following commands is used to save any transaction permanently into the database?

10. Which one of the following refers to the total view of the database content?

11. Which one of the following command is used to delete the existing row in a table?

12. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

13. Which of the following is used in the application programs to request data from the database management system?

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

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

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

17. Which of the following refers to the number of attributes in a relation?

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

19. Data redundancy occurs

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

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

22. Which of the following is the most important feature of DBMS:

23. Which of the following statements contains an error?

24. Which of the following is NOT Advantages of DBMS

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

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

27. What is returned by SUBSTR(‘TUTORIALS POINT’, 1, 9)

28. This is an authorization command of SQL

29. Which of the following refers collection of the information stored in a database at a specific time?

30. The term "ODBC" stands for_____

31. Which of the following is not a DBMS despite having database capabilities:

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

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

34. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .(i.e the total number of utilized space by A,B)

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

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

37. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

38. SELECT * FROM employeeWhat type of statement is this?

39. Concurrent access by multiple users is not possible by using DBMS

40. CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this?

41. A view of database that appears to an application program is known as

42. Every Boyee-Codd normal form is in

43. Which command is used to remove all rows from a table ?

44. A DBMS query language is designed to

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

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

47. A database management system (DBMS) is a collection of programs that enables users to

48. A................... is a collection of raw data files stored in the hard-drive

49. Data items grouped together for storage purposes are called a :

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

Enjoyed the Quiz. Share this with friends

Comments

Add Your Review

Book Now & Get 50% Discount

Quick Contact to Help?

Related MCQ's

Transistors MCQ 70 Questions

Laravel MCQ 80 Questions

React JS MCQ 83 Questions

AngularJs MCQ 93 Questions

Node js MCQ 59 Questions

Subscribe to Newsletter!

Computer Science

Science

Commerce

Mathematics

Aptitude

General Knowledge

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

34. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has spaces and attribute B has spaces .(i.e the total number of utilized space by A,B)