I. Chose The Beset Answer From The Given Alternative

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 5

Database Administration Level 4 theory Question

I. chose the beset answer from the given alternative


1. which one is not true about relational database management system
A. ability to process document for different purpose
B. collection of information organized in table
C. Table are constricted and associated to each other
D. A set of attribute comprise a record
2. While listing limitation of file processing system identify the wrong statement?
A. data redundancy &inconsistency available
B. difficult in accessing data
C. data isolation and integrity
D. concurrent access is possible
3. The language associated with a database management system that is employed by end users and
programmer to alter data in the database is the
A. data presentation language
B. Data manipulation language
C. Data transaction language
D. Data definition language
4. The problem resolved on the second normal form
A. Transitive dependency
B. Multi-valued attribute
C. Partial dependency
D. Repeating groups
5. Which of the following views listed bellow may assist with security policy implementation?
A. Restrict the table column to which user has access
B. Restrict the database to which a user has access
C. Store database audit result
D. Monitoring for database intruders
6. Which of the following is a FALSE statement about a transaction?
A. May be partially processed and committed
B. May not be partially processed and committed
C. Changes the database from one consistence state to another
D. Is sometimes called a unit of work
7. A set of data whose values make up un instance of each attribute defined for that relation
A. Tuple
B. Attribute
C. Table
D. Relation
8. Which of the following can be mapped to a database user?
A. Window account
B. Domain account
C. Window group
D. Login

Database Administration Set By : Endeshaw m. 1


Database Administration Level 4 theory Question

9. Which of the following defines mixed mode authentication?


A. Connection can be made using only widow account
B. Connection can be made using only SQL server login
C. Connection can be made using only database user
D. Connection to SQL server can be made with either windows account or with SQL server login
10. One of the statement bellow indicate the advantage a document review
A. Picture and diagram is not valuable tool for understanding system
B. Documents will always be up to date
C. documents will always reflect current practice
D. Documents often present overviews better than other techniques can
11. The machine must have loaded and running a complied java program?
A. Java compiler
B. Java virtual machine
C. Java byte code
D. A web browser
12. The requirement to bring database from an access into SQL server
A. Business intelligence development studio
B. copy database wizard
C. Import and export wizard
D. BCP
13. An open source DBMS product that run on UNIX Linux and windows
A. JD JSP/SQL
B. BC/SQL
C. MY SQL
D. Sun ACCESS
14. One of the following is NOT related to database performing
A. Partitioning of table
B. SQL tuning
C. Hardware optimizing
D. Taking backup
15. Which transaction property ensures changes are still present following a crash or system
feature?
A. Atomicity
B. Isolation
C. Consistency
D. Durability
16. A referential constant in a relational database
A. Must have primary key and foreign key columns that have identical name
B. Ensure that primary key does NOT have duplicate values in a table
C. Defines a many-to-many relationship between two tables
D. Ensure that a foreign key value always refers to an existing primary key value ………………

Database Administration Set By : Endeshaw m. 2


Database Administration Level 4 theory Question

17. One of the following statements is an example of a business rule


A. A referential constraint must refer to the primary key of the parent table
B. A database query that eliminate columns an employee should not see
C. Every order may belong to only one customer, but each costumer may have many orders
D. Every relation should have a primary key in RDBMS
18. Which of the following is NOT TRUE about SQL?
A. Modify a database structure
B. Unable to change system security
C. Add user permission on database or table
D. Query a database for information
19. Examples of logical change that can satisfy made in a system with a higher degree of logical data
Independence
A. Moving a database object from one physical file to another
B. deleting database object
C. Adding new database object
D. Deleting data item from existing database object
20. One of the reasons below show the importance of the user view
A. People querying the database references them
B. they provide physical data independency
C. They cannot be tailed to the need of the database user
D. data update are shown in a delayed fashion
21. Which of the following is NOT true about strategic plan?
A. Apply to the entire organization
B. implemented within two year
C. Establish the organization overall goals
D. Seek to position the organization in term of its environment

Database Administration Set By : Endeshaw m. 3


Database Administration Level 4 theory Question

II. Match column “A” with column “B”

Column A Column B
_____1. Which is used to represent the data model graphically with A. Reverse zone
entity attribute And relationship B. Entity relationship
_____2. Firewall profile identified by network administrator diagram
_____3. Resolve host name to ip address during DNS server C. File server resource
configuration manager
_____4. One piece of information about an object or entity D. Encryption
_____5. Possible types of data to store salary filed E. Data element
_____6. Enables sharing file using DFS name space and replicating file F. Questionnaire
between DFS server G. Currency
_____7.install tools for generating storage reports configuring quotas H. Distributed file
and Defining file screen policy system
_____8. Indexes file for fast searching when client connect to shared I. Filed
folders J. Forward zone
_____9. The translation of data into a secret code K. Home or private
_____10. A networking device that convert one cabling technology to network
Another L. attribute
_____11. The lowest unit of meaning full information in a file or M. Print server resource
document May consist of numbers, letters or a combination of manager
both N. Window search
_____12. Place where list of problem that occurred on a system are service
found O. Transceivers
_____13. A method of collecting information or determining P. Event-viewer
requirements Q. Query
_____14. A term used in information retrieval pertaining to particular R. Record
request For the database
_____15. A complete set of information about one thing in a table

Database Administration Set By : Endeshaw m. 4


Database Administration Level 4 theory Question

Answer sheet
I. Chose Item II. Matching Item
1. A 1. B
2. C 2. K
3. B 3. J
4. C 4. I
5. B 5. G
6. B 6. H
7. A 7. C
8. D 8. N
9. D 9. D
10. D 10. O
11. A 11. E
12. C 12. P
13. A 13. F
14. D 14. Q
15. D 15. R
16. D
17. A
18. B
19. A
20. A……
21. D……

Database Administration Set By : Endeshaw m. 5

You might also like