Earn Money
Trading Forex Online
Paramount Airways
Free Data Recovery
Cargo
Job Portal
HSBC Investment
Management
Cheap Web Hosting
Make Trip
Cheap Air Travel
Leisure Hotel
Free Air Travel
Mutual Fund Informations
Cheapest Cellular Plan
Free Sexy Indians
Call Center Software
Hot Indian
|
Programming Help |
Homework Help |
Counseling
Astrology Advice |
Tarot Advice |
Parenting
Dating Advice |
Love Advice |
Divorce Advice
Legal Advice |
Debt Advice |
Career Advice
types of indexing
DML,DDL, SQL querry,primary key, whts a null
diff btw DDL,DML, whts parallel DML,
whts normalisation explain with example till 3NF
6>need for normalisation
differnce btw oracle 8.0,8i,9i
what are pseudocolumns? given example.
(CURRVAl,LEVEL,NEXTVAL,ROWID,ROWNUM)
what are synonyms ? example.
( an alias name to the table , which is used for
location transperancy.)
CREATE SYNONYM emp2 FOR emp@newyork;
SELECT ename, job INTO my_ename, my_job
FROM emp2
WHERE empno = my_empno;
what are snapshots.
what is indexing. what are its advantages.
what is cluster. advantages.
how do you add primary key to the table already
existing.
what is table space.
what partitioning. how many types of partitions.
what is mutating table.
When a table is in state of transition it is said to be
mutating.
eg :: If a row has been deleted then the table is said
to be
mutating and no operations can be done on the table
except select.
what is the keyword type.
what is 'exists'.
what is a cursor. what are the types.
two types of cursors: implicit and explicit. PL/SQL
declares a cursor implicitly for all
|
Earn Money
Trading Forex Online
Paramount Airways
Free Data Recovery
Cargo
Job Portal
HSBC Investment
Management
Cheap Web Hosting
Make Trip
Cheap Air Travel
Leisure Hotel
Free Air Travel
Mutual Fund Informations
Cheapest Cellular Plan
Free Sexy Indians
Call Center Software
Hot Indian
|
