The file organization which allows us to read records that would satisfy the join condition by using one block read is(a) Heap file organization(b) Sequential file organization(c) Clustering file organization(d) Hash file organizationThis question was addressed to me in examination.I'd like to ask this question from File Organisations topic in section Storage and File Structures of Database Management

The file organization which allows us to read records that would satis

1.	The file organization which allows us to read records that would satisfy the join condition by using one block read is(a) Heap file organization(b) Sequential file organization(c) Clustering file organization(d) Hash file organizationThis question was addressed to me in examination.I'd like to ask this question from File Organisations topic in section Storage and File Structures of Database Management
Answer» Right option is (c) CLUSTERING FILE organization For explanation: All SYSTEMS in the cluster SHARE a common file structure via NFS, but not all disks are MOUNTED on all other systems.

Discussion

No Comment Found

Related InterviewSolutions

A block that is not allowed to be written back to disk is said to be ______________(a) Pinned(b) Forced(c) Buffer(d) All of the mentionedThe question was posed to me in an international level competition.My doubt stems from Database Buffer topic in chapter Storage and File Structures of Database Management
A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called(a) Metadata(b) Catalog(c) Log(d) DictionaryI had been asked this question in unit test.This interesting question is from Data-Dictionary Storage in division Storage and File Structures of Database Management
Choose the RDBMS which supports full fledged client server application development(a) dBase V(b) Oracle 7.1(c) FoxPro 2.1(d) IngressThis question was addressed to me in an international level competition.This question is from File Organisations topic in chapter Storage and File Structures of Database Management
Once the head has reached the desired track, the time spent waiting for the sector to be accessed to appear under the head is called the _______________(a) Access time(b) Average seek time(c) Seek time(d) Rotational latency timeI have been asked this question in class test.My question is taken from Magnetic Disk and Flash Storage topic in section Storage and File Structures of Database Management
The primary medium for the long-term online storage of data is the __________ where the entire database is stored on magnetic disk.(a) Semiconductor memory(b) Magnetic disks(c) Compact disks(d) Magnetic tapesI got this question in a national level competition.I need to ask this question from Physical Storage Media topic in portion Storage and File Structures of Database Management
Which of the following stores several gigabytes of data but usually lost when power failure?(a) Flash memory(b) Disk(c) Main memory(d) Secondary memoryThe question was posed to me during an interview.This is a very interesting question from Physical Storage Media in division Storage and File Structures of Database Management
The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.(a) Cache(b) Disk(c) Main memory(d) Flash memoryThe question was asked during an interview.Enquiry is from Physical Storage Media in section Storage and File Structures of Database Management
Which of these is not a feature of Hierarchical model?(a) Organizes the data in tree-like structure(b) Parent node can have any number of child nodes(c) Root node does not have any parent(d) Child node can have any number of parent nodesI have been asked this question in a national level competition.This interesting question is from Organization of Records in Files in portion Storage and File Structures of Database Management
Large collection of files are called ____________(a) Fields(b) Records(c) Database(d) SectorsThe question was asked during an interview for a job.Question is from Organization of Records in Files in division Storage and File Structures of Database Management
One approach to standardization storing of data?(a) MIS(b) Structured programming(c) CODASYL specification(d) None of the mentionedI had been asked this question in an interview for internship.I'm obligated to ask this question of File Organisations in section Storage and File Structures of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment