Database Management Systems

Here, it is possible to lock at the file level i.e to lock at the fragment level.

It is available to any RNAN client that connects to the catalog and the target database.

During this phase, if more than one channel is allocated, then recovery manager can execute certain commands in parallel so that all of the channel's target database sessions are concurrently executing a remote procedure call.

This component of the RMAN environment can use Oracle Net to connect to a target database.

This feature of the RMAN describes the number and size of the input and output disk buffers.

The work of backup and recovery is performed by server sessions running on this component of the RMAN environment.

Data hierarchy organizes data from smallest to largest: bit (smallest unit), byte (8 bits), field (group of bytes forming a data element), record (collection of related fields), file (collection of related records), and database (collection of related files). This ascending order reflects how data is structured and organized in database systems.

MS-Access allows multiple database files to be open simultaneously. You can open different database windows in separate instances or use the FileOpen dialog to open additional databases. The statement is false because Access supports working with multiple databases at the same time, though only one database can be active at a time in a single Access instance.

An external database is typically defined as a database created using a DBMS package (like Oracle, SQL Server, MySQL) that exists outside the current application. While Excel can store data in a tabular format, it's not considered a true database in the formal sense. MS-Word is definitely not a database. Option B is the most accurate answer.

A database is fundamentally a collection of data arranged in rows and columns, where rows represent records and columns represent fields/attributes. This tabular structure allows for efficient storage, retrieval, and manipulation of data. Options A and B are incomplete - a database requires both rows AND columns to be functional.

To run a macro automatically when a database starts in MS Access, you must name it 'AutoExec', not any of the .exe filenames listed. The question incorrectly presents .exe extensions (which are executable programs, not macro names), so none of the provided options (Start.exe, Auto.exe, Macro.exe) are correct.

Microsoft Access is a Relational Database Management System (RDBMS). It uses tables with relationships between them to store and organize data efficiently. DDBMS (Distributed DBMS) refers to databases spread across multiple physical locations, Access is not that. Access is software, not a server or protocol.

Data consolidation is specifically the process of combining and summarizing data from multiple sources into a single, unified view. Data validation checks for errors, Data form is an interface for entering data, and Data filter shows/hides specific records - none of these describe summarizing from multiple sources.

In Microsoft Access, the 'Database Documenter' or similar documentation tools use Details view to show database objects along with their descriptions. The 'Show' command typically displays objects without detailed properties, and 'List' shows objects in a simple list format. 'Details' provides the most comprehensive view including object descriptions.