Databases Interview Questions
Questions Answers Views Company eMail

what is primary key? : Sql dba

504

what is isam? : Sql dba

564

what are the type of locks ? : Sql dba

523

what is view? : Sql dba

553

what is a control file ? : Sql dba

569

what is the difference between undefined value and null value? : Sql dba

550

explain the difference between bool, tinyint and bit. : Sql dba

513

how mysql optimizes distinct? : Sql dba

541

how many ways we can we find the current date using mysql? : Sql dba

603

what are local and global variables and their differences? : Sql dba

526

how to enter numeric values as hex numbers? : Sql dba

561

what is datawarehouse? : Sql dba

560

what happens if null values are involved in expressions? : Sql dba

557

how many ways to get the current time? : Sql dba

520

how to enter binary numbers in sql statements? : Sql dba

485


Un-Answered Questions { Databases }

Explain the use of file option in exp command.

591


Explain oracle insert into command?

618


A scenario for amount correction & how to use amount correction functionality in AP invoices

1642


How can I create a database in mysql?

461


Explain about service Broker functions?

606






What do you know by pl/sql cursors?

556


How sql query is executed?

546


What are subqueries in sql server?

584


What is a group function explain with an example?

514


What kind of join is join?

545


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1547


What is the difference between mongodb and mongoose?

1


Explain filestream storage of sql server 2008?

509


How to view the log files in sybase?

482


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

486