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

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How to Debug a Stored Procedure?

Allianz,

5 11952

How to link up the text file to a Database table?

Allianz,

2 5225

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?

3 4838

What is a REF CURSOR? Compare strong and week ref cursor types.

6 26600

Which institute is best for SQL Server 2005 Training?

6 5566

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

Tech Mahindra,

1 10059

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 12977

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

Polaris,

7 15277

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

Polaris,

1 4478

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

2578

structural difference between bitmap and btree index ?

Infosys,

1 11330

How MySQL is different from SQL?

HCL, IBM,

17 18512

What is format trigger?

1618

How do I take a backup of Stored Procedure in Oracle?

3 28760

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 6232

Un-Answered Questions { Databases }

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1168

What is the command enable-debug?

496

What is the 3-tier architecture?

513

What is postgis used for?

421

What's the best database software for mac?

490

What are the different stages in 'data warehousing'?

473

State some of the criticism about sybase iq?

503

What is tkprof and how is it used?

288

What are the types of functions in sql?

569

Which is the latest version of sql server and when it is released?

550

What is sql injection? How to protect against sql injection attack?

557

What is striped backup

1832

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

467

What are some examples of schemas?

535

Put some light on multi-version concurrency control?

404

For More Un-Answered { Databases } Questions Click Here