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


Databases Interview Questions
Questions Answers Views Company eMail

How many primary keys can a table have?

 532

Does truncate remove indexes?

 559

How can we find duplicate records in a table?

 512

Can we insert data in view?

 502

How do I remove all records from a table?

 563

Why truncate is faster than delete?

 560

Are subqueries faster than joins?

 573

Does truncate free space?

 515

Can a foreign key be null?

 588

How do you respond to dementia behavior?

 531

Can we create clustered index without primary key?

 521

How many types of index are there?

 551

Is primary key an index?

 533

How do you optimize a query?

 536

Is natural join same as inner join?

 505

Un-Answered Questions { Databases }

What are the key characteristics of rac or why to use rac?

1

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

641

what are null values? : Sql dba

542

What are the dmvs?

568

Explain what is the function of sql server agent windows service?

543




How to use select statement to count the number of rows in oracle?

554

What is attribute relationships, why we need it? : sql server analysis services, ssas

500

What is the use of %rowtype?

535

How can you change the name of any existing table by using the sql statement?

510

Which is the best graph database?

533

What do you know about mongodb?

1

As couchdb is written in erlang and erlang is known as slow to adopt unicode. So, if it creates a problem for couchdb?

1

What is delete query?

519

How many employees does mongodb have?

1

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

569

For More Un-Answered { Databases } Questions Click Here