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 -
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%
The founder of the independent Sikh state was :
Option 1:
Guru Nanak
Option 2:
Guru Govind Singh
Option 3:
Dalip Singh
Option 4: Ranjit Singh
From the Following information what will be the amount of asset purchased during the year?
Closing
Opening
Machinery (At cost)
690000
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
Calculate Cash Flow From Investing activities From the following information -
Purchase of machine
300000
Purchase of goodwill
150000
Purchase of Investment
200000
Sale of Machine
85000
Sale of inveatment
80000
Sale of Patents
Interest and dividend Received
Rent Received
Option 1: Rs.(2,55,000)
Option 2: Rs.6,50,000
Option 3: Rs.3,95,000
Option 4: None of the Above
On the basis of following information received from a firm, its proprietary ratio will be -
Fixed assets
330000
Current assets
190000
Preliminary Exp.
Equity share capital
244000
Prefrence share capital
170000
Reserve Fund
58000
Option 2: 85%
Option 3: 70%
Option 4: 90%
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile