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
 
  Oracle (1947)   SQL Server (1095)   MS Access (26)   MySQL (200)   Postgre (50)
  Sybase (22)   DB Architecture (7)   DB Administration (214)   DB Development (56)   SQL PLSQL (818)
  Databases AllOther (113)
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?    0  5
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID    1  13
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?    0  15
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?    1  20
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?    0  10
How many triggers can be implemented for a table?    1  14
How to fetch records from a partitioned table?    0  6
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?    0  12
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9    0  13
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage    0  14
difference between function and procedure    1  24
how to copy only distinct data into another table which is not already exist in database?    0  19
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?    0  14
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad    0  29
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?    0  60
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 22   ... 43   ... 64   ... 85   ... 106   ... 127   ... 148   ... 169   ... 190   ... 211   ... 232   ... 253   ... 274   ... 295    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode. 400
what is the difference between LENGTH AND SIZE? 945
can u plz provide me oca sql dumps please i need them 354
diff b/w inter process and in process 412
What is an SQL FORMS ? 996
A scenario for amount correction & how to use amount correction functionality in AP invoices 293
How do use Having,Group by,Group function in SQL? 313
How can we expand Parameter Form Canvas on Reports 6i? 901
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve. 873
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count 8219
What view(s) do you use to associate a user's SQLPLUS session with his o/s process? 740
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage. 952
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 557
Could you please provide oca (oracle 10g) dumps for my certification ? 2233
what is meant by magic query 605
E-Mail New Answers        Answer Selected Questions