NEW
Font size
Worksheetsdata base management system
Total questions: 23
Worksheet time: 12mins
Select the best answer.
The four main objects of a database consist of:
form, table, query, report
filter, table, database, query
form, data type, record, query
form, record, field, report
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
You have been tasked to establish a new table named 'Employees' in your SQL database. The table needs to have columns for 'EmployeeID', 'FirstName', and 'LastName'. Which command would you use to establish this table through SQL?
Drop Table employees
select employee id , first name, last name from employees
update employee set employeeID= int, FIRST NAME = varchar(255) last name= varchar(255)
Create table employees (employee ID int, First Name varchar(255), Last Name varchar(255)
Which of these would be the data type used for the field "PostCode"?
This is an example of sorting in _______ order.
What BEST describes the purpose of a record in a database?
to alter data in a table
to remove data from a database
to store related data in various fields.
to view the structure of a table.
What is the purpose of a query in a database?
To connect to the database
to add new records to the database.
to format the data for reporting.
To specify criteria to match values in fields and select information of interest.
When it comes to databases, which one of the following BEST defines a report?
a formatted and organized presentation of data
a set of SQL commands executed in sequence
a group of related database tables
a specific type of database query.
Which SQL command is MOST suitable for removing existing data from an SQL database?
Update
delete
Insert
select
A computerized record keeping system is called as
Communication system
Database management System(DBMS)
Networking System
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
What you understand by data redundancy?
Assurance of the accuracy of data
Duplicate values in database
Security of Data
None of these
