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


Databases Interview Questions
Questions Answers Views Company eMail

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

Mind Tree,

24 24367

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?

IBM,

4 5653

what is the difernece between named and anonymous pl/sql blocks??

TCS, Wells Fargo,

8 18448

What are ACID Properties?

TCS,

1 4973

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 13334

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

IBM,

2 6097

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

CarrizalSoft Technologies, iGate,

3 11639

What is the Extension of Oracle Database? As extension of Access Database is .mdb

 2 7819

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

3i Infotech, Rolta, TCS,

17 14495

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

 3 5187

Explain Trigger with an example?

2 11217

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

 3 4250

how to do application monitoring through AutoSys?

Cognizant,

3 26221

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

 2 3617

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

HCL,

1495

Un-Answered Questions { Databases }

How can we run batch mode in mysql?

550

Explain transaction server implicit?

526

What is procedure explain with example?

544

How to make the project as .exe file in oracle forms & reports(d2k)?

1

Can we use view in stored procedure?

514




Explain what is lock escalation?

581

Why Update is too slow

956

What is self referencing foreign key?

418

How to download oracle sql developer?

667

What is a left join mysql?

480

Which command is used for user defined error messages?

565

How to run pl/sql statements in sql*plus?

594

What are the tools of ms access?

427

How to start an oracle instance?

576

What is vacuuming in postgresql?

379

For More Un-Answered { Databases } Questions Click Here