Test 1 – IT 4153/6733

tealackingΤεχνίτη Νοημοσύνη και Ρομποτική

8 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

347 εμφανίσεις

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
only.


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


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


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
DBMS


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



CREATE TABLE tg7r5u99_p


(c1 INTEGER NOT NULL,



c2 CHAR(5) NOT NULL,



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
SQL


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

normal form


2
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”


24.

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
appli
cation design?


31. Describe how a relational database uses indexes.


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


33. Why is data modeling important for database development?


34.
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
them.













36. For the following table


normalize it to 3
rd

normal form:

(it starts with the 2 rows of
data)


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

___________________________________________________________________________



5678

Memory chip Fast Chips Cupertino 3.00


Quality Chips Austin 2.00



Smart Chips Phoenix 5.00

___________________________________________________________________________