How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?
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
What are the Features of Forms 6i over 4.5?
What are the Features of Forms 10g?
What are the Features of Reports 6i?
What are the Features of Reports 10g ?
142
what are the API of GL,PO,AP
190
Explain couple pf features of SQL server
264
if u develop report do u ask for anything from u r team leader
130
What are the ways tablespaces can be managed and how do they
differ?
16
what is the sql equivaent of the dataset relation object ?
97
for what purpose we use MDM(master data management)tell me plz.
154
1. Tell me your daily activities
2. If sql server installation fails at time
installation what will do
3. Where does the sql server installation log details
are stored
4. After the installation what will you do for memory
configuration
5. What is the difference between SQL max maximum
memory and AWE memory
6. How will you configure AWE memory
7. How will setup an email alert for the backup job
8. After the SQL installation what are the jobs will
you configure
9. What does –g mean in the sql startup parameter
10. What is the difference between Bulked log and Full
recovery model
11. What is the difference between mirroring and log
shipping
12. What are the steps to be followed before in-place
up gradation
13. After installing the patch the sql server does not
start and application team tells to rollback the
changes .In this scenario what will you do
from where do u receive the information to develop report
121
please explain about oracle
6
What view would you use to look at the size of a data file?
119
How would you go about increasing the buffer cache hit
ratio?
0. Explain the difference between a hot backup and a cold
backup and the benefits associated with each
1. You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
2. How do you switch from an init.ora file to a spfile?
3. Explain the difference between a data block, an extent
and a segment.
4. Give two examples of how you might determine the
structure of the table DEPT.
5. Where would you look for errors from the database engine?
6. Compare and contrast TRUNCATE and DELETE for a table.
7. Give the reasoning behind using an index.
8. Give the two types of tables involved in producing a star
schema and the type of data they hold.
9. What type of index should you use on a fact table?
10. Give two examples of referential integrity constraints.
11. A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
12. Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
13. What command would you use to create a backup control
file?
14. Give the stages of instance startup to a usable state
where normal users may access it.
15. What column differentiates the V$ views to the GV$ views
and how?
16. How would you go about generating an EXPLAIN plan?
40
Is it possible to disable the parameter from while running
the report ?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
