Langsung ke konten utama

Section 8 Quiz Database Design Oracle

Section 8 Quiz
                (Answer all questions in this section)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                BABY and AGE
                CUSTOMER and ORDERS (*)
                TEACHER and AGE
                CUSTOMER and PAYMENTS (*)

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                LIBRARY and BOOK (*)
                STUDENT and GRADE (*)
                STUDENT and AGE
                LIBRARY and NUMBER OF BOOKS

4.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
(1) Points
                                                (Choose all correct answers)      

                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.

                The crows feet (many ends) can point whichever way is the easiest to draw.

                Avoid crossing one relationship line with another. (*)

                It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)

5.            No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

6.            You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?             Mark for Review
(1) Points
                True
                False (*)

7. 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?        Mark for Review
(1) Points
                True
                False (*)

8.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

9.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.
                Dates must be stored with Time.

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

10.          What is the function of logging or journaling in conceptual data models?               Mark for Review
(1) Points
                Represents entities as time in the data model.
                Creates a fixed time for all events in a data model.
                Gives a timestamp to all entities.
                Allows you to track the history of attribute values, relationships, and/or entire entities (*)

11.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points
                It depends on the functional needs of the system . (*)
                Always model time; you can take it out later if it is not needed.
                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
                The rules are fixed and should be followed.

12.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
(1) Points
                If you are doing a system for France or Germany, you would need security clearance.
                Daily traffic patterns must be monitored to determine which countries are overcrowded.
                Countries may change their names and/or borders over a period of time. (*)
                People have births and deaths in their countries that must be tracked by the system.

13.          In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

14.          Modeling historical data is optional. True or False?           Mark for Review
(1) Points
                True (*)
                False

15.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Transferable Relationship
                Non-transferable Relationship.
                Conditional Non-transferable Relationship. (*)
                Arc.

1.            You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?             Mark for Review
(1) Points
                True
                False (*)

2.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
(1) Points
                                                (Choose all correct answers)      
                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.

                It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)

                The crows feet (many ends) can point whichever way is the easiest to draw.

                Avoid crossing one relationship line with another. (*)

3.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

4.            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?      Mark for Review
(1) Points
                True
                False (*)

5.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                CUSTOMER and ORDERS (*)
                CUSTOMER and PAYMENTS (*)
                TEACHER and AGE
                BABY and AGE

6.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                LIBRARY and NUMBER OF BOOKS
                STUDENT and GRADE (*)
                LIBRARY and BOOK (*)
                STUDENT and AGE

7.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

8.            In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

9.            Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
(1) Points
                If you are doing a system for any French City, you would need security clearance.
                People are born in the city and people die in the city.

                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

                Cites may change their names and/or country association if the borders of a country change. (*)

10.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

11.          If you have an entity with a DATE attribute, in addition to other attributes that track date characteristics, you should create a DAY entity. True or False?            Mark for Review
(1) Points
                True (*)
                False

12.          There are no circumstances where you would create a DAY entity. True or False?             Mark for Review
(1) Points
                True
                False (*)

13.          You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points

                Email current prices to all employees whenever a price changes.

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Allow them to enter whatever delivery charge they want.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

14.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
(1) Points
                The Government of your country might want to be notified of this transaction.
                You would not want to model this; it is not important.

                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)

                Sales people must determine where the gold is coming from.

15.          All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                LIBRARY and BOOK (*)
                STUDENT and AGE
                LIBRARY and NUMBER OF BOOKS
                STUDENT and GRADE (*)

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                CUSTOMER and PAYMENTS (*)
                CUSTOMER and ORDERS (*)
                BABY and AGE
                TEACHER and AGE

4.            When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Transferable Relationship
                Non-transferable Relationship.
                Conditional Non-transferable Relationship. (*)
                Arc.

5.            All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

6.            In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

7.            When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

8.            If you have an entity that a DATE attribute, and other attributes that track characteristics of the date, you should create a DAY entity. True or False?            Mark for Review
(1) Points
                True (*)
                False

9.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

10.          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?      Mark for Review
(1) Points
                True
                False (*)

11.          No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

12.          In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

13.          You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points
                Email current prices to all employees whenever a price changes.

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

                Allow them to enter whatever delivery charge they want.

14.          Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                EMPLOYEE periods can overlap causing the database to crash.
                Dates must be stored with Time.
                End Date must be before the Start Date.

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

15.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
(1) Points
                You would not want to model this; it is not important.
                The Government of your country might want to be notified of this transaction.

                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)

                Sales people must determine where the gold is coming from.

1.            You are doing a data model for a computer sales company where the price fluctuates on a regular basis. If you want to allow the company to modify the price and keep track of the changes, what is the best way to model this?      Mark for Review
(1) Points

                A. Create a product entity and a related price entity with start and end dates, and then let the users enter the new price whenever required.
                B. Create a new item and a new price every day.
                C. Use a price entity with a start and end date
                D. Allow them to delete the item and enter a new one.
                E. Both A and C (*)

2.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

                Dates must be stored with Time.
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.

3.            You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

                Email current prices to all employees whenever a price changes.
                Allow them to enter whatever delivery charge they want.

4. Historical data must never be kept. True or False?       Mark for Review
(1) Points
                True
                False (*)

5.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

6.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                BABY and AGE
                TEACHER and AGE
                CUSTOMER and ORDERS (*)
                CUSTOMER and PAYMENTS (*)

7.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

8.            No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

9.            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?   Mark for Review
(1) Points
                True
                False (*)

10.          Which of the following statements are true to enhance the readability of ERDs? (Choose Two)  Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Crossing relationship lines help the readability of the diagram.

                Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)

                Relationship lines should not cross. (*)

                It does not matter which way the crows feet (many ends of a relationship) point.

11.          Modeling historical data is optional. True or False?           Mark for Review
(1) Points
                True (*)
                False

12.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Conditional Non-transferable Relationship. (*)
                Arc.
                Transferable Relationship
                Non-transferable Relationship.

13.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

14.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

15.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points

                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

                The rules are fixed and should be followed.
                Always model time; you can take it out later if it is not needed.
                It depends on the functional needs of the system . (*)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                STUDENT and GRADE (*)
                STUDENT and AGE
                LIBRARY and BOOK (*)
                LIBRARY and NUMBER OF BOOKS

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

4.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

5.            You are doing a data model for a computer sales company where the price fluctuates on a regular basis. If you want to allow the company to modify the price and keep track of the changes, what is the best way to model this?      Mark for Review
(1) Points

                A. Create a product entity and a related price entity with start and end dates, and then let the users enter the new price whenever required.
                B. Create a new item and a new price every day.
                C. Use a price entity with a start and end date
                D. Allow them to delete the item and enter a new one.
                E. Both A and C (*)

6.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.
                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
                Dates must be stored with Time.

7.            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?   Mark for Review
(1) Points
                True
                False (*)

8.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

9.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

10.          No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

11.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points

                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
                Always model time; you can take it out later if it is not needed.
                The rules are fixed and should be followed.
                It depends on the functional needs of the system . (*)

12.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

13.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Conditional Non-transferable Relationship. (*)
                Transferable Relationship
                Non-transferable Relationship.
                Arc.

14.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
(1) Points
                Daily traffic patterns must be monitored to determine which countries are overcrowded.
                Countries may change their names and/or borders over a period of time. (*)
                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.

15.          Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
(1) Points

                Cites may change their names and/or country association if the borders of a country change. (*)

                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

                People are born in the city and people die in the city.


                If you are doing a system for any French City, you would need security clearance.

Komentar

  1. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Ruby on Rails Online Training Hyderabad

    BalasHapus
  2. 心理健康真的非常重要。想想幾件事:你喝得太多了嗎?你是否注意到經常被忽視的抑鬱症或勃起功能障礙的跡象。犀利士 ; 患者自述-犀利士使用心得

    BalasHapus
  3. 如果有勃起功能障礙 (ED),應該去看醫師。除了明顯的缺點外,ED 還可能是其他嚴重健康問題(包括心臟病)的徵兆,應該進行檢查。威而鋼壯陽藥推薦

    BalasHapus
  4. I want to share a testimony of how Mr. Pedro helped me with a $ 2,000,000.00 loan to fund my marijuana cultivation project, I am very grateful and promised to share this legitimate funding company with anyone looking for a way to expand their business project. . financing company. Anyone seeking financial support should contact them at pedroloanss@gmail.com.

    BalasHapus
    Balasan
    1. Court marriage takes place in front of the marriage officer in the court without any traditional ceremony. Arya Samaj Mandir Dehradun

      Hapus
  5. 2. Historical data should always be kept. True or False?

    True
    False (*)


    Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False?

    True (*)
    False

    BalasHapus
  6. When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?
    (1/1) Points
    True (*)
    False

    BalasHapus
  7. Thanks for the sharing information with us . Section 8 Company

    BalasHapus

Posting Komentar

Postingan populer dari blog ini

Section 6 Quiz Oracle Database Programming with SQL

Section 6 Quiz             (Answer all questions in this section)                                                             1.         Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee メ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name   Null?    Type EMPLOYEE_ID          NOT NULL     NUMBER (6) FIRST_NAME             VARCHAR2 (20) LAST_NAME  NOT NULL     VARCHAR2 (25) EMAIL NOT NULL     VARCHAR2 (25) PHONE_NUMBER                  VARCHAR2 (20) HIRE_DATE   NOT NULL     DATE JOB_ID           NOT NULL     VARCHAR2 (10) SALARY                     NUMBER (8,2) COMMISSION_PCT                NUMBER (2,2) MANAGER_ID                       NUMBER (6) DEPARTMENT_ID                 NUMBER (4) JOBS Table: Name   Null?    Type JOB_ID           NOT NULL     VARCHAR2 (10) JOB_TITLE     NOT NULL     VARCHAR2 (35) MIN_SALARY                      

Section 10 Quiz Database Programming With SQL

Section 10 Quiz             (Answer all questions in this section) 1.         A multiple-row operator expects how many values?   Mark for Review (1) Points             One or more (*)             Only one             Two or more             None 2.         The salary column of the f_staffs table contains the following values: 4000 5050 6000 11000 23000 Which of the following statements will return the last_name and first_name of those employees who earn more than 5000?  Mark for Review (1) Points             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT last_name, first_name FROM f_staffs WHERE salary <5000 o:p="">             SELECT last_name, first_name FROM f_staffs WHERE salary = (SELECT salary FROM f_staffs WHERE salary < 5000);             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT salary FROM f_staffs WHERE salary > 5000); (*)             SELEC

Section 6 Quiz Database Design Oracle

Section 6 Quiz             (Answer all questions in this section) 1.         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  Mark for Review (1) Points             1st Normal Form.             2nd Normal Form.             3rd Normal Form.             None of the above, the entity is fully normalised. (*) 2.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review (1) Points             True (*)             False 3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review (1) Points             Functional dependency             Dependency             Transitive dependency (*)             Non-dependency