Databases Interview Questions
Questions Answers Views Company eMail

Explain datetimeoffset data type in sal server 2008?

507

What is buffer cash in sql server?

579

Define master database?

556

Explain transaction server auto commit?

517

What are the essential components of sql server service broker?

534

Why do we use non clustered index?

537

How to use the inserted and deleted pseudo tables?

521

Define full outer join?

500

Explain concepts of analysis services?

488

Explain where clause?

515

What are the advantages of sql stored procedure?

514

Explain syntax for disabling triggers?

500

Define left outer join?

552

How dts is used to extract, transform and consolidate data?

572

How to implement service broker?

502


Un-Answered Questions { Databases }

How would you extract DDL of a table without using a GUI tool?

2016


How would you import a sharepoint list?

461


What is primefaces used for?

541


Which certification is best for sql?

510


What is create command?

503






Define database model.

584


How to return multiple rows from the stored procedure?

497


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

531


What is mysql slow query?

501


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

526


How you can export data in excel format?

479


Where is mongodb located?

1


When to use ms access vs excel?

424


How mongodb works? Explain

1


What is ASM (Automatic Storage Management) in Oracle?

688