Database Programming Section 15 Quiz - Oracle iLearning

Database Programming Section 15 Quiz - Oracle iLearning

Selamat datang kembali di TeknoTips.NET. TeknoTips.NET adalah media online Indonesia yang diluncurkan pada bulan Maret 2015. Kami berkomitmen menyajikan konten seputar teknologi yang berkualitas dan bermanfaat. Ulasan kami terdiri dari berbagai topik: pemrograman komputer & database, review produk, tutorial windows, linux, android, kumpulan source code & project program, referensi tugas akhir & skripsi, download ebook, game & software.

Pada kesempatan ini kita akan mengulas artikel yang berjudul : Database Programming Section 15 Quiz - Oracle iLearning.


Section 15 Quiz
(Answer all questions in this section)

1. A view can contain a select statement with a subquery. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


2. The FACULTY table contains these columns:
FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEY
FIRST_NAME VARCHAR2(20)
LAST_NAME VARCHAR2(20)
ADDRESS VARCHAR2(35)
CITY VARCHAR2(15)
STATE VARCHAR2(2)
ZIP NUMBER(9)
TELEPHONE NUMBER(10)
STATUS VARCHAR2(2) NOT NULL

The COURSE table contains these columns:

COURSEID VARCHAR2(5) NOT NULL PRIMARY KEY
SUBJECT VARCHAR2(5)
TERM VARCHAR2(6)
FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEY

You have been asked to compile a report that identifies all adjunct professors who will be teaching classes in the upcoming term. You want to create a view that will simplify the creation of this report. Which CREATE VIEW statements will accomplish this task?



CREATE VIEW pt_view IN    (SELECT first_name, last_name, status, courseid, subject, term
FROM faculty course);


CREATE VIEW pt_view
ON (SELECT first_name, last_name, status, courseid, subject, term
FROM faculty f and course c
WHERE f.facultyid = c.facultyid);


CREATE VIEW
   (SELECT first_name, last_name, status, courseid, subject, term
   FROM faculty, course
   WHERE facultyid = facultyid);


CREATE VIEW pt_view AS
   (SELECT first_name, last_name, status, courseid, subject, term
   FROM faculty f, course c
   WHERE f.facultyid = c.facultyid);
(*)



3. You need to create a view on the SALES table, but the SALES table has not yet been created. Which statement is true? Mark for Review
(1) Points


You must create the SALES table before creating the view.


You can create the table and the view at the same time using the FORCE option.


By default, the view will be created even if the SALES table does not exist.


You can use the FORCE option to create the view before the SALES table has been created. (*)



4. Which statement about the CREATE VIEW statement is true? Mark for Review
(1) Points


A CREATE VIEW statement CANNOT contain a function.


A CREATE VIEW statement CAN contain a join query. (*)


A CREATE VIEW statement CANNOT contain a GROUP BY clause.


A CREATE VIEW statement CANNOT contain an ORDER BY clause.


5. Which of the following keywords cannot be used when creating a view? Mark for Review
(1) Points


HAVING


WHERE


ORDER BY (*)


They are all valid keywords when creating views.
(Answer all questions in this section)

6. You create a view on the EMPLOYEES and DEPARTMENTS tables to display salary information per department.
What will happen if you issue the following statement?
CREATE OR REPLACE VIEW sal_dept
AS SELECT SUM(e.salary) sal, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
GROUP BY d.department_name;

 Mark for Review
(1) Points


A complex view is created that returns the sum of salaries per department. (*)


A simple view is created that returns the sum of salaries per department, sorted by department name.


A complex view is created that returns the sum of salaries per department, sorted by department id.


Nothing, as the statement contains an error and will fail.



7. Which of the following is TRUE regarding simple views? Mark for Review
(1) Points


Simple views retrieve data from many tables, so they typically contain joins.


Simple views can be used to perform DML operations. (*)


Simple views are not stored in the Data Dictionary.


Simple views contain functions or groups of data.



8. Only one type of view exists. True or False? Mark for Review
(1) Points


True


False (*)


9. Which statement about performing DML operations on a view is true? Mark for Review
(1) Points


You cannot perform DML operations on a view that contains the WITH CHECK OPTION clause.


You can perform DML operations on a view that contains columns defined by expressions, such as COST + 1.


You can perform DML operations on simple views. (*)


You can perform DML operations on a view that contains the WITH READ ONLY option.



10. Which action can be performed by using DML statements? Mark for Review
(1) Points


Altering a table


Deleting records in a table (*)


Disabling an index


Creating PRIMARY KEY constraints
(Answer all questions in this section)

11. Evaluate this SELECT statement:
SELECT ROWNUM "Rank", customer_id, new_balance
FROM (SELECT customer_id, new_balance
     FROM customer_finance
     ORDER BY new_balance DESC)
WHERE ROWNUM <= 25;

Which type of query is this SELECT statement?

 Mark for Review
(1) Points


A simple view


A hierarchical view


A Top-n query (*)


A complex view



12. When you drop a view, the data it contains is also deleted. True or False? Mark for Review
(1) Points


True


False (*)




13. The CUSTOMER_FINANCE table contains these columns:
CUSTOMER_ID NUMBER(9)
NEW_BALANCE NUMBER(7,2)
PREV_BALANCE NUMBER(7,2)
PAYMENTS NUMBER(7,2)
FINANCE_CHARGE NUMBER(7,2)
CREDIT_LIMIT NUMBER(7)

You created a Top-n query report that displays the account numbers and new balance of the 800 accounts that have the highest new balance value. The results are sorted by payments value from highest to lowest.

Which SELECT statement clause is included in your query?

 Mark for Review
(1) Points


Inner query: ORDER BY new_balance DESC (*)


Inner query: WHERE ROWNUM = 800


Inner query: SELECT customer_id, new_balance ROWNUM


Outer query: ORDER BY new_balance DESC




14. A Top-N Analysis is capable of ranking a top or bottom set of results. True or False? Mark for Review
(1) Points


True (*)


False


15. Which statement about an inline view is true? Mark for Review
(1) Points


An inline view is a schema object.


An inline view is a complex view.


An inline view is a subquery in the FROM clause, often named with an alias. (*)


An inline view can be used to perform DML operations.
























































































































































































































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






Tag : oracle academy quiz answers, oracle ilearning quiz answers, oracle academy certification, oracle academy training, soal dan jawaban kuis oracle, jawaban kuis oracle academy, jawaban kuis oracle ilearning, kunci jawaban oracle academy, kunci jawaban oracle ilearning.


Untuk mendapat notifikasi setiap artikel terbaru, masukkan e-mail anda disini
Selanjutnya cek e-mail anda untuk verifikasi.

Silahkan tuliskan komentar relevan Anda dengan jelas dan sopan, sesuai dengan topik postingan tentang "" pada halaman dibawah ini.

0 Response to "Database Programming Section 15 Quiz - Oracle iLearning"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2


Iklan Bawah Artikel