Introduction to Database Management System Additional Practice Test

12th Standard Computer Applications — Introduction to Database Management System: 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 database model represents records in a tree-like structure with a parent-child relationship?

A.Relational model B.Network model C.Hierarchical database model D.Object-oriented model

In the ACID properties of a database, which property ensures that all updates in a transaction are completed successfully, or none of them are applied at all?

A.Atomicity B.Consistency C.Isolation D.Durability

Which administrative MySQL command must be executed after creating a new user account to update the privileges in the server without manual server rebooting?

A.RESET PRIVILEGES; B.FLUSH PRIVILEGES; C.RELOAD PRIVILEGES; D.UPDATE PRIVILEGES;

What is a candidate key that has not been selected as the primary key of a relation called?

A.Alternate key B.Composite key C.Foreign key D.Super key

In an Entity-Relationship (ER) model, which type of attribute is represented by a double ellipse?

A.Simple attribute B.Composite attribute C.Single valued attribute D.Multivalued attribute

Which of the following SQL commands is classified under Data Definition Language (DDL)?

A.INSERT B.UPDATE C.TRUNCATE D.DELETE

Under which category of SQL commands do COMMIT, ROLLBACK, and SAVEPOINT fall?

A.Data Definition Language (DDL) B.Data Control Language (DCL) C.Transaction Control Language (TCL) D.Data Manipulation Language (DML)

What is the SQL standard version referenced in the provided introduction to MySQL?

A.1986 B.1987 C.1999 D.2003

Which database model combines Object-Oriented Programming (OOP) concepts with database technologies and serves as the practical base of the relational model?

A.Hierarchical database model B.Object-oriented database model C.Network model D.Relational model

Q10

Which administrative desktop application tool is specifically designed for developers and DBAs to help with visualization, data modeling, server configuration, and backups?

A.phpMyAdmin B.HeidiSQL C.MySQL Workbench D.SQLite

Q11

What is the degree of a relationship that connects one entity type to itself in a loop?

A.Unary B.Binary C.Ternary D.N-ary

Q12

Which property of a foreign key allows it to represent a relationship, but differs from a primary key's default behavior?

A.It must always have unique values B.Its values do not usually have to be unique and can be null C.It cannot contain composite attributes D.It must never reference another table's primary key

Q13

Which of the following is a minimal super key with no redundant attributes?

A.Primary key B.Alternate key C.Candidate key D.Composite key

Q14

Which administrative command is used by a DBA to get a detailed report on the performance of a specific table in MySQL?

A.SHOW INDEX FROM tablename; B.SHOW COLUMNS FROM tablename; C.SHOW TABLE STATUS LIKE tablename\G D.SHOW TABLES;

Q15

Which database model is similar to the hierarchical model but allows each member to have more than one owner, handling many-to-many relationships better?

A.Network model B.Relational model C.Object-oriented model D.Flat model

More for this chapter

About this Introduction to Database Management System test

This free online practice test covers Introduction to Database Management System from the 12th Standard Computer Applications (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 Applications

View all