Databases Interview Questions
Questions Answers Views Company eMail

How many primary keys can a table have?

533

Does truncate remove indexes?

560

How can we find duplicate records in a table?

513

Can we insert data in view?

504

How do I remove all records from a table?

564

Why truncate is faster than delete?

562

Are subqueries faster than joins?

574

Does truncate free space?

517

Can a foreign key be null?

589

How do you respond to dementia behavior?

533

Can we create clustered index without primary key?

523

How many types of index are there?

552

Is primary key an index?

535

How do you optimize a query?

537

Is natural join same as inner join?

507


Un-Answered Questions { Databases }

if some data is not transfered where it will get stored

1458


How do I remove all records from a table?

564


What is a database in healthcare?

490


What is the difference between set and select?

576


how to determine the service pack currently installed on sql server? : Sql server database administration

565






where can you add custom error messages to sql server? : Sql server administration

577


What is difference between inner join and join?

538


How we can create an index in mongodb?

1


What is pct free/pct used/pct increase parameter in segment? What is growth factor?

282


How will you add a dimension to cube? : sql server analysis services, ssas

552


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

636


What does over partition by mean in sql?

532


What is record data type?

516


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1559


Explain relational algebra?

505