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

If you know "Access", you can capture data from "Excel" broadsheet, but the limitation is that, a memo data type of "Access" can only hold characters upto- (a)31,000; (b 32,000; (c)33,000; (d)34,000.

Wipro,

1 6517

whats the maximum size of view state??

2249

Its possible to add more than one primary key for the table

4 7941

Write a procedure to return the month and the number of developers joined in each month (cursor )

Tech Mahindra,

2 9749

How many Flexfields are there in AR and what are they ?

1 3105

What are User Exits and what are different types of User Exits in Oracle Apps ?

2 10654

What is an Invoice ? How many types of invoices are there in AP and AR ?

3 7227

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2369

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

Ion Exchange,

2 5080

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 3583

I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 8661

select 10 from dual; y its showing all the rows with 10?

1 5756

How can u get the number of pupils connecting the database?

Cap Gemini,

1 5778

How to a Query to copy data from on table to another table.

Cap Gemini,

6 9243

What is Schema in Database?

Cap Gemini,

1 5618

Un-Answered Questions { Databases }

What is 3nf in dbms?

952

Where is mysql data stored?

939

Explain index covering? List its merits.

1029

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3454

How do I open a pgadmin file in windows?

942

Where do we use pl sql?

1052

How can I create database in mysql?

982

What do you understand by aggregation and atomicity?

958

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2266

When should you increase copy latches? What parameters control copy latches?

607

How many types of cursors supported in pl/sql?

1260

What is procedure in mysql?

984

Explain how to use transactions efficiently : transact sql

1018

Can you explain what is the use of custom fields in report?

1102

What is gridfs in mongodb?

For More Un-Answered { Databases } Questions Click Here