WorksheetsYEAR 11 DP EXAM REVIEW
Total questions: 20
Worksheet time: 6mins
Name
Class
Date
1.
1. Special lookup table used to speed up data retrieval is called
a)
search key
b)
indexes
c)
log
d)
pointer
2.
2. A unique key used to identify each row on a table is referred to as
a)
A. Composite key
b)
B. Primary key
c)
C. Secondary key
d)
D. Compound key
3.
3. How many clustered indexes are allowed in a table?
a)
A. one
b)
B. two
c)
C. three
d)
D. four
4.
4. They are the rules enforced on the data columns of a table.
a)
A. Relational
b)
B. Megabyte
c)
C. Constraints
d)
D. Indexes
5.
5. Modifying the database structure is the role of
a)
A. DBA
b)
B. ABA
c)
C. ADA
d)
D. ABA
6.
6. To scramble data means to
a)
A. View data
b)
B. Encrypt data
c)
C. Password data
d)
D. Manipulate data
7.
7. The process of changing the encrypted data to its original form is called
a)
A. Decryption
b)
B. Encryption
c)
C. Encoding
d)
D. Decording
8.
8. Protecting database and the various applications that access it is a part of
a)
A. Database Administrator
b)
B. Database
c)
C. Validation
d)
D. Database security
9.
9. The copying and archiving of data to restore the original after a data loss event is
a)
A. Integrity control
b)
B. Backups
c)
C. Rollback
d)
D. Redo
10.
10. The secondary purpose of backups is to
a)
A. Delete data
b)
B. Copy data
c)
C. Recover data
d)
D. Edit data
11.
11. Which of these keys is generated automatically when the table is created?
a)
A. Primary index
b)
B. Sparse index
c)
C. Dense index
d)
D. Secondary index
12.
12. ____ is used to extract information in the database
a)
A. Forms
b)
B. Query
c)
C. Report
d)
D. Wizard
13.
13. The type of index that contains an index entry for only some records in the database table and not all is called
a)
A. Sparse Index
b)
B. Dense Index
c)
C. Primary Index
d)
D. Secondary Index
14.
14. The index that is stored at one place and table data is stored in another place is called
a)
A. Sparse Index
b)
B. Dense Index
c)
C. Clustered Index
d)
D. Non Clustered Index
15.
15. The collection of information that is organized so that it can easily be accessed, managed and updated is referred to as
a)
A. Data
b)
B. Information store
c)
C. Database
d)
D. Query
16.
16. Which of these is not a security risk to database?
a)
A. Unauthorized access
b)
B. Malware
c)
C. Performance constraints
d)
D. Database upgrade
17.
17. The process of identifying and analyzing potential hazards that may negatively impact a system is called
a)
A. Database Analysis
b)
B. Database Monitoring
c)
C. Risk Assessment
d)
D. Datafile Monitoring System
18.
18. Which of these is not a security control on data
a)
A. Password
b)
B. Encryption
c)
C. Pharming
d)
D. Auditing
19.
19. The E in ARIES stands for
a)
A. Encryption
b)
B. Exploiting
c)
C. Exhibition
d)
D. Enclosed
20.
20. How many principles of ARIES are there
a)
A. 3
b)
B. 4
c)
C. 2
d)
D. 5
100 %
