NEW
Font size
WorksheetsDBMSS UNIT 1 QUIZ
Total questions: 15
Worksheet time: 6mins
What is a Data Model?
A programming language
A hardware device
A way to describe database design
A network protocol
Who introduced the Relational Data Model?
Peter Chen
Edgar F. Codd
James Gosling
Charles Babbage
A column in a table is called?
Row
Tuple
Attribute
Record
The total number of attributes in a relation is called?
Cardinality
Degree
Domain
Key
Which identifies a tuple uniquely in a table?
Key
Attribute
Domain
Relation
In an ER diagram, a rectangle represents?
Attribute
Relationship
Entity
Key
Is SQL case-sensitive?
Yes
No
Which command is used to modify existing data?
INSERT
DELETE
UPDATE
DROP
Which command removes all rows but keeps the table structure?
DELETE
DROP
TRUNCATE
REMOVE
Which command is used to retrieve data from a table?
GET
FETCH
SELECT
SHOW
DDL stands for?
Data Delete Language
Data Definition Language
Data Design Language
Data Domain Language
What is a distributed database?
Stored on one computer
Stored across multiple sites
Stored only on mobile
Offline database
SQL is mainly used to?
Control hardware
Design networks
Manage databases
Create operating systems
What is data fragmentation?
Copying data
Dividing a table into smaller parts
Deleting data
Encrypting data
A foreign key is used to uniquely identify a record in the same table.
TRUE
FALSE
