Databases Interview Questions
Questions Answers Views Company eMail

what are myisam tables? : Sql dba

535

how to increment dates by 1 in mysql? : Sql dba

528

what is sql in mysql? : Sql dba

559

how to show all tables with 'mysql'? : Sql dba

593

how many columns can be used for creating index? : Sql dba

505

how to rename an existing table in mysql? : Sql dba

560

Mention the differences between substr and charindex in sql server.

505

Write an sql query to find first weekday of the month?

475

What do you understand by triggers and mention the different types of it?

477

When do you think a developer should use sql server-based cursors?

509

Mention the differences between having and where clause.

543

Explain the usage of floor function in sql server.

494

What do you understand by replication in sql server?

560

What do you understand by hotfixes and patches in sql server?

504

Mention the different authentication modes in sql server.

516


Un-Answered Questions { Databases }

Why is stored procedure faster than query?

478


Describe in brief system database.

532


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

527


What is the usage of couchdb?

1


Explain transaction manager?

598






How do I find mysql database?

475


Tell me the phases a transaction has to undergo?

535


What is before trigger?

534


How does pl sql work?

513


What is dknf in normalization form?

549


if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1462


What is global database name?

537


What is the use of count (*) in sql?

532


What is oracle sid?

496


What is structural independence and why is it important?

537