GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 109 of 196    Print  
What is stored in tables under creator SYSIBM?

  
Total Answers and Comments: 2 Last Update: March 19, 2006     Asked by: anup 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
November 14, 2005 07:22:10   #1  
Krishna        
RE: What is stored in tables under creator SYSIBM?
Meta data information is stored in the sysibm schema. sysibm schema holds the database information and this schema exists for each database and holds the tables, columns, procedures and others that a user creates under that database.
 
Is this answer useful? Yes | No
March 18, 2006 21:54:55   #2  
Culver_lake Member Since: March 2006   Contribution: 46    
RE: What is stored in tables under creator SYSIBM?
keep it simple. The DB2 catalog is under the schema SYSIBM (along with a whole lotta other stuff as well).
 
Is this answer useful? Yes | No

 Related Questions

A DB2 bind is a process that builds an access path to DB2 tables.  
Latest Answer : A BIND process establishes a relationship between an APPLICATION PROGRAM and its RELATIONAL DATA. ...
These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.  
Latest Answer : Foreign Keys are keys used in a table as an attribute and are primary keys of some other table ...
A view is a virtual table made up of data from base tables and other views, but not stored separately.  
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...
An outer join includes rows from tables when there are no matching values in the tables.  
Latest Answer : 3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected. ...
Tables are stored in tablespaces (hence the name)! There are three types of tablespaces: simple, segmented and partitioned.  
Latest Answer : Any database contain one or more Table spaces. Each Table space is devided into pages of size 4kb or 32kb. Each table psace can have one or more tables. TABLE SPACE SPACE IS UNIT OF RECOVERY OR REORGANIZATION. There are 3 types of Table Spaces a) ...
Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.  
Latest Answer : In datawarehouse environment, mostly all the tables are semi- normalized ( ie it is fully normalized) to reduce no of joins . so de-normalization is having lot of advantages in datawarehouse . ...
A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities 
Latest Answer : Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.  
Tables related with a foreign key are called delete-connected because a deletion in the primary key table can affect the contents of the foreign key table.  
Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables. And updates of primary key values may require 

 Sponsored Links

 
Related Articles

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
 

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
 

How Data Is Stored Within a Data Warehouse

How Data Is Stored Within a Data Warehouse The data that is stored in the data warehouse is just as important as the data warehouse itself Having a fundamental understanding of how this data is stored can be useful in the successful implementation and utilization of a data warehouse One term that yo
 

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
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

HR Interview - Telephone Interview Etiquette

Telephone Interview Etiquette When you conduct a telephone interview for a job it is important to show the proper etiquette Not only is it important it is critical is you wish to be hired by the company There are a number of things you will want to do and other things should never be done mosgoogle
 

Sponsored Links

 



About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape