15. Is it possible to encrypt an existing, un-encrypted storage space? *This que
ID: 3594711 • Letter: 1
Question
15. Is it possible to encrypt an existing, un-encrypted storage space? *This question is required.
a. No, spaces must be encrypted when they are first created
b. Yes, by using the ONSPACES command
c. Yes, by using a RESTORE operation
d. Yes, by updating the keystore file
16. Which access path allows the database server to retrieve all the data requested from the index without having to read the associated data pages? *This question is required.
a. Sequential scan
b. Index scan
c. Key only index scan
d. Auto index scan
17. You create the following view:
CREATE VIEW myview AS
SELECT * FROM tab1 WHERE code = 'ABC'
WITH CHECK OPTION;
Which of the following statements are true TRUE concerning this view? *This question is required.
a. You could insert a row with a value in the code column of ABC into the table using the view
b. You could insert a row with a value in the code column of DEF into the table using the view
c. You could delete a row with a value in the code column of ABC from the table using the view
d. You could delete a row with a value of DEF from the table using the view
18. You create the following roles:
CREATE ROLE employee;
CREATE ROLE mkting;
CREATE ROLE sales;
You then issue the following GRANT and REVOKE statements:
GRANT employee TO sales;
GRANT sales TO mkting;
GRANT mkting TO emma;
REVOKE ALL ON table1 FROM PUBLIC;
GRANT SELECT ON table1 TO employee;
GRANT DELETE ON table1 TO sales;
GRANT INSERT, UPDATE ON table1 TO mkting;
What privileges on table1 does emma have? *This question is required.
a. INSERT and UPDATE only
b. DELETE only
c. INSERT, UPDATE, and DELETE only
d. INSERT, UPDATE, DELETE, and SELECT
Explanation / Answer
15. d. Yes, by updating the keystore file
16. d. Auto index scan
17.a. You could insert a row with a value in the code column of ABC into the table using the view
18.a. INSERT and UPDATE onl
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.