72 + Interview Questions in Storage And File Structures in Database Management Page 2 InterviewSolution

51.	______________ partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.(a) Block interleaved parity(b) Block interleaved distributed parity(c) Bit parity(d) Bit interleaved parityI had been asked this question in my homework.My question is based upon RAID in division Storage and File Structures of Database Management
Answer» Right answer is (b) Block interleaved distributed PARITY The best explanation: In LEVEL 5, all disks can participate in satisfying read requests, unlike RAID level 4, where the parity disk cannot participate, so level 5 INCREASES the total number of requests that can be met in a GIVEN amount of TIME.

Discussion

52.	An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.(a) Database dictionary(b) Dictionary table(c) Data dictionary(d) DictionaryThe question was asked in an international level competition.My question comes from Data-Dictionary Storage topic in chapter Storage and File Structures of Database Management
Answer» RIGHT answer is (C) Data dictionary For explanation: Data dictionary is also called as SYSTEM CATALOG.

Discussion

53.	Relational schemas and other metadata about relations are stored in a structure called the ____________(a) Metadata(b) Catalog(c) Log(d) Data DictionaryThis question was addressed to me during an interview.This intriguing question comes from Data-Dictionary Storage in chapter Storage and File Structures of Database Management
Answer» The CORRECT CHOICE is (d) Data Dictionary Easiest explanation - Data dictionary is ALSO called as system CATALOG.

Discussion

54.	Each tablespace in an Oracle database consists of one or more files called(a) Files(b) name space(c) datafiles(d) PFILEThe question was asked in an online quiz.Enquiry is from File Organisations in division Storage and File Structures of Database Management
Answer» RIGHT option is (c) datafiles Best EXPLANATION: A data file is a computer file which stores data to USE by a computer application or SYSTEM.

Discussion

55.	The information about data in a database is called _______(a) Metadata(b) Hyper data(c) Tera data(d) None of the mentionedThe question was posed to me in final exam.Origin of the question is Organization of Records in Files topic in chapter Storage and File Structures of Database Management
Answer» CORRECT OPTION is (a) METADATA The explanation is: Metadata is INFORMATION about a data.

Discussion

56.	The frequently used buffer replacement strategy is(a) Most recently used(b) Least recently used(c) Longest block(d) All of the mentionedI got this question by my school teacher while I was bunking the class.This question is from Database Buffer topic in section Storage and File Structures of Database Management
Answer» CORRECT choice is (b) Least recently used The EXPLANATION is: If a BLOCK must be REPLACED, the least recently referenced block is replaced.

Discussion

57.	The management information system (MIS) structure with one main computer system is called a(a) Hierarchical MIS structure(b) Distributed MIS structure(c) Centralized MIS structure(d) Decentralized MIS structureThis question was addressed to me by my school principal while I was bunking the class.The doubt is from File Organisations in portion Storage and File Structures of Database Management
Answer» Right CHOICE is (c) Centralized MIS structure The explanation is: Structure of MIS MAY be UNDERSTOOD by looking at the physical components of the INFORMATION system in an ORGANIZATION.

Discussion

58.	A data dictionary is created when a __________ created.(a) Instance(b) Segment(c) Database(d) DictionaryThe question was posed to me in an interview for internship.My question is based upon Data-Dictionary Storage in portion Storage and File Structures of Database Management
Answer» CORRECT answer is (c) Database Easiest explanation - DATA dictionary is ALSO called as system catalog.

Discussion

59.	The flash memory storage used are(a) NOR Flash(b) OR Flash(c) AND Flash(d) All of the mentionedI had been asked this question in an online quiz.I'm obligated to ask this question of Physical Storage Media in portion Storage and File Structures of Database Management
Answer» Right option is (a) NOR FLASH Easy explanation - NAND flash has a much higher STORAGE CAPACITY for a given cost, and is widely USED for data storage in devices such as cameras, music players, and cell PHONES.

Discussion

60.	__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.(a) Tablespace(b) Segment(c) Extent(d) BlockThis question was posed to me at a job interview.The question is from Data-Dictionary Storage in division Storage and File Structures of Database Management
Answer» RIGHT answer is (C) Extent The BEST EXPLANATION: An extent is a set of contiguous BLOCKS allocated in a database.

Discussion

61.	The replacement of a bad block generally is not totally automatic because(a) data in bad block cannot be replaced(b) data in bad block is usually lost(c) bad block does not contain any data(d) none of the mentionedThe question was asked in unit test.My doubt is from Tertiary Storage topic in section Storage and File Structures of Database Management
Answer» Correct choice is (B) DATA in bad BLOCK is usually lost The explanation is: Physical database design is the process of selecting the data storage and data ACCESS characteristics of the database.

Discussion

62.	Tertiary storage is built with :(a) a lot of money(b) unremovable media(c) removable media(d) secondary storageThis question was posed to me by my school principal while I was bunking the class.The above asked question is from Tertiary Storage topic in section Storage and File Structures of Database Management
Answer» The CORRECT answer is (c) removable media The explanation is: Tertiary storage involves a robotic mechanism which will MOUNT (insert) and dismount removable mass storage media into a storage device according to the SYSTEM’s DEMANDS; this data is often copied to secondary storage before use.

Discussion

63.	A unit of storage that can store one or more records in a hash file organization is denoted as(a) Buckets(b) Disk pages(c) Blocks(d) NodesThe question was asked in homework.Enquiry is from File Organisations in portion Storage and File Structures of Database Management
Answer» Correct option is (a) BUCKETS The best explanation: A UNIT of STORAGE that can store ONE or more records in a hash file organization is DENOTED as buckets.

Discussion

64.	Which level of RAID refers to disk mirroring with block striping?(a) RAID level 1(b) RAID level 2(c) RAID level 0(d) RAID level 3This question was addressed to me in class test.I need to ask this question from File Organisations topic in division Storage and File Structures of Database Management
Answer» The CORRECT choice is (a) RAID level 1 Easiest explanation - RAID (redundant ARRAY of independent disks) is a way of storing the same DATA in different places (thus, redundantly) on multiple hard disks.

Discussion

65.	The surface area of a tape is ________ the surface area of a disk.(a) much lesser than(b) much larger than(c) equal to(d) none of the mentionedThe question was asked in an online quiz.I want to ask this question from Tertiary Storage topic in chapter Storage and File Structures of Database Management
Answer» Correct option is (b) much LARGER than Best explanation: Network MODEL has DATA stored in a HIERARCHICAL network flow.

Discussion

66.	During recovery from a failure(a) each pair of physical block is examined(b) specified pair of physical block is examined(c) first pair of physical block is examined(d) none of the mentionedThis question was addressed to me in an online interview.Query is from Tertiary Storage in chapter Storage and File Structures of Database Management
Answer» The correct choice is (a) each pair of PHYSICAL block is examined For EXPLANATION: Tertiary storage involves a robotic mechanism which will mount (insert) and dismount REMOVABLE MASS storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.

Discussion

67.	The RAID level which mirroring is done along with stripping is(a) RAID 1+0(b) RAID 0(c) RAID 2(d) Both RAID 1+0 and RAID 0I have been asked this question during an online interview.My doubt is from RAID in division Storage and File Structures of Database Management
Answer» Correct CHOICE is (d) Both RAID 1+0 and RAID 0 Best explanation: Mirroring WITHOUT striping can also be USED with arrays of disks, to give the APPEARANCE of a single large, RELIABLE disk.

Discussion

68.	Which level of RAID refers to disk mirroring with block striping?(a) RAID level 1(b) RAID level 2(c) RAID level 0(d) RAID level 3The question was asked in an online interview.My doubt is from RAID in section Storage and File Structures of Database Management
Answer» Right option is (a) RAID level 1 The best I can explain: RAID level 1 refers to DISK MIRRORING with BLOCK STRIPING.

Discussion

69.	The disk controller uses ________ at each sector to ensure that the data is not corrupted on data retrieval.(a) Checksum(b) Unit drive(c) Read disk(d) ReadsumThis question was posed to me in semester exam.I want to ask this question from Magnetic Disk and Flash Storage in division Storage and File Structures of Database Management
Answer» The CORRECT answer is (a) Checksum Easy explanation - A disk CONTROLLER interfaces between the COMPUTER system and the ACTUAL hardware of the disk DRIVE.

Discussion

70.	A __________ is the smallest unit of information that can be read from or written to the disk.(a) Track(b) Spindle(c) Sector(d) PlatterThis question was posed to me in an internship interview.This is a very interesting question from Magnetic Disk and Flash Storage in section Storage and File Structures of Database Management
Answer» Correct choice is (c) Sector Best EXPLANATION: The DISK surface is LOGICALLY divided into tracks, which are subdivided into sectors.

Discussion

71.	A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.(a) Tablespace(b) Segments(c) Extents(d) BlocksThe question was posed to me in homework.I want to ask this question from Data-Dictionary Storage topic in portion Storage and File Structures of Database Management
Answer» RIGHT choice is (a) Tablespace Easiest EXPLANATION - A tablespace is a storage LOCATION where the actual data underlying DATABASE objects can be kept.

Discussion

72.	In Flash memory, the erase operation can be performed on a number of pages, called an _______ at once, and takes about 1 to 2 milliseconds.(a) Delete block(b) Erase block(c) Flash block(d) Read blockThe question was posed to me during an internship interview.I want to ask this question from Magnetic Disk and Flash Storage in portion Storage and File Structures of Database Management
Answer» Correct choice is (B) Erase block Explanation: The size of an erase block (often REFERRED to as just “block” in FLASH literature) is usually significantly larger than the block size of the storage SYSTEM.

Discussion

Explore topic-wise InterviewSolutions in .

Each tablespace in an Oracle database consists of one or more files called(a) Files(b) name space(c) datafiles(d) PFILEThe question was asked in an online quiz.Enquiry is from File Organisations in division Storage and File Structures of Database Management

The information about data in a database is called _______(a) Metadata(b) Hyper data(c) Tera data(d) None of the mentionedThe question was posed to me in final exam.Origin of the question is Organization of Records in Files topic in chapter Storage and File Structures of Database Management

A data dictionary is created when a __________ created.(a) Instance(b) Segment(c) Database(d) DictionaryThe question was posed to me in an interview for internship.My question is based upon Data-Dictionary Storage in portion Storage and File Structures of Database Management

The flash memory storage used are(a) NOR Flash(b) OR Flash(c) AND Flash(d) All of the mentionedI had been asked this question in an online quiz.I'm obligated to ask this question of Physical Storage Media in portion Storage and File Structures of Database Management

A unit of storage that can store one or more records in a hash file organization is denoted as(a) Buckets(b) Disk pages(c) Blocks(d) NodesThe question was asked in homework.Enquiry is from File Organisations in portion Storage and File Structures of Database Management

Which level of RAID refers to disk mirroring with block striping?(a) RAID level 1(b) RAID level 2(c) RAID level 0(d) RAID level 3This question was addressed to me in class test.I need to ask this question from File Organisations topic in division Storage and File Structures of Database Management

The RAID level which mirroring is done along with stripping is(a) RAID 1+0(b) RAID 0(c) RAID 2(d) Both RAID 1+0 and RAID 0I have been asked this question during an online interview.My doubt is from RAID in division Storage and File Structures of Database Management

Which level of RAID refers to disk mirroring with block striping?(a) RAID level 1(b) RAID level 2(c) RAID level 0(d) RAID level 3The question was asked in an online interview.My doubt is from RAID in section Storage and File Structures of Database Management