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


Databases Interview Questions
Questions Answers Views Company eMail

when loggined as SYSTEM,how to display all the users of database using sql query?

 2 3882

how to create a new database in oracle?

TCS,

6 6786

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

IBM, TCS,

7 6881

What is @@Identity in sql?

Cap Gemini,

1 5342

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 10427

What is Difference Between delete and Truncate?

 9 9056

What is Difference between StoredProcedure and function?

 3 6174

what is Difference between Having and Where clause?

IBM,

5 9234

How many rows will return from dual table?

Fujitsu,

4 10460

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

IBM,

1 4657

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

TCS,

2494

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

 1683

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

Goldman Sachs,

2038

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

Goldman Sachs,

1 5216

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

 1580

Un-Answered Questions { Databases }

What is a table called in database?

467

How does clustered and non clustered index work?

509

Consider you have the following three tables which have to be linked together.

484

What is the command to change the recovery model?

561

In mongodb how do you use $set to update a nested value?

5




Can we insert data into view?

514

How connect excel to sql server?

500

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

482

How do databases work?

501

What is the synonym of join?

515

What is the difference between python and sql?

514

Is trigger a stored procedure?

496

What is rowtype?

554

what is uncommittable transactions? : Transact sql

554

Can you load data into multiple tables at once? : aql loader

593

For More Un-Answered { Databases } Questions Click Here