Question :
Subschema can be used to -
Option 1: Create very different, personalized views of the same data
Option 2: Hide sensitive information by omitting fields from the sub-schema’s description
Option 3: Present information in different formats
Option 4: All of the above
Correct Answer: All of the above
Solution : A subschema is a database view that sorts or filters all data to show only the information that is relevant to the user or application in question. Software developers use subschemas to exclusively access a certain area of a larger database while creating apps. A definition of a subschema would look something like this:
a distinctive subschema name What the name of the underlying schema is various record types and views at least one set type or view
Hence the correct answer is option 4.
Which of the following is not a Schema?
Option 1: View Schema
Option 2: Physical Schema
Option 3: Critical Schema
Option 4: Logical Schema
The way a particular application views the data from the data base that the application uses is a:
Option 1: Module
Option 2: Relational model
Option 3: Schema
Option 4: Subschema
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
Calculate Operating ratio -
Amount
Revenue from Operations
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
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile