Databases Interview Questions
Questions Answers Views Company eMail

Display the records between two range?

2 2684

Select the Nth lowest value from a table?

4 3747

What is difference between Rename and Alias?

1 3691

Difference between an implicit & an explicit cursor.?

2 6243

What is a OUTER JOIN?

1 2087

What is the purpose of a cluster?

1 2568

What is OCI. What are its uses?

1 2375

How you open and close a cursor variable.Why it is required?

2 2751

Display Odd/ Even number of records?

3 5381

What are various constraints used in SQL?

Polaris,

1 2957

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3054

Difference between NO DATA FOUND and %NOTFOUND?

1 3690

Can you use a commit statement within a database trigger?

4 3892

What WHERE CURRENT OF clause does in a cursor?

2 3158

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 3001


Un-Answered Questions { Databases }

What is the starting oracle error number?

558


What is the tcp/ip port on which sql server runs?

559


How do I bcp null dates in sybase?

453


Whis is not false in primary key?

968


How to create a stock management database in microsoft access?

453






What is Fully Functional dependency?

553


How do I uninstall sql server 2014?

514


What is the best database?

518


What is difference between views and tables?

457


What is the data quality?

296


8. Supporting AP, AR and GL?

1803


What is sequences in postgresql?

433


How to control the max size of a heap table?

546


how to create a table index in mysql? : Sql dba

588


Can you skip header records while loading? : aql loader

533