GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Mainframe  >  IDMS
Next Question 
 IDMS  |  Question 1 of 42    Print  
What is the difference between a schema and a subschema?
The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.


  
Total Answers and Comments: 1 Last Update: October 24, 2006   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: viswa
 

Schema : RePresents the complete desription of the database

subschema - subset of schema,application view of the idms db



Above answer was rated as good by the following members:
afshan shaikh
October 24, 2006 10:10:04   #1  
viswa        

RE: What is the difference between a schema and a subs...

Schema : RePresents the complete desription of the database

subschema - subset of schema application view of the idms db


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 1Overall Rating: -N/A-    

 Related Questions

The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.  
Latest Answer : Schema : RePresents the complete desription of the databasesubschema - subset of schema,application view of the idms db ...

A record occurrence is the instances of a record; it is the smallest addressable unit of data. A type is the description of a record; there need not be any occurrences.  

In local there is no IDMS System running above the DBMS. It is the more efficient mode but lacks the recovery and integrity facilities of the central version (CV) control program. In CV many application 

It generates a bind run-unit and binds all the records for the sub-schema the program is referencing.  

No. The mode is specified via the SYSCTL DD card in the JCL.  

If you are current on the owner of a set, what is the difference between an obtain next and obtain first?
No difference. There is a difference between obtain first and obtain next for an area sweep, but not when current on the owner in a set. 


 Sponsored Links

 
Related Articles

Performing DML Operations on XML Schema Based XMLType Views

Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
 

What is Conceptual Schema

In any data warehouse implementation there are many different considerations which should in place before the final physical setting up. This is to avoid in problems related to quality of data and consistencies in data processes. A conceptual schema is an abstract definition of the whole project.
 

What is Business Schema

A schema that represents the structure of business transactions used by clients in the real world. It is considered to be unnormalized data. The dictionary defines the word "schema" as a plan, diagram, scheme or an underlying organizational structure.  It can also mean a c
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape