Which Of The Following Scenarios Should Be Modeled So That Historical Data Is Kept? (Choose Two)

Dibawah ini adalah semuasoal dan jawaban kuis oracle ilearning -oracle academy, sebagai penambah ilmu pengetahuan untuk kita semua, yang pada intinya jangan lupa untuk dipahami.

Database design and exams section 9 quiz answers & ilearning quiz answers for database design english quizzes and exams

Lanjutan.... Database Programming Department i Quiz Answers

1. An entity tin can only take 1 Primary UID. True or False?
Truthful (*)
False

2.            If an entity has no attribute suitable to be a Principal UID, we can create an bogus 1. Truthful or Fake?
                Truthful (*)
                Simulated

3.            At that place is no limit to how many columns can make upward an entity'southward UID. True or Fake?
                True (*)
                False

iv.            A unique identifier tin can only be fabricated upwardly of one aspect. True or False?
                True
                False (*)

5.            When is an entity in 2nd Normal Form?
                When all non-UID attributes are dependent upon the unabridged UID. (*)
                When attributes with repeating or multi-values are present.
                When no attritibutes are mutually contained and all are fully dependent on the main key.
                None of the Above.

6.            What is the rule of 2nd Normal Course?
                No non-UID attributes can be dependent on whatever office of the UID.
                Some non-UID attributes can be dependent on the entire UID.
                All non-UID attributes must be dependent upon the entire UID. (*)
                None of the above

7.            Examine the post-obit entity and decide how to brand it conform to the dominion of 2nd Normal Course:
ENTITY: RECEIPT
ATTRIBUTES:
   #CUSTOMER ID
   #Store ID
   Shop LOCATION
   Engagement
                Do nothing, information technology is already in 2nd Normal Form.
                Delete the attribute STORE ID
                Move the attribute STORE LOCATION to a new entity, STORE, with a UID of Shop ID, and create a relationship to the original entity. (*)
                Motility the attribute STORE LOCATION to a new entity, STORE, with a UID of Store LOCATION, and create a human relationship to the original entity.

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

9.            Examine the post-obit Entity and make up one's mind which dominion of Normal Form is being violated:
ENTITY: Client
ATTRIBUTES:
    # CLIENT ID
    First Proper name
    Final Proper name
    ORDER ID
    STREET
    Zippo Code
                1st Normal Class. (*)
                2nd Normal Form.
                3rd Normal Form.
                None of the above, the entity is fully normalised.

10.         As a database designer, you do not need to worry about where in the datamodel yous store a particular attribute; as long as you lot get it onto the ERD, your chore is done. True or Faux?       Mark for Review
(1) Points
                True
                False (*)

11.         Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
    # Customer ID
    Start NAME
    LAST Proper noun
    STREET
    Urban center
    Zip Lawmaking
                1st Normal Class.
                2nd Normal Form.
                third Normal Grade.
                None of the above, the entity is fully normalised. (*)

12.         When data is stored in more than 1 place in a database, the database violates the rules of ___________.
                Normalcy
                Replication
                Normalization (*)
                Decency

13.         If an entity has a multi-valued attribute, to accommodate to the rule of 1st Normal Form we:
                Brand the attribute optional
                Do nothing, an entity does non take to be in 1st Normal Form
                Create an additional entity and relate it to the original entity with a one:1000 human relationship. (*)
                Create an additional entity and relate it to the original entity with a Yard:M relationship.

xiv.         An entity ORDER has the attributes Guild ID, Lodge Appointment, Product id, Client ID. This entity is in 1st Normal Form. True or Faux?
                True
                Fake (*)

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

16.         Cascading UIDs are a feature oft found in what type of Human relationship?
                Invalid Relationship
                General Relationship
                Heirarchical Relationship (*)
                Recursive Relationship

17.         A relationship between an entity and itself is called a/an:
                General Relationship
                Recursive Relationship (*)
                Heirarchical Relationship
                Invalid Relationship

18.         A unmarried human relationship tin be both Recursive and Hierarchical at the same fourth dimension. Truthful or False?
                Truthful
                Imitation (*)

nineteen.         A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. Truthful or False?
                Truthful (*)
                Faux

20.         A particular trouble may be solved using either a Recursive Human relationship or a Hierarchical Human relationship, though non at the same time. True or False?
                True (*)
                False

21.         Which of the following would best exist represented by an arc?
                STUDENT (Grade A educatee, Boilerplate Student)
                PARENT (Daughter, Bob)
                Teacher (Female, Bob)
                Commitment ADDRESS (Dwelling, Role) (*)

22.         Arcs are used to visually correspond _________ between two or more relationships in an ERD.
                Sameness
                Differences
                Exclusivity (*)
                Inheritance

23.         An arc can often be modeled as Supertype and Subtypes. Truthful or False?
                True (*)
                False

24.         Which of the following would all-time exist represented by an arc?
                STUDENT (Grade A student, Boilerplate Student)
                STUDENT (senior, male)
                STUDENT ( Academy, Technical College) (*)
                STUDENT (graduating, female person)

25.         Which of the following would exist a logical constraint when modeling time for a country entity?
                Daily traffic patterns must be monitored to make up one's mind which countries are overcrowded.
                People have births and deaths in their countries that must exist tracked by the system.
                If you are doing a organization for France or Deutschland, you would need security clearance.
                Countries may modify their names and/or borders over a period of fourth dimension. (*)

26.         Which of the following would be a logical constraint when modeling time for a City entity?
                Daily traffic patterns must exist monitored to determine how many law enforcement officers are needed.
                If you are doing a system for any French City, you would need security clearance.
                Cites may change their names and/or land association if the borders of a state change. (*)
                People are born in the metropolis and people dice in the city.

27.         All systems must include functionality to provide logging or journaling in conceptual information models. True or False?
                True
                False (*)

28.         When a system requires that old values for attributes are kept on tape, this is know as Journaling or Logging. True or False?
                True (*)
                False

29.         In that location is no betoken in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste product of time. True or False?
                Truthful
                False (*)

30.         Formal rules exist for drawing ERD's. You must ever follow them, even if information technology results in an ERD that is difficult to read. True or Faux?
                True
                False (*)

31.         Which of the post-obit scenarios should exist modeled so that historical information is kept? (Choose two)
(Choose all right answers)
                LIBRARY and NUMBER OF BOOKS
                Student and GRADE (*)
                STUDENT and Historic period
                LIBRARY and BOOK (*)

32.         Historical data must never be kept. Truthful or Imitation?
                True
                Imitation (*)

33.         The explanation below is an example of which constraint type?
A main central must be unique, and no part of the primary key can be null.
                Referential integrity
                Cavalcade integrity
                Entity integrity (*)
                User-defined integrity

34.         Foreign keys cannot be zilch when
                It refers to the aforementioned table
                Information technology is part of a chief key (*)
                It refers to another table
                It contains three or more columns

35.         The caption below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS tabular array is beneath 100, we must send a letter to the account owner which will crave extra programming to enforce.
                User-defined integrity (*)
                Entity integrity
                Column integrity
                Referential integrity

36.         A foreign primal cannot refer to a primary key in the same table. Truthful or Simulated?
                Truthful
                False (*)

37.         Column integrity refers to
                Columns always containing text data less than 255 characters
                Columns always containing values consistent with the defined data format (*)
                Columns ever having values
                Columns always containing positive numbers

38.         When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Central. Truthful or Faux?
                True
                False (*)

39.         One-to-Many Optional to Mandatory becomes a _______________ on the Chief tabular array.
                Unique Primal
                Optional Strange Key (*)
                Mandatory Foreign Key
                Primary Key

twoscore.         A barrred Human relationship will result in a Foreign Fundamental column that also is office of:
                The Column Proper noun
                The Check Constraint
                The Table Name
                The Primary Cardinal (*)

41.         Relationships on an ERD tin can just be transformed into UIDs in the physical model? True or Fake?
                True
                False (*)

42.         One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?
                Truthful
                False (*)

43.         The "Arc Implementation" is a synonym for what type of implementation?
                Cascade Implementation
                Supertype Implementation
                Subtype Implementation
                Supertype and Subtype Implementation (*)

44.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented every bit strange keys, merely the foreign key columns all become optional. True or False?
                Truthful (*)
                Faux

45.         The transformation from an ER diagram to a physical pattern involves changing terminology. Entities in the ER diagram become __________ :
                Columns
                Tables (*)
                Foreign Keys
                Unique Keys

46.         The conceptual model is transformed into a physical model. The physical implementation volition exist a relational database. True or Simulated?
                Truthful (*)
                Imitation

47.         In an Oracle database, why would 1_TABLE non work as a tabular array name?
                There is no problem here. Yous tin can create a tabular array called 1_TABLE.
                Object names must not beginning with a number. They must begin with a letter. (*)
                TABLE is a reserved give-and-take.
                The database does not understand all upper-case letter messages.

48.         In an Oracle database, why would the following tabular array proper noun not be allowed 'EMPLOYEE JOBS'?
                JOBS is a reserved word
                The database does not understand all majuscule letters
                Y'all cannot have spaces between words in a table name (*)
                EMPLOYEE is a reserved word

49.         In which phases of the System Development Life Bike will we need to utilize SQL as a language? (Choose Ii)
(Choose all correct answers)
                Build and Certificate (*)
                Analysis
                Transition (*)
                Strategy

50.         During which phases of the Organization Evolution Life Cycle would you roll out the system to the users?
                Build and Transition
                Design and Production
                Strategy and Analysis
                Transition and Production (*)

Lanjutan... Database Programming Department 1 Quiz

Oracle Ilearning for Database Design
Pelajar yang menyelesaikan Desain & Pemrograman Database Oracle Academy dengan kursus SQL dapat sebagai gantinya (atau juga) memilih untuk mempersiapkan dan mengikuti ujian sertifikasi SQL Server SQL Expert. Namun, ujian Oracle Database SQL Expert berisi topik tambahan yang akan membutuhkan lebih banyak belajar mandiri dan berlatih sendiri untuk mempersiapkan.

Membutuhkan penyelesaian yang berhasil sebelum Ujian Sertifikasi Oracle Database SQL Expert, Pengantar Oracle Ujian Sertifikasi SQL, atau Oracle Database : Ujian Sertifikasi SQL Fundamentals.

Pembahasan didalam Oracle Ilearning - Oracle University

Oracle Ilearning for Database Pattern
Oracle Ilearning for Course Resources
Oracle Ilearning for Introduction
Oracle Ilearning for Entities and Attributes
Oracle Ilearning for Relationship Nuts
Oracle Ilearning for Super/Sub Types and Business Rules
Oracle Ilearning for Relationship Fundamentals
Oracle Ilearning for UIDs and Normalization
Oracle Ilearning for Arcs, Hierarchies, and Recursive Modeling
Oracle Ilearning for Changes and Historical Modeling
Oracle Ilearning for Mapping
Oracle Ilearning for Creating Database Projects
Oracle Ilearning for Presenting Database Projects
Oracle Ilearning quiz answers for Database Design English Quizzes and Exams
Oracle Ilearning quiz answers for Database Design Midterm Test
Oracle ilearning quiz answers for Database Blueprint Final Exam

Tag : all section quiz answers, jawaban kuis oracle ilearning.

Selain Sebagai Penyedia Panduan Belajar Database dan Tutorial Pemrograman, Kami Juga Membagikan Kumpulan Source Lawmaking Program Aplikasi dan Ebook Pemrograman Terlengkap yang Bisa Anda Dapatkan Secara Costless di Halaman :