NEW
Font size
WorksheetsDATABASE AND SQL
Total questions: 10
Worksheet time: 3mins
is a collection of related data entries and it consists of columns and rows.
Table
Database
RDBMS
SQL
The data in__________ Is stored in database objects called tables.
Database
RDBMS
Tables
SQL
It is a vertical entity in a table that contains all information associated with a specific field in a table.
table
row
column
SQL
statement is used to select data from a database.
DELETE
INSERT
UPDATE
SELECT
The__________ statement is used to insert new records in a table.
SELECT
UPDATE
INSERT INTO
DROP
used to modify the existing records in a table.
INSERT INTO
SELECT
DROP
UPDATE
The _________statement is used to omit existing records in a table.
SELECT
UPDATE
INSERT INTO
DELETE
It is the most popular database system used with PHP.
MySQL
PHPADMIN
SQL
RDBMS
It is a free, open-source web-based tool for managing MySQL and MariaDB databases.
phpMyAdmin
SQL
MySQL
RDBMS
To delete the table completely, use the ____________statement
DROP TABLE
DELETE TABLE
UPDATE TABLE
INSERT TABLE
