GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Placement Papers  >  IBM  >  Aptitude
Go To First  |  Previous Question  |  Next Question 
 Aptitude  |  Question 90 of 124    Print  
A question on views
A. views have separate tables
B. they do not specify tables
C. they have simply definition
D. None of the above.

Which of the following has function scope:
A. automatic variables
B. static variables
C. extern variables
D. none of the above


  
Total Answers and Comments: 1 Last Update: October 16, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: deviji2000
 
1)      views r stored as a SELECT statements in the data dictionary.

2)      they specify tables like

         create or replace view vw_emp as SELECT * FROM emp;

         so, they specify tables in select statements.

3)      of course there is nothing like view body like package body or proc body
          instead u can view the structure of a view using


         desc vw_emp;

         and get the contents the view like

         select * from vw_emp;

cheers,
viji

Above answer was rated as good by the following members:
Bhoomika sharma
October 16, 2007 04:23:19   #1  
deviji2000 Member Since: July 2007   Contribution: 11    

RE: A question on viewsA. views have separate tab...
1) views r stored as a SELECT statements in the data dictionary.

2) they specify tables like

create or replace view vw_emp as SELECT * FROM emp;

so they specify tables in select statements.

3) of course there is nothing like view body like package body or proc body
instead u can view the structure of a view using


desc vw_emp;

and get the contents the view like

select * from vw_emp;

cheers
viji

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    

 Related Questions

In a group there are two kinds of people type A & type B. Type A people answer for any question as YES & that of type B as NO. If they cannot answer to these question then they remain silent. the mayor asks question to them as follows........If he asks a person are u type Aa. YES b.NO c. Silent d.Can not be determinedHe asks two persons X &Simultaneously whether u of same typea. YES b. NO c.YES or NO d. Silent e. cannot be determinedPointing to a person X he asks Y what is his typea.

int (*f)(),int* f() 
Tags : Pointer

What does the following statement mean?Int (*a)[4]A. 'a' is a pointer to an array of 4 integersB. 'a' is an array of pointers to integerC. 'a' is a pointer to function returning an integer
Tags : Pointer

A question on viewsA. views have separate tablesB. they do not specify tablesC. they have simply definitionD. None of the above.Which of the following has function scope:A. automatic variablesB. static variablesC. extern variablesD. none of the above

Class a{float add (..);double add(…);…..}This is an example ofA. function overloadingB. function overridingC. none of the above


 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
 

Using XMLType Views

Using XMLType Views Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML Once written an XMLType view may be used in various queries making them simpler and so increasing their readability mosgo
 

ODP.NET - Working with Bind Variables together with OracleParameter

ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m
 

Microsoft AJAX Library - Functions as Variables

Functions as Variables In JavaScript functions are first class objects This means that a function is regarded as a data type whose values can be saved in local variables passed as parameters and so on For example when defining a function you can assign it to a variable and then call the function thr
 

C++ Static Functions

C Static Functions Static member functions have a class scope and they do not have access to the this pointer of the class When a member is declared as static a static member of class it has only one data for the entire class even though there are many objects created for the class The main usage of
 

C++ Pure Virtual Function and Base Class

C Pure Virtual Function and Virtual Base Class In this C tutorial you will learn about pure virtual function declaration of pure virtual function and virtual base class virtual base class and how to implement a virtual base class explained with examples mosgoogle center What is Pure Virtual Function
 

C++ Function Passing Types

C Function Passing Types In this C tutorial you will learn about function passing types two types of arguments passing in functions passed by value  and  passed by reference are discussed here mosgoogle center The arguments passed to a function can be performed in two ways Passed
 

What is Comprehensive Data Definition

A Comprehensive Data Definition refers to a formal data definition that provides a complete, meaningful, easily read, readily understood definition explaining the content and meaning of data. In a business enterprise environment where people are heavily depending on intelligent business systems (bus
 

Automatic Data Replication

Automatic Data Replication is the process wherein created data and metadata automatically replicates based in the request of the client at a specific data site. A data site could maintain many computers working as a system to manage one or more data warehouses. These warehouses are repositories of m
 

Automatic Data Partitioning

Automatic data partitioning is the process of breaking down large chunks of data and metadata at a specific data site into partitions according to the request specification of the client. Data sites contain multitudes of varied data which can be extremely useful as a statistical basis for determin
 

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