Register

ISRO2007-50

• edited by
13,209 views
6 votes
6 votes

A view of database that appears to an application program is known as

  1. Schema
  2. Subschema
  3. Virtual table
  4. None of these
• edited by
User Avatar

4 Answers

Best answer
8 votes
8 votes

The external level is the user’s view of the database and closest to the users.This level describes that part of the database that Fundamentals of Database Management .System is relevant to the user. Most of the users of database are not concerned with
all the information contained in the database. Instead, they need only a part of  the  database  relevant  to  them. An external schema describes each external view. The external schema consists of the definition of the logical records
and the relationships in the external view.

A subschema expresses the external view.External schema are called also called as sub schemas .

So option B is correct.

• selected by
User Avatar
5 votes
5 votes

A subschema is a subset of the schema and inherits the same property that a schema has. Subschema refers to an application programmer's (user's) view of the data item types and record types, which he or she uses. It gives the users a window through which he/she can view only that part of the database, which is of interest to him. Therefore, different application programs can have a different view of data.

User Avatar
0 votes
0 votes

Answer is b) Subschema 

A sub-schema is best described as the way that the data in a DBMS appears when viewed by an application or a user. The most important criteria for a sub-schema is that it appears logically, and as part of a decipherable system.
 

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

8 votes
8 votes
3 answers
1
go_editor asked Jun 10, 2016
4,693 views
ISRO2007-64, ISRO2008-50
Feedback queues are very simple to implement dispatch tasks according to execution characteristics are used to favour real time tasks require manual intervention to implement properly
Feedback queuesare very simple to implementdispatch tasks according to execution characteristicsare used to favour real time tasksrequire manual intervention to implement...
User Avatar
5 votes
5 votes
3 answers
2
go_editor asked Jun 10, 2016
7,499 views
ISRO2007-60
Which of the following is correct with respect to Two phase commit protocol? Ensures serializability Prevents Deadlock Detects Deadlock Recover from Deadlock
Which of the following is correct with respect to Two phase commit protocol?Ensures serializabilityPrevents DeadlockDetects DeadlockRecover from Deadlock
User Avatar
4 votes
4 votes
2 answers
3
go_editor asked Jun 10, 2016
7,913 views
ISRO2007-54
BCNF is not used for cases where a relation has Two (or more) candidate keys Two candidate keys and composite The candidate key overlap Two mutually exclusive foreign keys
BCNF is not used for cases where a relation hasTwo (or more) candidate keysTwo candidate keys and compositeThe candidate key overlapTwo mutually exclusive foreign keys
User Avatar
8 votes
8 votes
5 answers
4
go_editor asked Jun 10, 2016
4,471 views
ISRO2007-52
Which operation is used to extract specified columns from a table? Project Join Extract Substitute
Which operation is used to extract specified columns from a table?ProjectJoinExtractSubstitute
User Avatar
Link Copied!