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

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 7326

how to get the second max val for every group in a table

Verizon,

6 9695

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

Oracle, TCS, Tecnics,

4 19823

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

Scope International,

4 17454

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

Scope International,

3 9797

what is the step for rmanbackup?

1 3816

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 10681

Write a query to get last 10 records from the table.

iNautix,

12 26830

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

TCS,

2494

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

CTS, iNautix, TCS,

4 8561

Un-Answered Questions { Databases }

Can we perform backup restore operation on tempdb? : sql server database administration

1001

How many types of km's? And you what are the type's km are used in your project?

577

What do you mean by oracle dba?

570

What is executive plan?

917

Can you tell me about the concept of ER diagrams?

1082

What does blob mean in mysql?

967

What is the contrast amongst drop and truncate?

1034

What are the topics in pl sql?

974

What is row level locking in access?

891

What is t-sql script to take database offline – take database online.

1088

What are the different ways you can create databases in sql server?

1109

What is data control language (dcl)?

1143

How can you determine the space left in a file system?

649

How to select some rows from a table in oracle?

1078

Compare sql & pl/sql

1143

For More Un-Answered { Databases } Questions Click Here