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


Databases Interview Questions
Questions Answers Views Company eMail

what is the purpose of catlaog in oracle rman?

Value Labs,

2 4211

what is the difference between hot backup n rman backup?

Value Labs,

1 14251

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

BOB Technologies, Cap Gemini, IBM,

2 7851

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

 1467

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

TCS,

1 3770

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

Polaris,

1 6159

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

Accenture,

1 9024

Magic Tables ?

Thomson Reuters,

2 5312

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 4207

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 3634

CTE(common table expression)

Thomson Reuters,

1 7782

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 11951

what is Covering Index ?

Thomson Reuters,

3 6035

How to create a view on a table which does not exists

Oracle, TCS,

4 19583

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

TCS,

1 5624

Un-Answered Questions { Databases }

How can you find all the processes on your system?

293

What is artificial key?

525

Explain top-n analysis in DBMS.

1042

When should you not use firebase?

607

How many types of functions are there in sql server?

457




Explain the types of exception?

650

How many commands are there in sql?

545

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2013

What is the difference between pl and sql?

541

 What are the oracle DML commands possible through an update strategy?

579

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

575

What is clustered vs nonclustered index?

505

What is openedge rdbms?

549

What are different between mongodb and sql server databases?

5

What is having clause in sql?

527

For More Un-Answered { Databases } Questions Click Here