Databases Interview Questions
Questions Answers Views Company eMail

Is left join faster than join?

542

Does inner join remove duplicates?

522

Can we rollback after truncate?

563

Can we create a trigger on view?

487

Does truncate release storage space?

558

Are views faster than queries?

546

Can we perform dml on view?

552

How does a trigger work?

533

Can we insert delete data in view?

542

How does a covering index work?

526

Can we have two clustered index on a table?

562

How many types of primary keys are there?

527

Can we insert data into view?

525

How do you define a foreign key?

534

Can we join tables without foreign key?

520


Un-Answered Questions { Databases }

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1655


What is tabulation?

553


Can you insert NULL in unique column?

625


Explain user account with reference to oracle.

530


How do you create a db file?

520






ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1743


How to execute a stored program unit?

581


Where do we use connected and un connected lookups?

1


What is the syntax of update document?

5


How to choose all records from the table?

653


What is replication and database mirroring?

576


What is microsoft access 2013 runtime?

468


How to check if a column is nullable before setting to nullable?

580


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

596


What is a result set object returned by odbc_exec()?

546