NEW
Font size
WorksheetsDBMS Quiz
Total questions: 50
Worksheet time: 38mins
DBMS stands for:
Database Managing Software
Database Management System
Data Managing Structure
Data Base Manipulation System
Which of the following is NOT a DBMS example?
MySQL
Oracle
MS SQL Server
HTML
In traditional file processing systems, data redundancy means:
Same data stored multiple times
No duplicate data
Only unique values stored
Data always compressed
Which is NOT an advantage of DBMS?
Data security
Data redundancy
Backup and recovery
Multiple user access
Which of the following is NOT an application of DBMS?
Payroll system
E-commerce websites
Social media
Word processors
Which advantage of DBMS ensures transactions are executed fully or not at all?
Atomicity
Consistency
Redundancy
Integrity
Which DBMS advantage avoids data duplication?
Data security
Data isolation
Reduce redundancy
Backup and recovery
Which application of DBMS is related to Netflix?
Banking
Online television streaming
Payroll
Hospital management
Restricting unauthorized access to data is an example of:
Atomicity
Security
Recovery
Data isolation
Which feature of DBMS allows more than one user to access data simultaneously?
Multi-user support
Integrity constraints
Atomicity
Schema
Which abstraction level shows how data is physically stored?
Logical level
View level
Physical level
Conceptual level
Logical level describes:
How data is stored physically
What data is stored and relationships
User-specific views
Data compression
External level is also called:
Physical level
View level
Conceptual level
Schema level
Ability to change physical schema without affecting logical schema is:
Logical data independence
Physical data independence
Data abstraction
Data isolation
Adding a new attribute without changing application programs is:
Physical independence
Logical independence
Data redundancy
Data inconsistency
Naive users:
Write SQL queries directly
Use ready-made applications
Design databases
Maintain security
DBA is responsible for all EXCEPT:
Schema definition
Performance monitoring
Playing games
Backup and recovery
Which user type uses SQL tools directly?
Naive user
Sophisticated user
Application programmer
End user
Granting authorization for data access is done by:
Application programmer
DBA
End user
Query processor
Assisting application programmers is a role of:
Sophisticated user
DBA
Data dictionary
Buffer manager
Which is NOT a mapping cardinality?
One-to-One
One-to-Many
Many-to-Many
One-to-None
A weak entity is identified by:
Its own primary key
A foreign key and partial key
Only a foreign key
Composite attribute
Primary key:
Allows NULL values
Uniquely identifies a record
Can have duplicates
Is optional in a table
NOT NULL constraint ensures:
No duplicate values
No null values
Always indexed
Always a key
Foreign key maintains:
Redundancy
Referential integrity
Data compression
Physical independence
Network model organizes data as:
Tables
Nodes and edges
Objects
Hierarchies
Object-oriented model organizes data as:
Graph nodes
Tables
Objects with attributes and methods
Keys and constraints
Relational model stores data in:
Graphs
Tables
Trees
Blocks
Which model uses pointers for relationships?
Network model
Object-oriented model
Relational model
Physical model
ER diagrams mainly show:
Physical storage
Entities and relationships
SQL syntax
File paths
SQL command to create a table:
INSERT
CREATE
UPDATE
SELECT
To find average age:
SUM()
AVG()
COUNT()
MAX()
Retrieve students with branchcode 5:
SELECT * FROM T1 WHERE branchcode=5;
SELECT branchcode=5 FROM T1;
SELECT T1.branchcode=5;
DISPLAY branchcode=5;
Change student age to 20 where rollno=1:
UPDATE T1 SET age=20 WHERE rollno=1;
MODIFY T1 age=20 rollno=1;
CHANGE age=20 FROM T1;
ALTER T1 age=20;
Delete students of age 18:
REMOVE FROM T1 WHERE age=18;
DELETE * FROM T1 WHERE age=18;
DELETE FROM T1 WHERE age=18;
DROP FROM T1 WHERE age=18;
Add a new branch:
INSERT INTO T2 VALUES (...);
ADD INTO T2 VALUES (...);
CREATE INTO T2 VALUES (...);
UPDATE T2 VALUES (...);
Retrieve branch info in descending order:
SELECT * FROM T2 ORDER BY branchname DESC;
SELECT DESC branchname FROM T2;
SELECT branchname DOWN FROM T2;
ORDER branchname FROM T2;
GRANT command is used to:
Withdraw privileges
Give access rights
Delete a table
Create a table
REVOKE command is used to:
Give privileges
Withdraw privileges
Commit changes
Rollback changes
COMMIT command:
Saves changes permanently
Undoes changes
Gives access
Deletes rows
COUNT() function returns:
Sum of values
Average value
Number of rows
Minimum value
SUM() function is used to:
Count rows
Calculate total
Find maximum
Average values
MAX() returns:
Highest value
Lowest value
Sum of values
Count of values
MIN() returns:
Highest value
Lowest value
Sum of values
Count of values
AVG() returns:
Count of rows
Average value
Minimum value
Maximum value
Schema is:
A snapshot of database
Overall design of database
A row in database
A column in database
Instance is:
Permanent structure of database
Collection of data at a specific time
A SQL query
A storage device
DDL statements are:
Auto-committed
Rollback-able
Temporary
Not stored
DML statements are:
Auto-committed
Rollback-able
Only read data
Only delete data
The data dictionary stores:
User data
Metadata
Indexes only
Queries only
