Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17068

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 62538

What are inner join and outer join?

3 8763




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 62954

what are Triggers?

TCS,

5 9072

what are stored procedures?

TCS, Wells Fargo,

6 7332

what are indexes..how many types of index's are there and what are they?

TCS, Green Info Solutions,

7 12377

what are views?

TCS,

7 13906




Define 'view' advantage ?

TCS, AZTEC,

2 8680

What are the components of Physical database structure of Oracle Database?

4 8465

What are the components of Logical database structure of ORACLE database?

4 10344

What is a Tablespace?

5 5251

What is SYSTEM tablespace and When is it Created?

2 4714

Explain the relationship among Database, Tablespace and Data file?

4 7924

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 38700


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

how to clone 9i Database on to 10g Database.

1148


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

955


Which environment variables are absolutely critical in order to run the OUI?

1012


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

2602


WHAT IS ecc 6.0

907






if you ctreate table identity

1060


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2286


Hi Can any one tell me what are the API's used in requisition import.

894


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

826


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1051


what's query optimization and without use of IN AND Exist can we get another way data from query

1016


1) Does oracle have any table which contain all the exceptions and it's code internally?

682


How can we create the complete backup of data in the oracle.

1131


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

820


What is snapshot is too old? Give and example for better understand.

518