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 : 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 the ........... normal form, a composite attribute is converted to individual attributes. A) First B) Second C) Third D) Fourth
Last Answer : A) First
Description : Consider the following statements regarding relational database model: (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is ... true. (C) (b) and (c) are true. (D) (a), (b) and (c) are true.
Last Answer : (D) (a), (b) and (c) are true.
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 : 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 : 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 : 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 : ............. 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 : ………………. First proposed the process of normalization. A) Edgar. W B) Edgar F. Codd C) Edward Stephen D) Edward Codd
Last Answer : B) Edgar F. Codd
Description : …………………… is the process of organizing data into related tables. A) Normalization B) Generalization C) Specialization D) None of the above
Last Answer : A
Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.
Last Answer : reducing the number of joins required to satisfy a query.
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 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 ............. 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 : 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 : Cerebrospinal fluid: a. is produced mainly by the lateral, third and fourth ventricles b. enters the subarachnoid space through foramina Lushka and Magendie c. is reabsorbed mainly into the lymphatics d. production is dependent of the blood pressure
Last Answer : is produced mainly by the lateral, third and fourth ventricles
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 : A set of possible data values is called (A) attribute. (B) degree. (C) tuple. (D) domain.
Last Answer : D) domain.
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 : A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF
Last Answer : a) is in 1NF
Description : What is BCNF (Boyce-Codd Normal Form)?
Last Answer : A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.
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 : 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 : 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 : 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 windows 2000 operating system all the processor-dependent code is isolated in a dynamic link library called (A) NTFS file system (B) Hardware abstraction layer (C) Microkernel (D) Process Manager
Last Answer : (B) Hardware abstraction layer
Description : FAN IN of a component A is defined as (A) Number of components that can call or pass control to component A. (B) Number of components that are called by component A. (C) Number of components related to component A. (D) Number of components dependent on component A.
Last Answer : (A) Number of components that can call or pass control to component A.
Description : The conceptual model is (A) dependent on hardware. (B) dependent on software. (C) dependent on both hardware and software . (D) independent of both hardware and software.
Last Answer : (D) independent of both hardware and software.
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 : If S1 is total number of modules defined in the program architecture, S3 is the number of modules whose correct function depends on prior processing then the number of modules not dependent on prior processing is: (A) 1 + S3/S1 (B) 1 - S3/S1 (C) 1 + S1/S3 (D) 1 - S1/S3
Last Answer : (B) 1 - S3/S1
Description : One of the disadvantages of user level threads compared to Kernel level threads is (1) If a user level thread of a process executes a system call, all threads in that process are ... privileges. (4) The library procedures invoked for thread management in user level threads are local procedures.
Last Answer : If a user level thread of a process executes a system call, all threads in that process are blocked.
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 : Information per source is called a. A. sampling b. B. quantization c. C. entropy d. D. normalization
Last Answer : c. C. entropy
Description : What is a composite primary key field ?
Last Answer : Answer : A combination of two or more attributes or keys can collectively identify an NTT set, but they are called composite primary keys.
Description : Is normalization of pedophilia inevitable?
Last Answer : The normalization of pedophilia theory is usually touted by far right wing lunatics who are already vehemently anti-gay. There is absolutely no way that acting on pedophiliac urges will ever ... so ridiculous that a lot of conservatives can't comprehend the difference between consent and coercion.
Description : Won't normalization of relations with Cuba risk the embarrassing prospect of planeloads of American "medical refugees" besieging the island for health care and pharmaceuticals?
Last Answer : Probably right with ones extorting the average American, getting laws passed to protect their interest. BUT don't worry they will undoubtedly spread some sort of propaganda saying it's for the little guys best ... , and you want to know the sad part is a LOT of your citizens will believe them.
Description : A patient who has had a previous stroke and is taking warfarin tells the nurse that he started taking garlic to help reduce his blood pressure. The nurse knows that garlic when taken ... headaches. Garlic and warfarin taken together can greatly increase the INR, increasing the risk of bleeding.
Last Answer : a) can greatly increase the international normalization ratio (INR) and therefore increase the risk of bleeding. Garlic and warfarin taken together can greatly increase the INR, increasing the risk of bleeding.
Description : If the P(E) = 1, it means event a. does not occur b. always occur c. no probability d. Normalization
Last Answer : b. always occur
Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii
Last Answer : a) i& ii b) ii & iii
Description : What is normalization?
Last Answer : It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties ∙ Minimizing redundancy ∙ Minimizing insertion, deletion and update anomalies.
Description : List advantages of Normalization.
Last Answer : List of Advantages of Normalization are the following: 1. More efficient data structure. 2. Avoid redundant fields or columns. 3. More flexible data structure i.e. we should be able to ... 7. Minimizes data duplication. 8. Close modeling of real world entities, processes and their relationships.
Description : Define Normalization, list its types.
Last Answer : Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that ... data from the relation tables. Types of Normalization are: 1NF,2NF,3NF,4NF,5NF
Description : A portion of the Polymorphic virus, generally called a …………………….. , creates, a random encryption, key to encrypt the remainder of the virus. A) mutual engine B) mutation engine C) multiple engine D) polymorphic engine
Last Answer : C) multiple engine
Description : The candidate key is that you choose to identify each row uniquely is called …………….. A) Alternet Key B) Primary Key C) Foreign Key D) None of the above
Last Answer : B) Primary Key
Description : ey to represent relationship between tables is called (A) Primary key (B) Secondary Key (C) Foreign Key (D) None of these
Last Answer : (C) Foreign Key
Description : Which one of the following is not a key attribute that is essential to perform an assurance service? a. Independence b. Accounting skills c. Established criteria or standards d. Subject matter knowledge
Last Answer : Accounting skills
Description : The messageChannel class declares the _________ class attribute that defines the key string. a) command_key b) command-key c) commandkey d) Key_command
Last Answer : a) command_key
Description : The third type of comment is used by a tool called .................. for automatic generation of documentation. A) Java commenting B) Java generator C) Java doc D) Java loc
Last Answer : C) Java doc