Advanced Database and Object Modeling Reviewer

Which of the following is NOT a feature of relational databases?

• Structured query language (SQL)

• Fixed schema

• Schema-less design

• ACID compliance

IIn a relational schema, what is a foreign key used for?

• Uniquely identifying a row

• Creating a relationship between tables

• Improving query performance

• Indexing the data

Which database type is best suited for real-time analytics and high scalability?

• Relational databases

• NoSQL databases

• File-based databases

• Object databases

Which NoSQL database is an example of a Document Database?

• Redis

• MongoDB

• Cassandra

• Neo4j

What is the primary purpose of database optimization techniques?

• Increase storage size

• Improve query performance

• Make the database schema more complex

• Reduce the need for indexes

NoSQL databases are often used for:

• Handling structured data with fixed schemas

• Storing large-scale unstructured or semi-structured data

• Enforcing strict ACID compliance

• Replacing relational databases in all cases

What is inheritance in object modeling?

• The process of defining a new class using existing class properties and methods

• The ability of a class to have multiple instances

• A technique for storing objects in a database

• The conversion of objects into relational tables

Which UML diagram is primarily used to represent object relationships?

• Use case diagram

• Class diagram

• Sequence diagram

• Activity diagram

What does cardinality describe in an ERD?

• The number of attributes in an entity

• The number of tables in the database

• The number of relationships an entity can have with another entity

• The datatype of an attribute

How do you convert an ERD into a relational schema?

• Replace entities with tables and relationships with foreign keys

• Remove relationships and store all data in one table

• Convert all attributes into tables

• Remove primary keys from the entities