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 is the built-in used to get and set lov properties during run-time?

1 4956

What are the various methods of performing a calculation in a report ?

1 3836

Can a field be used in a report wihtout it appearing in any data group?

1 3997

what are different types of canvas views?

3 17926

Explain about stacked canvas views?

2 11367

what are the different objects that you cannot copy or reference in object groups?

1 3928

What are the triggers available in the reports?

3 5428

List some built-in routines used to manipulate images in image_item?

1 4385

What are modalless windows?

1 4223

Which of the two views should objects according to possession?

1 4406

Can a repeating frame be careated without a data group as a base?

2 4907

What is an anchoring object & what is its use?

2 5322

What is the built-in function used for finding the alert?

1 4275

What is the built_in routine used to count the no of rows in a group?

1 5541

How can a text file be attached to a report while creating in the report writer?

1 3642

Un-Answered Questions { Databases }

Why do you partition data?

1022

Can I use sql in mongodb?

What is 2nf and 3nf?

934

How many levels of sp nesting are possible?

1028

How do I create a schema in mysql?

875

How do I partition in sql?

964

What does an inner join do?

1183

What is the use of 'with check' option in views?

904

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1582

Why do you link tables in access?

875

What is dual table in postgresql?

784

what is the use of system.effective.date variable in oracle?

1116

How does sybase replication work?

893

How can you find out how many users are currently logged into the database?

606

What do you understand by unique key?

988

For More Un-Answered { Databases } Questions Click Here