[{"id":189090,"question":"Which of the following is an example of volatile memory?","choices":[{"text":"RAM","value":"A"},{"text":"ROM","value":"B"},{"text":"Flash memory","value":"C"},{"text":"CPU","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189089,"question":"Which of the following is not true about input forms?","choices":[{"text":"Provide an easy, effective, efficient way to enter data into a table","value":"A"},{"text":"Especially useful when the person entering the data is not familiar with the inner workings","value":"B"},{"text":"Provide different controls to add data into the tables","value":"C"},{"text":"One input forms can populate one table at a time","value":"D"},{"value":"E"}],"correctAnswer":4},{"id":189088,"question":"Consider a transaction which includes following operations\r\nZ= Z + 10\r\nWrite Z\r\n...\r\nSuppose that the value of Z after addition and the execution of this operation is 17. Now against the write\r\noperation the entry made in the log file will be\r\nWhat does Z reflects in the above entry?","choices":[{"text":"Object being updated","value":"A"},{"text":"Identity of the transaction","value":"B"},{"text":"Object value","value":"C"},{"text":"Identity of the next transaction to be executed","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189087,"question":"Which of the following statements creates a database named COMPANY.","choices":[{"text":"CREATE DATABASE company","value":"A"},{"text":"CREATE DB company\r\n","value":"B"},{"text":"ADD DATABASE copmany","value":"C"},{"text":"CREATE company DATABASE","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189086,"question":"Which of the following is one of the purposes of using DDL commands?","choices":[{"text":"inserting records into databases","value":"A"},{"text":"updating records into databases","value":"B"},{"text":"manipulating databases","value":"C"},{"text":"creating and destroying databases ","value":"D"},{"value":"E"}],"correctAnswer":4},{"id":189085,"question":"Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)\r\nand the following functional dependencies.\r\nFD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo\r\nFD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo\r\nFD3 : StaffNo, InterviewDate -> RoomNo\r\nWhich of the following is correct?\r\n","choices":[{"text":"The relation Interview is in 3NF ","value":"A"},{"text":"The relation Interview is in BCNF","value":"B"},{"text":"The FD3 violates 3NF.","value":"C"},{"text":"The FD2 violates 2NF.\r\n","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189084,"question":"Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 columns in TABLE2; what is the size of\r\nthe Cartesian product incase of CROSS JOIN between these two tables?","choices":[{"text":"24","value":"A"},{"text":"54","value":"B"},{"text":"6","value":"C"},{"text":"1","value":"D"},{"value":"E"}],"correctAnswer":1},{"id":189083,"question":"Which of the following statements are Data Definition Language command?\r\n","choices":[{"text":"INSERT","value":"A"},{"text":"UPDATE\r\n","value":"B"},{"text":"GRANT ","value":"C"},{"text":"TRUNCATE","value":"D"},{"value":"E"}],"correctAnswer":4},{"id":189082,"question":"Which of the following is NOT one of the ways of resolving deadlocks?","choices":[{"text":"Undoing all the updates made by the particular transaction which is the cause of deadlock.","value":"A"},{"text":"A message is passed to the victim and depending on the system the transaction may or may not be\r\nstarted again automatically","value":"B"},{"text":"Picking a list of all previously completed transactions and undoing all the updates.","value":"C"},{"text":"Rollback `victim' transaction and restart it","value":"D"},{"value":"E"}],"correctAnswer":3},{"id":189081,"question":"A ____ relationship exists when an association is maintained within a single entity.","choices":[{"text":"unary","value":"A"},{"text":"ternary","value":"B"},{"text":"binary","value":"C"},{"text":"weak","value":"D"},{"value":"E"}],"correctAnswer":1}]