Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 16726

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

Wipro, BeBo Technologies,

7 61987

What are inner join and outer join?

3 8609




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

CSC, TCS, Amdocs,

29 62471

what are Triggers?

TCS,

5 8820

what are stored procedures?

TCS,

6 7116

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

TCS, Green Info Solutions,

7 12121

what are views?

TCS,

7 13653

what is web server?

Satyam,

3 8119

What are functions

3 6342

What are the different table present in MYsql?

3 8603

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 8400

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

Oracle, i2,

2 14958

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

CA,

1 2675

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

2 3242







Un-Answered Questions { Databases }

how to solve cardinality in dbms...many to many ralationships

697


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

1629


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?

886


where do u put the report file

945


how to restore particular schema from rman full backup?

728






In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

876


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

5971


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

855


What is PL/SQL ?

445


I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

1175


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1227


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

747


Write short notes on manual refreshes.

1712


What are code pages ?

1064


what is logical system in sap basis

447