Oracle - Data Modeling - Final Term Exam

Domeniu: Limbaje de Programare

Conține 1 fișier: doc

Pagini : 183 în total

Cuvinte : 22129

Mărime: 66.28KB (arhivat)

Publicat de: Valter Mirea

Puncte necesare: 5

Profesor îndrumător / Prezentat Profesorului: Ilinca Mavrianopol

Documentul contine toate raspunsurile posibile pentru intrebarile care apar in quiz-ul Data modeling - Final term exam (Oracle).

Descarcă acum

Cuprins Extras Bibliografie Preview

Extras din notiță

Acestea sunt toate intrebarile posibile care pot aparea in Data modeling - Final term exam.

Raspunsurile corecte sunt marcate cu (*).

Apasati tastele CTRL+F pentru a cauta in interiorul documentului cuvantul sau fraza dorita.

Section 12 Lesson 1

(Answer all questions in this section)

1. A table must have a primary key. True or False? Mark for Review

(1) Points

True

False (*)

Correct

2. The text below is an example of what constraint type: If the number of BOOKS lent to a BORROWER in the LIBRARY exceeds 5, then we must send him/her a letter requesting the return of the BOOKS, which will require extra programming to enforce. Mark for Review

(1) Points

Entity integrity

User-defined integrity (*)

Column integrity

Referential integrity

Correct

3. The explanation below is a User Defined integrity rule and must therefore be manually coded, the Database cannot enforce this rule automatically: A primary key must be unique, and no part of the primary key can be null. True or False? Mark for Review

(1) Points

True

False (*)

Correct

4. A foreign key can not refer to a primary key in the same table. True or False? Mark for Review

(1) Points

True

False (*)

Correct

Section 12 Lesson 2

(Answer all questions in this section)

5. In a physical data model, an attribute becomes a _____________. Mark for Review