This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Planning Oracle Applications—Approaches, Risks, and Standards”.
1. 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 Mentioned
View Answer
Explanation: DBMS are most likely to useful in the above mentioned operation.
2. One approach to standardization storing of data ?
a) MIS
b) Structured programming
c) CODASYL specification
d) None of the Mentioned
View Answer
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).
3. 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 Mentioned
View Answer
Explanation: 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.
4. 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 queries
View Answer
Explanation: Report generation used the files to retrieve information and give answer of queries.
5. 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 structure
View Answer
Explanation: Centralized MIS structure is useful in the serving the request and response singly.
6. 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 Mentioned
View Answer
Explanation: 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.
7. Choose the RDBMS which supports full fledged client server application development
a) dBase V
b) Oracle 7.1
c) FoxPro 2.1
d) Ingress
View Answer
Explanation: Oracle 7.1 support the all server-client application development.
8. 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 Mentioned
View Answer
Explanation: ID-dependent entities depends on the Association, Multivalued attributes and instance.
9. Which of the following statements concerning business rules is true?
a) It should be complex.
b) It should not be convertible to computer code.
c) It may include restrictions.
d) All of the Mentioned
View Answer
Explanation: According to the business rule it always may include restrictions.
10. In order to use a record management system
a) you need to understand the low level details of how information is stored
b) you need to understand the model the record management system uses
c) you need to understand both information storage and the model of record management system
d) None of the Mentioned
View Answer
Explanation: For get to know the RMS (Record Management System) you should know the flow and of model and record management system.
Sanfoundry Global Education & Learning Series – Oracle Database.
To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers.