Database Management Systems

These files can be set or modified in case the database is running.

This option is not present in Application Tracing Utilities in the Oracle database.

These are the correct statements about the back up files in the Oracle database.

The journal is the book of original (prime) entry where all business transactions are recorded chronologically as they occur, before being classified and posted to ledger accounts.

This extension is an embedded structured query language library that does not require any SQL server.

This session allows an application to store information for the current session, which can be defined as one user being logged into your application.

Network Model and Relational Model are both record-based logical models. Network Model uses graph structures with records and sets, while Relational Model uses tables (relations) with rows and columns. ER Model is not record-based but a conceptual modeling tool.

Data redundancy creates inconsistency because the same data stored in multiple places may be updated in one location but not others. This leads to different values for the same data entity, violating data consistency - a fundamental database principle.

The DBA (Database Administrator) is responsible for the conceptual level of the DBMS, which defines the logical structure and relationships of data for the entire organization. End users interact with the external level, systems programmers work at the physical level, and clients are consumers of the database services.

A subschema (or external schema) defines how a particular application or user views the data from the database. It provides a customized view of the database that is relevant to specific applications or user groups, hiding irrelevant details and restricting access to authorized data only.

Locking protocols prevent concurrent transaction problems: lost updates (overwriting uncommitted changes), uncommitted dependencies (reading dirty data), and inconsistent data (reading partially updated records). Locking ensures transaction isolation and serializability by controlling access to shared data items.

The ER (Entity-Relationship) Model is an object-based logical data model because it represents real-world entities as objects with attributes and relationships between them. Unlike physical models, it focuses on logical structure. Unlike record-based models, it uses objects/entities rather than tabular structures.

In the Relation Model, a column is referred to as an attribute, representing a specific property or characteristic of the entity. A row is called a tuple, the number of columns is the degree, and a relation represents the entire table structure containing tuples and attributes.

4th Dimension, FoxPro, and dbase-IV are all xBase database systems that support relational database features including SQL, relational operations, and tabular data structures. While they have xBase heritage, they are widely classified as relational databases in practice and support the core relational model concepts.