Recent questions tagged Oracle-interview-questions-answers

0 votes

During MV complete Refresh, users can use the materlized view and see the old data.

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

Materialized views stores the data and you can refresh it on timely bases

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

ALL_SOURCE will help us to

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

Multiple updates in a table will decrease the performance.

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

What would be the output of below SQL statement, select empName from Employee order by 2 desc:

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

How the parameter atomic_refresh in dbms_mview.refresh will make the refresh faster?

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

What are composite Indexes?

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

________ database link of PL/SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

0 votes

How non clustered index helps to fetch the data?

asked Mar 18 in Oracle by GeorgeBell (4.5k points)

To see more, click for the full list of questions or popular tags.

...