Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Databases Interview Questions
Questions Answers Views Company eMail

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

TCS,

1 2694

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,

1538

All questions related to Control m monitoring tool

HCL, TY,

2545

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

Arrow Electronics,

1 2716

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

Arrow Electronics,

1687

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

CTS,

1749

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,

1596

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,

1579

- 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,

1829

display your age in months?

2 4486

what is reindexing?

Tata Technologies,

1676

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,

1594

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,

1690

how to insert the records in particular position

1 3387

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 2577


Un-Answered Questions { Databases }

Describe in brief system database.

1011


What is information schema in sql?

1070


You need to purge data from audit database. What will you do?

891


What is rdbms and also explain its components?

1097


What is an Oracle Instance?

1122


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?

1949


How to Change a users password from unix shell.

1122


What does the hierarchical profiler does?

1058


Explain transaction server isolation?

1042


Explain correlated query work?

1054


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762


What are the different Topologies in which Replication can be configured?

1183


What language does oracle use?

1098


How we can apply bit m a podded index in ms access

2097


What are 3 ways to get a count of the number of records in a table?

1078