Test 1 – IT 4153/6733

tealackingIA et Robotique

8 nov. 2013 (il y a 7 années et 10 mois)

753 vue(s)

Test 1

IT 4153/6733

Name __________________________________________________

Questions 1
24 and 35 & 36 are for ALL Students (be sure you go to 35
& 36 at the bottom), and questions 25
34 are for Graduate students

1. What are the primary high
evel job responsibilities of a DBA

2. What is the difference between a data administrator and a database

3. How does new technology impact the job of the DBA

4. What are the three types of integrity that DBAs must understand

5. Why sh
ould database standards be implemented (also list risks if they’re
not implemented)

6. What is the difference between a version and a release of a DBMS

7. Name five requirements that must be planned for when installing a new

8. What is wrong wit
h the following SQL statement pertaining to database
naming standards

CREATE TABLE tg7r5u99_p



c9 DATE);

9. What is the only reason to denormalize a database table

10. Which types of data access wil
l benefit from data clustering

11. When should you consider physically storing derived data in a database

12. If indexes are beneficial to performance, why not create every possible
index conceivable just to be on the safe side

13. Describe what the a
cronym ACID means and define each component

14. Why is locking required to assure data integrity

15. List and define the types of locking and the degree of locking that we
can do (areas we can lock)

16. What is the difference between a lock timeout a
nd a deadlock

17. Name the roles required for each design review

18. Why is it important to review application code in addition to reviewing

19. During which type of design review should the design be checked for
conformance to 3

normal form

0. Why should the DBA lead most of the design reviews

21. Why is it difficult to add a column between two existing columns in an
existing table

22. What is the impact of dropping a database

23. Explain what is meant by the term “cascading DROP”


If you have to drop an entire table to effect a database change, what
other database structures will also be dropped automatically by the DBMS

Questions for Graduate Students ONLY

25. Name the three types of database comparisons that may be required
in a
changing database environment.

26. Why would a DBA want to have the capability to compare one database
structure to another quickly and simply?

27. What output is required of every design review?

28. Cite several reasons for including representa
tives from application
development management in design reviews.

29. Under what circumstances should a transaction processing system be
considered for database applications?

30. What does “relational closure” mean, and what is its significance on
cation design?

31. Describe how a relational database uses indexes.

32. Every attribute will do one of three things. Name these and describe

33. Why is data modeling important for database development?

What are the potential risks of upg
rading to a new DBMS release
without a plan?

35. Here are four entitities:

Student (StudentID, LastName,FirstName,MiddleInit,MajorID)

Major (MajorID, Major)

Enrollment (StudentID,CourseNum,CourseCompDate)

Course (CourseNum,CourseName,Credits)

Draw the
E/R Diagram for these four, and then write the SQL DDL statements to create

36. For the following table

normalize it to 3

normal form:

(it starts with the 2 rows of

Part/Vendor Table


Part Num Description Vendor_Name Vendor_City Unit_Cost


1234 Logic chip Fast Chi
ps Cupertino 10.00

Smart Chips Phoenix 8.00



Memory chip Fast Chips Cupertino 3.00

Quality Chips Austin 2.00

Smart Chips Phoenix 5.00