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


Databases Interview Questions
Questions Answers Views Company eMail

syntex of insert

 7 5660

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 2602

What are the mandatory setups in setting up a PO in oracle

Silicon,

1 3223

is it sufficient to normalize a database up to 3NF?

4 5743

How to Select second Maximum salary in a Table ?

Oracle,

13 12009

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

Oracle, SAH,

2 3814

what is the exact diiference between DBMS and RDBMS

Tesco,

4 6811

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

Cap Gemini, TCS,

1 8343

how many no of table can be join in a sql query.

 4 8396

why we use cursors

 1 2947

what is package configuration variable?How to change file name in folder dynamically?Plz help me

 1 2590

How to truncate a table first before running a package?

 1 3142

how to find full database size

BirlaSoft, Consultancy,

1 4877

How to change maximise or minimise the window in forms

Oracle,

4 10972

what is joins please explain breffly ??

Adaequare, TCS,

1 4135

Un-Answered Questions { Databases }

Explain foreign key in sql?

625

Define database.

566

Explain update statistics.

500

Can you drop all the columns of a table ?

540

Can you always create a cache of a report?

115




How would you check the long running transaction?

482

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

733

Why do we need foreign key?

481

Explain four layers of abstraction microsoft architectured?

124

What is a trigger word?

516

How to turn on or off recycle bin for the instance?

611

How to check if a column is nullable before setting to nullable?

589

How to manage transaction isolation level?

565

What does psql command do?

464

What does the update command do?

617

For More Un-Answered { Databases } Questions Click Here