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 2011

Clipper / DBF error

 1 2077

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

BT,

1626

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

TCS,

3 5787

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 4571

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

Oracle,

1 3317

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 3415

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 2926

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 3069

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 3117

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 2617

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 2704

how to we delete a row using varray

CTC,

3 3314

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

MasterCard,

2 3252

difference between bind variable and variable

Attra,

1 2331

Un-Answered Questions { Databases }

How to identify current user in ssrs report?

238

What are table partitions? How is it different with ase 15.0 version?

461

What do you mean by Checkbox ?

1923

What is InnoDB?

557

How do I find the size of a postgres table?

403




What does you mean by s4 super key?

558

What is the difference between primary key, foreign key and candidate key?

639

Explain what are the characteristics of data files?

618

What is difference between materialized view and view?

472

How does mongodb store data?

1

What is index fragmentation in ms sql server?

590

Why use “pivot” in sql server?

613

Difference between Row Id and Row Num?

375

Why do we need cursors in pl sql?

509

What are the types of table?

538

For More Un-Answered { Databases } Questions Click Here