Which of the following is not a recovery technique?
Answer: C
Correct answer: Two-phase commit
Deferred update, immediate update and shadow paging are all recovery techniques. Two-phase commit is a protocol for making a distributed transaction commit consistently across several sites - a concurrency and coordination problem rather than recovery from failure.
Please log in or register to report this question.
Isolation of the transactions is ensured by
Answer: C
Correct answer: Concurrency control
Isolation - that each transaction behaves as though it ran alone - is what the concurrency control component provides, through locking or timestamping. Atomicity and durability are the transaction and recovery managers' business.
Please log in or register to report this question.
The ______ operator is used to compare a value to a list of literal values that have been specified.
Answer: A
Correct answer: IN
IN tests whether a value appears in a list, as in \( \text{city IN ('Delhi','Mumbai','Pune')} \). LIKE matches a pattern against a single string and BETWEEN tests a range.
Please log in or register to report this question.
Which among the following filter method is not available in Access?
Answer: C
Correct answer: Advanced filter
Access offers Filter by Selection and Filter by Form as its two filtering commands. Its third facility is Advanced Filter/Sort, which opens a query-like grid and both filters and sorts - not a plain advanced filter alongside the other two.
Please log in or register to report this question.
Which among the following field type can store maximum data?
Answer: D
Correct answer: Memo fields
A Memo field holds long text - up to 65,535 characters - against a Text field's 255. Date/Time and Yes/No fields hold a fixed few bytes each.
Please log in or register to report this question.
Which among following relationship type is not possible to realize in Access Database directly?
Answer: C
Correct answer: Many to many
Access cannot store a many-to-many relationship directly; it has to be resolved into a junction table holding two one-to-many relationships, one to each of the original tables. That is a general property of the relational model rather than a limitation of Access.
Please log in or register to report this question.
Which among the following field type is used to store photograph of employees?
Answer: C
Correct answer: OLE
An OLE Object field stores an embedded or linked file - a photograph, a document, a spreadsheet. There is no Picture or Photo field type; Memo holds text only.
Please log in or register to report this question.
