NEW
Font size
S
M
L
XL
WorksheetsInformation storage
Total questions: 65
Worksheet time: 33mins
Name
Class
Date
1.
RDBMS stands for:
a)
Relational Data Business Management System
b)
Relational Database Management System
c)
Regional Database Management System
d)
Relational Data Base Main System
2.
Which of the following is not a DBMS example?
a)
Oracle
b)
MySQL
c)
MS Word
d)
SQL Server
3.
Which language is used to query the database?
a)
HTML
b)
SQL
c)
XML
d)
PHP
4.
A table in a relational database is also called a:
a)
Record
b)
File
c)
Relation
d)
Attribute
5.
The rows in a table are called:
a)
Fields
b)
Attributes
c)
Tuples
d)
Entities
6.
The columns in a table represent:
a)
Tuples
b)
Fields
c)
Attributes
d)
Records
7.
Which key uniquely identifies a record in a table?
a)
Foreign key
b)
Primary key
c)
Super key
d)
Candidate key
8.
SQL stands for:
a)
Structured Query Language
b)
Simple Query Language
c)
Sequential Query Logic
d)
Structured Question Language
9.
Which SQL command is used to retrieve data?
a)
SELECT
b)
INSERT
c)
UPDATE
d)
DELETE
10.
To remove all records but keep structure:
a)
DROP
b)
ERASE
c)
DELETE
d)
TRUNCATE
11.
Which operator is used to compare NULL values?
a)
=
b)
IS
c)
==
d)
LIKE
12.
Which clause is used to filter rows?
a)
WHERE
b)
ORDER BY
c)
GROUP BY
d)
HAVING
13.
What does DISTINCT do?
a)
Deletes duplicate rows
b)
Inserts unique values
c)
Returns only unique values
d)
Sorts results
14.
Which SQL command adds new rows?
a)
ADD
b)
INSERT
c)
UPDATE
d)
APPEND
15.
Which command modifies existing records?
a)
ALTER
b)
UPDATE
c)
MODIFY
d)
CHANGE
16.
What does DDL stand for?
a)
Data Definition Language
b)
Data Description Language
c)
Data Decision Language
d)
Database Description Language
17.
Which SQL command removes a table permanently?
a)
TRUNCATE
b)
ERASE
c)
DROP
d)
REMOVE
18.
Which symbol is used for pattern matching?
a)
$
b)
%
c)
*
d)
#
19.
What is a foreign key?
a)
Key that uniquely identifies records
b)
Key referencing another table’s primary key
c)
Temporary key
d)
Non-unique field
20.
Which of the following is a DCL command?
a)
GRANT
b)
SELECT
c)
UPDATE
d)
CREATE
21.
ER model represents data as:
a)
Tables
b)
Objects
c)
Entities and relationships
d)
Files
22.
Change structure of table:
a)
UPDATE
b)
MODIFY
c)
ALTER
d)
CHANGE
23.
Return total number of rows:
a)
COUNT()
b)
SUM()
c)
MAX()
d)
AVG()
24.
Arrange data in order:
a)
GROUP BY
b)
ORDER BY
c)
SORT BY
d)
ARRANGE BY
25.
NULL value means:
a)
0
b)
Empty string
c)
Unknown or missing value
d)
False
26.
Which clause groups rows with same values?
a)
ORDER BY
b)
GROUP BY
c)
HAVING
d)
DISTINCT
27.
Constraint ensures column not NULL:
a)
CHECK
b)
DEFAULT
c)
NOT NULL
d)
UNIQUE
28.
Primary and foreign key relationship is:
a)
Referencing Relationship
b)
Referential Integrity
c)
Entity Relationship
d)
Data Consistency
29.
Combine results from multiple tables:
a)
UNION
b)
INTERSECT
c)
JOIN
d)
LINK
30.
Retrieve salary between 5000 & 10000:
a)
WHERE salary > 5000 AND salary < 10000
b)
WHERE salary BETWEEN 5000 AND 10000
c)
WHERE salary RANGE 5000 TO 10000
d)
WHERE salary IN (5000,10000)
31.
JOIN returns all rows with match:
a)
INNER JOIN
b)
LEFT JOIN
c)
FULL JOIN
d)
RIGHT JOIN
32.
Function returns largest value:
a)
BIG()
b)
MAX()
c)
TOP()
d)
UPPER()
33.
Create table from existing table:
a)
CREATE TABLE AS SELECT
b)
COPY TABLE
c)
MAKE TABLE
d)
DUPLICATE TABLE
34.
COUNT(DISTINCT dept_id) gives:
a)
Total employees
b)
Total unique departments
c)
Total department heads
d)
NULL departments
35.
CHECK constraint does:
a)
Validates data condition
b)
Checks duplicates
c)
Checks syntax
d)
Defines primary key
36.
Normalization:
a)
Reduces redundancy
b)
Increases duplication
c)
Decreases integrity
d)
Removes primary keys
37.
ROUND(345.678,1):
a)
345.7
b)
345.6
c)
346
d)
345
38.
A view is:
a)
Virtual table
b)
Temporary table
c)
Permanent copy
d)
Snapshot
39.
Eliminate duplicates:
a)
UNIQUE
b)
DISTINCT
c)
DIFFERENT
d)
NODUP
40.
Revoke access rights:
a)
REMOVE
b)
REVOKE
c)
DELETE
d)
DROP
41.
Query with GROUP BY HAVING COUNT()>5:
a)
Departments with >5 employees
b)
Employees with >5 departments
c)
All departments
d)
Error
42.
Create foreign key constraint:
a)
FOREIGN KEY(emp_id)
b)
FOREIGN KEY(emp_id) REFERENCES employee(emp_id)
c)
KEY FOREIGN(emp_id)
d)
LINK FOREIGN emp_id
43.
Correlated subquery:
a)
Executes before main query
b)
Refers to outer query columns
c)
Independent subquery
d)
Joins multiple subqueries
44.
Ensures ACID properties:
a)
SQL Engine
b)
Transaction Management
c)
Schema Definition
d)
Normalization
45.
Cascade delete means:
a)
Deleting parent deletes child rows
b)
Prevents any deletion
c)
Deletes duplicates
d)
Manual delete only
46.
All-or-nothing transaction property:
a)
Consistency
b)
Durability
c)
Atomicity
d)
Isolation
47.
Nested query example:
a)
SELECT name FROM emp WHERE dept_id IN (SELECT dept_id FROM dept WHERE location='Chennai')
b)
SELECT * FROM emp
c)
SELECT dept_id FROM dept
d)
DELETE FROM emp
48.
Isolation level prevents dirty read:
a)
READ UNCOMMITTED
b)
READ COMMITTED
c)
REPEATABLE READ
d)
SERIALIZABLE
49.
Recursive queries use:
a)
SELF JOIN
b)
WITH RECURSIVE
c)
UNION ALL
d)
CONNECT BY PRIOR
50.
Customers with no orders:
a)
LEFT JOIN with WHERE NULL
b)
SELECT customer_id FROM Orders
c)
SELECT * FROM Customers WHERE EXISTS Orders
d)
None
51.
A transaction is:
a)
Collection of databases
b)
Logical unit of work
c)
Command to modify table
d)
Temporary store
52.
Property ensures all or nothing:
a)
Consistency
b)
Durability
c)
Isolation
d)
Atomicity
53.
ACID properties stand for:
a)
Atomicity, Consistency, Isolation, Durability
b)
Accuracy, Consistency, Independence, Durability
c)
Atomicity, Control, Isolation, Dependency
d)
Association, Consistency, Isolation, Data
54.
Simultaneous read/write issue causes:
a)
Deadlock
b)
Data inconsistency
c)
Concurrency control
d)
Serialization
55.
Read uncommitted data issue:
a)
Lost update
b)
Dirty read
c)
Non-repeatable read
d)
Phantom read
56.
Serializability ensures:
a)
Same result as serial execution
b)
Parallel execution only
c)
No locks used
d)
Rollback avoidance
57.
Non-serial but conflict-serializable schedule:
a)
Interleaved without conflict
b)
Parallel writes on same item
c)
All serial
d)
T2 starts after T1
58.
Cascadeless schedule:
a)
Prevents cascading rollback
b)
Allows rollback anytime
c)
Non-recoverable
d)
Always serial
59.
Two operations conflict if:
a)
Same transaction
b)
Different transactions on same data (one write)
c)
Both read
d)
Different data
60.
Two-Phase Locking protocol:
a)
Locks before unlocks
b)
Unlocks anytime
c)
No locks used
d)
Time stamping
61.
Deadlock occurs when:
a)
Two transactions wait for each other’s locks
b)
Transaction rollback
c)
Concurrent reads
d)
Serial execution
62.
Always serializable schedule:
a)
Cascadeless
b)
Conflict-serializable
c)
Serial
d)
Recoverable
63.
Two-Phase Locking phases:
a)
Growing and Shrinking
b)
Locking and Unlocking
c)
Read and Write
d)
Commit and Abort
64.
Isolation allows phantom reads but prevents dirty:
a)
READ UNCOMMITTED
b)
READ COMMITTED
c)
REPEATABLE READ
d)
SERIALIZABLE
65.
UNDO operation applies to:
a)
Committed
b)
Aborted
c)
Active
d)
Backup
Reset
