Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 11754

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

Wipro, BeBo Technologies,

7 52907

What are inner join and outer join?

3 5954

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

CSC, TCS, AMDOC,

27 54273

what are Triggers?

TCS,

4 5928

what are stored procedures?

TCS,

6 4327

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

TCS, Green Info Solutions,

6 8953

what are views?

TCS,

7 10426

what is web server?

Satyam,

3 4335

What are functions

3 3739

What are the different table present in MYsql?

3 6294

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 5971

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

Oracle, i2,

2 12556

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

CA,

1 1356

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

2 2092



Un-Answered Questions { Databases }

What are the consideration at tehe migration of Oracle 9i to 10G.

1469


IS it possible to built the oracle database without setting the kernal parameters?

733


what is data access layer?

877


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

637


can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

664


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

25


Suppose database is running slow, what will you do?

663


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

445


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

605


Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

2072


if i want to display the name of students such that to which city they belong must have count greaer than two

741


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

829


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

497


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

553


write a query that returns first characters of each word in Oracel/Sql pl sql

4772