HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS
WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE
THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL &
PLSQL?
Hi ,
any one can help me on the same,this is regarding the
Informatica Function doc,i want to know how developer is
will develop the mapping. pl forwar the any function
doc .just for my references.
svlc75@yahoo.co.in
CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
59
What are the disadvantages of cursors? How can you avoid
cursors?
314
How to start SQL Server in minimal configuration mode?
109
Describe what redo logs are.
43
Q1:code to connect to sql server(database) through jdbc
application.
Q2:code to connect to Mysql(database) through jdbc application.
Q3:code to connect to oracle(database) through jdbc application.
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
45
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?