TN Online TestSamacheer Kalvi practice

12th Standard Computer Applications — Introduction to Database Management System: Book Back MCQs with Answers & Explanations

Share this chapter: Telegram

Every Book Back multiple-choice question from Introduction to Database Management System (12th Standard Computer Applications, Samacheer Kalvi) — each with the correct option highlighted and a clear, worked explanation. Free to read in English and Tamil.

Answer key at a glance

Q1
Which language is used to request information from a Database?
  • A. Relational
  • B. Structural
  • C. QueryCorrect
  • D. Compiler
Explanation. Query languages are specifically designed to request, manipulate, and retrieve data from a database system.
Q2
The ---------- diagram gives a logical structure of the database graphically?
  • A. Entity-RelationshipCorrect
  • B. Entity
  • C. Architectural Representation
  • D. Database
Explanation. An Entity-Relationship (ER) diagram represents the logical and graphical structure of a database, showing entities and their relations.
Q3
An entity set that does not have enough attributes to form primary key is known as
  • A. Strong entity set
  • B. Weak entity setCorrect
  • C. Identity set
  • D. Owner set
Explanation. A weak entity set lacks a primary key of its own and depends on another strong entity set for its existence.
Q4
---------- Command is used to delete a database.
  • A. Delete database database_name
  • B. Delete database_name
  • C. drop database database_nameCorrect
  • D. drop database_name
Explanation. In SQL, the DROP DATABASE command is used to permanently delete an existing database and all its structures.
Q5
MySQL belongs to which category of DBMS?
  • A. Object Oriented
  • B. Hierarchical
  • C. RelationalCorrect
  • D. Network
Explanation. MySQL is a popular open-source relational database management system that stores data in tables of rows and columns.
Q6
MySQL is freely available and is open source.
  • A. TrueCorrect
  • B. False
  • C. Both A and B
  • D. None of the above
Explanation. MySQL is distributed under an open-source license, making it freely available for anyone to download, use, and modify.
Q7
---------- represents a 'tuple' in a relational database?
  • A. Table
  • B. RowCorrect
  • C. Column
  • D. Object
Explanation. In relational database terminology, a tuple represents a single horizontal row or record in a database table.
Q8
Communication is established with MySQL using
  • A. SQLCorrect
  • B. Network calls
  • C. Java
  • D. APIs
Explanation. MySQL databases use Structured Query Language (SQL) as the standard language to communicate, query, and manage data.
Q9
Which is the MySQL instance responsible for data processing?
  • A. MySQL Client
  • B. MySQL ServerCorrect
  • C. SQL
  • D. Server Daemon Program
Explanation. The MySQL Server instance is responsible for managing the database, processing client requests, and executing data operations.
Q10
The structure representing the organizational view of entire database is known as -------- in MySQL database.
  • A. SchemaCorrect
  • B. View
  • C. Instance
  • D. Table
Explanation. A schema is the overall structure or organizational view that defines how the entire database is designed and structured.
Take the Book Back practice test → Open the app

More for this chapter

Additional MCQs15 extra MCQs · solved Practice TestInteractive · instant score Book Back TestTest yourself on the textbook set Additional MCQ TestTest yourself on the extra set Study NotesConcepts & methods Formula SheetAll key formulas

About these Introduction to Database Management System questions

These are the Book Back multiple-choice questions for Introduction to Database Management System from the Tamil Nadu State Board (Samacheer Kalvi) 12th Standard Computer Applications syllabus. Each question shows the correct option and an original, step-by-step explanation so you understand the method, not just the answer. Use the answer key above to jump to any question, then take the practice test to check yourself under exam-like conditions.

Frequently asked questions

How many MCQs are there in Introduction to Database Management System?

This chapter has 10 book-back multiple-choice questions, each with the correct answer and a step-by-step explanation.

Are these 12th Standard Computer Applications MCQs free to practise online?

Yes. Every question, answer and explanation here is free, and you can also take them as a timed practice test.

Where can I find the Introduction to Database Management System book-back answers?

The correct option for each question is highlighted on this page with a worked explanation, plus a quick answer-key summary at the top.

More chapters in Computer Applications

View all
1 Multimedia 2 An Introduction to Adobe PageMaker 4 PHP: Hypertext Preprocessor 5 Functions and Arrays in PHP 6 Conditional Statements in PHP 7 Loops in PHP 8 Forms and Files 9 Connecting PHP and MYSQL 10 Introduction to Computer Networks 11 Network Examples and Protocols 12 Domain Name System (DNS) 13 Network Cabling 14 Open Source Concepts 15 E-Commerce 16 Electronic Payment Systems 17 E-Commerce Security Systems 18 Electronic Data Interchange- EDI