Database Programming Section 17 Quiz - Oracle iLearning

Section 17 Quiz
(Answer all questions in this section)

1. You want to grant user BOB the ability to change other users' passwords. Which privilege should you grant to BOB? Mark for Review
(1) Points

The DROP USER privilege

The CREATE USER privilege

The CREATE PROFILE privilege

The ALTER USER privilege (*)


2. User JAMES has created a CUSTOMERS table and wants to allow all other users to SELECT from it. Which command should JAMES use to do this? Mark for Review
(1) Points

GRANT customers(SELECT) TO PUBLIC;

GRANT SELECT ON customers TO PUBLIC; (*)

GRANT SELECT ON customers TO ALL;

CREATE PUBLIC SYNONYM customers FOR james.customers;



3. The database administrator wants to allow user Marco to create new tables in his own schema. Which privilege should be granted to Marco? Mark for Review
(1) Points

SELECT

CREATE OBJECT

CREATE TABLE (*)

CREATE ANY TABLE



4. Which Object Privilege (other than Alter) can be granted to a Sequence? Mark for Review
(1) Points

SELECT (*)

UPDATE

DELETE

INSERT


5. Which of the following best describes a role in an Oracle database? Mark for Review
(1) Points

A role is an object privilege which allows a user to update a table.

A role is a type of system privilege.

A role is a name for a group of privileges. (*)

A role is the part that a user plays in querying the database.
(Answer all questions in this section)

6. User ADAM has successfully logged on to the database in the past, but today he receives an error message stating that (although he has entered his password correctly) he cannot log on. What is the most likely cause of the problem? Mark for Review
(1) Points

ADAM's CREATE SESSION privilege has been revoked. (*)

One or more object privileges have been REVOKEd from Adam.

ADAM's user account has been removed from the database.

ADAM's CREATE USER privilege has been revoked.



7. _________________ are special characters that have a special meaning, such as a wildcard character, a repeating character, a non-matching character, or a range of characters. You can use several of these symbols in pattern matching. Mark for Review
(1) Points

Alphanumeric values

Clip Art

Meta characters (*)

Reference checks


8. REGULAR EXPRESSIONS can be used on CHAR, CLOB, and VARCHAR2 datatypes? (True or False) Mark for Review
(1) Points


True (*)

False


9. Select the correct REGULAR EXPRESSION functions: (Choose two) Mark for Review
(1) Points

(Choose all correct answers)

REGEXP_LIKE, REGEXP_NEAR

REGEXP_LIKE, REGEXP_REPLACE (*)

REGEXP_REPLACE, REGEXP_REFORM

REGEXP_INSTR, REGEXP_SUBSTR (*)



10. You need to grant user BOB SELECT privileges on the EMPLOYEES table. You want to allow BOB to grant this privileges to other users. Which statement should you use? Mark for Review
(1) Points


GRANT SELECT ON employees TO PUBLIC WITH GRANT OPTION;

GRANT SELECT ON employees TO bob WITH ADMIN OPTION;

GRANT SELECT ON employees TO bob WITH GRANT OPTION; (*)

GRANT SELECT ON employees TO bob;
(Answer all questions in this section)

11. Which statement would you use to grant a role to users? Mark for Review
(1) Points

GRANT (*)
CREATE USER
ALTER USER

ASSIGN


12. Which keyword would you use to grant an object privilege to all database users? Mark for Review
(1) Points

ALL

PUBLIC (*)

USERS

ADMIN



13. When a user is logged into one database, he is restricted to working with objects found in that database. True or False? Mark for Review
(1) Points


True


False (*)


14. Which of the following simplifies the administration of privileges? Mark for Review
(1) Points

An index

A view

A trigger

A role (*)


15. User CRAIG creates a view named INVENTORY_V, which is based on the INVENTORY table. CRAIG wants to make this view available for querying to all database users. Which of the following actions should CRAIG perform? Mark for Review
(1) Points


He must grant each user the SELECT privilege on both the INVENTORY table and INVENTORY_V view.


He is not required to take any action because, by default, all database users can automatically access views.


He should assign the SELECT privilege to all database users for the INVENTORY table.


He should assign the SELECT privilege to all database users for INVENTORY_V view. (*)

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 :