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 10520

What is dataset and its uses

2 4321

get second maximum date from tables.

1 4147

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

CGI, IBM,

3 8022

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 5012

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 3685

How to change location of errorlog in SQL?

ABC, IBM,

2 6227

check, not null,unique

IBM,

2 5368

Un-Answered Questions { Databases }

What is a mysql view?

917

What is the difference between mongodb and redis database?

What is the difference between online and offline backups?

1139

What are scheduled tasks in sql server?

1160

Does amazon use mongodb?

How does using a separate hard drive for several database objects improves performance right away?

992

How to define and use table alias names in ms sql server?

1220

Do you know what are acid properties?

1127

what is cursor. write example of it. What are the attributes of cursor.

1471

What are different types of transactions in ar? : oracle accounts receivable

1375

What is called dbms?

1152

Do while loop in mysql procedure?

1122

How do I upgrade sql?

1053

What does the option psql -l of PostgreSQL display?

1516

Is ms access hard to learn?

818

For More Un-Answered { Databases } Questions Click Here