1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Display the records between two range?

 2 2682

Select the Nth lowest value from a table?

 4 3742

What is difference between Rename and Alias?

 1 3689

Difference between an implicit & an explicit cursor.?

 2 6241

What is a OUTER JOIN?

 1 2087

What is the purpose of a cluster?

 1 2567

What is OCI. What are its uses?

 1 2373

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

 2 2746

Display Odd/ Even number of records?

 3 5379

What are various constraints used in SQL?

Polaris,

1 2954

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 3687

Can you use a commit statement within a database trigger?

 4 3889

What WHERE CURRENT OF clause does in a cursor?

 2 3156

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

 2 2997

Un-Answered Questions { Databases }

Is postgresql secure?

442

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1607

What is the oracle implicit cursor?

582

What is dense_rank in sql?

532

List types of tables in SQL Azure?

102




What is tkprof?

1

how can a session indicate its interest in receiving alerts?

557

What are the types of indexes that are present inside a database?

628

when does an alert gets signaled?

572

What is hibernate and its relation to sql?

585

What is database example?

465

What is the difference between layer and tier?

472

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

527

What is dbcc?

725

What is a temporal table?

482

For More Un-Answered { Databases } Questions Click Here