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.
You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
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?
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
4
How would you extract DDL of a table without using a GUI tool?
3
What are statistics, under what circumstances they go out
of date, how do you update them?
169
what are the differences of where and if in SAS?
179
What are the steps you will take, if you are tasked with
securing an SQL Server?
125
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
27
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
4
Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
3
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
2
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
143
You're getting high "busy buffer waits" - how can you find
what's causing it?
10
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.
5
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
Replication environment?
1
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
137
How would you best determine why your MVIEW couldn't FAST
REFRESH?
4
If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
13
Explain the concept of the DUAL table.
22
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
2
Which environment variables are absolutely critical in order
to run the OUI?
4
Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.
along with your userid / name. ThanQ
Site Map
