Answer Posted / ehtesham malik
Alter index index_name REBUILD COPMUTE STATISTICS
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is replication? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the diffrence between core dba and apps dba?
how can you record information about current session?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the importance of a recovery model? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
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 is transparent data encryption? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the commands used in dcl? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Query processing is slow(eg select query)how will u solve that
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?