Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 10249

What is dataset and its uses

2 4242

get second maximum date from tables.

1 4081

1.display list of all users from ur data base.what is the query?

CGI, IBM,

3 7854

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 4897

I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........

1 3595

How to change location of errorlog in SQL?

ABC, IBM,

2 6120

check, not null,unique

IBM,

2 5260

Un-Answered Questions { Databases }

What does psql command do?

926

Explain a checkpoint and when does it occur?

1012

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2329

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

What is database clustering in mysql?

1036

What are the different pseudo commands? Explain in general?

1080

How many categories of data types used by sql server?

1020

What is substitution variable in pl sql?

1051

How do I connect to a postgresql database in windows?

914

Explain select statements in sql?

1059

What are different types of keys?

1106

Is mysql connect deprecated?

968

How many types of table in Oracle?

1128

How to get a list all databases on the sql server?

1105

What are the difference between sql and mongodb? Explain

For More Un-Answered { Databases } Questions Click Here