Databases Interview Questions
Questions Answers Views Company eMail

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 810

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

SAPCO,

532

All questions related to Control m monitoring tool

HCL, TY,

967




what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

Arrow Electronics,

1 600

how to do daily transactions with out sql* loader control file regesterd in apps?

Arrow Electronics,

455

1) Does oracle have any table which contain all the exceptions and it's code internally?

CTS,

597

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

CTS,

486

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

Prodapt,

443

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

CTS,

448

display your age in months?

2 1679

what is reindexing?

Tata Technologies,

391

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

392

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

472

how to insert the records in particular position

1 766

what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

OVGU,

1 648







Un-Answered Questions { Databases }

difference between global n context sensitive segments?

1457


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

901


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

871


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

818


what is insert all statement in sql

4073






What would you do with an "in-doubt" distributed transaction?

740


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1079


Explain the use of table functions.

1027


how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

433


what is scan listener.

941


What is the difference between online clustering and Offline clustering?

1260


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.

986


i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

745


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1160


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

2447