Aspirant Academy
ENHI

MCQ

Paper - II (x) — Database Management System MCQ - Practice Questions with Answers

Solve 56 Paper - II (x) — Database Management System questions for RAS/RPSC preparation.

Practice questions

Q1Which SQL command is used to add a new row into an existing table?

A SELECT
B INSERT
C REVOKE
D COMMIT
Explanation

INSERT is used to place a new record into a table. SELECT reads data, COMMIT finalizes transactional changes, and REVOKE belongs to access-control operations rather than row creation.

Q2In a relational database table, what does one row normally represent?

A One record or tuple of related attribute values
B The physical address of the database file
C A data type assigned to a column
D A query language keyword
Explanation

In the relational model, data is organized in tables. Each row represents one record or tuple, and columns represent attributes of that record.

Q3An application mainly needs fixed relationships, joins between tables, and strict referential integrity. Which database choice is generally most suitable?

A Object cache only
B Document database only
C Relational database management system
D Key-value store only
Explanation

The database choice should follow the workload. When the main needs are stable tabular structure, foreign-key relationships, joins, and constraint enforcement, an RDBMS is usually the most direct fit.

Q4Which statement correctly describes a primary key in a relational table?

A It is a column that must repeat the same value in every row
B It stores the physical address of each database file
C It uniquely identifies each row and does not allow null values
D It is used only for encrypting a table
Explanation

In an RDBMS, a primary key is chosen to identify each record uniquely. Because it must identify a real row, it cannot be null, and duplicate key values are not allowed in the table.

Q5What is the role of a foreign key in a relational database?

A It encrypts every value stored in a table
B It automatically deletes the whole database after a failed query
C It makes a table independent of all other tables
D It links a column in one table to a key value in another related table
Explanation

A foreign key is used to represent a relationship between two tables. For example, an Orders table may store CustomerID as a foreign key referring to CustomerID in the Customers table, so orders cannot point to non-existing customers when referential integrity is enforced.

You've seen 5 of 56 sample questions

Unlimited practice on Paper - II (x) — Database Management System comes with the RAS Test Series + Practice pack or Gate Pass.

More questions

6Which pair contains only SQL Data Manipulation Language commands?

AGRANT and REVOKE
BINSERT and UPDATE
CCREATE and ALTER
DCOMMIT and ROLLBACK

7In database design, an ER diagram is mainly used to represent which aspect?

AEntities, their attributes and relationships
BOnly the screen layout of data-entry forms
CThe exact keyboard shortcuts used in SQL software
DOnly the backup schedule of the server

8Which database design practice primarily reduces unnecessary duplication and update anomalies in relational tables?

ADisabling indexes
BIncreasing font size in reports
CEncrypting every column
DNormalization

9Which constraint is used to ensure that a value in a child table exists as a key value in a related parent table?

AFOREIGN KEY constraint
BNOT NULL constraint
CCHECK constraint
DDEFAULT constraint

10For a banking application that requires strict consistency, relational integrity, and well-defined transactions, which database choice is generally the best fit?

AA spreadsheet shared by email among users
BA text editor file with no validation rules
CA document store chosen only because schemas can vary
DAn RDBMS with transaction and constraint support

11In a database management system, which facility most directly reduces data redundancy compared with keeping the same data in separate files?

AStoring every user's screen view as a separate file
BCentralised control of shared data
CAllowing only one program to access the database
DRemoving all constraints from tables

12In the three-schema architecture of a database system, which level describes the overall logical structure of the whole database?

ADisplay level
BConceptual level
CPhysical level
DExternal level

13In a DBMS, which statement best describes the purpose of a database schema?

AIt is only the current set of rows stored in all tables.
BIt defines the logical structure of the database, such as tables, attributes, and relationships.
CIt is a backup copy created after every transaction.
DIt is the password file used by the database administrator.

14During database design, what is the main purpose of normalization?

ATo convert every table into an image file
BTo reduce redundancy and avoid update anomalies
CTo make every field accept duplicate and null values
DTo remove all relationships between tables

15Which option best describes the main purpose of a Database Management System (DBMS)?

ATo store, organize, retrieve, and manage data with controlled access
BTo convert every database table into a spreadsheet file
CTo replace all operating-system file handling
DTo execute only arithmetic calculations on numeric data

More topics in DBMS, SAD & IoT (Basic CI)

Paper - II (xi) — System Analysis and DesignPaper - II (xii) — Internet of things and its applicationDatabase

Explore other subjects

Current AffairsIndian EconomyReasoning & Mental AbilityScience & TechnologyIndian Constitution & GovernanceRajasthan History, Art & CultureEnvironment & EcologyGeography of Rajasthan