1. Views stores the data and you can refresh it on timely bases
a. False
b. True
Correct answer is False
2. Views are created on top of Materialized views
a. False
b. True
Correct answer is :- True
3. How to concatenate multiple rows into a single string in sql
a. COALESCE
b. STRING_AGG
C. Option 1 & 2
d. None of the above
Correct answer is :- C. Option 1 & 2
4. IN and NOT IN operations decreases the performance of an SQL query compared to AND/OR operations. it it True or False?
a. True
b. False
Correct answer is : True
5. Rownum numbers the records in a result set.
a. False
b. True
Correct answer is :- True
6. Which privillega from the following is used to create a private sybonym in another user's schema?
a. CREATE SYNONYM
b. CREATE PUBLIC SYNONYM
c. CREATE ANY SYNONYM
d. None of the above
Correct answer is :- c. CREATE ANY SYNONYM
7. Indexes enhance the performance even if the table is updated frequently
a. True
b. False
Correct answer is :- True
8. RowId is the physical address which the data is stored
a. False
b. True
Correct answer is :- True
9. What will be the output of the below query. Given an Employee table having 10 records?
DROP TABLE Employees
ROLLBACK
SELECT * FROM Employees
a. 10 Records.
b. Produce and Error
c. 100 Records
d. 0 Records
Correct answer is :- b. Produce and Error
10.During MV Comlete Refresh, users can use the materialized view and see the old data
a. False
b. True
Correct answer is :- b. True