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   To Refer this Site to Your Friends   Click Here
Google
 
 Categories  >>  Software  >>  Databases  >>  SQL PLSQL       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
how many tupples can insert in 1 second in sql  0  48
What is the default value of CHAR type? Bosch  0  41
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g) Relq  1  245
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary  1  40
What does “select count(1) from tab” result? IBM  3  396
What does “select count(*) from tab” result? IBM  3  193
How would you go about increasing the buffer cache hit ratio? 0. Explain the difference between a hot backup and a cold backup and the benefits associated with each 1. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? 2. How do you switch from an init.ora file to a spfile? 3. Explain the difference between a data block, an extent and a segment. 4. Give two examples of how you might determine the structure of the table DEPT. 5. Where would you look for errors from the database engine? 6. Compare and contrast TRUNCATE and DELETE for a table. 7. Give the reasoning behind using an index. 8. Give the two types of tables involved in producing a star schema and the type of data they hold. 9. What type of index should you use on a fact table? 10. Give two examples of referential integrity constraints. 11. A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? 12. Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each. 13. What command would you use to create a backup control file? 14. Give the stages of instance startup to a usable state where normal users may access it. 15. What column differentiates the V$ views to the GV$ views and how? 16. How would you go about generating an EXPLAIN plan?  0  30
What are the new features in Oracle 10g. Compared to Oracle 9i? Polaris  1  313
there are .......different types of serializability Wipro  0  30
..........refers to the disk mirroring iFlex  0  23
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance  1  257
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification  0  39
what is the output of this query selet * from employee where 1=2 ??  5  728
What are the different types of joins and explain them briefly.  2  256
Write a query to find second highest salary of an employee.  11  993
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
 
 [1]    2  ... 3   ... 5   ... 7   ... 9   ... 11   ... 13   ... 15   ... 17   ... 19   ... 21   ... 23   ... 25   ... 27   ... 29    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
 
What is the default value of CHAR type? 41 Bosch
How consistent is the view of the data between and within multiple sessions, transactions or statements ? 93  
How would you go about increasing the buffer cache hit ratio? 0. Explain the difference between a hot backup and a cold backup and the benefits associated with each 1. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? 2. How do you switch from an init.ora file to a spfile? 3. Explain the difference between a data block, an extent and a segment. 4. Give two examples of how you might determine the structure of the table DEPT. 5. Where would you look for errors from the database engine? 6. Compare and contrast TRUNCATE and DELETE for a table. 7. Give the reasoning behind using an index. 8. Give the two types of tables involved in producing a star schema and the type of data they hold. 9. What type of index should you use on a fact table? 10. Give two examples of referential integrity constraints. 11. A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? 12. Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each. 13. What command would you use to create a backup control file? 14. Give the stages of instance startup to a usable state where normal users may access it. 15. What column differentiates the V$ views to the GV$ views and how? 16. How would you go about generating an EXPLAIN plan? 30  
Authentication mechanisms in Sql Server ? 186 BirlaSoft
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name. 204 TCS
What are code pages ? 113 BirlaSoft
what is indexing, searching and user interface? 94 HCL
How well can multiple sessions access the same data simultaneously ? 109  
Does it possible to pass object (or) table as an argument to a remote procedure? 500 TCS
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 140  
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 89 Satyam
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 174 Microsoft
what is organisational index? 158  
what is the boundary line in varrays? 119  
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution 185 TCS
what is the bond code in materialized view? 155  
Which one is the Best approach to put code, among Triggers and Procedures? Explain? 166 Sierra-Atlantica
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September. 206  
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 218 Virtusa
when MSQL8.0 is in market 122  
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