Oracle SQL Interview Questions
Why statistics are different in Oracle9i and Oracle 10g?
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);
What is the internal structure of database and how SQL is related with it?
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 ...
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...
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
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.
We can do using databasename.tablename
Give is the maximum prime number which can be fit into 8-bit memory
253 is not prime, it is divisible by 11 and 23. So the ans. is 251.
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?
No. A function has to return a value,an out parameter cannot return a value.
Yes ,function can return a value but it is not a good programming practice
Yes. Functions can have OUT parameter.
Difference between hash join and merge join
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.
Hash join occupies lots of memory as it creates hashes
Can data be inserted/deleted/updated from clob,blob,nclob columns.If not why?
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?
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?
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...
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
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.
NH
Deafult Optimizer9i: CHOOSE10g: CBO
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 )...