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.
Related Questions
Question :
Calculate Operating ratio -
|
Particulars |
Amount |
|
Revenue from Operations |
600000 |
|
Gross profit |
20% |
|
Office Expense |
30000 |
|
Selling Expense |
48000 |
Option 1: 80%
Option 2: 95.33%
Option 3: 85%
Option 4: 93%
Question :
From the Following information what will be the amount of asset purchased during the year?
|
Particulars |
Closing |
Opening |
|
Machinery (At cost) |
690000 |
600000 |
|
Accumulated Depreciation |
90000 |
60000 |
Additional information: During the year a machine coating Rs.50,000 with accumulated depreciation Rs.32,000 was sold for Rs.20,000.
Option 1: Rs.1,40,000
Option 2: Rs.1,20,000
Option 3: Rs.1,65,000
Option 4: None of the above
Question :
Calculate Cash Flow From Investing activities From the following information -
|
Particulars |
Amount |
|
Purchase of machine |
300000 |
|
Purchase of goodwill |
150000 |
|
Purchase of Investment |
200000 |
|
Sale of Machine |
85000 |
|
Sale of inveatment |
80000 |
|
Sale of Patents |
90000 |
|
Interest and dividend Received |
60000 |
|
Rent Received |
80000 |
Option 1: Rs.(2,55,000)
Option 2: Rs.6,50,000
Option 3: Rs.3,95,000
Option 4: None of the Above
Question :
On the basis of following information received from a firm, its proprietary ratio will be -
|
Particulars |
Amount |
|
Fixed assets |
330000 |
|
Current assets |
190000 |
|
Preliminary Exp. |
30000 |
|
Equity share capital |
244000 |
|
Prefrence share capital |
170000 |
|
Reserve Fund |
58000 |
Option 1: 80%
Option 2: 85%
Option 3: 70%
Option 4: 90%
Trending Articles/News
