arrow
arrow
arrow
Map entries, attributes, and relations in Oracle is represented by ____________.
Question



Map entries, attributes, and relations in Oracle is represented by ____________.

A.

Special Schema

B.

Conceptual and Physical schema

C.

Logical Schema

D.

Physical Schema

E.

Conceptual Schema

Correct option is C

In Oracle, Logical Schema represents the mapping of entries, attributes, and relationships. It defines the structure of the database without specifying physical storage details.
Important Key Points:
1. Logical Schema: Focuses on how data is organized and connected logically.
2. Physical Schema: Describes the physical storage of data, such as files and tablespaces.
3. Conceptual Schema: Represents a high-level design of the database, abstracted from implementation details.
Knowledge Booster:
· Logical vs. Physical Schema: Logical schema deals with data relationships, while physical schema handles storage details.
· Special Schema: Refers to predefined database schemas like SYS and SYSTEM in Oracle.
· ER Diagrams: Often used to create logical schemas during the design phase.

Free Tests

Free
Must Attempt

DSSSB G-II/ASO Full Mock Test 1

languageIcon English
  • pdpQsnIcon200 Questions
  • pdpsheetsIcon200 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

DSSSB ASO PYP (Held on 18 Aug 2025 S1)

languageIcon English
  • pdpQsnIcon200 Questions
  • pdpsheetsIcon200 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

General Awareness Subject Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon10 Mins
languageIcon English
test-prime-package

Access ‘SBI SO Assistant Manager’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
383k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow