WorksheetsDatabaseBasic
Total questions: 17
Worksheet time: 8mins
Name
Class
Date
1.
What does RDBMS stand for?
a)
Relational Database Management System
b)
Reversible Database Management System
c)
Real-time Database Management System
d)
Random Database Management System
2.
What is a primary key in a database?
a)
A unique identifier for a record in a table
b)
A secondary key in a database
c)
A table that stores metadata
d)
A column with numeric values
3.
What is the purpose of an index in a database?
a)
To eradicate redundancy
b)
To store backup copies of data
c)
To establish relationships within tuple
d)
To enforce data constraints
4.
What is SQL?
a)
Structured Query Language
b)
Structured Query Logic
c)
Simple Query Language
d)
Systematic Query Language
5.
What is a table in a database?
a)
A collection of related data organized in rows and columns
b)
A function that performs a specific calculation on data
c)
A query that retrieves data from multiple tables
d)
A diagram that represents the structure of a database
6.
Which data type is used to store a whole number in SQL?
a)
INTEGER
b)
VARCHAR
c)
BOOLEAN
d)
FLOAT
7.
Which SQL data type is used to store textual data of variable length?
a)
VARCHAR
b)
INTEGER
c)
BOOLEAN
d)
DATE
8.
Which SQL statement is used to insert data into a table?
a)
INSERT INTO
b)
CREATE TABLE
c)
SELECT
d)
UPDATE
9.
Which SQL statement is used to create a new table?
a)
CREATE TABLE
b)
SELECT
c)
INSERT INTO
d)
UPDATE
10.
Which SQL data type is best for storing large amounts of text?
a)
TEXT
b)
VARCHAR
c)
BOOLEAN
d)
INTEGER
11.
Which SQL data type is best for storing a decimal number with a fixed precision and scale?
a)
DECIMAL
b)
INTEGER
c)
BOOLEAN
d)
VARCHAR
12.
Other word for Field name or Column is (a)
13.
Other word for Record
(a)
14.
Which one is not applicable for Primary Key?
a)
Quantity Number
b)
ISBN (International Standard Book Number)
c)
License Plate Number
d)
Reservation Number
15.
Which one is a varchar?
a)
Department
b)
Student ID
c)
Exchange Rate
d)
Year Publish
16.
Choose the three options that suitable for Integers.
a)
Age
b)
Zip Code
c)
Tax
d)
PageNumber
17.
Choose two answers that suits Primary Key.
a)
Discount Percentage
b)
Property Parcel Number (for real estate)
c)
Barcode (used in inventory management)
d)
Bank Account Balance
100 %
