Databases Interview Questions
Questions Answers Views Company eMail

What is the contrast between sql and mysql?

567

What are the different types of sub-queries?

578

How to choose all records from the table?

631

What is an index. What are the types?

559

What happens on checkpoint?

592

Distinguish between nested subquery and correlated subquery?

525

Define synonym?

705

What are the different ways you can create databases in sql server?

544

How many null values we can have in a unique key field in sql server?

532

How would we use distinct statement? What is its use?

582

What are scalar functions in sql?

581

What are distinctive joins find as a part of sql?

537

What are diverse clauses that form a part of sql?

575

Define primary key?

636

What is the distinction amongst delete and truncate?

567


Un-Answered Questions { Databases }

What is the difference between count and distinct count?

447


What are the common performance issues in sql server?

477


Differentiate between pre-select and pre-query?

594


Is mongodb single threaded?

1


How do you run a trace?

500






Is sql scripting language?

506


What is normalisation and its type?

522


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1512


What is the use of sqldataadapter?

505


What is the difference between "as" and "is" in an oracle stored procedure?

514


Which is faster union or join?

466


what is datawarehouse? : Sql dba

548


What is a cache in ssrs?

108


Is primary key indexed by default?

419


How to get the definition of a stored procedure back?

507