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.

1900

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

1 3474

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,

2072

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

IBM,

7 10790

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23328

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

2 8076

How to synchronize 2 schema's objects?

Virtusa,

2186

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.

2570

What is difference beteen Migration and Upgrdation?

Satyam,

7 25094

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

4 27414

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

1 8662

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

2740

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

2438

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31693

What is row by row processing ?

2 8562

Un-Answered Questions { Databases }

What is the most common database language that a db administrator needs to know?

577

Does office 365 include microsoft access?

821

How do I connect to an rds postgres database?

904

What is left inner join in sql?

1050

Explain the table term used in database.

1048

what is msql? : Sql dba

994

What is the sid in oracle?

972

How do I create a sql script?

1106

What is replica set in mongodb?

Explain having clause?

972

Is mysql from oracle?

974

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1274

Is mongodb a nosql?

Write short notes on manual refreshes.

2742

How heap is implemented in database?

1176

For More Un-Answered { Databases } Questions Click Here