ALLInterview.com :: Home Page      
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases >> DB Administration
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?    0  145
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?    1  347
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace????? genpact   2  744
how do see how much space is used and free in a tablespace genpact   2  565
any body know about orawaves do they really provide placements in their unique placement program tcs   1  344
which background process invoke at the time of upgradation tell me??? igate   0  293
What is the dataguard background process?? igate   1  448
what is rebuild index?? sapient   2  486
what is the use of home directory??? hp   1  322
I lost one datafile i dont have backup how can you recover that??? hp   2  418
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ??? igate   1  595
one datafile is lost in standy side how can you recover that??    0  178
how can you connect from 10g user to 11g user?? hp   0  157
what is the diffrence between core dba and apps dba? cap-gemini   0  196
how will you see when the database was started using sql prompt? ibm   2  658
E-Mail New Answers        Answer Selected Questions        Post New db-administration Questions
 [1]   2   3   4   5   6   7   8   9   10   11   12   13   14   15    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
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. 247
As a part of your job, what are the DBCC commands that you commonly use for database maintenance? 375
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance? 717
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example? 145
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. 573
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it? 367
which background process invoke at the time of upgradation tell me??? 293
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. 338
what is the role of dip user in our database? 547
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? 397
one datafile is lost in standy side how can you recover that?? 178
Typically, where is the conventional directory structure chosen for Oracle binaries to reside? 465
What are statistics, under what circumstances they go out of date, how do you update them? 440
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment? 233
In oracle 10g export, import if we declare rows=y/n what would be the output? 709
E-Mail New Answers        Answer Selected Questions