Placement Papers for All Companies

3i infotech
Abacus Infotech
Abatix
Abaxis
ABB
ACC Limited
Accel Frontline
Accenture
Aditi Technologies
Adobe System
ADP
Agilysys
AgreeYa
AIG
AirNet
Alanco Technologies
Alle Technologies
Allfon
Alter Systems
Amazon
AMDL
Amdocs
AMI
Amiti Software Technologies
ANZ
Apple
Applied Materials
Apps Associates
Aricent
ASDC
Ashok Leyland Ltd
Asian Paints
Aspire System
AT & T
Atlas Copco
Atos Origin
AXA Technology Services
Axes Technology
Bain
Bajaj
Bayer
Bharti Airtel Ltd
Bhawan Cybertek
Birlasoft
Blue Star Infotech
BMC
BOB
Brakes India
C-DOT
CA Technologies
Cadence
Calsoft
Canarys
Capgemini
Caterpillar
Celstream
CGI Group
Changepond Technologies
Cimtrix Systems
Cisco system
Citicorp Overseas Software Ltd
ClinTech
CMC Limited
CMS
Cognizant
Compaq
Consagous Technologies
Convergys
CORDYS
CRISIL
Crompton Greaves
CSC
CSFB
CtrlS Datacenters Ltd
Cummins
Cyient
Daffodil
Daimler
Dell
Deloitte
Delphi-TVS
Dharma Systems
Directi
DSRC
Eicher
ELGI
ELICO
EMC Corporation
Emphasis
Ericsson
Ernst & Young
ESKO
Essar
Facebook
Fanuc Corporation
Fidelity
Flextronics
Flipkart
Freescale
Fujitsu
Gajshield
GE
Genpact India
Geodesic
Geometric Limited
GlobalEdge
GlobalLogic
GMR Group
Godrej Infotech
Google
Grapecity
Harita - TVS
HCL
HCL Technologies
Headstrong
Healthasyst
HEC Ltd
Hexaware
HFCL
Holool
Honeywell
HP
HTC Global Services
Huawei
Hughes
Hyundai
IBM
IBS Software Services
IGate
Ikanos
IKOS
Impetus
iNautix
Indecomm
IndiaBulls Power Limited
Inductis-EXL
Industrial Alliance
Infineon
Infogain
Infosys
Intec
Integra
Intel
Intergraph
ITC Infotech
Jindal Steel and Power Limited
KPIT
L & T
L & T Infotech
LG Soft
Linde India Ltd
LnT Emsys
LnT-ECC
Lucas - TVS
Mahindra Engineering Services Ltd
Mahindra Ltd
Maruti
Matrix
Maveric Systems
McAfee
Microland
Microsoft
Mindtree
Miraclesoft
MKCL
Motorola
Mu-Sigma
Nagarro
NASSCOM
NCR Corporation
Ness Technologies
Neudesic
NIIT Technologies
Novell
Nvidia
Oracle
Persistent
Philips
Planetasia
Polaris
Poornam Info Vision
PSI Data Systems Limited
Quest-Global
Quinnox
R Systems
Redpine
Reliance Energy
Robert Bosch
RS Software
Samsung
SAP labs India
Sapient
Sasken Communications
Schneider India
Serco
Siemens
Sierra Atlantic
SkyTECH
Soliton
Sonata Software
Sony India
SQL Star
Steria
Subex Limited
Sutherland Global Services
Syntel
Talisma
Tata motors
Tata technologies
Tata-ELXSI
TCE
TCS
Tech Mahindra
Temenos
Tesco
Texas Instruments
Thermax
ThoughtWorks
Torry Harris
Triad
Trianz
Trilogy
TVS Motor
Unisys
UnitedHealth Group
UST Global
UTC Aerospace System
Valuelabs
Vedanta
Verifone
Verizon
Virtusa
Vision Infotech
Vizual
VMware
Wipro
Yahoo
YASH Technologies
Zenith
Zensar Technologies
ZTE

DSRC Oracle based Interview Questions with Answers

Posted on :28-04-2016

Q1. What are the different types of Record groups in oracle? Explain each of them.

ANS:

Record group is an internal oracle forms data structure having a similar column-row structure and relationship as a database table.


Q2. What is a trace file and how is it created in oracle?

ANS:

Trace files are files used to store details of exceptions thrown by Oracle background processes i.e. dbwr, lgwr, pmon, smon etc. They are usually created for diagnostic dumps as well and help in debugging and solving exceptions in Oracle. 


Q3. What are the various Oracle Database objects?

ANS:

Various database objects are as follows: 
  1. Tables - This is a set of elements organized in vertical and horizontal fashion. 
  2. Tablespaces - This is a logical storage unit in Oracle. 
  3. Views - It is virtual table derived from one or more tables. 
  4. Indexes - This is a performance tuning method to process the records. 
  5. Synonyms - This is a name for tables. 
  6. Sequences.


Q4. List the types of joins used in writing SUBQUERIES.

ANS:
  1. Self join
  2. Outer Join
  3. Equi-join


Q5. Explain i.) Rename ii.) Alias.

ANS:

i) Rename - It is a permanent name provided to a table or column. 

ii) Alias - It is a temporary name provided to a table or column which gets over after the execution of SQL statement.


Q6. What is a view?

ANS:

It is virtual table which is defined as a stored procedure based on one or more tables.


Q7. What are the various components of physical database structure of Oracle database?

ANS:

Oracle database comprises of three kinds of files:
  1. Datafiles,
  2. Redo log files, 
  3. Control files.


Q8. List out the components of logical database structure of Oracle database.

ANS:
  1. Tablespaces 
  2. Databases schema objects.


Q9. What do you mean by a tablespace?

ANS:
  1. These are the Logical Storage Units into which a database is divided. 
  2. It is used to group together the related logical structures.


Q10. What is Control File used for?

ANS:

Control File is used for: 
  1. Database recovery. 
  2. Whenever an instance of an ORACLE database begins, its control file is used to identify the database and redo log files that must be opened for database operation to go ahead.


Q11. What is a synonym? What are its various types?

ANS:

A synonym can be called as an alias for a table, view, sequence or program unit. 

It is basically of two types: 
  1. Private - Only the owner can access it. 
  2. Public - Can be accessed by any database user.


Q12. What are the uses of synonyms?

ANS:
  1. Mask the real name and owner of an object.
  2. Provide public access to an object
  3. Provide location transparency for tables, views or program units of a remote database.
  4. Simplify the SQL statements for database users.


Q13. What do you mean by a deadlock?

ANS:
  1. When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock. 
  2. The reasons for it to happen are: 
  3. lack of proper row lock commands. 
  4. Poor design of front-end application
  5. It reduces the performance of the server severely.
  6. These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally.


Q14. What suggestions do you have to reduce the network traffic?

ANS:

Following are some of the actions which can be taken to reduce the network traffic: 
  1. Use snapshots to replicate data.
  2. Use remote procedure calls. 
  3. Replicate data in distributed environment.


Q15. What are the various types of snapshots?

ANS:

There are two types of snapshots: 
  1. Simple snapshots - Based on a query that does not contain GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.
  2. Complex snapshots- which contains atleast any one of the above.


Q16. What is a sub query? What are its various types?

ANS:

Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables. 
A sub query is added in the where clause of the main query.

There can be two types of subqueries: 

a.) Correlated sub query:
It can reference column in a table listed in the from list of the outer query but is not as independent as a query. .

b.) Non-Correlated sub query:
Results of this sub query are submitted to the main query or parent query.
It is independent like a query


  
   






FreshersLive - No.1 Job site in India. Here you can find latest 2016 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.

closepop
closepop