Description : A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. A) First B) Second C) Third D) Fourth
Last Answer : C) Third
Description : If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called ................ is needed. A) DKNF B) BCNF C) Fourth D) Third
Last Answer : B) BCNF
Description : The main task carried out in the …………… is to remove repeating attributes to separate tables. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Fourth Normal Form
Last Answer : D) Fourth Normal Form
Description : ............. is a combination of two of more attributes used as a primary key A) Composite Key B) Alternate Key C) Candidate Key D) Foreign Key
Last Answer : A) Composite Key
Description : A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity. A) Weak entity B) Strong entity C) Non attributes entity D) Dependent entity
Last Answer : A) Weak entity
Description : The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) ... Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price
Last Answer : (A) Non key attribute V_name is dependent on V_no which is part of composite key
Description : In ............. generation of operating system, operating system designers develop the concept of multiprogramming in which several jobs are in main memory at once. A) First B) Second C) Third D) Fourth
Description : Four middle-aged people were reminiscing about their individual journeys through life. Two of them were college grads, and the other two were business people. The first was heard to say, 'When I happened upon ... well as my wasting my money on $5,000 toupees, raccoon coats, and buying a R -Riddles
Last Answer : The four people had just finished playing the board game, LIFE, and were discussing some of the good and bad things they had encountered while playing.
Description : For a database relation R(A,B,C,D) where the domains of A,B,C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are: A→C B→D The ... form but not in third normal form (4) Both in second normal form as well as in third normal form
Last Answer : First normal form but not in second normal form
Description : Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF
Last Answer : (B) Lossless preserving decomposition into BCNF is always possible
Description : Linking to another place in the same or another webpage require two A (Anchor) tags, the first with the ................. attribute and the second with the ................ attribute. (A) NAME & LINK (B) LINK & HREF (C) HREF & NAME (D) TARGET & VALUE
Last Answer : (C) HREF & NAME
Description : 4NF stands for .. A) Fourth Normal File B) Fourth Normal Form C) Fourth Normal Fraction D) Fourth Negative File
Last Answer : B) Fourth Normal Form
Description : ………………….. operator is basically a join followed by a project on the attributes of first relation. A) Join B) Semi-Join C) Full Join D) Inner Join
Last Answer : B) Semi-Join
Description : An attribute that uniquely identifies the rows of a table is known as the ....... key. (1) primary (2) candidate (3) composite (4) foreign
Last Answer : primary
Description : Which of the following commands is used to display the directory attributes rather than its contents? A. ls -l -d B. ls -l C. ls -x D. ls -F E. None of the above
Last Answer : A. ls -l -d
Description : Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation. A) i-True, ii-False B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False
Last Answer : C) i-False, ii-True
Description : Identify the criteria for designing database from the point of view of user A) No redundancy B) No inapplicable attributes C) Uniformity in naming & definitions of the data items D) All of the above
Last Answer : D) All of the above
Description : In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities
Last Answer : C) Relations
Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity
Last Answer : B) Degree
Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns
Last Answer : B) Cardinality, Degree
Description : The one guideline to be followed while designing the database is A) A database design may be ambiguous. B) Unrelated data should be in the same table so that updating the data will be easy. C) It should avoid/reduce the redundancy. D) An entity should not have attributes.
Last Answer : C) It should avoid/reduce the redundancy.
Description : _____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product
Last Answer : A) Cartesian product
Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.
Last Answer : (C) Tables
Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints
Last Answer : (A) Number of tuples
Description : An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not ... ; IV (B) I&IV (C) I, II & IV (D) I & III
Last Answer : (A) I, II, III & IV
Description : Which one of the following set of attributes should not be encompassed by effective software metrics ? (A) Simple and computable (B) Consistent and objective (C) Consistent in the use of units and dimensions (D) Programming language dependent
Last Answer : (D) Programming language dependent
Description : What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ? (A) Generalization (B) Aggregation (C) Specialization (D) Adding suitable attributes
Last Answer : (D) Adding suitable attributes
Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1
Last Answer : (B) 3
Description : Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data ... weak entity set are not partitioned according to their relationship with tuples in a strong entity set.
Last Answer : (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.
Description : Which one of the following non-functional quality attributes is not highly affected by the architecture of the software ? (A) Performance (B) Reliability (C) Usability (D) Portability
Last Answer : (C) Usability
Description : Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique? (A) Only the joining attributes are sent from one site to ... the attributes are sent from one site to another and then only the required rows are returned.
Last Answer : (C) Only the joining attributes are sent from one site to another and then only the required rows are returned.
Description : Consider the following database table having A, B, C and D as its four attributes and four possible candidate keys (I, II, III and IV) for this table: I: {B} II: {B, C} III: {A, D} IV: {C, D} If ... the database table? (A) I and III only (B) III and IV only (C) II only (D) I only
Last Answer : (C) II only
Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;
Last Answer : (B) SELECT A, COUNT(*) FROM R;
Description : Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to ... and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3
Last Answer : Answer: 4
Description : Drop Table cannot be used to drop a table referenced by a …………… constraint. A) Local Key B) Primary Key C) Composite Key D) Foreign Key
Last Answer : D) Foreign Key
Description : COCOMO stands for (A) COmposite COst MOdel (B) COnstructive COst MOdel (C) COnstructive COmposite MOdel (D) COmprehensive COnstruction MOdel
Last Answer : (B) COnstructive COst MOdel Explanation: The Constructive Cost Model (COCOMO) is an algorithmic software cost estimation model.
Description : The principle that energy may be converted from one form to another but it cannot be either created or destroyed is: w) First Law of Thermodynamics. x) Second Law of Thermodynamics. y) Third Law of Thermodynamics. z) Principle of photoelectricity.
Last Answer : ANSWER: W -- FIRST LAW OF THERMODYNAMICS.
Description : The first letter is derived from the 18th letter of greek alphabet, the second one is the rounded form of v, the third one arises from the 2nd letter of greek alphabt, the fourth one is derived ... last letter is believed to be derived from Djet (an egyptian pharoah ) Can you decode it? -Riddles
Last Answer : This answer was deleted by moderators
Description : The form of oath of office for a minister for the union of India is enshrined in the - (1) first schedule (2) second schedule (3) third schedule (4) fourth schedule
Last Answer : (3) third schedule Explanation: The form of oath of office for a minister for the union of India is enshrined in the third schedule of the Constitution. In first schedule List of States & Union ... General of India. Fourth schedule is for allocation of seats for each state of India in Rajya Sabha.
Description : ………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs. A) Instance B) Schema c) Program D) Super Key
Last Answer : B) Schema
Description : In an ER model, ……………. is described in the database by storing its data. A) Entity B) Attribute C) Relationship D) Notation
Last Answer : A) Entity
Description : A set of possible data values is called (A) attribute. (B) degree. (C) tuple. (D) domain.
Last Answer : D) domain.
Description : The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.
Last Answer : (A) tuple
Description : A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.
Last Answer : C) a tuple
Description : For a weak entity set to be meaningful, it must be associated with another entity set in combination with some of their attribute values, is called as : (A) Neighbour Set (B) Strong Entity Set (C) Owner entity set (D) Weak Set
Last Answer : (C) Owner entity set
Description : Which of the following provides the best description of an entity type? (A) A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) (B) A value given to a ... template for a group of things with the same set of characteristics that may exist in the real world
Last Answer : Answer: D
Description : In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency
Last Answer : (C) Entity Integrity
Description : In mapping of ERD to DFD a) entities in ERD should correspond to an existing entity/store in DFD b) entity in DFD is converted to attributes of an entity in ERD c) relations in ERD has 1 to 1 correspondence to processes in DFD d) relationships in ERD has 1 to 1 correspondence to flows in DFD
Last Answer : a) entities in ERD should correspond to an existing entity/store in DFD
Description : I share people who you love. My fifth letter is in letter but not in mutt. if you cut off two heads I become what you do to hit some one with a weapon. I can have designes but I might be ... something that is really important not to do. I rhyme with two words in this riddle. What am I? -Riddles
Last Answer : Frame.
Description : Fifty is my first. Nothing is my second. Five just makes my third. My fourth, a vowel, is reckoned. Now to find my name, Fit my parts together. I die if I grow cold, but never fear cold weather. What am I? -Riddles
Last Answer : L O V E.