Databases Interview Questions
Questions Answers Views Company eMail

How many primary keys can a table have?

773

Does truncate remove indexes?

774

How can we find duplicate records in a table?

715

Can we insert data in view?

729

How do I remove all records from a table?

824

Why truncate is faster than delete?

857

Are subqueries faster than joins?

764

Does truncate free space?

755

Can a foreign key be null?

844

How do you respond to dementia behavior?

766

Can we create clustered index without primary key?

747

How many types of index are there?

755

Is primary key an index?

759

How do you optimize a query?

782

Is natural join same as inner join?

719


Un-Answered Questions { Databases }

What are the two major subsystems of system r?

851


what are all the common sql function? : Sql dba

831


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1826


Can two tables have same primary key?

778


Define truncate and delete commands?

738


What is Database Management System?

857


Explain the term ‘relations’?

685


In which language it is written?

742


What is tier in database?

614


What are sql azure firewall rules?

101


How can I delete duplicate rows?

789


What is difference between commit and rollback when used in transactions?

720


Which data dictionary views have the information on the triggers that are available in the database?

1002


What is stretch database in sql server?

840


How to filter records of table in SQL SERVER?

845