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
   Testimonials 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  388
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  948
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  2078
how do see how much space is used and free in a tablespace genpact   2  1977
any body know about orawaves do they really provide placements in their unique placement program tcs   1  1294
which background process invoke at the time of upgradation tell me??? igate   0  731
What is the dataguard background process?? igate   1  1434
what is rebuild index?? sapient   2  1580
what is the use of home directory??? hp   1  1168
I lost one datafile i dont have backup how can you recover that??? hp   2  1327
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  2024
one datafile is lost in standy side how can you recover that??    0  451
how can you connect from 10g user to 11g user?? hp   0  381
what is the diffrence between core dba and apps dba? cap-gemini   0  538
how will you see when the database was started using sql prompt? ibm   2  1508
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
 
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database? 339
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance? 1424
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? 1010
how to restore files with rman? 541
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..? 705
How would you best determine why your MVIEW couldn't FAST REFRESH? 657
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 386
As a part of your job, what are the DBCC commands that you commonly use for database maintenance? 633
Query processing is slow(eg select query)how will u solve that 3301
how can you connect from 10g user to 11g user?? 381
Typically, where is the conventional directory structure chosen for Oracle binaries to reside? 752
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. 500
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me 2315
What is the recommended interval at which to run statspack snapshots, and why? 719
What view(s) do you use to associate a user's SQLPLUS session with his o/s process? 713
E-Mail New Answers        Answer Selected Questions