data base management system

What software should we use to create a database?
Select the best answer.

• Excel
• Access
• OneNote
• Word

A ________ in a database is used to hold a single item of data, such as "pupilName".

• Table
• Record
• Cell
• Field

A row of fields in a database is known as:

• A column
• A cell reference
• A record
• A table

To search a database, we create a

• Sort
• Query
• Report
• Table

Which query could be used to find all pupils who are at least 13 years old in a pupil database?

• age >13
• age<13
• age>=13
• age<=13

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

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)

Answer explanation

The CREATE TABLE command is used to create a new table in SQL. The parameters in the parentheses define the columns of the table and their data types. The SELECT command is used to retrieve data from a database, not to create a table. The UPDATE command in SQL is used to modify the data in an existing database table, not to create a new table. The DROP TABLE command is used to completely remove a table from a database, not to create a new one.