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

Mention what is new feature in oracle asm 12c?

Mention what is split brain syndrome in rac?

Mention what are the main components of an oracle rac system?

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How do you run ms_batch file in forms?

What is oracle d2k?

Which flexfields you have customized?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How I can use srw.run_report in reports6i?

Are you familiar with user exits in reports?

What is the anchoring in reports?

How many concurrent programs you have customized, can you name some of them?

Have you used lexical parameters in reports?

Un-Answered Questions { Databases }

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

970

Does creating a foreign key create an index?

850

Explain all codd's rules for relational database system?

965

What are instead of triggers?

1063

How to deactivate triggers?

937

Is sql free?

991

What are the two types of periodical indexes?

957

Differentiate between pl/sql and sql?

1167

What is autonumber in ms access?

892

Why variables called the most powerful component of ssis?

1099

How many types of rdbms are there?

915

where the connection string store in the database

2084

What is mongodb stitch?

What is use of term?

1084

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2086

For More Un-Answered { Databases } Questions Click Here