Oracle - Data Modeling - Final Term Exam

Imagine preview
(8/10 din 1 vot)

Aceasta fituica rezuma Oracle - Data Modeling - Final Term Exam.
Mai jos poate fi vizualizat un extras din document (aprox. 2 pagini).

Arhiva contine 1 fisier doc de 183 de pagini .

Iti recomandam sa te uiti bine pe extras si pe imaginile oferite iar daca este ceea ce-ti trebuie pentru documentarea ta, o poti descarca. Ai nevoie de doar 5 puncte.

Domeniu: Limbaje de Programare

Extras din document

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

(1) Points

Table

Foreign Key

Constraint

Column (*)

Correct

6. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review

(1) Points

The database does not understand all capital letters

There is no problem here. You can create a table called 1_TABLE

Object names must not start with a number. They must begin with a letter (*)

TABLE is a reserved word

Correct

7. In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

Column

Primary Key or Unique Key (*)

Check Constraint or Unique Key

Foreign Key (*)

Correct

Fisiere in arhiva (1):

  • Oracle - Data Modeling - Final Term Exam.doc

Alte informatii

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