Databases Interview Questions
Questions Answers Views Company eMail

What are advantages fo Stored Procedures?

1 2498

What are the uses of Database Trigger ?

1100

What is Database Trigger ?

1 2216

Can the default values be assigned to actual parameters?

1 2037

Can a primary key contain more than one columns?

2 2762

What is an UTL_FILE.What are different procedures and functions associated with it?

1 2655

Differentiate between TRUNCATE and DELETE?

2 2107

What is difference between a formal and an actual parameter?

1 1960

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2061

What are different Oracle database objects?

1 1947

What is difference between SUBSTR and INSTR?

1 2202

Display the number value in Words?

1 2378

What is difference between SQL and SQL*PLUS?

1 2125

What are various joins used while writing SUBQUERIES?

2 3082

What a SELECT FOR UPDATE cursor represent.?

1 2206


Un-Answered Questions { Databases }

What do you mean by an execution plan? Why is it used? How would you view it?

527


What are the differences between char and nchar?

530


When you used JKM ?

312


What do you understand by functional dependency and transitive dependency in dbms?

474


How do I delete a table in postgresql?

434






how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173


How do I debug a stored procedure?

625


Why is databases important in healthcare?

539


Is mongodb publicly traded?

1


How to fine-tune reports?

151


What is table value parameters (tvp)?

541


What are the security alerts while using mysql?

575


How would you determine who has added a row to a table?

1792


Explain cascading triggers.

572


What are 4 types of models?

460