Databases Interview Questions
Questions Answers Views Company eMail

How can set the multipal database ?

CitiGroup,

2456

where do i find oracle interview questions.

1 3376

real time applications of nullif?

3 4950

Which is the best place or learning center for MS SQL?????In Bangladesh?????

TCL, Wipro,

1596

what is data independence exactly? give an example

6 40141

waht is the difference between primary key and super key?

9 29492

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 7150

from the table display the 2nd highest salary? and also the least 2nd salay?

8 8308

what is the output for this query select * from employee where 1=1;

4 12854

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 8351

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

RND Soft, Wipro,

3 6001

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

TCS,

1615

what is normalization

NIC,

2 4582

How can we know the exact updation date of a particular database?

Satyam,

2 4447

I have two sql database at different PC.how can link b/w database and database tables.

2 4529


Un-Answered Questions { Databases }

Explain procedure to change characterset of a database.

333


What are number line correlation administrators will use while working with a subquery?

629


What is blob and text in mysql?

616


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1647


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

547






What is blob datatype?

571


List the advantages of using stored procedures?

563


What is the return type of mysqli_query?

467


What is the contrast between sql and mysql?

594


What is the default '-sort' order for a sql?

519


How to Change a users password from unix shell.

572


What is the advantage of index in sql?

541


what is dbms? : Sql dba

545


What is primary and foreign key?

593


How do I change the max connections in mysql?

470