OODBMS & ORDBMS

What is an Object-Oriented Database Management System (OODBMS)?

• A database management system that uses objects to represent data

• A database management system that uses SQL for querying
  

• A database management system that organizes data in tables

• A database management system that uses files for storage

Which of the following is a key characteristic of OODBMS?

• Data stored in tables

• Data organized in a hierarchical structure

• Data represented as objects with attributes and methods

• Data stored in flat files

Which query language is commonly used with OODBMS?

• SQL

• Object Query Language(OQL)

• NoSQL

• PL/SQL

What is an example of a real-world application of OODBMS?

• E-commerce websites

• Social media platforms

• Computer-aided design (CAD) software

• Online banking systems

Which of the following is an example of an OODBMS?

• MySQL

• Oracle

• MongoDB

• ObjectStore

What is an object-relational database system (ORDBMS)?

• A database management system that supports object-oriented programming features

• A database management system that combines relational and object-oriented database models

• A database management system designed specifically for online analytical processing (OLAP)

• A database management system that implements NoSQL principles exclusively

Which of the following features is NOT typically found in an ORDBMS?

• Support for user-defined data types

• Inheritance and polymorphism

• Complex data types such as arrays and JSON

• Limited support for transactions and concurrency control

Which ORDBMS standard defines an SQL-based programming language for database access and manipulation?

• ODBC (Open Database Connectivity)

• JDBC (Java Database Connectivity)

• OLE DB (Object Linking and Embedding Database)

• SQL/MM (SQL Multimedia and Application Packages)

Which of the following ORDBMS features improves performance by storing frequently accessed data closer to the application?

• Materialized views

• Nested tables

• Object identifiers (OIDs)

• Database triggers

What is the purpose of user-defined data types in an ORDBMS?

• To define custom data types based on existing primitive types

• To specify constraints and rules for data integrity

• To enable the storage of complex data structures within a database

• 1. To improve the performance of query execution