define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more.
How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id
Why you are not able to create a table using select
command,if it is having a LONG column?
for eg:create table test as select * from test1
here test1 containg a column having LONG datatype...
If i can use sys.check_constraints to display my constraints
from my database using sql server 2005, how can i display
then if i am using sql server 2000????
How would you go about increasing the buffer cache hit
ratio?
0. Explain the difference between a hot backup and a cold
backup and the benefits associated with each
1. You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
2. How do you switch from an init.ora file to a spfile?
3. Explain the difference between a data block, an extent
and a segment.
4. Give two examples of how you might determine the
structure of the table DEPT.
5. Where would you look for errors from the database engine?
6. Compare and contrast TRUNCATE and DELETE for a table.
7. Give the reasoning behind using an index.
8. Give the two types of tables involved in producing a star
schema and the type of data they hold.
9. What type of index should you use on a fact table?
10. Give two examples of referential integrity constraints.
11. A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
12. Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
13. What command would you use to create a backup control
file?
14. Give the stages of instance startup to a usable state
where normal users may access it.
15. What column differentiates the V$ views to the GV$ views
and how?
16. How would you go about generating an EXPLAIN plan?
42
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
37
after tell procedure whole code he asked can i write the
same way in a function
136
How consistent is the view of the data between and within
multiple sessions, transactions or statements ?
95
GLOBAL TEMPORARY TABLE over Views in advantages insolving
mutating error?
1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...
--------------------------
2.what is the difference between the varray and index by
table ..
--------
3.
type type_name is table of number(8,3)
index by binary_integer;
identifier_name type_name;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
hello.....
i am an comp science engineering graduate planning to do
ORACLE certification in PLSQL 9i. just wanted to know whats
the possibility getting job is their openings???? is it
worth doin that course n certification
45
write a procedure to print a statement or number not
using "dbms_output.put_line" package.write a procedure
instead of it using procdure name as "print"
ex:-
declare
a number:=2;
begin
print(a);
end;
/* when U type above procedure 2 have to should be printed*/
C. Normalize the following data up to the 3rd Normal
form. Create the tables and insert the data given.
Emp_ID Name Dept_Name Salary
Course_Title Date_Completed
100 Adam Marketing 48,000 SPSS 6/19/2008
Surveys 10/7/2008
140 Bob Accounting 52,000 Tax Acc 12/8/2008
110 Cathy IT SQL Server 1/12/2008
C# 4/22/2008
190 Dan Finance
150 Emily Marketing 55,000 SPSS 6/16/2008
42,000 Analysis 8/12/2008
Queries
1. Find all Names who have completed the SPSS Course.
2. Find employee with max salary.
3. Find employee with 2nd max salary.
4. Find all employees in Dept “Marketing”.
5. Find all the employees who have taken more than 2
courses.
6. Find all the employees who have completed the courses
before month of September.
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
