Assuming that the process a) CKPT (Checkpoint Process) writes data from the flashback buffer to the flashback log. b) RVWR (Recovery Writer Process...

Assuming that the process
a) CKPT (Checkpoint Process) writes data from the flashback buffer to the flashback log.
b) RVWR (Recovery Writer Process) writes modified blocks from the buffer to the data files.
c) PMON (Process Monitor) periodically monitors all processes to check if they have been terminated abnormally. d) MMNL (Manegeability Monitor Process) monitors and updates data writes based on generated checkpoints.
e) DBWn (Database Writer Process) performs management tasks, including session history and obtaining metrics.
Disciplines / Subjects linked: Information Technology> Databases, Database Management Systems (DBMS), Oracle.
Source: Foundation for the University of São Paulo Vestibular - VUNESP 2022 / São Paulo Legislative Assembly ALE SP - SP / Legislative Analyst - Area: Business and Process Analysis / Question: 49
150. [Q2460400]
Regarding the characteristics of a Database Management System (DBMS), judge each of the following statements as true (V) or false (F).
I. A DBMS has the property of data dependence on the program. The structure of the data files is stored in the SGDB catalog separately from the access programs.
II. A multi-user DBMS needs to support defining multiple views of data. For example, a view can be a subset of the database or contain a virtual data that is derived from the database files.
III. A DBMS needs to ensure that concurrent transactions are performed correctly, that is, when multiple users try to update the same data, it is necessary to guarantee concurrency control so that the result of the operations is correct.
The correct sequence is
a) I - F; II - V; III - V.
b) I - F; II - F; III - V.
c) I - V; II - V; III - V.
d) I - F; II - F; III - F.
e) I - V; II - V; III - F.
Disciplines / Subjects linked: Information Technology> Databases, Database Management Systems (DBMS).
Source: Foundation for the Support and Development of Research - FADESP 2022 / State Department of Finance of Pará SEFAZ PA - PA / Tax Auditor / Question: 95
151. [Q2471283]
Regarding aspects and resources of the SQL language (Structured Query Language, SQL 1999 standard), choose the correct alternative.
a) The Data Manipulation Language (DML) is a subset of SQL that supports the creation, deletion, and modification of table and view definitions.
b) SQL does not provide mechanisms for controlling user access to data objects, such as tables and views.
c) The Data Definition Language (DDL) is a subset of SQL that allows users to formulate queries and insert, delete, and modify tuples.
d) Advanced integrity triggers and constraints are actions executed by the DBMS whenever changes to the database satisfy conditions specified in the trigger.
e) Object orientation, recursive queries, decision support queries, and text and XML data management resources are not SQL language resources or aspects.
Disciplines / Subjects linked: Information Technology> Databases, ANSI SQL Language.
Source: Federal University of Paraná - FUNPAR NC / UFPR 2022 / City Hall of Admiral Tamandaré - PR / Manager - Area: Information Technology / Question: 37
Use the following figure (Fig3), an Entity and Relationship Diagram (ERD), to answer questions 59 and 60.
Fig3
152. [Q2165825]
The elements “Collaborator”, “Administrative” and “Dependents” represent respectively:
a) Weak entity; Specialization; Strong entity.
b) Weak entity; Attribute; Strong entity.
c) Strong entity; Attribute; Weak entity.
d) Strong entity; Specialization; Weak entity.
Disciplines / Subjects linked: Information Technology> Entity-relationship model.
Source: Center for Extension, Training and Professional Improvement Ltda - CE

a) CKPT (Checkpoint Process) writes data from the flashback buffer to the flashback log.
b) RVWR (Recovery Writer Process) writes modified blocks from the buffer to the data files.
c) PMON (Process Monitor) periodically monitors all processes to check if they have been terminated abnormally.
d) MMNL (Manegeability Monitor Process) monitors and updates data writes based on generated checkpoints.
e) DBWn (Database Writer Process) performs management tasks, including session history and obtaining metrics.
I. A DBMS has the property of data dependence on the program. The structure of the data files is stored in the SGDB catalog separately from the access programs.
II. A multi-user DBMS needs to support defining multiple views of data. For example, a view can be a subset of the database or contain a virtual data that is derived from the database files.
III. A DBMS needs to ensure that concurrent transactions are performed correctly, that is, when multiple users try to update the same data, it is necessary to guarantee concurrency control so that the result of the operations is correct.
The correct sequence is
The Data Manipulation Language (DML) is a subset of SQL that supports the creation, deletion, and modification of table and view definitions.
SQL does not provide mechanisms for controlling user access to data objects, such as tables and views.
The Data Definition Language (DDL) is a subset of SQL that allows users to formulate queries and insert, delete, and modify tuples.
Advanced integrity triggers and constraints are actions executed by the DBMS whenever changes to the database satisfy conditions specified in the trigger.
Object orientation, recursive queries, decision support queries, and text and XML data management resources are not SQL language resources or aspects.
The elements “Collaborator”, “Administrative” and “Dependents” represent respectively:
a) CKPT (Checkpoint Process) writes data from the flashback buffer to the flashback log.
b) RVWR (Recovery Writer Process) writes modified blocks from the buffer to the data files.
c) PMON (Process Monitor) periodically monitors all processes to check if they have been terminated abnormally.
d) MMNL (Manegeability Monitor Process) monitors and updates data writes based on generated checkpoints.
e) DBWn (Database Writer Process) performs management tasks, including session history and obtaining metrics.
a) I - F; II - V; III - V.
b) I - F; II - F; III - V.
c) I - V; II - V; III - V.
d) I - F; II - F; III - F.
e) I - V; II - V; III - F.
a) The Data Manipulation Language (DML) is a subset of SQL that supports the creation, deletion, and modification of table and view definitions.
b) SQL does not provide mechanisms for controlling user access to data objects, such as tables and views.
c) The Data Definition Language (DDL) is a subset of SQL that allows users to formulate queries and insert, delete, and modify tuples.
d) Advanced integrity triggers and constraints are actions executed by the DBMS whenever changes to the database satisfy conditions specified in the trigger.
e) Object orientation, recursive queries, decision support queries, and text and XML data management resources are not SQL language resources or aspects.
a) Weak entity; Specialization; Strong entity.
b) Weak entity; Attribute; Strong entity.
c) Strong entity; Attribute; Weak entity.
d) Strong entity; Specialization; Weak entity.