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 – Attribute, Tuple and Entity

Posted on December 6, 2014 by staff10

This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Attribute, tuple and Entity”.

1. In an E-R diagram an entity set is represent by a
a) Rectangle
b) Ellipse
c) Diamond box
d) Circle
View Answer

Answer: a
Explanation: Entity types represent sets of objects and are pictured by rectangular nodes.
advertisement

2. A relational database developer refers to a record as
a) A criteria
b) A relation
c) A tuple
d) An attribute
View Answer

Answer: c
Explanation: A tuple is analogous to a record in non-relational databases.

3. The relational model feature is that there
a) is no need for primary key data
b) is much more data independence than some other database models
c) are explicit relationships among records
d) are tables with many dimensions
View Answer

Answer: b
Explanation: The relational model is the conceptual basis of relational databases. Proposed by E.F.Codd in 1969, it is a method of structuring data using relations, which are grid-like mathematical structures consisting of columns and rows.

4. E-R model uses this symbol to represent weak entity set ?
a) Dotted rectangle
b) Diamond
c) Doubly outlined rectangle
d) None of the Mentioned
View Answer

Answer: c
Explanation: A weak entity set is indicated by a doubly-outlined box.

5. Which of the following is record based logical model?
a) Network Model
b) Object oriented model
c) E-R Model
d) None of the Mentioned
View Answer

Answer: a
Explanation: The network model is a database model conceived as a flexible way of representing objects and their relationships.
advertisement

6. A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
a) First
b) Second
c) Third
d) Fourth
View Answer

Answer: c
Explanation: A database is in third normal form if it satisfies the following conditions:1)It is in second normal form. 2)There is no transitive functional dependency

7. Identify the criteria for designing database from the point of view of user
a) No redundancy
b) No inapplicable attributes
c) Uniformity in naming & definitions of the data items
d) All of the Mentioned
View Answer

Answer: d
Explanation: To designing database from the point of user view we need all the mentioned required.

8. The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________
a) Fields
b) Records
c) Relations
d) Keys
View Answer

Answer: b
Explanation: In the context of a relational database, a row also called a record or tuple represents a single, implicitly structured data item in a table.

9. An aggregation association is drawn using which symbol:
a) a line which loops back onto the same table
b) small closed diamond at the end of a line connecting two tables
c) small open diamond at the end of a line connecting two tables
d) small triangle at the end of a line connecting the aggregated item and multiple component items
View Answer

Answer: c
Explanation: There are three primary inter-object relationships: association, aggregation, and composition. Using the right relationship line is important for placing implicit restrictions on the visibility and propagation of changes to the related classes, matter which play major role in reducing system complexity.

10. An n-array relationship is drawn using which symbol:
a) A diamond
b) A line with arrows showing direction
c) A line without arrows showing direction
d) A rectangle
View Answer

Answer: a
Explanation: When a single parent-child relationship exists, the relationship is called binary. All of the previous examples of relationships to this point have been binary relationships. However, when creating a data model, it is not uncommon to come across n-array relationships, the modeling name for relationships between two or more parent entities and a single child table.
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 – Foreign, Candidate, Primary, Composite, Unique Keys
» Next Page - Oracle SQL Questions and Answers – Structured Query Language

« Java Program to Find the Number of Non-Repeated Elements in an Array
Oracle SQL Questions and Answers – Structured Query Language »
advertisement

Deep Dive @ Sanfoundry:

  1. C# Programming Examples on Networking
  2. C Programming Examples on File Handling
  3. MongoDB Questions and Answers
  4. C++ Programming Examples on Data-Structures
  5. C# Programming Examples on Inheritance
  6. C Programming Examples on Data-Structures
  7. RDBMS Questions and Answers
  8. MySQL Database Questions and Answers
  9. Database Management System Questions and Answers
  10. Oracle Database Questions and Answers
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.