Database Design Section 6 Quiz Answers

Database Design Section 6 Quiz Answers

Selamat datang kembali di TeknoTips.NET. TeknoTips.NET adalah media online Indonesia yang diluncurkan pada bulan Maret 2015. Kami berkomitmen menyajikan konten seputar teknologi yang berkualitas dan bermanfaat. Ulasan kami terdiri dari berbagai topik: pemrograman komputer & database, review produk, tutorial windows, linux, android, kumpulan source code & project program, referensi tugas akhir & skripsi, download ebook, game & software.

Pada kesempatan ini kita akan mengulas artikel yang berjudul : Database Design Section 6 Quiz Answers.

Dibawah ini adalah semua soal dan jawaban kuis oracle ilearning - oracle academy, sebagai penambah ilmu pengetahuan untuk kita semua, yang pada intinya jangan lupa untuk dipahami.
Ilearning quiz answers section 6 database design english quizzes and exams & Database design and exams quiz answers

Lanjutan.... Database Design & Exams Section 7 Quiz Answers


Section 6 Quiz (Answer all questions in this section)

1. A candidate UID that is not chosen to be the Primary UID is called:
Composite
Secondary (*)
Simple
Artificial


2. Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.
Secondary
Simple
Candidate (*)
Composite


3. If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?
True (*)
False


4. There is no limit to how many columns can make up an entity's UID. True or False?
True (*)
False


5. An entity can have repeated values and still be in 1st Normal Form. True or False?
True
False (*)


6. When data is only stored in one place in a database, the database conforms to the rules of ___________.
Multiplication
Normality
Normalization (*)
Reduction


7. If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we
Do nothing, an entity does not have to be in 1st Normal Form
Make the attribute optional
Create an additional entity and relate it to the original entity with a 1:M relationship.
Create an additional entity and relate it to the original entity with a M:M relationship.


8. When all attributes are single-valued, the database model is said to conform to:
2nd Normal Form
4th Normal Form
1st Normal Form (*)
3rd Normal Form


9. When is an entity in 2nd Normal Form?
When all non-UID attributes are dependent upon the entire UID. (*)
When attributes with repeating or multi-values are present.
When no attritibutes are mutually independent and all are fully dependent on the primary ke
None of the Above.


10. To resolve a 2nd Normal Form violation, we:
Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
Do nothing, an entity does not need to be in 2nd Normal Form.
Move the attribute that violates 2nd Normal Form to a new ERD.
Delete the attribute that was causing the violation.
(Answer all questions in this section)


11. Any Non-UID attribute must be dependent upon the entire UID. True or False?
True (*)
False


12. A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.
True (*)
False


13. Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
    # CLIENT ID
    FIRST NAME
    LAST NAME
    ORDER ID
    STREET
    ZIP CODE

1st Normal Form. (*)
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised.


14. Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
ENTITY: TRAIN
ATTRIBUTES:
    TRAIN ID
    MAKE
    DRIVER ID
    DRIVER NAME
    DATE OF MANUFACTURE

TRAIN ID, MAKE
DRIVER ID, DRIVER NAME (*)
MAKE, DATE OF MANUFACTURE
None of the above, the entity is already in 3rd Normal Form.


15. When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:
Transitive dependency (*)
Non-dependency
Dependency
Functional dependency



Lanjutan... Database Design Section 7 Quiz



Tag : oracle academy quiz answers, database design section 6 quiz answers.
Untuk mendapat notifikasi setiap artikel terbaru, masukkan e-mail anda disini
Selanjutnya cek e-mail anda untuk verifikasi.

Silahkan tuliskan komentar relevan Anda dengan jelas dan sopan, sesuai dengan topik postingan tentang "" pada halaman dibawah ini.

0 Response to "Database Design Section 6 Quiz Answers"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2


Iklan Bawah Artikel