Database Programming Section 7 Quiz - Oracle iLearning

1.     Will the following statement work?

SELECT department_name, last_name
FROM employees, departments
WHERE department_id = department_id;
    Mark for Review
(1) Points
                   
           
    Yes, Oracle will resolve which department_id colum comes from which table.
   
           
    No, Oracle will return a Column Ambiguously Defined error. (*)
   
           
    No, Oracle will not allow joins in the WHERE clause
   
           
    Yes, there are no syntax errors in that statement
   
                   
               
[Correct]         Correct
   
                   
        2.     What is produced when a join condition is not specified in a multiple-table query using Oracle proprietary Join syntax?     Mark for Review
(1) Points
                   
           
    An outer join
   
           
    A Cartesian product (*)
   
           
    An equijoin
   
           
    A self-join
   
                   
               
[Correct]         Correct
   
                   
        3.     What happens when you create a Cartesian product?     Mark for Review
(1) Points
                   
           
    The table is joined to itself, one column to the next column, exhausting all possibilities
   
           
    All rows from one table are joined to all rows of another table (*)
   
           
    All rows that do not match in the WHERE clause are displayed
   
           
    The table is joined to another equal table
   
                   
               
[Correct]         Correct
   
                   
        4.     You have the following EMPLOYEES table:

EMPLOYEE_ID NUMBER(5) NOT NULL PRIMARY KEY
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
ADDRESS VARCHAR2(35)
CITY VARCHAR2(25)
STATE VARCHAR2(2)
ZIP NUMBER(9)
TELEPHONE NUMBER(10)
DEPARTMENT_ID NUMBER(5) NOT NULL FOREIGN KEY

The BONUS table includes the following columns:

BONUS_ID NUMBER(5) NOT NULL PRIMARY KEY
ANNUAL_SALARY NUMBER(10)
BONUS_PCT NUMBER(3, 2)
EMPLOYEE_ID VARCHAR2(5) NOT NULL FOREIGN KEY

You want to determine the amount of each employee's bonus as a calculation of salary times bonus. Which of the following queries should you issue?
    Mark for Review
(1) Points
                   
           
    SELECT first_name, last_name, annual_salary * bonus_pct
FROM employees, bonus NATURAL JOIN;

   
           
    SELECT e.first_name, e.last_name, b.annual_salary, b. bonus_pct
FROM employees, bonus
WHERE e.employee_id = b.employee_id;

   
           
    SELECT e.first_name, e.last_name, b.annual_salary, b. bonus_pct
FROM employees e, bonus b
WHERE e.employee_id = b.employee_id;

   
           
    SELECT e.first_name, e.last_name, b.annual_salary * b. bonus_pct
FROM employees e, bonus b
WHERE e.employee_id = b.employee_id;

(*)
   
                   
               
[Correct]         Correct
   
                   
        5.     If table A has 10 rows and table B has 5 rows, how many rows will be returned if you perform a equi-join on those two tables?     Mark for Review
(1) Points
                   
           
    5
   
           
    It depends on how many rows have matching data in each of the two tables. (*)
   
           
    10
   
           
    50
   
                   
               
[Correct]         Correct
     (Answer all questions in this section)
                   
        6.     The PATIENTS and DOCTORS tables contain these columns:

PATIENTS
PATIENT_ID NUMBER(9)
LAST_NAME VARCHAR2 (20)
FIRST_NAME VARCHAR2 (20)

DOCTORS
DOCTOR_ID NUMBER(9)
LAST_NAME VARCHAR2 (20)
FIRST_NAME VARCHAR2 (20)

You issue this statement:
SELECT patient_id, doctor_id
FROM patients, doctors;

Which result will this statement provide?
    Mark for Review
(1) Points
                   
           
    A report containing all possible combinations of the PATIENT_ID and DOCTOR_ID values (*)
   
           
    A report with NO duplicate PATIENT_ID or DOCTOR_ID values
   
           
    A syntax error
   
           
    A report containing each patient's id value and his doctor's id value
   
                   
               
[Correct]         Correct
   
                   
        7.     Evaluate this SQL statement:

SELECT e.employee_id, e.last_name, e.first_name, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id AND employees.department_id > 5000
ORDER BY 4;

Which clause contains a syntax error?
    Mark for Review
(1) Points
                   
           
    AND employees.department_id > 5000 (*)
   
           
    FROM employees e, departments d
   
           
    SELECT e.employee_id, e.last_name, e.first_name, d.department_name
   
           
    ORDER BY 4;
   
           
    WHERE e.department_id = d.department_id
   
                   
               
[Correct]         Correct
   
                   
        8.     What is the result of a query that selects from two tables but includes no join condition?     Mark for Review
(1) Points
                   
           
    A selection of rows from the first table only
   
           
    A syntax error
   
           
    A selection of matched rows from both tables
   
           
    A Cartesian product (*)
   
                   
               
[Correct]         Correct
   
                   
        9.     You need to join the EMPLOYEES table and the SCHEDULES table, but the two tables do not have any corresponding columns. Which type of join will you create?     Mark for Review
(1) Points
                   
           
    A full outer join
   
           
    It is not possible to join these two tables.
   
           
    A non-equijoin (*)
   
           
    An equijoin
   
                   
               
[Correct]         Correct
   
                   
        10.     Which statement about joining tables with a non-equijoin is false?     Mark for Review
(1) Points
                   
           
    A WHERE clause must specify a column in one table that is compared to a column in the second table (*)
   
           
    The number of join conditions required is always one less than the number of tables being joined
   
           
    The columns being joined must have compatible data types
   
           
    None of the above
   
                   
               
[Correct]         Correct
     (Answer all questions in this section)
                   
        11.     The following is a valid outer join statement:

SELECT c.country_name, d.department_name
FROM countries c, departments d
WHERE c.country_id (+) = d.country_id (+)

True or False?
    Mark for Review
(1) Points
                   
           
    True
   
           
    False (*)
   
                   
               
[Correct]         Correct
   
                   
        12.     Evaluate this SELECT statement:

SELECT p.player_id, m.last_name, m.first_name, t.team_name
FROM player p
LEFT OUTER JOIN player m ON (p.manager_id = m.player_id)
LEFT OUTER JOIN team t ON (p.team_id = t.team_id);

Which join is evaluated first?
    Mark for Review
(1) Points
                   
           
    The join between the player table and the team table on PLAYER_ID
   
           
    The join between the player table and the team table on TEAM_ID
   
           
    The self-join of the player table (*)
   
           
    The join between the player table and the team table on MANAGER_ID
   
                   
               
[Correct]         Correct
   
                   
        13.     Which statement about outer joins is true?     Mark for Review
(1) Points
                   
           
    The OR operator cannot be used to link outer join conditions. (*)
   
           
    The tables must be aliased.
   
           
    Outer joins are always evaluated before other types of joins in the query.
   
           
    The FULL, RIGHT, or LEFT keyword must be included.
   
                   
               
[Correct]         Correct
   
                   
        14.     Which operator is typically used in a nonequijoin?     Mark for Review
(1) Points
                   
           
    *
   
           
    OR
   
           
    IN
   
           
    NOT
   
           
    >=, <=, or BETWEEN ...AND (*)
   
                   
               
[Correct]         Correct
   
                   
        15.     To perform a valid outer join between DEPARMENTS and EMPLOYEES to list departments without employees, select the correct WHERE clause for the following select statement:

SELECT d.department_name, e.last_name
FROM employees e, departments d
WHERE
    Mark for Review
(1) Points
                   
           
    e.department_id(+) = d.department_id(+)
   
           
    e.department_id(+) = d.department_id (*)
   
           
    e.department_id = d.department_id(+)
   
           
    e.department_id = d.department_id
   
                   
               
[Correct]         Correct

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.



Di atas adalah soal dan jawaban kuis oracle ilearning - oracle academy, sebagai penambah ilmu pengetahuan untuk kita semua, yang pada intinya jangan lupa untuk dipahami dan dikuasai.

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

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 :