What is difference between db2 and sql?

1019

How many control files should you have? Where should they be located?

597

Why is group-clause used?

963

C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

2636

where the dff data will be stored

2471

Is storing images in a database a good idea?

1018

What is oracle data type?

978

How to prevent firebird.log file from filling up the disk partition?

939

What is the primary use of the model database?

1105

What are the steps you must follow to hide sql server instances?

999

what is normalization? Explain different levels of normalization? : Sql server database administration

1348

how we will Show selected records sorted in an ascending (asc) or descending (desc).

1000

How to revise and re-run the last sql command?

1178

Which are the third-party tools used in sql server and why would you use them?

930

What is the difference between between and in condition operators?

1023