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