Answer Posted / deepak
alter index <indexname> rebulid;
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is asm?
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 used in dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
what is the diffrence between core dba and apps dba?
Can you redefine a table online?
What are the recovery models for a database? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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?
how can you create a user-defined lock?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
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.
How would you extract DDL of a table without using a GUI tool?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?