|
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 |