About DBMS

Following are some of the multiple choice questions on the DBMS with answers that will help the students in developing their knowledge.

DBMS MCQ

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

Enjoyed the Quiz. Share this with friends

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.