wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

12C Btec Database

Total questions: 120

Worksheet time: 1hrs 20mins

Name
Class
Date
1.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
2.
The DBMS that most difficult to use is ________
a)
Microsofts SQL Server
b)
Oracle Corporation Oracle
c)
Microsoft Access
d)
IBM DB2
3.
Duplicate data often results in loss of data integrity because:
a)
A. Data formats may be inconsistent
b)
B. Data values may not agree
c)
Neither A & B
d)
Both A & B
4.
A database management system (DBMS) is a:
a)
Software system used to create, maintain, and provide controlled access to a database
b)
Hardware system used to create, maintain, and provide controlled access to a database
c)
Hardware system used to create, maintain, and provide uncontrolled access to a database
d)
Software system used to create, maintain, and provide uncontrolled access to a database
5.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
6.
Data administrator are responsible for ________
a)
Overall management of data resources in an organization
b)
Physical data design
c)
Managing technical issues in the database environment
d)
Writing application program
7.
Some advantages of the database approach include all, but:
a)
Minimal data redundancy
b)
Program-data dependency
c)
Improved data consistency
d)
Improved data sharing
8.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
9.
A_______ in a table represents a relationship among a set of values
a)
Field
b)
Foreign key
c)
Record
d)
Primary key
10.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
11.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
12.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
13.
Which one of the following should be taken as a primary key?
a)
Name
b)
DepartmentID
c)
Department
d)
Street
14.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
15.
A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
16.
Which of the following gives a logical structure of the database graphically?
a)
Entity--relationship diagram
b)
Entity diagram
c)
Database diagram
d)
Architectural representation
17.
The entity relationship set is represented in E-R diagram as
a)
Double diamonds
b)
Undivided rectangles
c)
Dashed lines
d)
Diamond
18.
The rectangles divided into two parts represents
a)
Entity set
b)
Relationship set
c)
Attributes of a relationship set
d)
Primary key
19.
If you were collecting and storing information about your music collection, an album would be considered a(n) _____.
a)
Relation
b)
Entity
c)
Instance
d)
Attribute
20.
The records of a table can be of ________ order.
a)
Any
b)
Same
c)
Sorted
d)
Constant
21.

Normalisation is:

a)

Removing all necessary data from a database

b)

Organising a database to remove repeated entries and increase the accuracy of the data

c)

Putting fields from different tables into one big database

22.

Which of the following statements fully describes data in 2NF:

a)

When any repeating fields have been removed and the table is given a primary key

b)

When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other

c)

When all the fields in each table are directly related to the primary key

23.

An advantage of normalisation is:

a)

The storage space needed for a normalised database is likely to be smaller

b)

The process of normalising a database is very easy and doesn’t require any skill

c)

It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry

24.

A disadvantage of normalisation is:

a)

The data loses its integrity as some of it is removed in the normalisation process

b)

The process of searching the database may be slower due to a higher demand on the central processing unit (CPU)

c)

Removing redundant data means that links cannot be created between tables

25.

What is an atomic field?

a)

A field that contains multiple items of data

b)

A field that is repeated

c)

A field that contains only one item of data

26.

What is a foreign key?

a)

A unique identifier in a database

b)

A primary key of one table that appears in another table

c)

A field that should not be in a table and needs removing

27.

A relation is in 1NF if it doesn't contain any ____________?

a)

Determinants

b)

Repeating groups

c)

Null values in primary key fields

d)

Functional dependencies

28.

A table is in 2NF if the table is in 1NF and what other condition is met?

a)

There are no functional dependencies.

b)

There are no null values in primary key fields.

c)

There are no repeating groups.

d)

There are no attributes that are not functionally dependent on the relation's primary key.

29.

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?

a)

Remove any functional dependencies from both relations

b)

Assign both relations the same primary key field(s)

c)

Create a primary key(s) for the new relation

30.

When designing a database you should ____.

a)

make sure entities are in normal form before table structures are created

b)

create table structures then normalize the database

c)

only normalize the database when performance problems occur

d)

consider more important issues such as performance before normalizing

31.

The normalization process involves assigning ____ to tables based on the concept of determination.

a)

data

b)

files

c)

attributes

d)

relations

32.

A ____ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.

a)

surrogate

b)

composite

c)

candidate

d)

foreign

33.

The ____ model views the data as part of a table or collection of tables in which all key values must be identified.

a)

relational

b)

object-oriented

c)

conceptual

d)

external

34.

Tables in ____ will perform suitably in business transactional databases.

a)

0NF

b)

1NF

c)

2NF

d)

3NF

35.

The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

a)

conversion from 1NF to 2NF

b)

conversion from 2NF to 3NF

c)

compromises that may include denormalization

d)

conversion from 3NF to 4NF

36.

Identification of the ____ will let you know where you are in the normalization process.

a)

normal form

b)

primary key

c)

attributes

d)

repeating groups

37.

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

a)

1NF

b)

2NF

c)

3NF

d)

4NF

38.

Row in a database table

a)

Record

b)

Field

c)

Query

d)

Form

39.

Database object that asks a table a question

a)

Record

b)

Field

c)

Query

d)

Form

40.

Database object that simplifies the process of entering, editing, and displaying data

a)

Record

b)

Field

c)

Query

d)

Form

41.

Column in a database table

a)

Record

b)

Field

c)

Query

d)

Form

42.

Kind of information a field contains

a)

Record

b)

Field

c)

Data Type

d)

Query

43.

Any list you make for a specific purpose can be considered a simple database, even a grocery list.

a)

True

b)

False

44.

By default, the Navigation Pane appears on the right side of the Access screen each time you create or open a database.

a)

True

b)

False

45.

Forms, queries, and reports are examples of database objects.

a)

True

b)

False

46.

In a database table, data is stored in rows and columns—similar in appearance to a spreadsheet.

a)

True

b)

False

47.

An important principle to consider when planning a database is to try to record each piece of information as many times as possible for easy access.

a)

True

b)

False

48.

The section of a report where the name of a grouped field is displayed and printed.

a)

Aggregate Field

b)

Group header

c)

Grouping levels

d)

Group footer

49.

The section of a report where the data in a group is summarized.

a)

Aggregate Field

b)

Group header

c)

Grouping levels

d)

Group footer

50.

A field by which data is grouped

a)

Aggregate Field

b)

Grouping field

c)

Grouping levels

d)

Group footer

51.

The nested arrangement of groups in a report.

a)

Aggregate Field

b)

Grouping field

c)

Grouping levels

d)

Group footer

52.

Group headers take on the name of the group.

a)

True

b)

False

53.

The arrows at the end of a Group On row determine sort order.

a)

True

b)

False

54.

Average is an aggregate function.

a)

True

b)

False

55.

You must preview a report before you can print.

a)

True

b)

False

56.

Labels can be printed using reports.

a)

True

b)

False

57.

Primary key from one table that is used in another table

a)

Composite Key

b)

Referential Integrity

c)

Filter

d)

Foreign Key

58.

Two or more primary keys in a table

a)

Composite Key

b)

Referential Integrity

c)

Filter

d)

Foreign Key

59.

Prevents orphan records, to ensure that records do not reference other records that no longer exist

a)

Composite Key

b)

Referential Integrity

c)

Filter

d)

Foreign Key

60.

Set of rules for determining which records will be displayed

a)

Composite Key

b)

Referential Integrity

c)

Filter

d)

Foreign Key

61.

Secondary sort field in a multifield sort

a)

Innermost field

b)

Referential Integrity

c)

Filter

d)

Foreign Key

62.

After you delete a record, you can click the Undo button to bring it back.

a)

True

b)

False

63.

The Find and Replace dialog box searches all the tables in a database at one time.

a)

True

b)

False

65.

The outermost field is the primary sort field in a multifield sort.

a)

True

b)

False

65.

The outermost field is the primary sort field in a multifield sort.

a)

True

b)

False

66.

The outermost field is the primary sort field in a multifield sort.

a)

True

b)

False

67.

In a one-to-many relationship, each record in the first table can have many records in the second table.

a)

True

b)

False

68.

Michelle used the property sheet to customize her form in Microsoft

Access. Which task can she complete?

a)

A. Change the background and add captions.

b)

B. Enter a new record.

c)

C. Move data.

d)

D. Switch from Design View to Print Preview.

69.

An assistant at Doggie Daycare was asked to update the patient

information for all new pets. What view is best to enter the new patient

information?

a)

A. Layout View

b)

B. Form View

c)

C. Design View

d)

D. Report View

70.

Michelle wants to change the color of her form to make it more attractive. Which should she use?

a)

A. Form

b)

B. Filter

c)

C. Controls

d)

D. Theme

71.

The owner of Ima Graphic Animator, Inc., a graphic design company,

wants to quickly create a new blank database object, one which includes

one record at a time and a more detailed view of the structure. Which

design should be used?

a)

A. Table Design

b)

B. Report Design

c)

C. Query Design

d)

D. Form Design

72.

Hank wants to add color to the header section of his form. Which

formatting option would he use?

a)

A. Fill Color

b)

B. Font Size

c)

C. Font Color

d)

D. Format Painter

73.

Michelle needs each National Technical Honor Society member to

complete an information sheet. Which tool would be best?

a)

A. Form

b)

B. Filter

c)

C. Controls

d)

D. Theme

74.

Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?

a)

A. Form View

b)

B. Layout View

c)

C. Design View

d)

D. Navigation Form

75.

Riley is using Microsoft Access to collect data for a science project. He is

creating a form and wants to apply predefined color and font scheme

formats. Which Form Layout Tools contextual tabs should he select for

the theme group?

a)

A. Design tab

b)

B. Format tab

c)

C. Arrange tab

d)

D. Page Setup tab

76.

Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?

a)

A. Blank Form

b)

B. Form Design

c)

C. Form Wizard

d)

D. Form Tool

77.

Kevin created a form to input FBLA membership data. He needs to

change the background color of the form so that it displays correctly on

mobile devices. Which option provides the tools Kevin will need to modify

the form?

a)

A. Blank Form

b)

B. Form Design

c)

C. Form Wizard

d)

D. Form Tool

78.

Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the fields to display and simplify the interface by adding labels and instructions. He would use a:

a)

A. form.

b)

B. table.

c)

C. report.

d)

D. query.

79.

Juan wants to view one record at a time in his database. Which view should he use?

a)

A. Design View

b)

B. Form View

c)

C. Layout View

d)

D. Navigation Pane

80.

Tyler is using Microsoft Access for a class assignment. Which database

object would she use to enter one record at a time?

a)

A. Table

b)

B. Form

c)

C. Macro

d)

D. Report

81.
Where do you see the results of a Query?
a)
Query Design View
b)
Query Datasheet View
c)
Query DataSet Review
d)
Table Design View
82.
If you want to put your data into alphabetical order by last name, you could use the __________ command.
a)
Shift
b)
Font
c)
autofill
d)
Sort
83.
To rename a table or other database object, first 
a)
save it.
b)
close it.
c)
edit it. 
d)
open it. 
84.
A complete list of field properties is available in 
a)
the Navigation Pane.
b)
Datasheet view.
c)
Design view. 
d)
all of the above. 
85.
Which field property requires users to enter data in a specific format such as a telephone number or social security?
a)
Validation Text
b)
Default Value
c)
Required
d)
Input Mask
86.
When you create a new blank database, Access opens a database that contains
a)
one of each type of database object.
b)
a table.
c)
sample data.
d)
a template.
87.
A unique identifier used in creating a table that assures there will be no duplicate data. 
a)
Primary Key
b)
Query
c)
Data Type
d)
Object
88.
.accdb means
a)
Abracadabra
b)
Access
c)
Amazing
d)
Animal
89.
A query is a cell in the database.
a)
True
b)
False
90.
What is design view?
a)
The function we use to set up a table in a database.
b)
The place where we type in all the information.
91.
What is the grid containing columns (fields) and rows (records) where you add, edit, and delete records in an Access database table.
a)
Design View
b)
Window View
c)
Ocean View
d)
Datasheet view
92.
Which of the following is NOT  data type?
a)
Date/Time
b)
Short Text
c)
Long Text
d)
Formula
93.
__________ are small squares that allow you to resize a photo or object
a)
Label Handles
b)
Combo Boxes
c)
Resizers
d)
Sizing Handles
94.
Which data type will be used if I am wanting to list a start date?
a)
Long Text
b)
Short Text
c)
AutoNumber
d)
Date/Time
95.
The tab shows a ____ is open.
a)
Table
b)
Query
c)
Form
d)
Report
96.
The ____ button filters records that equal or do not equal. 
a)
Comparative
b)
Selection
c)
Comparison
d)
Advanced
97.
Hospitals uses database
a)
TRUE
b)
false
98.
Which type of query has brackets in the question?
a)
Specific Criteria
b)
Wildcard Query
c)
Parameter Query
d)
Query using comparison operative operators
99.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
100.
Where do you configure the field properties of a Table?
a)
Design View
b)
Datasheet View
c)
Access View
d)
Window View
101.
Data type where the field can contain any character is "_____".
a)
text
b)
autonumber
c)
currency
d)
decimal
102.
What Automatically adds a unique number to the primary key field for each record in the table?
a)
AutoFit
b)
AutoNumber
c)
BestFit
d)
FitNow
103.
Which of the following is NOT a valid database object?
a)
Table
b)
Form
c)
Report
d)
File
104.
What database object is a series of rows and columns that organize data effectively?
a)
Table
b)
Query
c)
Form
d)
Report
105.
What is a database object that enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instructions?
a)
Table
b)
Form
c)
Report
d)
Query
106.
Columns in the table
a)
field columns
b)
fields
c)
columns
d)
none of the answers
107.
The wildcard character is a(n) _____ sign.
a)
&
b)
=
c)
#
d)
*
108.
This icon shows a____.
a)
Table
b)
Query
c)
Form
d)
Report
109.
The circled command_______
a)
Sorts records in descending order
b)
Sorts records in ascending order
c)
helps you select a single record or all records in a datasheet
d)
removes the current sort order
110.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record 
b)
Field 
c)
Text 
d)
Number
111.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
a)
Query
b)
Report
c)
Database 
d)
Spreadsheet
112.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
113.
In a database table, rows are called __________
a)
Field
b)
Record
c)
Primary Key
114.
Forms, queries, and reports are created based on the information in the _________
a)
Form
b)
Table
c)
Report
115.
In a database form, the blanks in which information is entered are called ________.
a)
Fields
b)
Record
c)
Query
d)
 Database
116.
When the blanks are filled in, the form becomes a _________.
a)
Fields
b)
Record
c)
Database
d)
Query 
117.
The sort feature is responsible for controlling the sequence, or order, of the records.
a)
True
b)
False
118.
A database and a table is the same thing.
a)
True
b)
False
119.
The _________ is used to identify each record in the table with a number.Correct answer: 
a)
Field
b)
Primary key
120.
Database forms are computerized versions of paper forms, such as a patient record, job application or a class registration form.
a)
True
b)
False

Similar Resources on Wayground

Claud additional 114 questions

116 questions

Claud additional 114 questions

quiz

Worksheet

•

11th Grade

KELAS 9 - SISTEM PENGKODEAN DAN PENGOLAHAN CITRA

115 questions

KELAS 9 - SISTEM PENGKODEAN DAN PENGOLAHAN CITRA

quiz

Worksheet

•

9th Grade

ON VAO 10 HOA SINH

119 questions

ON VAO 10 HOA SINH

quiz

Worksheet

•

9th Grade - University

PENGUATAN MATERI KELAS 7

125 questions

PENGUATAN MATERI KELAS 7

quiz

Worksheet

•

7th Grade - University

ISCC Pop Quiz

120 questions

ISCC Pop Quiz

quiz

Worksheet

•

University

Boolean Test

125 questions

Boolean Test

quiz

Worksheet

•

9th - 12th Grade

Airplanes/FMC Test

120 questions

Airplanes/FMC Test

quiz

Worksheet

•

9th - 12th Grade

ОББББББ

123 questions

ОББББББ

quiz

Worksheet

•

University