Database Concepts Additional Practice Test — Class 12 Computer Science

12th Standard Computer Science — Database Concepts: Additional 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 — 15 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

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.

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.

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

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.

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.

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

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

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.

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

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.

Q10

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.

Q11

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.

Q12

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

Q13

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

Q14

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.

Q15

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