Databases Interview Questions
Questions Answers Views Company eMail

how to find the second salary?

HCL, Prithvi,

10 10489

LOV can best describe a) window b)modal c)list d) none of these d)

ESS,

5 5741

can u plz provide me oca sql dumps please i need them

1439

i need query for displaying the eno,ename in a table from row 2 to row 5

1 2831

using primary can we relate two table, with out foreign key?

2273

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3962

what is the size of date datatype in sql?

2 4179

Which of the following is used to enter or display data via Internet? Data in it is stored as HTML files, with data read from and written to the database. Macros Queries Forms Pages

Wipro,

1 3963

is it necessary to write group by and order by clause together

HCL, Wipro,

3 9529

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

Sierra Atlantica,

1506

How to swap the data of two columns in a table. both the columns containing varchar values.

9 14745

how to calcuate the second highest salary of he employee

Synechron,

13 14916

what is outer join? what is selef join? what is difference between them? what is cartecion join?

Fiserv, Herbinger, Synechron,

1 10451

i need department wise top 2 employees salary.which logic i will use

17 27686

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 6291


Un-Answered Questions { Databases }

Is time a data type in sql?

458


What is sql prepared statement?

519


Explain the types of record group.

1


How to create nested stored procedure?

527


How do you remove duplicates without using distinct in sql?

475






what kind of lan types do you know? : Sql server database administration

486


What does ss stand for sexually?

553


Explain about your sql server dba experience? : sql server DBA

519


what is the difference between rownum pseudo column and row_number() function? : Sql dba

592


Explain the difference between rename and alias?

523


Is mongodb a backend?

1


What is fact and explain its types?

1


Is it possible to call a stored procedure within a stored procedure?

534


How to run sql functions in pl/sql?

522


How to enter unicode character string literals in ms sql server?

553