Introduction to Database Management System Practice Test

12th Standard Computer Applications — Introduction to Database Management System: 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

Which language is used to request information from a Database?

A.Relational B.Structural C.Query D.Compiler

The ---------- diagram gives a logical structure of the database graphically?

A.Entity-Relationship B.Entity C.Architectural Representation D.Database

An entity set that does not have enough attributes to form primary key is known as

A.Strong entity set B.Weak entity set C.Identity set D.Owner set

---------- Command is used to delete a database.

A.Delete database database_name B.Delete database_name C.drop database database_name D.drop database_name

MySQL belongs to which category of DBMS?

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

MySQL is freely available and is open source.

A.True B.False C.Both A and B D.None of the above

---------- represents a 'tuple' in a relational database?

A.Table B.Row C.Column D.Object

Communication is established with MySQL using

A.SQL B.Network calls C.Java D.APIs

Which is the MySQL instance responsible for data processing?

A.MySQL Client B.MySQL Server C.SQL D.Server Daemon Program

Q10

The structure representing the organizational view of entire database is known as -------- in MySQL database.

A.Schema B.View C.Instance D.Table

Q11

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

Q12

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

Q13

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;

Q14

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

Q15

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

Q16

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

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

Q17

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)

Q18

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

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

Q19

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

Q20

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

Q21

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

Q22

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

Q23

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

Q24

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;

Q25

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