Sign Up Login


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How many primary keys can a table have?

 740

Does truncate remove indexes?

 742

How can we find duplicate records in a table?

 684

Can we insert data in view?

 701

How do I remove all records from a table?

 790

Why truncate is faster than delete?

 817

Are subqueries faster than joins?

 743

Does truncate free space?

 722

Can a foreign key be null?

 815

How do you respond to dementia behavior?

 733

Can we create clustered index without primary key?

 723

How many types of index are there?

 734

Is primary key an index?

 724

How do you optimize a query?

 742

Is natural join same as inner join?

 687

Un-Answered Questions { Databases }

How to create a table?

712

How do you rebuild an identity column?

737

How to rename an existing column with sql server management studio?

702

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2035

Why do we need normalization?

684

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1787

Explain tables in SQL Azure?

114

what is blocking? : Sql server database administration

750

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

690

Describe how to use the linked server?

826

When can we use the where clause and the having clause?

786

What is the syntax to execute the sys.dm_db_missing_index_details?

762

Which profile required to access solution in Designer tool?

417

Explain different types of self contained sub query?

748

What is the order by used for?

799

For More Un-Answered { Databases } Questions Click Here