[{"id":189060,"question":"Structural constraints of a relationship type refer to","choices":[{"text":"identifying the owner entity type relevant to a given entity type","value":"A"},{"text":"whether the existence of an entity depends on it being related to another entity via the relationship\r\ntype.","value":"B"},{"text":"the role that a participating entity from the entity type plays in each relationship instance","value":"C"},{"text":"the constraints applicable in granting access to tables, columns and views in a database schema.","value":"D"},{"value":"E"}],"correctAnswer":2},{"id":189059,"question":"Select the correct statement among the following on proper naming of schema constructs:","choices":[{"text":"Entity type name applies to all the entities belonging to that entity type and therefore a plural name is\r\nselected for entity type.","value":"A"},{"text":"In the narrative description of the database requirements, verbs tend to indicate the names of\r\nrelationship types.","value":"B"},{"text":"The nouns arising from a database requirement description can be considered as names of attributes.","value":"C"},{"text":"Additional nouns which are appearing in the narrative description of the database requirements represent the\r\nweak entity type names.","value":"D"},{"value":"E"}],"correctAnswer":2},{"id":189058,"question":"Which of the following is correct regarding Dataflow diagram?","choices":[{"text":"Single DFD is required to represent a system","value":"A"},{"text":"The dataflow must be bidirectional","value":"B"},{"text":"Created at increasing levels of detail","value":"C"},{"text":"Used to represent the relationships among the external entities","value":"D"},{"value":"E"}],"correctAnswer":3},{"id":189057,"question":"Which of the following is INCORRECT with respect to file systems?","choices":[{"text":"At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data\r\nindependence at the user level.","value":"A"},{"text":"A logical record is concerned with efficient storage of information in the secondary storage devices.","value":"B"},{"text":"Some physical organisations use pointers to record blocks to locate records on disk.","value":"C"},{"text":"The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete\r\nmay be performed on the information stored in the file.","value":"D"},{"value":"E"}],"correctAnswer":2},{"id":189056,"question":"DML commands are used for:","choices":[{"text":"inserting data into databases","value":"A"},{"text":"creating databases","value":"B"},{"text":"destroying databases","value":"C"},{"text":"creating DB objects","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189055,"question":"Which of the following types of partitioning reduces the chances of unbalanced partitions?","choices":[{"text":"vertical","value":"A"},{"text":"List","value":"B"},{"text":"Hash","value":"C"},{"text":"Range","value":"D"},{"value":"E"}],"correctAnswer":3},{"id":189054,"question":"Which of the following is incorrect with respect to indexed sequential files?","choices":[{"text":"New records are added to an overflow file","value":"A"},{"text":"Record in main file that precedes it is updated to contain a pointer to the new record","value":"B"},{"text":"The overflow is merged with the main file during a batch update","value":"C"},{"text":"Multiple indexes for the same key field cannot be setup","value":"D"},{"value":"E"}],"correctAnswer":4},{"id":189053,"question":"Which of the following is not true with respect to denormalization ?","choices":[{"text":"A denormalized data model is not the same as a data model that has not been normalized","value":"A"},{"text":"Denormalization takes place before the normalization process","value":"B"},{"text":"It is an attempt to optimize the performance of database","value":"C"},{"text":"Denormalization process can not be initiated before the Database design","value":"D"},{"value":"E"}],"correctAnswer":2},{"id":189052,"question":"Identify the correct statement with respect to normalization.","choices":[{"text":"Normalization is a formal technique that can be used only at the starting phase of the database design.","value":"A"},{"text":"Normalization can be used as a top-down standalone database design technique.","value":"B"},{"text":"The process of normalization through decomposition must achieve the lossless join\r\nproperty at any cost whereas the dependency reservation property is sometimes sacrificed.","value":"C"},{"text":"The process of normalization through decomposition must achieve the dependency reservation\r\nproperty at any cost whereas the lossless join property is sometimes sacrificed.","value":"D"},{"value":"E"}],"correctAnswer":4},{"id":189051,"question":"Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the\r\nfollowing gives all the information of the customers in the table whose last name is ALI?\r\n","choices":[{"text":"SELECT * FROM CUST WHERE last_name='ALI'; ","value":"A"},{"text":"SELECT * FROM CUST WHERE last_name=ALI;","value":"B"},{"text":" SELECT * FROM CUSTOMER WHERE name=ALI;","value":"C"},{"text":"SELECT * FROM CUSTOMER WHERE last_name=ALI;","value":"D"},{"value":"E"}],"correctAnswer":1}]