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


Databases Interview Questions
Questions Answers Views Company eMail

how to display last 5 letters from a name (take emp table ename )

IBM,

6 7777

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

IBM,

6 8155

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

 1587

WHAT IS OPM?(IN DETAILED)

L&T,

1 9802

what is difference between having and where clause ?

 3 4583

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

ABC,

3 8079

How can we create the complete backup of data in the oracle.

IPEC, Satyam, SunTec,

1673

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

Satyam,

3 5649

Accidentally i deleted my table. How can i get that table?

 4 7725

how can i view structure of table in sql server? tell me that query.

 10 15526

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

 5 6956

How the log writer writes the data into database

Baidu, Satyam,

4 6312

what is the role of archiever

Baidu, Satyam, TCS,

4 6919

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 2871

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 9981

Un-Answered Questions { Databases }

Is ms sql is free?

521

How we can see all indexes defined for a table in mysql?

473

Why are function needed?

481

Why are you getting errors when creating a new odbc dsn?

577

Explain table valued parameters in sql server? Why tvp used?

543




Explain the cursor lock types?

541

Do you know how to implement service broker?

530

Write a syntax for update query in oracle?

606

How do clustered indexes store data?

599

What are mongodb indexes?

1

define primary key index, bitmap index, hash index,virtual indwx

2835

Where is postgresql conf?

439

What is rdms?

480

What options are available to audit login activity? : sql server security

627

Why are cursors used?

569

For More Un-Answered { Databases } Questions Click Here