Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

261

What do you mean by cdb and pdb in oracle 12c?

627

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

284

Explain the dml?

585

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1770

What privilege is needed for a user to insert rows to tables in another schema?

550

What are the five functions of a database?

303

How to get / select the nth row from the table?

1

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

284

What is a canvas in oracle forms?

579

What is recovery manager in Oracle?

581

how the indexes are stored in the Oracle Database?

1730

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

338

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1793

What is a Garbage Collection? and what is full recursive Garbage collection?

2380