Databases Interview Questions
Questions Answers Views Company eMail

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

Oracle,

1801

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

Oracle,

1 6167

What is trigger associated with the timer ?

Oracle,

1 5985

What are the trigger associated with image items ?

Oracle,

1 6135

What are the different windows events activated at runtime ?

Oracle,

2410

Can we use more than one null value for unique key?

A1 Technology, Wipro,

31 56836

how do u call in & out parameters for stored procedures?

A1 Technology, TCS, Techicon,

10 16445

What is database schema?

Infosys,

4 14428

What is Reduced List of Values?

iFlex,

1708

What is Hash Index?

1 5179

There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3i Infotech,

3 6126

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

Accenture, Unisoft Infotech,

2 16215

Give which cursor is better for better performance means type of cursors?

2 6700

what is the difference between granting and creating a view?

2 5147

How to return multiple records from procedure?

2 8002


Un-Answered Questions { Databases }

Explain the difference between primary key and candidate key in mysql?

520


What is row-level compre?

549


Is record in pl sql?

517


What is the name of query language used by neo4j?

1


What is a dba programmer?

302






What is bcnf in the dbms?

511


Why union all is faster than union?

510


What are the different sql commands?

525


What is a group function explain with an example?

523


What is 1nf normalization form?

601


What is trigger in sql and its types?

538


What is dbms pdf?

611


How view is different from a table?

560


What should be the fill factor for indexes created on tables? : sql server database administration

630


Characterize join and name diverse sorts of joins?

533