Test Grila Microsoft Access: Quiz!

1. Componenta software specifică arhitecturii pe componente a unui sistem de baze de date poate conţine:

dicţionarul de date;

sistemul de gestiune al bazei de date;

datele;

fişierele anexă

The correct answer is "sistemul de gestiune al bazei de date" because it refers to the software component responsible for managing and controlling the database. This component handles tasks such as data storage, retrieval, manipulation, and security. It provides a set of tools and functions to interact with the database, ensuring its integrity and efficiency. The other options mentioned, such as the data dictionary and attached files, are important elements of a database system but are not specifically related to the software architecture of the system.

Explanation

The correct answer is "sistemul de gestiune al bazei de date" because it refers to the software component responsible for managing and controlling the database. This component handles tasks such as data storage, retrieval, manipulation, and security. It provides a set of tools and functions to interact with the database, ensuring its integrity and efficiency. The other options mentioned, such as the data dictionary and attached files, are important elements of a database system but are not specifically related to the software architecture of the system.

2. Legătura de tipul unu-la-mai-mulţi se realizează atunci când:

unui tuplu din fiecare relaţie îi corespunde cel mult un tuplu din cealaltă relaţie;

unui tuplu din prima relaţie îi corespund mai multe tupluri în cea de-a doua relaţie, în
timp ce unui tuplu din a doua relaţie îi corespunde un singur tuplu din prima;

unui tuplu din fiecare relaţie îi corespund mai multe tupluri din cealaltă relaţie;

se asociază cel puţin trei relaţii.

The correct answer states that in a one-to-many relationship, multiple tuples from the second relation correspond to a single tuple from the first relation, while a single tuple from the second relation corresponds to a single tuple from the first relation. This means that for each tuple in the first relation, there can be multiple related tuples in the second relation, but for each tuple in the second relation, there is only one related tuple in the first relation.

Explanation

The correct answer states that in a one-to-many relationship, multiple tuples from the second relation correspond to a single tuple from the first relation, while a single tuple from the second relation corresponds to a single tuple from the first relation. This means that for each tuple in the first relation, there can be multiple related tuples in the second relation, but for each tuple in the second relation, there is only one related tuple in the first relation.

3. Un SGBD permite:

doar actualizarea datelor din baza de date;

doar extragerea datelor prin intermediul limbajului de descriere a datelor;

doar extragerea datelor prinintermediul limbajului de manipulare a datelor;

actualizarea datelor şi extragerea lor prin intermediul limbajului de manipulare a datelor.

The correct answer states that an SGBD (Sistem de Gestiune a Bazelor de Date) allows for both updating the data and extracting it through the data manipulation language (limbajului de manipulare a datelor). This means that users can modify the data in the database and retrieve specific information using commands and queries provided by the data manipulation language.

Explanation

The correct answer states that an SGBD (Sistem de Gestiune a Bazelor de Date) allows for both updating the data and extracting it through the data manipulation language (limbajului de manipulare a datelor). This means that users can modify the data in the database and retrieve specific information using commands and queries provided by the data manipulation language.

4. O bază de date relaţională se referă la

colecţii organizate de date;

colecţii corelate din punct de vedere logic;

colecţii organizate şi corelate din punct de vedere logic;

colecţii organizate şi corelate fizic pe suportul de stocare.

A relational database refers to collections of data that are organized and related to each other logically. This means that the data within the database is structured and linked based on logical relationships, such as primary and foreign keys. This organization and correlation of data allows for efficient storage, retrieval, and manipulation of information within the database.

Explanation

A relational database refers to collections of data that are organized and related to each other logically. This means that the data within the database is structured and linked based on logical relationships, such as primary and foreign keys. This organization and correlation of data allows for efficient storage, retrieval, and manipulation of information within the database.

5. Referitor la o bază de date relaţională, putem afirma că va conţine:

colecţii organizate de date între care pot exista diferite legături;

colecţii organizate de date între care pot exista legături, iar dacă există, ele sunt legături
logice;

colecţii organizate de date fărălegături logice;

colecţii organizate de date între care există legături logice.

A relational database contains organized collections of data that can have different relationships between them. If there are any relationships, they are logical connections between the collections of data.

Explanation

A relational database contains organized collections of data that can have different relationships between them. If there are any relationships, they are logical connections between the collections of data.

6. Fiecare relaţie:

are o singură cheie primară;

are mai multe chei primare;

are o singură cheie primară, însă atunci când este nevoie, se poate identifica cel mult încă
una;

nu contează câte chei primare are o relaţie

Each relationship in a database typically has a single primary key. This primary key is used to uniquely identify each record in the table. While it is possible for a relationship to have multiple primary keys, it is not common practice. Having multiple primary keys can make it more difficult to manage and query the data. Therefore, the most common and recommended approach is to have a single primary key for each relationship.

Explanation

Each relationship in a database typically has a single primary key. This primary key is used to uniquely identify each record in the table. While it is possible for a relationship to have multiple primary keys, it is not common practice. Having multiple primary keys can make it more difficult to manage and query the data. Therefore, the most common and recommended approach is to have a single primary key for each relationship.

7. SGBD-ul reprezintă o interfaţă între:

sistemul de operare şi alt SGBD;

două sau mai multe SGBD-uri, dacăele se găsesc pe platforme diferite;

utilizatori şi sistemul de operare;

două sisteme de operare care rulează pe platforme diferite.

The correct answer is users and the operating system. A database management system (SGBD) acts as an interface between the users and the operating system, allowing users to interact with the database through the operating system. The SGBD handles tasks such as data storage, retrieval, and management, while also providing a user-friendly interface for users to interact with the database system.

Explanation

The correct answer is users and the operating system. A database management system (SGBD) acts as an interface between the users and the operating system, allowing users to interact with the database through the operating system. The SGBD handles tasks such as data storage, retrieval, and management, while also providing a user-friendly interface for users to interact with the database system.

8. Câte chei poate avea o relaţie?

una primară, una străină si una alternantă;

mai multe candidat, una primară şi cel puţin una străină;

una sau mai multe candidat, una primară şi nici una, una, sau mai multe alternante;

una sau mai multe candidat, una primară, nici una, una, sau mai multe alternante şi cel puţin una străină.

The correct answer is "una sau mai multe candidat, una primară, nici una, una, sau mai multe alternante şi cel puţin una străină." This answer states that a relationship can have one or more candidates, one primary key, zero or more alternate keys, and at least one foreign key.

Explanation

The correct answer is "una sau mai multe candidat, una primară, nici una, una, sau mai multe alternante şi cel puţin una străină." This answer states that a relationship can have one or more candidates, one primary key, zero or more alternate keys, and at least one foreign key.

9. Cheia primară reprezintă un atribut sau un grup de atribute care:

identifică unic fiecare tuplu al unei relaţii;

identifică unic fiecare tuplu, în funcţie de relaţia în care migrează;

identifică în mod unic toate celelalte atribute ale relaţiei din care face parte;

nu poate migra niciodată din relaţia din care face parte.

The correct answer is "identifică unic fiecare tuplu al unei relaţii". This means that the primary key uniquely identifies each tuple in a relation. The primary key is a set of attributes that ensures that each tuple in the relation is uniquely identified and can be used to uniquely identify and access each tuple in the relation.

Explanation

The correct answer is "identifică unic fiecare tuplu al unei relaţii". This means that the primary key uniquely identifies each tuple in a relation. The primary key is a set of attributes that ensures that each tuple in the relation is uniquely identified and can be used to uniquely identify and access each tuple in the relation.

10. Printre factorii care au contribuit la adoptarea în masa a sistemelor de baze de date se numără:

necesitatea unei administrări mai eficiente a unei cantităţi mai mari de informaţii;

creşterea semnificativă a preţurilor aferente componentelor hardware şi software;

apariţia tehnicilor bazate pe gandirea orientată-obiect;

dezvoltarea prelucrărilor bazate pe tehnologia client-server.

The factors that contributed to the mass adoption of database systems include the need for more efficient management of larger amounts of information, the emergence of object-oriented thinking techniques, and the development of processing based on client-server technology.

Explanation

The factors that contributed to the mass adoption of database systems include the need for more efficient management of larger amounts of information, the emergence of object-oriented thinking techniques, and the development of processing based on client-server technology.

Submit