NEW
Font size
WorksheetsSOF102 Topic 6
Total questions: 12
Worksheet time: 4mins
Which of the following best defines a database?
A collection of programs
A structured set of data files
A network of computer systems
A method to design software
Which of the following is the smallest unit of data in a database?
Record
File
Field
Bit
What does a record represent in a table?
A data file
A single attribute
A row of related fields
A column
Which of the following is NOT a relational database management system (RDBMS)?
Microsoft SQL Server
Oracle
MySQL
Linux
Which is used to uniquely identify each record in a table?
Foreign key
Index
Primary key
Attribute
A foreign key in a table:
Must contain unique values
Is not required
Links to a primary key in another table
Stores temporary data
In many-to-many relationships, a third table is used. This table is called:
Reference table
Join table
Master table
Bridge record
Which of the following is NOT a common data type in databases?
Character
Numeric
Logical
Format
Attribute domain refers to:
Column header format
Valid range of values for an attribute
Size of the database
Attribute number
What happens in a cascading delete operation?
Deletes all records
Deletes matching records in a related table
Updates data types
Deletes all columns
What does the SQL command SELECT * FROM Students do?
Deletes all students
Displays all student records
Adds a new student
Updates student names
Which SQL clause is used to filter records based on conditions?
WHERE
SELECT
ORDER BY
GROUP BY
