1. Categories >> Software >> Databases
  2. Suggest New Category


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,

1793

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

Oracle,

1 6158

What is trigger associated with the timer ?

Oracle,

1 5972

What are the trigger associated with image items ?

Oracle,

1 6125

What are the different windows events activated at runtime ?

Oracle,

2408

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

A1 Technology, Wipro,

31 56631

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

A1 Technology, TCS, Techicon,

10 16380

What is database schema?

Infosys,

4 14400

What is Reduced List of Values?

iFlex,

1700

What is Hash Index?

 1 5165

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 6100

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 16190

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

 2 6692

what is the difference between granting and creating a view?

 2 5135

How to return multiple records from procedure?

 2 7983

Un-Answered Questions { Databases }

Do you know what is normalization of database? What are its benefits?

557

What is a rollup clause?

543

You want to implement the one-to-one relationship while designing tables. How would you do it?

527

How do you create a table in pgadmin 4?

424

What do you understand by intension and extension?

491




Why olap is used?

561

Explain what is rdbms?

580

How efficient you are in oracle and SQL server?

634

State the difference between a primary key and foreign key?

511

Can objects of the same schema reside in different tablespace?

584

What is a primary index?

522

Explain few examples of stored procedure over triggers?

517

How do I find the default sql server instance?

516

What is data modeling with example?

528

What is the use solutions?

320

For More Un-Answered { Databases } Questions Click Here