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


Databases Interview Questions
Questions Answers Views Company eMail

What is the between Function and Procedure?

HCL,

3 4999

how can i lock the column in the table

Accenture,

2 6147

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

 2 4013

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

 1 2513

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

IBM,

13 16149

can you give me the syntax of named procedure??

 2 3577

How can we check whether A S M instance is up or down?

Excelacom, HCL,

1977

How can we tune if buffer busy wait issue comes in oracle?

IBM,

1 3049

How can we tune a oracle database if log file sync issue comes

L&T,

1684

What are different types of refreshment techniques of materialised view

 2 7227

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

 8 9591

how to get the salary in descending order with out using the keyword desc in sql

Ramco,

5 8553

12 RULES OF RDBMS

 1 3741

What is the relation b/w view and trigger

Accenture, TCS,

3 14795

can i use global variables in stored procedure or function

L&T,

1 7508

Un-Answered Questions { Databases }

What is the difference between the conventional and direct path loads? : aql loader

707

Explain the functionalities that views support?

703

Is postgresql object oriented?

438

What are Heap tables?

858

In which files does sql server actually store data?

493




What is ole db used for?

594

What is triggers and how it can be used in mysql?

539

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

659

How do I change mysql password?

503

When do I need to use a semicolon vs a slash in oracle sql?

604

What is database optimization?

525

what is data manipulation language? : Sql dba

546

Write a trigger example in oracle?

594

Describe the functionalities that views support.

678

How are the exceptions handled in sql server programming?

615

For More Un-Answered { Databases } Questions Click Here