Question :
Which two files are used during operation of the DBMS?
Option 1: Query language and utilities
Option 2: Data manipulation language and query language
Option 3: Data dictionary and transaction log
Option 4: Data dictionary and query language
Correct Answer: Data dictionary and transaction log
Solution : Data dictionary Data elements utilised or recorded in a database, information system, or as a component of a research study are given names, definitions, and properties in a data dictionary.
Transaction log Every SQL Server database has a transaction log that keeps track of all transactions and the changes that they make to the database. The database's transaction log is an essential part. You will require that log in order to restore consistency to your database in the event of a system failure.
Hence, the two files used by the dbms during operation are the data dictionary and transaction log.
Hence the correct answer is option 3.
Calculate Operating ratio
The founder of the independent Sikh state was :
From the Following information what
Calculate Cash Flow From Investing
On the basis of following information
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile