Oracle General Interview Questions
Questions Answers Views Company eMail

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

Mphasis,

5 13907

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 5826

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 3631

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

1406

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

1 5242

how can we write trigger in trigger???????? can we write one trigger on two table???

Value Labs,

2 4822

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

JPMorgan Chase,

4 6193

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

IBM,

7 6523

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

Cognizant,

2 3943

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 2728

How to Remove the 3rd highest salary person record from table?

HCL, IBM,

9 16228

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 4217

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

IBM,

6 5642

what is the difference between table and veiw?

IBM,

4 5705

How to display First 4 rows From Database Table?

6 7664


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to list all indexes in your schema?

558


What is the difference between online and offline backups?

541


Explain oracle instance.

660


How to define a data field as not null?

608


How to synchronize 2 schema's objects?

1664






What are joins, explain all types of joins?

1691


How many memory layers are in the oracle shared pool?

613


What is tns name?

516


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1638


How to display row numbers with the records?

564


How would you go about verifying the network name that the local_listener is currently using?

1582


What is the relationship among database, tablespace and data file?

514


Describe varray?

561


What are the execution control statements in oracle?

574


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3822