NEW
Font size
WorksheetsDatabase - Full Quiz
Total questions: 41
Worksheet time: 1hrs 22mins
What is this?
Record (row)
Field (Column)
The best data type to choose for date of birth would be
Currency
Date/Time
In a database, data is stored in
Tables
Sheets
What does SQL stand for?
Standard Query Language
Structured Query Language
Which of the following SQL is used to DELETE tables from a database ?
DELETE
REMOVE
DROP
Find cities with temperature less than 25.
How to Change “Mohammed” into “Mr.Mohammed”
in “LastName” column
in the Persons table?
Select all the records that ends with “a”?
add a record into the database?
Which word is missing?
Select * table_name
Where
From
______________ constraint prevents NULL values
FOREIGN KEY
NOT NULL
A primary key can be NULL.
TRUE
FALSE
SQL is not case sensitive.
TRUE
FALSE
The _________ statement is used to delete a table.
DROP TABLE
DELETE TABLE
to sorts rows
SORT BY
ORDER BY
Select all the columns from a table named "Persons"?
SELECT * FROM Persons
SELECT Persons
SELECT * Persons
SQL can be used to:
Create database
Get data from database
Modify data inside database
All of the above
The best data type to choose for product price would be
Decimal
Date/Time
Text
You can insert many rows at the same time using SQL.
TRUE
FALSE
You can find summation of degrees of student named "Mohamed" by using
What is this?
Relation
Entity
Primary keys must contain UNIQUE values, and cannot contain NULL values.
True
False
" Foreign Key " on UPDATE " CASCADE"
If data of parent table changed , the child table will be changed.
If data of parent table changed , the child table will not be changed.
DROP DATABASE database-name;
Remove Database
Archive Database
What is missing in the following code?
CREATE TABLE table-name;
Column name
Column name and data type
Database name
Length of TINYINT is less than SMALLINT
True
False
What is missing in the below code?
ALTER TABLE table-name
ADD
(column-name) ;
Constraint
Data Type
All data of spare parts made in Italy
All data of spare parts made in China
Both
The result of the following code :
SELECT MAX(product_price) FROM spare_parts ;
Most expensive
Cheapest product
phpMyAdmin is a database.
False
True
"Foreign Key" links tables together.
TRUE
FALSE
"XAMPP" is a database.
TRUE
FALSE
We can convert "Relational Schemas" into SQL .
FALSE
TRUE
CRUD in database means ?
Create, Read , Update , Delete
Cat , Rat, Unicorn, Dog
Tables can be exported in SQL format.
TRUE
FALSE
Database used in our course is:
Access
MySQL
B
A
;
data type
Table name
Field Name
No
Yes
Yes
No
What is missing?
Length of product_country
Data type of product_description
