Database Programming Section 18 Quiz - Oracle iLearning

Artikel Terkait Oracle iLearning
Section 18 Quiz
(Answer all questions in this section)

1. User BOB's CUSTOMERS table contains 20 rows. BOB inserts two more rows into the table but does not COMMIT his changes. User JANE now executes:
SELECT COUNT(*) FROM bob.customers;

What result will JANE see?

 Mark for Review
(1) Points


JANE will receive an error message because she is not allowed to query the table while BOB is updating it.


20 (*)


22


2


2. You need not worry about controlling your transactions. Oracle does it all for you. True or False? Mark for Review
(1) Points


True


False (*)



3. If a database crashes, all uncommitted changes are automatically rolled back. True or False? Mark for Review
(1) Points


True (*)


False


4. COMMIT saves all outstanding data changes? True or False? Mark for Review
(1) Points


True (*)


False


5. If UserB has privileges to see the data in a table, as soon as UserA has entered data into that table, UserB can see that data. True or False? Mark for Review
(1) Points


True


False (*)
(Answer all questions in this section)

6. Examine the following statements:
INSERT INTO emps SELECT * FROM employees; -- 107 rows inserted.
SAVEPOINT Ins_Done;
CREATE INDEX emp_lname_idx ON employees(last_name);
UPDATE emps SET last_name = 'Smith';

What happens if you issue a Rollback statement?

 Mark for Review
(1) Points


The update of last_name is undone, but the insert was committed by the CREATE INDEX statement. (*)


Both the UPDATE and the INSERT will be rolled back.


The INSERT is undone but the UPDATE is committed.


Nothing happens.

7. A transaction makes several successive changes to a table. If required, you want to be able to rollback the later changes while keeping the earlier changes. What must you include in your code to do this? Mark for Review
(1) Points


A sequence


A savepoint (*)


A database link


An update statement


An object privilege



8. Which SQL statement is used to remove all the changes made by an uncommitted transaction? Mark for Review
(1) Points


ROLLBACK TO SAVEPOINT;


UNDO;


ROLLBACK; (*)


REVOKE;


9. Examine the following statements:
UPDATE employees SET salary = 15000;
SAVEPOINT upd1_done;
UPDATE employees SET salary = 22000;
SAVEPOINT upd2_done;
DELETE FROM employees;

You want to retain all the employees with a salary of 15000; What statement would you execute next?

 Mark for Review
(1) Points


ROLLBACK;


ROLLBACK TO SAVEPOINT upd1_done; (*)


ROLLBACK TO SAVEPOINT upd2_done;


ROLLBACK TO SAVE upd1_done;


There is nothing you can do; either all changes must be rolled back, or none of them can be rolled back.



10. If Oracle crashes, your changes are automatically rolled back. True or False? Mark for Review
(1) Points


True (*)


False


11. Table MYTAB contains only one column of datatype CHAR(1). A user executes the following statements in the order shown.
INSERT INTO mytab VALUES ('A');
INSERT INTO mytab VALUES ('B');
COMMIT;
INSERT INTO mytab VALUES ('C');
ROLLBACK;

Which rows does the table now contain?

 Mark for Review
(1) Points


A, B, and C


A and B (*)


C


None of the above


12. Examine the following statements:
INSERT INTO emps SELECT * FROM employees; -- 107 rows inserted.
SAVEPOINT Ins_Done;
DELETE employees; -- 107 rows deleted
SAVEPOINT Del_Done;
UPDATE emps SET last_name = 'Smith';

How would you undo the last Update only?

COMMIT Del_Done;


ROLLBACK to SAVEPOINT Del_Done; (*)


ROLLBACK UPDATE;


There is nothing you can do.


13. Which of the following best describes the term "read consistency"? Mark for Review
(1) Points


It ensures that all changes to a table are automatically committed


It prevents other users from seeing changes to a table until those changes have been committed (*)


It prevents other users from querying a table while updates are being executed on it


It prevents users from querying tables on which they have not been granted SELECT privilege


14. When you logout of Oracle, your data changes are automatically rolled back. True or False? Mark for Review
(1) Points


True


False (*)


15. Steven King's row in the EMPLOYEES table has EMPLOYEE_ID = 100 and SALARY = 24000. A user issues the following statements in the order shown:
UPDATE employees
SET salary = salary * 2
WHERE employee_id = 100;
COMMIT;

UPDATE employees
SET salary = 30000
WHERE employee_id = 100;

The user's database session now ends abnormally. What is now King's salary in the table?

 Mark for Review
(1) Points


30000


78000


24000


48000 (*)


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.




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
  1. 20rb perbulan. Diskon hingga 40% kode kupon: MCP Daftar disini (apache).
  2. 10rb perbulan. Diskon hingga 75% kode kupon: MCP Daftar disini (litespeed).
  3. 10rb perbulan. Diskon hingga 70% kode kupon: aff-MCP Daftar disini (apache).