Databases Interview Questions
Questions Answers Views Company eMail

Is inner join same as self join?

587

Does group by remove duplicates?

556

Is inner join faster than left join?

641

Is primary key always clustered index?

541

Is primary key clustered index?

524

Can we rollback truncate?

544

Can delete statement be rollbacked?

529

Can we use distinct and group by together?

592

Do we need to rebuild index after truncate?

529

What is the basic form of sql query?

499

Is sql sequential or random?

543

Why truncate is used in sql?

533

How many types of indexes are there in sql?

540

What are sql procedures?

586

What is dense_rank in sql?

546


Un-Answered Questions { Databases }

How can you find out how many users are currently logged into the database? How can you find their operating system id?

262


What is the difference between insensitive and scroll cursor?

585


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4215


how can we repair a mysql table? : Sql dba

542


How do I find my mysql username and password?

552






Does sap use sql?

521


What is ms sql server reporting services?

512


What is sql clause?

545


What are joins in sql?

541


How to export data to a csv file?

629


What is mongodb config server?

1


State two functional blocks used in couchbase server?

1


What is meant by mysqli?

500


Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

299


How show all rows in sql?

616