+1 vote
in Oracle by
ORACLE SQL MCQ Questions and Answers

1 Answer

0 votes
by
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

Related questions

+1 vote
asked Jun 30, 2019 in Spark Sql by anonymous
+1 vote
0 votes
asked Aug 27, 2022 in IOT Prime by Robin
...