Langsung ke konten utama

Postingan

Menampilkan postingan dengan label section 5

Section 5 Quiz Database Design Oracle

Section 5 Quiz             (Answer all questions in this section) 1.         Relationships can be Redundant. True or False?          Mark for Review (1) Points             True (*)             False 2.         If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review (1) Points             Redundant and Replicated             Resourced and Really Good             Redundant or Required (*)   ...

Section 5 Quiz Oracle Database Programming with SQL

Section 5 Quiz                 (Answer all questions in this section) 1.            CASE and DECODE evaluate expressions in a similar way to IF-THEN-ELSE logic. However, DECODE is specific to Oracle syntax. True or False? Mark for Review (1) Points                 True (*)                 False 2.            For the given data from Employees (last_name, manager_id) what is the result of the following statement: DATA:( King, null Kochhar, 100 De Haan, 100 Hunold, 102 Ernst, 103) SELECT last_name, DECODE(manager_id, 100, 'King', 'A N Other') "Works For?" FROM employees  Mark for Review (1) Points    ...