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 7434

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

Verizon,

6 9868

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 19959

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

Scope International,

4 17618

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 9904

what is the step for rmanbackup?

1 3925

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 10848

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

iNautix,

12 27239

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,

2538

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

CTS, iNautix, TCS,

4 8722

Un-Answered Questions { Databases }

Which tools are available to manage SQL Azure databases and servers?

115

Enlist the advantages of normalizing database.

1089

What is the difference between microsoft excel and microsoft access?

922

How do I copy a table in sql?

1042

How to define an anonymous procedure without variables?

1197

What is a function in oracle pl sql?

1098

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2176

Can sql function call stored procedure?

1074

what are user defined datatypes and when you should go for them? : Sql server database administration

1066

What happens when converting big values to integers?

1061

What are the various benefits of using rac architecture?

Which profile required to access Models in Designer tool?

749

How many categories of data types?

1043

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1184

What is an optimization and performance tuning and how does it really work in practical projects?

957

For More Un-Answered { Databases } Questions Click Here