1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Microsoft,

2 4735

what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item

 2 10228

how to get count of tables in particular database in Oracle?

 3 4549

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

Cap Gemini,

4 6508

the user should know to which database he is connected currently in oracle

 3 3470

what is meant by physical order and logical order in clustered index and non clustered index.

 2 7148

what is debit memo and credit memo in AR?

1 3352

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

IBM,

1 3771

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

IBM,

1 4601

What is the difference between SQL and SQL Server?

CTS, TCS,

2 4652

In Oracle 10g, "g" Stands for what?

Mphasis,

5 13972

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

 3 5865

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

 2 3657

what is port in oracle? how is it related to database application.

 1426

what is host string in sql plus? how does it related to database?

 1 5277

Un-Answered Questions { Oracle }

Point the difference between translate and replace?

560

Explain the types of record group.

1

Explain the use of compress option in exp command.

538

How is clustered database important in oracle rac architecture?

1

Explain what does a control file contain?

596




What is CKM and when we will use this CKM?

291

Difference between the “verify” and “feedback” command?

755

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1799

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

648

Please explain compound trigger in oracle?

586

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2038

In topology manager where the data are stored?

324

What is a user role in oracle?

606

What is data store? How to create data store?

319

Explain master-detail relationship with some examples.

575

For More Un-Answered { Oracle } Questions Click Here