KyaPoocha.com

Related Interview Questions

• What is Table set sharing and Set ID?What is the difference between Master table, Transaction table and Control table?  17.11.08

  Set ID is the highest level key in Peoplesoft. Its very important to understand the concepts of SET ids and table set sharing for the purpose of centralisation...

• What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?  06.11.08

  Total 5 types of tables we can create 1. MyISAM 2. Heap 3. Merge 4. INNO DB 5. ISAM MyISAM is the default storage engine as of MySQL 3.23. When you fi...

• What is the purpose of 1:M extended table?  03.11.08

  1. we can use it in parent child relationship where the child entity is lonely related to the parent table. 2. or we can make it as a intersection table...

• What is the difference between star schema and snow flake schema ?and when we use those schema’s?  20.09.08

  Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...

• Explain the situations where snowflake is better than star schema  20.09.08

  A snowflake schema is a way to handle problems that do not fit within the star schema. It consists of outrigger tables which relate to dimensions rather than...

• What RDMS objects are created with the SQL CREATE statements ?  25.07.08

  The SQL CREATE statements are used to create the following objects: STOGROUP A storage group DATABASE A logical collection of tables TABLESPACE An area...

• What are relation objects in dataset and how & where to use them ?  14.04.08

  In a DataSet that contains multiple DataTable objects, you can use DataRelation objects to relate one table to another, to navigate through the tables, and to r...

• What are the types of tables?  14.04.07

  1) Transparent table 2) Pool table 3) Cluster table are data dictionary table objects 4) Sorted table 5) Indexed table 6) Hash table 7) Internal tables....

• What is the use of CASCADE CONSTRAINTS?  26.03.06

  When this clause is used with the DROP command, a parent table can be dropped even when a child table exists....

• What is the use of CASCADE CONSTRAINTS?  09.03.06

  When this clause is used with the DROP command, a parent table can be dropped even when a child table exists....