NEW
Font size
WorksheetsDBMS_Quiz_1
Total questions: 15
Worksheet time: 8mins
Which of the following is NOT a component of a DBMS?
Database Engine
Query Processor
Spreadsheet Manager
Transaction Manager
The three-tier architecture of DBMS consists of which layers?
User, Network, Database
External, Conceptual, Internal
Physical, Logical, Virtual
Application, Data, Network
What is Data Independence in DBMS?
The ability to access data from multiple databases
The ability to store data in multiple locations
The ability to change the schema at one level without changing the schema at the next higher level
The ability to perform transactions independently
Which of the following represents the overall design of the database?
Instance
Table
View
Schema
What is the main purpose of data modeling?
To visualize database structure before implementation
To improve network connectivity
To speed up computations
To provide cloud storage
In the E-R model, a weak entity is identified by which attribute?
Primary Key
Composite Key
Foreign Key
Partial Key
What is a foreign key in a relational model?
A key that uniquely identifies an entity
A key that refers to the primary key of another table
A key that is never null
A key used only in a single table
Which SQL category is used to define the structure of a database?
DML
DDL
DCL
TCL
Which of the following is a Data Definition Language (DDL) command?
SELECT
UPDATE
CREATE
INSERT
The SQL command used to delete all records from a table without removing its structure is:
DELETE
DROP
TRUNCATE
REMOVE
Which SQL constraint ensures that all values in a column are different?
CHECK
UNIQUE
NOT NULL
FOREIGN KEY
The SQL keyword used to filter records based on a specific condition is:
WHERE
ORDER BY
GROUP BY
HAVING
Which SQL query will create a table named "Students" with columns "ID" (integer, primary key) and "Name" (VARCHAR of 50 characters)?
CREATE TABLE Students (ID INT, Name VARCHAR(50));
CREATE Students (ID INT PRIMARY KEY, Name VARCHAR(50));
CREATE TABLE Students (ID INT PRIMARY KEY, Name VARCHAR(50));
MAKE TABLE Students (ID INT PRIMARY KEY, Name VARCHAR(50));
Which SQL query will remove a table from the database permanently?
DELETE TABLE Employees;
DROP Employees;
TRUNCATE TABLE Employees;
DROP TABLE Employees;
How do you filter results to show employees whose salary is greater than 50,000?
SELECT * FROM Employees WHERE Salary > 50000;
FILTER Employees WHERE Salary > 50000;
SHOW Employees WHERE Salary > 50000;
GET Employees WHERE Salary > 50000;
