Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 16206

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 61309

What are inner join and outer join?

3 8327




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 61537

what are Triggers?

TCS,

5 8360

what are stored procedures?

TCS,

6 6735

what are indexes..how many types of index's are there and what are they?

TCS, Green Info Solutions,

7 11713

what are views?

TCS,

7 13239

what is web server?

Satyam,

3 7685

What are functions

3 6018

What are the different table present in MYsql?

3 8303

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 8023

what is the difference between oracle 81,91,11i

Oracle, i2,

2 14742

How client makes connection with server in client/server architecture?

CA,

1 2475

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 3073







Un-Answered Questions { Databases }

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

801


Is there any link between pr form(purchse requisition)and po form(purchase order)

1080


What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

913


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

913


What is the mandatory setup in cyclecount ?

1239






how do u setup a replication site?

776


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

969


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

681


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1167


Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5773


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

832


How would you best determine why your MVIEW couldn't FAST REFRESH?

1135


How to synchronize 2 schema's objects?

985


did u received a single file or multiple files

934


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

934