logo
  • Home
  • Test & Rank
  • About
  • Training
  • Programming
  • CS
  • IT
  • IS
  • ECE
  • EEE
  • EE
  • Civil
  • Mechanical
  • Chemical
  • Metallurgy
  • Instrumentation
  • Aeronautical
  • Aerospace
  • Biotechnology
  • Mining
  • Marine
  • Agriculture
  • MCA
  • BCA
  • Internship
  • Jobs
  • Contact

Oracle Database Multiple Choice Questions | MCQs | Quiz

Oracle Database Interview Questions and Answers
Practice Oracle Database questions and answers for interviews, campus placements, online tests, aptitude tests, quizzes and competitive exams.

Get Started

•   Oracle DB 11g Architecture
•   Databases & Instances
•   Data Storing & Guarding
•   Programmatic Structure
•   Installing Oracle Database
•   Approaches & Risks
•   Atomic Data Models
•   Data Entry & Reporting
•   Normalization
•   Foreign & Unique Keys
•   Attribute, Tuple & Entity
•   Structured Query Language
•   DDL command
•   DML command
•   DCL & TCL command

Best Reference Books

Oracle Database Books

« Prev Page
Next Page »

Oracle Database Questions and Answers – Planning Oracle Applications – Approaches, Risks and Standards

Posted on November 22, 2014 by staff10

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

Answer: d
Explanation: DBMS are most likely to useful in the above mentioned operation.
advertisement

2. One approach to standardization storing of data ?
a) MIS
b) Structured programming
c) CODASYL specification
d) None of the Mentioned
View Answer

Answer: c
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

Answer: a
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

Answer: d
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

Answer: c
Explanation: Centralized MIS structure is useful in the serving the request and response singly.
advertisement

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

Answer: a
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

Answer: b
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

Answer: d
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

Answer: c
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

Answer: b
Explanation: For get to know the RMS (Record Management System) you should know the flow and of model and record management system.
advertisement

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.

« Prev Page - Oracle Database Questions and Answers – Installing Oracle Database 11g and Creating a Database
» Next Page - Oracle Database Questions and Answers – The Atomic Data Models and Business Models

« C++ Program to Perform Stooge Sort
Oracle Database Questions and Answers – The Atomic Data Models and Business Models »
advertisement

Deep Dive @ Sanfoundry:

  1. Terms of Service
  2. Compilers Questions and Answers
  3. Operating System Questions and Answers
  4. MongoDB Questions and Answers
  5. C# Programming Examples on Files
  6. RDBMS Questions and Answers
  7. MySQL Database Questions and Answers
  8. C Programming Examples on File Handling
  9. Database Management System Questions and Answers
  10. Oracle Database Questions and Answers – The Atomic Data Models and Business Models
Manish Bhojasia
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He is Linux Kernel Developer & SAN Architect and is passionate about competency developments in these areas. He lives in Bangalore and delivers focused training sessions to IT professionals in Linux Kernel, Linux Debugging, Linux Device Drivers, Linux Networking, Linux Storage, Advanced C Programming, SAN Storage Technologies, SCSI Internals & Storage Protocols such as iSCSI & Fiber Channel. Stay connected with him @ LinkedIn | Facebook | Twitter

Best Careers

Developer Tracks
SAN Developer
Linux Kernel Developer
Linux Driver Developer
Linux Network Developer

Live Training Photos
Mentoring
Software Productivity
GDB Assignment
Sanfoundry is No. 1 choice for Deep Hands-ON Trainings in SAN, Linux & C, Kernel Programming. Our Founder has trained employees of almost all Top Companies in India such as VMware, Citrix, Oracle, Motorola, Ericsson, Aricent, HP, Intuit, Microsoft, Cisco, SAP Labs, Siemens, Symantec, Redhat, Chelsio, Cavium, ST-Micro, Samsung, LG-Soft, Wipro, TCS, HCL, IBM, Accenture, HSBC, Mphasis, Tata-Elxsi, Tata VSNL, Mindtree, Cognizant and Startups.

Best Trainings

SAN I - Technology
SAN II - Admin
Linux Fundamentals
Advanced C Training
Linux-C Debugging
System Programming
Network Programming
Linux Threads
Kernel Programming
Kernel Debugging
Linux Device Drivers

Best Reference Books

Computer Science Books
Algorithm & Programming Books
Electronics Engineering Books
Electrical Engineering Books
Chemical Engineering Books
Civil Engineering Books
Mechanical Engineering Books
Industrial Engineering Books
Instrumentation Engg Books
Metallurgical Engineering Books
All Stream Best Books

Questions and Answers

1000 C Questions & Answers
1000 C++ Questions & Answers
1000 C# Questions & Answers
1000 Java Questions & Answers
1000 Linux Questions & Answers
1000 Python Questions
1000 PHP Questions & Answers
1000 Hadoop Questions
Cloud Computing Questions
Computer Science Questions
All Stream Questions & Answers

India Internships

Computer Science Internships
Instrumentation Internships
Electronics Internships
Electrical Internships
Mechanical Internships
Industrial Internships
Systems Internships
Chemical Internships
Civil Internships
IT Internships
All Stream Internships

About Sanfoundry

About Us
Copyright
Terms
Privacy Policy
Jobs
Bangalore Training
Online Training
Developers Track
Mentoring Sessions
Contact Us
Sitemap
© 2011 Sanfoundry. All Rights Reserved.