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

Oracle (3259)
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.

1910

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

1 3486

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,

2085

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

IBM,

7 10799

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23373

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

2 8094

How to synchronize 2 schema's objects?

Virtusa,

2196

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.

2581

What is difference beteen Migration and Upgrdation?

Satyam,

7 25132

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

4 27446

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

1 8671

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

2748

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

2451

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31711

What is row by row processing ?

2 8570

Un-Answered Questions { Databases }

How can we force the database to use the user specified rollback segment?

1157

Which rman command is used to create an exact replica of a database innew host?

599

What is clause?

1162

Can you please explain the difference between function and stored procedure?

1022

What is the innodb in mysql?

1051

is there a column to which a default can't be bound? : Sql server database administration

1025

What is the exist operator?

What are points to remember while using the fillfactor argument?

978

What is normalization of database?

1122

What is use of except clause? How does it differ from not in clause?

1038

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2943

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4022

What are different type of normalization?

984

What is a Join and explain its types?

1114

Write a query to create a duplicate table with and without data present?

870

For More Un-Answered { Databases } Questions Click Here