Database Design Midterm Exam Quiz Answers

Artikel Terkait Oracle iLearning
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.
Database design midterm exam quiz answers & ilearning quiz answers for database design english quizzes and exams

Section 1 Quiz  Database Design Midterm Exam

1.         The main subject areas taught by the Oracle Academy are:
            Data Modeling, SQL, and PL/SQL (*)
            Computer Repairs
            Database performance tuning
            Systems programming and computer architecture

2.         What is the difference between "information" and "data"?
            Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
            Information and data have no differences - they are two words for the same thing.
            Information is held and understood only by users.
            Data is held and understood only by users.

3.         Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information?
            Information (*)

4.         Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.
In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.
In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.
            Yes (*)

5.         The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.
            False (*)

6.         In the grid computing model, resources are pooled together for efficiency.
            True (*)

7.         Personal computers (PCs) have been in existence since 1950. True or False?
            False (*)

8.         Entities are transformed into Tables during the Database Design process. True or False?
            True (*)

9.         Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?
            True (*)

10.       Oracle was one of the first relational database systems available commercially. True or False?
            True (*)

Section 2 Quiz  Database Design Midterm Exam

11.       Data models show users the data that their Physical Model will contain. True or False?
            True (*)

12.       Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False?
            True (*)

13.       An ERD is an example of a Physical Model. True or False?
            False (*)

14.       Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False?
            True (*)

15.       Which of the following attributes is suitable to be a Unique Identifier?
            Last name
            First name
            Social Security Number (*)

16.       In the following statements, find two good examples of ENTITY: Instance. (Choose Two)
            (Choose all correct answers)   
            BOOK: Biography of Mahatma Gandhi (*)
            VEGETABLE: grows
            TRAIN: runs
            DAIRY PRODUCT: milk (*)

17.       Which of the following is an example of a volatile attribute?
            Hire Date
            Date of Birth
            Age (*)

18.       Which of the following entities most likely contains valid attributes? (Choose two)
            (Choose all correct answers)   
            Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)
            Entity: Pet. Attributes: Name, Birthdate, Owner (*)
            Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
            Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date

19.       All of the following could be attributes of an ENTITY called PERSON, except which one?
            Natacha Hansen (*)

20.       Which of the following are examples of ENTITY: Instance ? (Choose Two)
            (Choose all correct answers) 
            MEAT PRODUCT: Lettuce
            TRANSPORTATION METHOD: Car (*)
            BODY PART: Larry Ellison
            ANIMAL: Dog (*)

21.       An Entity Relationship model is independent of the hardware or software used for implementation. True or False?
            True (*)

22.       Which of the following statements are true about ERD's? (Choose Two)
            (Choose all correct answers)   
            You should not model derivable data. (*)
            A piece of information can be shown multiple times on an ERD.
            A piece of information should only be found in one place on an ERD. (*)
            All data must be represented on the ERD, including derived summaries and the result of calculations.

23.       Which of the following can be found in an ERD? (Choose Two)
            (Choose all correct answers)   
            Attributes. (*)
            Entities. (*)

Section 3 Quiz  Database Design Midterm Exam

24.       When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?
            True (*)

25.       Relationship names are not shown on an ERD. True or False?
            False (*)

26.       Which symbol is used to show that a particular attribute is mandatory?
            * (*)

27.       Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?
            False (*)

28.       Matrix Diagrams are developed BEFORE the ERD. True or False?
            True (*)

29.       What are the three properties that every relationship should have?
            Transferability, degree, name
            Name, optionality, cardinality (*)
            Name, optionality, arcs
            A UID bar, a diamond, an arc

30.       Which of the following are used to show Cardinality on an ERD? (Choose two)
            (Choose all correct answers)   
            Dashed line.
            Single toe. (*)
            Crow's foot. (*)
            Solid line.

Section 4 Quiz  Database Design Midterm Exam

31.       Relationship Cardinality is important. True or False?
            True (*)

32.       Why is it important to identify and document business rules?
            It allows you to create a complete data model and then check it for accuracy. (*)
            It allows you to improve the client's business.
            It ensures that the data model will automate all manual processes.
            None of the above

33.       Why is it important to identify and document structural rules?
            Ensures we know what data to store and how that data works together. (*)
            Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only.
            Ensures we know what processes are in place and how to program them.
            All of the Above.

34.       How should you handle constraints that cannot be modeled on an ER diagram?
            Explain them to the users so they can enforce them
            Always let the network architect handle them
            List them on a separate document to be handled programmatically (*)
            All constraints must be modeled and shown on the ER diagram

35.       A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False?
            True (*)

36.       All ER diagrams must have one of each of the following: (Choose two)
            (Choose all correct answers)   
            At least one supertype and subtype
            One or more Entities (*)
            Relationships between entities (*)

37.       A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False?
            True (*)

38.       A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?
            False (*)

39.       A subtype can have a relationship not shared by the supertype. True or False?
            True (*)

40.       All instances of a subtype may be an instance of the supertype but does not have to. True or False?
            False (*)

Section 5 Quiz  Database Design Midterm Exam

41.       If the same relationship is represented twice in an Entity Relationship Model, it is said to be:
            Redundant (*)

42.       What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"
            Many to Many Mandatory
            One to Many Optional
            One to Many Mandatory
            One to One Optional (*)

43.       If two entities have two relationships between them, these relationships can be either _____________ or _____________ .
            Redundant or Required (*)
            Replicated or Required
            Resourced and Really Good
            Redundant and Replicated

44.       Which of the following pairs of entities is most likely to be modeled as a M:M relationship?
            TREE and BRANCH
            PERSON and FINGERPRINT
            TEACHER and SUBJECT AREA (*)
            CAR and WHEEL

45.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:
            The UID's from the entities in the original M:M.
            The attributes of both related entities.
            A relationship to each entity from the original M:M. (*)
            Nothing is inherited from the original entities and relationship.

46.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?
            False (*)

47.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by
            Creating new attributes.
            Barring the relationships to the original entities. (*)
            Placing the UID attributes from the original entities into the intersection entity.
            None of the above.

48.       If a relationship can NOT be moved between instances of the entities it connects, it is said to be:
            Non-Transferable (*)

49.       A non-transferable relationship means the relationship is manatory at both sides. True or False?
            False (*)

50.       A non-transferable relationship is represented by which of the following symbols?
            Diamond (*)

Lanjutan... Database Design Final Exam 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 Academy
  • Oracle Ilearning for Database Design
  • Oracle Ilearning for Course Resources
  • Oracle Ilearning for Introduction
  • Oracle Ilearning for Entities and Attributes
  • Oracle Ilearning for Relationship Basics
  • 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 Exam
  • Oracle ilearning quiz answers for Database Design Final Exam

Tag : kunci jawaban oracle academy, database design midterm exam.

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

Rekomendasi Web Hosting
  1. 20rb perbulan. Diskon hingga 40% kode kupon: MCP Daftar disini (apache).
  2. 10rb perbulan. Diskon hingga 75% kode kupon: MCP Daftar disini (litespeed).
  3. 10rb perbulan. Diskon hingga 70% kode kupon: aff-MCP Daftar disini (apache).