ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
 Categories  >>  Software  >>  Databases  >>  DB Administration       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
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.  0  28
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.  0  52
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?  0  19
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?  0  13
What's the benefit of "dbms_stats" over "analyze"?  0  27
From the database level, how can you tell under which time zone a database is operating?  0  18
What are the ways tablespaces can be managed and how do they differ?  0  14
Explain the concept of the DUAL table.  0  21
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?  1  32
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?  0  9
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?  0  9
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?  0  12
In what script is "snap$" created? In what script is the "scott/tiger" schema created?  0  7
What are the commands you'd issue to show the explain plan for "select * from dual"?  0  13
What would you do with an "in-doubt" distributed transaction?  0  12
E-Mail New Answers        Answer Selected Questions        Post New DB Administration Question
 
 [1]   2   3   4   5   6   7   8   9   10    Next
 
 
 Oracle interview questions   Oracle Interview Questions  SQL Server interview questions   SQL Server Interview Questions  MS Access interview questions   MS Access Interview Questions
 MySQL interview questions   MySQL Interview Questions  Postgre interview questions   Postgre Interview Questions  Sybase interview questions   Sybase Interview Questions
 DB Architecture interview questions   DB Architecture Interview Questions  DB Administration interview questions   DB Administration Interview Questions  DB Development interview questions   DB Development Interview Questions
 SQL PLSQL interview questions   SQL PLSQL Interview Questions  Databases AllOther interview questions   Databases AllOther Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
Typically, where is the conventional directory structure chosen for Oracle binaries to reside? 13  
What view(s) do you use to associate a user's SQLPLUS session with his o/s process? 1  
What is the recommended interval at which to run statspack snapshots, and why? 2  
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? 2  
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports? 181 HSBC
Which environment variables are absolutely critical in order to run the OUI? 3  
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining? 2  
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba 134  
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. 5  
Where in the Oracle directory tree structure are audit traces placed? 159  
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. 3  
How would you best determine why your MVIEW couldn't FAST REFRESH? 4  
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. 28  
Explain materialized views and how they are used. 132  
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? 19  
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. 2  
what are the differences of where and if in SAS? 179  
How does Oracle guarantee data integrity of data changes? 5  
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it? 9  
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com 91 Oracle
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com