Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
What are the commands you'd issue to show the explain plan
for "select * from dual"?
Explain the difference between a FUNCTION, PROCEDURE and
Oracle client is not able to connect to Oracle server
although tnsnames.ora file has
valid enteries. Oracle error message is “ cannot resolve
net service name”.
Mention any three reasons.
what are the differences of where and if in SAS?
when we login sql editor using username and password then it
says this error "could not resolve service name" then what
can we do at client side.( here thing is tnsnames.ora file
is ok till yesterday and worked well, but now it giving error.
What is the recommended interval at which to run statspack
snapshots, and why?
how to restore files with rman?
How to start SQL Server in minimal configuration mode?
Claims and Drains are the locks used to control the
concurrency between SQL processes and utilities.
Referring to the above statement, what is the maximum
number of concurrent Claimers for a Subsystem?
I have A,B,C servers.i want to 3 servers jobs move to D
note: i said that take the backup of msdb and restore to the
target server..he said while restoring jobs replaced.
what is the solution
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB