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

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1 1959

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 3581

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

Telesis,

1 2136

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

7 11090

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23859

Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 8207

How to synchronize 2 schema's objects?

Virtusa,

1 2276

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1 2645

What is difference beteen Migration and Upgrdation?

Satyam,

7 25450

What are different types of Keys? Please explain all the keys with a suitable example.

4 27636

Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??

1 8778

why dont we assign not null constraint as table level constraint.

1 2821

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1 2536

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31909

What is row by row processing ?

2 8702

Un-Answered Questions { Databases }

How do I remove duplicates in two columns?

1178

Is there some bulk load or other way to import a lot of data fast?

931

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

How did mongodb get its name?

Suppose database is running slow, what will you do?

2590

What is the current mysql version?

1095

Can one drop a column from a table?

1081

how to start mysql server? : Sql dba

1260

how to use regular expression in pattern match conditions? : Sql dba

1105

How to rebuild the master database?

1160

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

1950

What are the types of database explain each of them briefly?

1053

How to write a left outer join with the where clause in oracle?

1149

Explain “row_number()” in sql server with an example?

1073

When should you use an instead of trigger?

1043

For More Un-Answered { Databases } Questions Click Here