Recent questions tagged oracle-interview-questions-answers

0 votes

1 answer

What is DML in Oracle?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

How can we represent comments in Oracle?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

What is BLOB datatype?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

What is COALESCE function in oracle?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

What are nested tables in oracle?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

Whether any commands are used for Months calculation? If so, What are they?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

What is the use of NVL function in Oracle?

asked Jan 17, 2024 in Oracle by AdilsonLima

0 votes

1 answer

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

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

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

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

ALL_SOURCE will help us to

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

Multiple updates in a table will decrease the performance.

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

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

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

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

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

What are composite Indexes?

asked Mar 18, 2023 in Oracle by GeorgeBell

0 votes

1 answer

________ 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, 2023 in Oracle by GeorgeBell

0 votes

1 answer

How non clustered index helps to fetch the data?

asked Mar 18, 2023 in Oracle by GeorgeBell

Page:

...