Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	Which of the following situation requires the use of ID-dependent entities ?(a) Association relationships only(b) Multivalued attributes only(c) Instance relationships only(d) All of the MentionedThis question was posed to me by my college director while I was bunking the class.This is a very interesting question from Planning Oracle Applications in portion Planning Oracle Applications of Oracle
Answer» Right ANSWER is (d) All of the Mentioned Easy explanation: ID-dependent ENTITIES depends on the Association, MULTIVALUED attributes and instance.

52.	Choose the RDBMS which supports full fledged client server application development(a) dBase V(b) Oracle 7.1(c) FoxPro 2.1(d) IngressI got this question in homework.I'd like to ask this question from Planning Oracle Applications in division Planning Oracle Applications of Oracle
Answer» The correct OPTION is (b) Oracle 7.1 The explanation: Oracle 7.1 SUPPORT the all server-client APPLICATION DEVELOPMENT.

53.	Which of the following is not true of the traditional approach to information processing(a) There is common sharing of data among the various applications(b) It is file oriented(c) Programs are dependent on the file(d) All of the MentionedThis question was posed to me in homework.Query is from Planning Oracle Applications in section Planning Oracle Applications of Oracle
Answer» The correct CHOICE is (a) There is common sharing of DATA among the VARIOUS applications To explain: In traditional approach, information is stored in flat FILES which are maintained by the file system under the operating system’s control.Application programs go through the file system in order to ACCESS these flat files.

54.	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 structureI have been asked this question during a job interview.My query is from Planning Oracle Applications in portion Planning Oracle Applications of Oracle
Answer» Right ANSWER is (c) CENTRALIZED MIS structure Explanation: Centralized MIS structure is USEFUL in the serving the request and response singly.

55.	Report generators are used to(a) Store data input by a user(b) Retrieve information from files(c) Answer queries(d) Retrieve information from files and Answer queriesThis question was addressed to me by my college professor while I was bunking the class.I want to ask this question from Planning Oracle Applications in portion Planning Oracle Applications of Oracle
Answer» Correct answer is (d) RETRIEVE information from files and Answer queries For explanation I WOULD SAY: Report generation used the files to retrieve information and GIVE answer of queries.

56.	The language used application programs to request data from the DBMS is referred to as the(a) DML(b) DDL(c) Query language(d) All of the MentionedI got this question in unit test.My question is based upon Planning Oracle Applications in chapter Planning Oracle Applications of Oracle
Answer» Right ANSWER is (a) DML To explain: The effect of a DML statement is not permanent until you COMMIT the TRANSACTION that includes it. A transaction is a sequence of SQL statements that Oracle Database treats as a unit.

57.	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 semester exam.My question is taken from Planning Oracle Applications in chapter Planning Oracle Applications of Oracle
Answer» The correct choice is (c) CODASYL specification Easiest explanation: A second database type is a network database.Many COMPUTER SYSTEMS have been implemented using the network Database Management System (DBMS) specifications developed by the Conference on Data Systems LANGUAGES (CODASYL).Also INVOLVED were TWO subgroups of CODASYL:the Database Task Group (DBTG), and the Data Description Language Committee (DDLC).

58.	Database management systems are intended to _____________(a) Eliminate data redundancy(b) Establish relationship among records in different files(c) Manage file access(d) All of the MentionedI got this question in an online quiz.I want to ask this question from Planning Oracle Applications topic in section Planning Oracle Applications of Oracle
Answer» Right OPTION is (d) All of the Mentioned The EXPLANATION: DBMS are most likely to USEFUL in the above mentioned OPERATION.