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


Databases Interview Questions
Questions Answers Views Company eMail

syntex of insert

 7 5648

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 2590

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

Silicon,

1 3209

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

4 5723

How to Select second Maximum salary in a Table ?

Oracle,

13 11973

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

Oracle, SAH,

2 3781

what is the exact diiference between DBMS and RDBMS

Tesco,

4 6791

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 8330

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

 4 8377

why we use cursors

 1 2938

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

 1 2579

How to truncate a table first before running a package?

 1 3131

how to find full database size

BirlaSoft, Consultancy,

1 4869

How to change maximise or minimise the window in forms

Oracle,

4 10961

what is joins please explain breffly ??

Adaequare, TCS,

1 4125

Un-Answered Questions { Databases }

how to define testing of network layers? : Sql server database administration

486

Explain about SQL server 2005?

557

Do you know what are pages and extents? : SQL Server Architecture

548

Is sqlite faster than mysql?

489

Explain what is lock escalation and what is its purpose?

511




What is logical replication in postgresql?

503

What do you mean by deferred update in sybase?

516

How to use go command in "sqlcmd"?

642

You want to delete a table in sybase. How would you do it?

460

What are acid properties of transaction?

550

How do you trace the traffic hitting a sql server?

614

What is mysql and why it is used?

556

Why do we partition data?

613

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

529

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

547

For More Un-Answered { Databases } Questions Click Here