Database Concepts Practice Test — Class 12 Computer Science

12th Standard Computer Science — Database Concepts: Online Practice Test

Pick how many questions you want and set a time limit, then start. You'll get your score at the end with the correct answer and an explanation for every question. Free, in Tamil and English — 25 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

What is the acronym of DBMS?

A.DataBase Management Symbol B.Database Managing System C.DataBase Management System D.DataBasic Management System

A table is known as

A.tuple B.attribute C.relation D.entity

Which database model represents parent-child relationship?

A.Relational B.Network C.Hierarchical D.Object

Relational database model was first proposed by

A.E F Codd B.E E Codd C.E F Cadd D.E F Codder

What type of relationship does hierarchical model represents?

A.one-to-one B.one-to-many C.many-to-one D.many-to-many

Who is called Father of Relational Database from the following?

A.Chris Date B.Hugh Darween C.Edgar Frank Codd D.Edgar Frank Cadd

Which of the following is an RDBMS?

A.Dbase B.Foxpro C.Microsoft Access D.Microsoft Excel

What symbol is used for SELECT statement?

A.σ B.Π C.X D.Ω

A tuple is also known as

A.table B.row C.attribute D.field

Q10

Who developed ER model?

A.Chen B.EF Codd C.Chend D.Chand

Q11

Which of the following is the best description of "Information" as defined in database concepts?

A.It refers to raw facts stored in a computer that have no specific meaning on their own. B.It is processed, organized, and formatted data that can be utilized in a significant way. C.It is a software-based tool used to write instructions to access and manipulate tables. D.It is the physical hard disk and storage media used to store database records.

Q12

In a Relational Database Management System (RDBMS), what is the primary purpose of applying database normalization?

A.To increase data redundancy by duplicating records across multiple physical drives. B.To divide data into multiple tables in such a way that unnecessary repetition is minimized. C.To eliminate the need for using any query languages to fetch or retrieve records. D.To allow only a single user to access and write data at any given time.

Q13

Which component of a Database Management System (DBMS) is responsible for interpreting the database access languages into executable database commands?

A.Hardware B.Software C.Data D.Procedures

Q14

In the Hierarchical database model developed by IBM, which of the following rules defines the relationship between parent and child nodes?

A.A child can have many parents, and a parent can have only one child. B.A child can have only one parent, but a parent can have many children. C.Both parents and children can have an unlimited number of parent-child relationships. D.Children nodes are completely independent and cannot be linked to any parent node.

Q15

How does the Network database model differ from the Hierarchical database model?

A.In a network model, data is stored in flat files, whereas the hierarchical model uses tables. B.In a network model, a child record can have many parent nodes, representing many-to-many relationships. C.The network model does not support any relationship mappings between its entities. D.The network model restricts each parent node to having at most one child node.

Q16

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent attributes?

A.Rectangle B.Diamond C.Ellipse D.Triangle

Q17

In the Object database model, how are specialized objects like "Circle" or "Rectangle" related to a general object like "Shape"?

A.They are completely independent and cannot share any properties. B.They inherit attributes and behaviors from the "Shape" object. C.They are stored as flat text strings inside the "Shape" object. D.They act as parent nodes that control the "Shape" object in a tree hierarchy.

Q18

Which type of database user is primarily responsible for managing security, licenses, user accounts, and access permissions in a DBMS?

A.Application Programmer B.Database Administrator (DBA) C.End User D.Database Designer

Q19

If table A is linked to table B in a One-to-Many relationship, which of the following statements is true regarding their rows?

A.One row in table A can link to many rows in table B, and one row in table B can link to many rows in table A. B.One row in table A is linked to many rows in table B, but one row in table B is linked to only one row in table A. C.Every single row in table A must be identical to every corresponding row in table B. D.Rows in table A are completely prevented from linking to any rows in table B.

Q20

In Relational Algebra, what is the behavior of the PROJECT (\(_\Pi\)) operation on its output relation?

A.It selects a subset of rows from the table that satisfy a specific horizontal condition. B.It eliminates all attributes of the input relation except those specified in the projection list. C.It joins all rows of two distinct tables and keeps all duplicate records. D.It changes the data types of all selected columns to floating-point numbers.

Q21

When using the SELECT (\(_\sigma\)) operation in Relational Algebra, what does the subscript 'c' in \(_\sigma_c(R)\) represent?

A.The column index where the search begins. B.The selection condition applicable to the attributes of relation R. C.The count of duplicate tuples to be removed from the relation. D.The name of the database file that holds relation R.

Q22

In Relational Algebra, which set-theory operation requires that the two participating relations be union-compatible?

A.Cartesian Product B.Intersection C.Projection D.Selection

Q23

If relation A contains 4 tuples and relation B contains 3 tuples, how many tuples will be present in the resulting Cartesian Product (\(A \times B\))?

A.7 tuples B.1 tuple C.12 tuples D.64 tuples

Q24

What is the result of the Set Difference (\(A - B\)) operation in Relational Algebra?

A.A relation containing all tuples that are present in both A and B. B.A relation containing all tuples that are in A but not in B. C.A relation containing all tuples that are in B but not in A. D.A relation combining all attributes of A and B without any row filtering.

Q25

Which relational algebra operation is classified as a Unary Relational Operation?

A.Union (\(_\cup\)) B.Cartesian Product (\(X\)) C.Select (\(_\sigma\)) D.Intersection (\(_\cap\))

More for this chapter

About this Database Concepts test

This free online practice test covers Database Concepts from the 12th Standard Computer Science (Samacheer Kalvi) syllabus. Choose the number of questions and an optional time limit, then answer and submit — everything is checked in your browser, with the correct answers and a worked explanation shown at the end. For the full solutions to every question in this set, see the solved MCQs page.

More chapters in Computer Science

View all