Data Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

Explain how you would restore a database using RMAN to Point in Time?

2155

How does Oracle guarantee data integrity of data changes?

2412

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 8981

From the database level, how can you tell under which time zone a database is operating?

1 3195

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 3234

What is Data Dictionary ?

2 5343

what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

NIIT, TCS,

2630

What is the difference between Connection Pool and data source?

HCL, HP, Polaris,

4 28659

What is DataSource ?how can its associated with connection pools ?

Wipro,

4 9532

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

Cognizant,

2 7891

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

Cognizant,

1 4052

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

Cognizant,

1 5394

if we have to upload the legacy data by using one transaction ex.me22, in bdc which way we will choose i.e. session method or call transaction? how we will choose that way? can we use both method in single program?

2 5011

In original biodata form identity certificate is there.we have to sign it by gazetted officer on original biodata form?

5341

How data flow from source to destination please Explain each step from layer to layer?

Cisco, HCL,

3 9304