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

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

how to create a database in oracle?

3 7269

select empid empname from employee What is the result for the about query?

4 7971

what are corelated subqueries

Global Infotech,

1 2930

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 6442

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3907

who is the father of oracle and send chodd rules

ME,

4 19218

one table has four field id,name,design,salary. i have to find maximum salary .

6 8062

In a package if we have 10 procedures or functions,How to know which will execute first?

Sollet Soft,

1 7268

what is data access layer?

1 2466

what is the difrence between sql and pl/sql

Wipro,

21 29221

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 10781

query to find the maximum no persons with same age(age colomn) from emp table

1 4925

How to find the date and time of last updated table?

4 7211

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 5083

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

Oracle, TCS,

13 23120

Un-Answered Questions { Databases }

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

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?

2560

How to define array in mongoose schema?

Can you index views?

953

Is it possible to have clustered index on separate drive from original table location?

1036

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1192

What are the source of constraints?

1006

What is clustered index

1083

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

Equi join and non equi join is possible with sql server?

1130

what is spatial nonclustered index

1054

How do I remove duplicates in two columns?

1179

Is inner join faster than left join?

1273

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1952

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2292

For More Un-Answered { Databases } Questions Click Here