GeekInterview.com
Series: Subject: Topic:

Oracle FAQs

 
Sub Categories (+ View)
Subject Name
Questions
Answers
Last updated
110
85
Nov
15th,
2011
Showing Questions 1 - 20 of 287 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

What is clustered table in Oracle? Difference between clustered table and view?

Asked By: Pradeep_Oracle | Asked On: Dec 12th, 2011

A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.

Answered by: ravinder on: May 4th, 2012

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.

Answered by: Lokesh M on: Feb 13th, 2012

A cluster is a group of tables which share the same data blocks. Clusters are an optional method of storing table data. Cluster share common columns and are often used together. It is a powerful met...

What is the difference between 9i and 10g.(especially I and g stands)

Asked By: Rampraas | Asked On: Mar 28th, 2006

Answered by: tej on: Apr 23rd, 2012

The Oracle version starting of I. The starting in 1999 with version 6i, 8i and 9i, I signify "Internet" means stands for "Internet" and Oracle added the "I" to the version name to reflect support for ...

Answered by: pradeep on: Aug 2nd, 2011

Oracle 9i and Oracle 10g....there are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automa...

Collection of privileges

Asked By: ccp3170 | Asked On: Sep 6th, 2010

What is a collection of privileges?

Answered by: BBBB on: Apr 19th, 2012

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Reverse a string in Oracle without using reverse

Asked By: amit88 | Asked On: Apr 5th, 2012

How do I reverse a dtring in Oracle without using PL/SQL and without using the reverse function??

Answered by: Mark Haynes on: Apr 13th, 2012

Are you looking for something like this?"plsql function revstring(instring varchar2) return varchar2 is rstring varchar2(750) := ; iCnt pls_integer; begin for icnt in reve...

What is a mutating trigger error? How can we resolve it?I need this reply asap. Thanks

Asked By: be17be | Asked On: Dec 1st, 2006

Answered by: Ashish on: Mar 24th, 2012

See, in oracle to maintain read consistency oracle keeps a copy in undo section of database for the data which is under modification by some transaction. And so readers do not wait for writers and ca...

Answered by: Kranthi on: Jul 13th, 2011

In before update/delete trigger if we use select statement for fetching the records.in this scenario will wet mutating trigger error.using row level trigger we can avoid instead of statement level trigger. we can accurate results.

Table contain 2 columns like name and genderfor that I need output like this..Countof female countofmale totalcountforeg 5 3 8

Asked By: viswam | Asked On: Oct 24th, 2006

Answered by: PK on: Feb 29th, 2012

There is one Oracle function ROLLUP, the same can be used for required output

QUERY:
SELECT GENDER,COUNT(GENDER)
FROM TABLE_NAME GROUP BY ROLLUP(GENDER);

Answered by: neelapu on: Apr 16th, 2010

SELECT COUNT(decode(sex1,'F',1)) "female count", 

COUNT(decode(sex1,'m',1)) "male count", 
COUNT(*) "total count"  
FROM

Materialized view memory space

Asked By: nageshk143 | Asked On: Jun 14th, 2010

How to see materialized view occupied memory space?

Answered by: PK on: Feb 29th, 2012

There is a data dictionary called as ALL_MVIEWS.
You can check the query and the length of the query in this data dictionary as

Select * from ALL_MVIEWS where MVIEW_NAME = MVIEWNAME

Join two columns with different datatype

Asked By: RPush | Asked On: Jul 7th, 2010

How to join two columns which is having different datatype? Say coulmn1 with varchar2 datatype and coulmn2 with long datatype.

Answered by: PK on: Feb 28th, 2012

You can join the columns with two different data types by using to_char, to_number to_date functions.
For e.g. one field is a varchar which stores number and other field is a number then you can use.
to_number(var_column) = number_column

Oracle program

Asked By: mishel | Asked On: Feb 23rd, 2012

Display list of jobs, number of employees of each job from departments 10 and 20. List only records if number of employees in each jobs are more than 1.

Use of constraint name

Asked By: svp.kiran | Asked On: Sep 28th, 2008

What is the use of mentioning of constraint_name along with not null constraint _type while creating a table?

Answered by: naizy_dba on: Feb 18th, 2012

Constraint are easy to reference if you give them a meaningful name. It is not necessary to assign name to constraint. If you do not assign any name to constraint Oracle will assign a name to constrai...

Answered by: jimmy.katiyar11 on: Nov 29th, 2011

Hi, Mainly use constraints for a businessmen rule that restrict enter the record in a table. IN oracle there are 5 type of constraints --- 1) Primary key, 2) foreign key 3) Unique key 4) Not NUll...

What is the use of SCN number? When does SCN increment?

Asked By: muralikasya | Asked On: Dec 22nd, 2011

Answered by: Neer.ocp10g on: Jan 20th, 2012

The SCN is an important quantifier that oracle uses to keep track of its state at any given point in time. The SCN is used to keep track of all changes within the database, its a logical timestamp tha...

Oracle synonym

Asked By: ccp3170 | Asked On: Sep 6th, 2010

What is a synonym in Oracle?

Answered by: jimmy.katiyar11 on: Nov 29th, 2011

Hi, In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
  1.  
  2.   CREATE SYNONYM synonym_name FOR table_name
  3.  
  4. You CREATE PUBLIC SYNONYM WITH the PUBLIC keywrd
  5.  
  6.  
  7. CREATE PUBLIC SYNONYM synonym_name FOR table_name

Answered by: Payal Shah on: Sep 5th, 2011

Synonum is a alias of the table..

How many types of triggers used in d2k report what r they?

Asked By: meghtripathy | Asked On: Oct 30th, 2006

Answered by: sateeshkonthala on: Nov 21st, 2011

There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before R...

Answered by: selvaspak on: Dec 31st, 2010

Total 5 Types of Trigger1. Before Parameter Trigger2. After parameter Trigger3. Before Report Trigger4. Between Pages Trigger5. After Report Triggerthe Action are given below1. Before Parameter T...

Identify instance name

Asked By: mojidra | Asked On: Oct 4th, 2008

How we identify instance name, free space, used space in database & datafile that makes up the system tablespace?

Answered by: kishore on: Nov 15th, 2011

how to find the instance name?


>select instance_name from v$instance;

Answered by: nattuduraip on: Dec 29th, 2010

Instance Name Is DATABASE NAME Default

Compund triggers

Asked By: balu.kolla | Asked On: Aug 18th, 2010

Explain the concept of compond triggers

Answered by: neeraj06.in on: Nov 10th, 2011

Compound Triggers: -> It combines all DML timing events into single trigger body. -> It also resolves mutating table error and enhance the code maintenance. -> The memory variables are persistent t...

What is the difference between chAR,varchAR,varchar2?

Asked By: praveen_garigipati | Asked On: Apr 5th, 2006

Answered by: ii on: Sep 21st, 2011

"c# SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dBConnection"].ToString()); con.Open(); DataSet ds = new DataSet(); SqlC...

Answered by: srinivas on: Sep 16th, 2011

Char: char is fixed length data type
VarChar:Varchar are variable in length In that varchar take the additional Memory bytes depending on the Declare the size of the variable.

Initsid.Ora is a parameter file.But which parameter file spfile or PFile?

Asked By: sirajdba | Asked On: Jun 26th, 2006

Answered by: MAHE on: Sep 16th, 2011

it is a Pfile

Answered by: hkrishna on: Jul 28th, 2008

Hi Friend,

Here is simple defination
initSID.ora will tell you SID is the database name where you are going to creating a new database.

when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you required use in database.

SCN and log sequence number

Asked By: gaurav_ry | Asked On: Sep 3rd, 2008

What are the differences and similarities (if any) between SCN and and log sequence number?

Answered by: sagar verma on: Sep 7th, 2011

The SCN plays an important role to determine if the database is in a consistent state when the database is brought online. SMON checks the SCN in all datafile headers when the database is started. Eve...

Difference between execute, execute query, execute update and execute batch.

Asked By: srinivas | Asked On: Jan 23rd, 2006

Answered by: do on: Aug 1st, 2011

Does it return only integer?

Answered by: taraldesai on: Mar 4th, 2009

Never seen in oracle

First | Prev | | Next | Last Page

 

 

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle DBA FAQ

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us:
 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".