Databases Interview Questions
Questions Answers Views Company eMail

What are the diifferences between the ms sql server vs mysql?

643

Which autogrowth database setting is good?

612

What types of replication are supported in sql server?

554

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

519

What is not null constraint?

611

How to get nth highest salary from employee table.

611

How would you add a section to a table?

560

What do you mean by stored techniques? How would we use it?

571

What does the argument [or replace] do?

566

what are integrity rules?

560

What are %type and %rowtype for?

605

What is a sql profiler?

580

How to select 10 records from a table?

639

How many times can we commit in a loop?

560

What is data manipulation language?

686


Un-Answered Questions { Databases }

What are the benefits of mongodb?

1


Is sql between inclusive?

580


How do I delete a query?

426


What is table level trigger?

573


how can we know the number of days between two given dates using mysql? : Sql dba

537






Define tempdb database?

587


What is an execution plan?

559


describe middleware applications that ease the connection of databases to web?

494


What does select * from mean in sql?

1977


What is db driver?

484


How to create table in particular schema in postgresql?

404


What is the process of copying data from table a to table b?

587


What is the difference between functions and stored procedures?

610


What is an external table?

579


Detail about query optimizer?

601