stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
KS3 END OF UNIT DATABASE TEST by Mrs Emele Flashcards | StudBud
Explore
/
KS3 END OF UNIT DATABASE TEST by Mrs Emele
KS3 END OF UNIT DATABASE TEST by Mrs Emele
20 terms
·
StudBud Administration
·
36 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
What is structured data?
A unique identifier for a record in a table
Data that is not stored in a pre-defined format
A type of database
Data that is stored in a pre-defined format
2
What data type is assigned to the “Salary” column if this table was created in MS Access?
Char
Number
currency
Date
3
What is the output of this query?
Employee ID, Emp Name and DOB of girls celebrating their birthdays in July.
Employee Name of females celebrating their birthdays in July.
Employee ID, Employee Name and DOB of celebrating their birthdays in July.
Employee Name and DOB of females celebrating their birthdays in July.
4
Which of the following is TRUE about flat-file databases?
A flat-file database has only one table.
A flat-file database has many tables.
A flat-file database has 3 related tables
A flat-file database has many tables that are not related to each other
5
Choose the set of validation checks used in Microsoft Access?
Standard, Intermediate, Advanced
National, State, Local
Lenght Check, Presence Check, Format Check
Speaker, Video, Mute
6
What is a Query?
A query is a request for data results from your powerpoint
A query is a request for data results from your database
A query is a request for data results from your Excel
A query is a request for data results from your publisher
7
What is the column with the title “Date of joining” called?
Record
Base
Data
Field
8
How is a database structured?
It is stored in records
It is stored in fields
Data in a database is stored in the form of tables.
It is stored in columns
9
Which of these is an advantage of database?
Reduces updating errors
Too much errors.
Long check errors
Too many mistakes
10
What is a database?
it a Microsoft word
It is an Excel document
it is a powerpoint
A structured set of data stored electronically in a computer
11
What data type is assigned to the “Gender” column if this table was created in MS Access?
Text
Number
String
Char
12
What is the function of the "RUN BUTTON" in a database?
It stops the database from running
It makes database to run slow
It makes database to run faster
The “Run” button once clicked displays the results to the user.
13
Which of the following is a programming language that customises and interacts with databases?
Structured Query Language
None of the above
Microsoft Access
Microsoft Visual Basics
14
Use the table shown below to answer questions 6-9.. The highlighted row is called a ....
Field
Data
Column
Record
15
What data types are available in Microsoft Access?
Internet, Explorer, Browser, Woolot
Database, Excel, Word, Quiz
Google, Access, Excel, Publisher
Text, Currency, Date/Time, Number
16
1. Which of the following is a software that is used to create and manage databases?
Oracle
My SQL
Microsoft Access
All of the above
17
What is the allocated size for the field name "GENDER"
2
4
1
3
18
What is the primary function of a database?
To analyse data
To store backup
To store and organise information
To count points
19
Which of these is a disadvantage of database?
The disadvantage is non-existent
It has no disadvantage
Initial training required for all programmers and users.
No training required for all programmers and users.
20
How are presence checks implemented in MS Access?
Setting Input Mask fieldB.
Setting Required field
A.Setting Input Mask field value lD
Setting Default Value field
