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. Which of the following levels is considered as the level closed to the end-users?

  • Internal Level
  • External Level
  • Conceptual Level
  • Physical Level

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

  • Delete
  • Update
  • Insert
  • None of the above

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

  • CREATE
  • UPDATE
  • DELETE
  • ALL THE ABOVE

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

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 of the following refers collection of the information stored in a database at a specific time?

  • Independence
  • Instance of the database
  • Schema
  • Data domain

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

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

  • Save point
  • Rollback
  • Commit
  • Both A & B

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

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

  • Commit
  • Rollback
  • Save point
  • None of the above

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

  • Conceptual view
  • Physical view
  • Internal view
  • External view

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

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

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

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

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

INSERT INTO employee _____ (1002,'Joey',2000);
  • table
  • values
  • from
  • relation

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

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

20. Which of the following is NOT Advantages of DBMS

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

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

  • Add columns
  • Add constraints
  • Delete columns
  • Delete constrains
  • All the above

22. The term "ODBC" stands for_____

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

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

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

  • Microsoft Excel or similar spreadsheets
  • Oracle
  • MySQL
  • Microsoft Access or similar

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

  • Tuples
  • Attributes
  • Rows
  • Tables

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

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 employeeWhat type of statement is this?

  • integrity constraint
  • ddl
  • dml
  • view

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

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

  • TUTORIAL
  • POINT
  • TUTORIALS
  • UTORIALS

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

  • true
  • false

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

  • view
  • ddl
  • dml
  • tcl

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

  • Degree
  • Row
  • Column
  • All of the above

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

  • schema
  • subschema
  • virtual table
  • none of the above

35. Every Boyee-Codd normal form is in

  • 1NF
  • 2Nf
  • 3NF
  • all the above

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

  • Delete
  • Remove
  • Truncate
  • Both [A] and [B]

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

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

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

39. 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;

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

  • a) Data Manipulation language
  • b) Data Definition Language
  • c) Data Control Language
  • d) All of the above

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

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

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

  • Floating
  • Integer
  • Boolean
  • Date/Time

43. Which data type collect whole numbers?

  • Float
  • Integer
  • Text
  • Date/Time

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

  • Weight
  • Product Code
  • Name
  • Colour

45. What is an example of a paper database?

  • A map
  • Student folder in the office
  • Snapchat

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

  • table
  • field
  • row
  • column

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

  • Books
  • Authors
  • Date published
  • Employees

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

  • Table
  • Row
  • Column
  • Cell

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

  • Network model
  • ER model
  • Relational model
  • Hierarchical model

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

  • Flowchart
  • Table
  • Relational model
  • ER diagram

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.