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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
 Categories  >>  Software  >>  Databases       
 
  Oracle (1591)   SQL Server (704)   MS Access (13)   MySQL (135)   Postgre (4)
  Sybase (13)   DB Architecture (1)   DB Administration (145)   DB Development (41)   SQL PLSQL (451)
  Databases AllOther (56)
 
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
When creating a user, what permissions must you grant to allow them to connect to the database?  2  854
Name a tablespace automatically created when you create a database.  1  905
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?  1  2408
What does coalescing a tablespace do?  1  2642
Give two methods you could use to determine what DDL changes have been made.  0  120
How would you force a log switch?  0  138
Describe what redo logs are.  0  100
How would you determine what sessions are connected and what resources they are waiting for?  0  128
What background process refreshes materialized views?  1  258
When a user process fails, what background process cleans up after it?  0  139
Explain materialized views and how they are used.  0  144
Where in the Oracle directory tree structure are audit traces placed?  0  172
Name three advisory statistics you can collect.  0  141
Explain the use of table functions.  0  172
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.  2  5443
E-Mail New Answers        Answer Selected Questions       
 
Prev    1   ... 14   ... 27   ... 40   ... 53   ... 66   ... 79   ... 92   ... 105   ... 118   ... 131   ... 144   ... 157    169   [170]    171  ... 183    Next
 
 
 Programming Languages interview questions   Programming Languages Interview Questions  Scripts interview questions   Scripts Interview Questions  Networking interview questions   Networking Interview Questions
 Microsoft Related interview questions   Microsoft Related Interview Questions  Databases interview questions   Databases Interview Questions  Operating Systems interview questions   Operating Systems Interview Questions
 Testing interview questions   Testing Interview Questions  Servers interview questions   Servers Interview Questions  MainFrame interview questions   MainFrame Interview Questions
 Java Related interview questions   Java Related Interview Questions  Middleware interview questions   Middleware Interview Questions  Web Related interview questions   Web Related Interview Questions
 Data Warehouse interview questions   Data Warehouse Interview Questions  HR Questions interview questions   HR Questions Interview Questions  Software Design interview questions   Software Design Interview Questions
 Debugging interview questions   Debugging Interview Questions  Version Control interview questions   Version Control Interview Questions  Editors interview questions   Editors Interview Questions
 Telecom interview questions   Telecom Interview Questions  ERP CRM interview questions   ERP CRM Interview Questions  Embedded Systems interview questions   Embedded Systems Interview Questions
 Client Server interview questions   Client Server Interview Questions  Artificial Intelligence interview questions   Artificial Intelligence Interview Questions  Cryptography interview questions   Cryptography Interview Questions
 EAI interview questions   EAI Interview Questions  Multimedia interview questions   Multimedia Interview Questions  Software Development Life Cycle interview questions   Software Development Life Cycle Interview Questions
 Image Processing interview questions   Image Processing Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how 109  
In workflow how can we send a notification to the Supplier giving the Corresponding report Details. 101  
How do you tell what your machine name is and what is its IP address? 1  
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue? 2  
What view(s) do you use to associate a user's SQLPLUS session with his o/s process? 1  
What is normalization? Explain different levels of normalization? 3449 IBM
if u want to delete all these detail block etc what will happen in form 147  
I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a 4  
If a stored procedure is taking a table data type, how it looks? 288  
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance. 90 IBM
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify. 128  
how do u compile a form i.e .fmb file in Unix or in dos 283 HCL
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program? 62  
why the Ctl file u put only in bin folder why not in other folder 108  
If CPU is very slow What can u do to speed up? 6  
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd 169  
Write the major components of a Database Management System? 320  
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table? 153  
How much memory that we are using in Logshipping Concept? 34  
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it. 110  
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