GeekInterview.com
Series: Subject: Topic:

Oracle SQL Interview Questions

Showing Questions 181 - 190 of 190 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Why statistics are different in Oracle9i and Oracle 10g?

Asked By: Interview Candidate | Asked On: Jul 9th, 2005

Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_stats.Auto_sample_size.Executedbms_stats.Gather_schema_stats('scott',estimate_percent=>dbms_stats.Auto_sample_size,granularity=>'all',cascade=>true);

Answered by: Jian Zhang on: Oct 22nd, 2006

Deafult Optimizer9i: CHOOSE10g: CBO

Answered by: skumarpenugonda on: Jul 7th, 2006

Hi,I just started reading 10g. What I came to know that there are many features added and w.r.t. statistics, below are the changes, or new features.1. AWR ( Automatics Work Load repository )...

What is the internal structure of database and how SQL is related with it?

Asked By: amit mandal | Asked On: Aug 28th, 2006

Answered by: Maria Antony Samy on: Oct 14th, 2006

Very Simple question! But should be explained a lot.Databse data is stored in data_file's of the databse. For every table's data some space from the data_files would be allocated. This space is known ...

What are Oracle precompilers?

Asked By: Interview Candidate | Asked On: Aug 29th, 2004

Using Oracle precompilers, SQL statements and PL/SQL blocks can be contained inside 3GL programs written in c,c++,cobol,pascal, fortran,pl/1 and ada.The precompilers are known as pro*c,pro*cobol,...This form of PL/SQL is known as embedded PL/SQL,the language in which PL/SQL is embedded is known as the...

Answered by: RamaKrishna.Yerra,TCS,Hyd,9989018508 on: Aug 21st, 2006

Hi !! PRAGMA is one of the Precompiers of Oracle ..Wht it does is similar to Pre compier Directives in C Lang.. Thanks&RegdsRamaKrishna.Yerra,TCS,Hyd,9989018508

How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with primary key. Say for example emp and dept table. We have deptno in both...

Asked By: sbagai2001 | Asked On: May 26th, 2006

Answered by: dmadhusudhanarao on: Aug 2nd, 2006

see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.

Answered by: Prakash Pagam on: Jul 24th, 2006

We can do using databasename.tablename

Give is the maximum prime number which can be fit into 8-bit memory

Asked By: MANISHA | Asked On: Sep 27th, 2005

Answered by: Rajesh on: Jun 16th, 2006

253 is not prime, it is divisible by 11 and 23. So the ans. is 251.

Answered by: Ravi on: Apr 29th, 2006

Hi Guys:

Iam unable to follow ur discussion. why is it 251 and not 253. afterall we are finding the maximum (highest in value) prime number less than 255.

Please correct me if Iam wrong.

Thanks

Can a function take out parameters. If not why?

Asked By: Interview Candidate | Asked On: Aug 29th, 2004

No. A function has to return a value,an out parameter cannot return a value.

Answered by: ashvini on: Apr 24th, 2006

Yes ,function can return a value but it is not a good programming practice

Answered by: indrajit on: Nov 9th, 2005

Yes. Functions can have OUT parameter.

Difference between hash join and merge join

Asked By: Interview Candidate | Asked On: Jul 9th, 2005

Hash joing is implemented in cbo and comparatively faster.  merge joing is comparatively slow because both the row sources are to be sorted before merging.

Answered by: Sampath on: Oct 22nd, 2005

Hash join occupies lots of memory as it creates hashes

Can data be inserted/deleted/updated from clob,blob,nclob columns.If not why?

Asked By: Interview Candidate | Asked On: Jul 9th, 2005

Answered by: Vijay on: Jul 9th, 2005

Yes it possible to insert/update/delete data for CLOB, BLOB, NCLOB columns. Now how to do it.  1. Suppose if you are using JAVA applications to modify the database columns, then you have t...

How you were passing cursor variables in PL/SQL 2.2?

Asked By: Interview Candidate | Asked On: Aug 29th, 2004

In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using pro*c or oci with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

What is the meaning of cost, card, bytes?

Asked By: Interview Candidate | Asked On: Jul 9th, 2005

Cost is basically unit of work or resource used involved memory, i/oand cpu to execute the query.Card( or base cardinality) - is the number of rows in a base table captured by running statistics on the table. If u have incorrect statistics u will be having problem here.Bytes - represents number of bytes...

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.