QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> Oracle

Question

View Answer

=> What is the function of SMON?

=> Explain in brief oracle database objects.

=> What are the Characteristics of Data Files

=> Explain the methods provided by SQL Loader.

=> what is the difference between SID and Global Database Name ?

=> Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool.

=> What is the diff b/w BTREE INDEX and BITMAP INDEX

=> Explain the areas of memory used by oracle, i.e. Software code area, system global area (SGA), program global area(PGA), sort area.

=> Describe Oracle architecture in brief.

=> What is the differnece between materialized view and snapshot

=> SGA definition files

=> What is the physical and logical structure of oracle?

=> Explain the types of data files used by the oracle RDBMS.

=> Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment.

=> What are the Large object types supported by Oracle?

=> What are the built-in functions used for sending Parameters to forms ?

=> Does a Before form trigger fire when the parameter form is suppressed ?

=> Can a field be used in a report without it appearing in any data group ?

=> The join defined by the default data link is an outer join yes or no ?

=> Can a property clause itself be based on a property clause ?

Page: 3 4 5 6 7 8 9 10 11

Last

Latest Oracle Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan