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

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.