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.
1. An entity can only have one Primary UID. True or False?
True (*)
False
2. If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?
True (*)
False
3. There is no limit to how many columns can make up an entity's UID. True or False?
True (*)
False
4. A unique identifier can only be made up of one attribute. True or False?
True
False (*)
5. 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 key.
None of the Above.
6. What is the rule of Second Normal Form?
No non-UID attributes can be dependent on any part 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 following entity and decide how to make it conform to the rule of 2nd Normal Form:
ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE
Do nothing, it 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 STORE ID, and create a relationship to the original entity. (*)
Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a 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 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.
10. As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False? 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:
# CLIENT ID
FIRST NAME
LAST NAME
STREET
CITY
ZIP CODE
1st Normal Form.
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised. (*)
12. When data is stored in more than one place in a database, the database violates the rules of ___________.
Normalcy
Replication
Normalization (*)
Decency
13. If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:
Make the attribute optional
Do nothing, an entity does not have to be in 1st Normal Form
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.
14. An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False?
True
False (*)
15. An entity can have repeated values and still be in 1st Normal Form. True or False?
True
False (*)
16. Cascading UIDs are a feature often found in what type of 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 single relationship can be both Recursive and Hierarchical at the same time. True or False?
True
False (*)
19. A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?
True (*)
False
20. A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?
True (*)
False
21. Which of the following would best be represented by an arc?
STUDENT (Grade A student, Average Student)
PARENT (Girl, Bob)
TEACHER (Female, Bob)
DELIVERY ADDRESS (Home, Office) (*)
22. Arcs are used to visually represent _________ between two or more relationships in an ERD.
Sameness
Differences
Exclusivity (*)
Inheritance
23. An arc can often be modeled as Supertype and Subtypes. True or False?
True (*)
False
24. Which of the following would best be represented by an arc?
STUDENT (Grade A student, Average Student)
STUDENT (senior, male)
STUDENT ( University, Technical College) (*)
STUDENT (graduating, female)
25. Which of the following would be a logical constraint when modeling time for a country entity?
Daily traffic patterns must be monitored to determine which countries are overcrowded.
People have births and deaths in their countries that must be tracked by the system.
If you are doing a system for France or Germany, you would need security clearance.
Countries may change their names and/or borders over a period of time. (*)
26. Which of the following would be a logical constraint when modeling time for a City entity?
Daily traffic patterns must be 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 country association if the borders of a country change. (*)
People are born in the city and people die in the city.
27. All systems must include functionality to provide logging or journaling in conceptual data models. True or False?
True
False (*)
28. When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?
True (*)
False
29. There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False?
True
False (*)
30. Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?
True
False (*)
31. Which of the following scenarios should be modeled so that historical data is kept? (Choose two)
(Choose all correct answers)
LIBRARY and NUMBER OF BOOKS
STUDENT and GRADE (*)
STUDENT and AGE
LIBRARY and BOOK (*)
32. Historical data must never be kept. True or False?
True
False (*)
33. The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.
Referential integrity
Column integrity
Entity integrity (*)
User-defined integrity
34. Foreign keys cannot be null when
It refers to the same table
It is part of a primary key (*)
It refers to another table
It contains three or more columns
35. The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.
User-defined integrity (*)
Entity integrity
Column integrity
Referential integrity
36. A foreign key cannot refer to a primary key in the same table. True or False?
True
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 always 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 Key. True or False?
True
False (*)
39. One-to-Many Optional to Mandatory becomes a _______________ on the Master table.
Unique Key
Optional Foreign Key (*)
Mandatory Foreign Key
Primary Key
40. A barrred Relationship will result in a Foreign Key column that also is part of:
The Column Name
The Check Constraint
The Table Name
The Primary Key (*)
41. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?
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?
True
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 as foreign keys, but the foreign key columns all become optional. True or False?
True (*)
False
45. The transformation from an ER diagram to a physical design 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 will be a relational database. True or False?
True (*)
False
47. In an Oracle database, why would 1_TABLE not work as a table name?
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.
The database does not understand all capital letters.
48. In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?
JOBS is a reserved word
The database does not understand all capital letters
You cannot have spaces between words in a table name (*)
EMPLOYEE is a reserved word
49. In which phases of the System Development Life Cycle will we need to use SQL as a language? (Choose Two)
(Choose all correct answers)
Build and Document (*)
Analysis
Transition (*)
Strategy
50. During which phases of the System Development Life Cycle would you roll out the system to the users?
Build and Transition
Design and Production
Strategy and Analysis
Transition and Production (*)
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 : all section quiz answers, jawaban kuis oracle ilearning.
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
- 20rb perbulan. Diskon hingga 40% kode kupon: MCP Daftar disini.
- 10rb perbulan. Diskon hingga 75% kode kupon: MCP Daftar disini.
- 10rb perbulan. Diskon hingga 70% kode kupon: aff-MCP Daftar disini.