1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Find all employees in Dept “Marketing”.

 2 3993

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.

2175

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

TCS,

3349

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).

Satyam,

5 6723

how to replace double quotes by single quotes in sql server

CAC,

2 12335

what is the difference between securityand protection in dbms?

 2 10655

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

 4 5309

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

 2 3825

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 6259

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

TCS,

9 9400

What is cluster table or non_cluster table?

 1 3342

How to do Data size testing? Who does this testing (Developer or tester)?

 2131

How to do Data integrity testing? Who does this testing (Developer or tester)?

 1618

How to do Stored procedure testing? Who does this testing (Developer or tester)?

 1393

What is the role of tester in discovery(in Checklist)?

 1461

Un-Answered Questions { Databases }

When is functional dependency said to be the fully functional dependency?

569

How can you find out how many users are currently logged into the database?

323

What are advantages of dateset in datastage?

1752

what is sql? : Sql dba

560

What are different types of joins in sql?

531




What is a collation?

596

what are the different type of sql's statements ? : Sql dba

522

Can group by and ordered by used in a single query?

537

Are semicolons required at the end of sql statements in sql server 2005?

570

What are the characteristics of data in the database?

477

How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

565

What are the key differences between SQL and PL SQL?

630

What is file manager?

506

Write the queries for commands like Create Table, Delete table, Drop Table etc.

618

How do you rename a procedure in mysql?

455

For More Un-Answered { Databases } Questions Click Here