About JTO-EXAM
Following are some of the multiple choice questions on the DBMS with answers that will help the students in developing their knowledge.
(1)Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
Show answer
(2)Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
Show answer
(3)The given Query can also be replaced with_______: SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= te aches_ID;
Show answer
(4)Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
Show answer
(5)Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
Show answer
(6)Which one of the following given statements possibly contains the error?
Show answer
(7)Rows of a relation are known as the _______.
Show answer
(8)Which one of the following is a type of Data Manipulation Command?
Show answer
(9)In case of any shut down during transaction before commit which of the following statement is done automatically ?
Show answer
(10)The term "TCL" stands for_____.
Show answer
(11)Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
Show answer
(12)Which of the following makes the transaction permanent in the database ?
Show answer
(13)A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
Show answer
(14)In order to undo the work of transaction after last commit which one should be used ?
Show answer
(15)In order to maintain the consistency during transactions database provides
Show answer
(16)When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is
Show answer
(17)The deadlock state can be changed back to stable state by using _____________ statement.
Show answer
(18)When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is
Show answer
(19)A deadlock exists in the system if and only if the wait-for graph contains a
Show answer
(20)Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
Show answer
(21)Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
Show answer
(22)Which one of the following is a failure to a system
Show answer
(23)If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
Show answer
(24)The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
Show answer
(25)A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
Show answer
(26)Triggers ________ enabled or disabled a) Can be
Show answer
(27)Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation.