Database II - SS3 ICT Past Questions and Answers - page 1
What is a database?
A software used for graphic design
A structured collection of data
A type of computer hardware
A programming language
Which of the following is not a popular Database Management System (DBMS)?
MySQL
Java
PostgreSQL
Oracle
What does a database schema define?
The physical location of data
The data types of columns
The structure and organization of the database
The database administrator's contact information
Which SQL statement is used to retrieve data from a database?
INSERT
DELETE
SELECT
UPDATE
In a database table, what does a column represent?
A row of data
A data record
A field of data
An entire table
Which SQL operation is used to remove data from a database table?
CREATE
DELETE
ALTER
INSERT
What is the purpose of creating indexes in a database?
To improve data security
To speed up data retrieval
To delete records
To hide data from users
Which SQL statement is used to modify existing data in a database?
DELETE
INSERT
ALTER
UPDATE
What is the primary key in a database table?
A column with unique values that identifies each row
The first column in the table
A column with the most data
A column with no data
What does SQL stand for?
Simple Query Language
Structured Question Language
Structured Query Language
Systematic Query Logic