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


Databases Interview Questions
Questions Answers Views Company eMail

Repair MS Access database without having program installed

HomeUs,

2 2014

Clipper / DBF error

 1 2081

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

BT,

1627

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

TCS,

3 5789

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 4576

I want to execute a piece of code before calling a procedure. How to achieve it?

Oracle,

1 3320

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

Maruti Suzuki,

2 3418

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

Maruti Suzuki,

2 2932

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

Maruti Suzuki,

2 3074

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 3118

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 2619

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 2707

how to we delete a row using varray

CTC,

3 3316

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 3256

difference between bind variable and variable

Attra,

1 2334

Un-Answered Questions { Databases }

How many types of database software are there?

285

Is postgresql scalable?

390

What are the different technologies used to access Database from Visual Basic?

515

What is an Entity set?

542

What is an agent and What are the types of agents?

301




What is chargeback invoice? How do we create it? : oracle accounts receivable

719

How can I get data from a database on another server?

503

Why are views required in the sql server or in any other database?

527

What do you understand by format trigger?

1

Can we store videos in mysql database?

487

How do I install the latest mysql on ubuntu?

482

What is oracle partial backup?

304

I want to find out all databases starting with ‘test’, I have access to?

663

Does postgres use sql?

433

What is primary key in dbms?

489

For More Un-Answered { Databases } Questions Click Here