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

Can we create an List of Values without an RECORD GROUP ?

2 4413

How many number of columns can a RECORD GROUP have ?

2070

Oracle precompiler translates the EMBEDDED SQL statemens into ?

1 5349

what Kind of COMMENT statements placed within SQL statements ?

2 4624

What is TERM ?

1 3421

For a field in a repeating frame, can the source come from a column ?

1 3631

What are the different file extensions that are created by Oracle ?

2 14442

Is it possible to Disable the Parameter form while running the report ?

1 6775

What are the SQL clauses supported in the link property sheet ?

1 3703

What are the types of Calculated columns available ?

1 3849

What are the different Sequence of events takes place while starting a Database ?

KPSC Karnataka Public Service Corporation,

1 5671

When the SYSTEM TABLESPACE can be made off-line ?

2 5673

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 5137

How the SMON process is used to write into LOG files ?

HCL,

2 8221

what is the use of EXP command ?

2 9072

Un-Answered Questions { Databases }

How to create a dynamic cursor with the dynamic option?

1104

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1012

What are ddl statements in oracle?

1128

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

926

How to change the data type of an existing column with "alter table" statements in ms sql server?

1039

How many databases can sql express handle?

1031

When using oracle export/import what character set concerns might come up? How do you handle them?

629

Does partitioning help performance?

997

What is auto increment in sql?

1177

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

What is bind reference and how can it be created?

1069

Mention what plvcmt and plvrb does in pl/sql?

1200

System tablespace cant be exported from one database and imported into another why?

592

Explain what is log shipping?

1195

How do I run a sql query?

1082

For More Un-Answered { Databases } Questions Click Here