1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

12 RULES OF RDBMS

 1 3706

How do we know whether an index is created on a table ???

TCS,

2 4915

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

 2 5167

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

Oracle,

1561

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

Oracle,

1 3817

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

 1 2789

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

HCL,

3 4285

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

HCL,

2 4215

select * from emp what happened internally when we write this query in the sql prompt?

 5 5898

can you explain performance tunning in oracle(sql,PL/SQL)

 2 3698

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

 1 3424

DBMS vs. RDBMS

TCS,

2 4406

Which database is better for os platform dependency?

 1 2933

Why we choose emp number as primarykey?

 4 5006

am completed mca2011 how get certification in oracle

 1 2325

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1464

What is a Garbage Collection? and what is full recursive Garbage collection?

2384

What is a database schema in oracle?

612

How can we delete duplicate rows in a table?

556

What is the usage of merge statement?

663




Why do we use bulk collect in oracle?

560

What are privileges and grants?

562

What is a system tablespace and when it is created?

555

How do I spool to a csv formatted file using sqlplus?

538

Why do you use stored procedures and state some of its disadvantages?

556

Please explain oracle left join with an example?

576

What is raw datatype in oracle?

573

What is instant client oracle?

533

Can we store pictures in the database and if so, how it can be done?

580

What are a collation and state the different types of collation sensitivity?

545

For More Un-Answered { Oracle General } Questions Click Here