If a View on a single base table is manipulated will the changes be reflected on the base table ?

If a View on a single base table is manipulated will the changes be reflected on the base table ?
by

1 Answer

Answer :

If changes are made to the tables which are base tables of a view will
the changes be reference on the view.
by

Related questions

In which view can you find information about every view and table of oracle dictionary

Description : In which view can you find information about every view and table of oracle dictionary

Last Answer : DICT or DICTIONARY

How will you delete duplicating rows from a base table?

Description : How will you delete duplicating rows from a base table?

Last Answer : delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid

Committed block sometimes refer to a BASE TABLE ?

Description : Committed block sometimes refer to a BASE TABLE ?

Last Answer : False

The mechanism which changes the value of manipulated variable in response to the output signal from the control unit is called the (A) Final control element (B) On-off control (C) Floating control action (D) None of these

Description : The mechanism which changes the value of manipulated variable in response to the output signal from the control unit is called the (A) Final control element (B) On-off control (C) Floating control action (D) None of these

Last Answer : Option A

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

What view would you use to determine free space in a tablespace?

Description : What view would you use to determine free space in a tablespae?

Last Answer : DBA_FREE_SPACE

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

Can a view be updated/inserted/deleted? If Yes under what conditions ?

Description : Can a view be updated/inserted/deleted? If Yes under what conditions ?

Last Answer : A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

What are the advantages of VIEW ?

Description : What are the advantages of VIEW ?

Last Answer : To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

What is a view ?

Description : What is a view ?

Last Answer : A view is stored procedure based on one or more tables, it’s a virtual table.

What is a canvas-view?

Description : What is a canvas-view?

Last Answer : A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they ... assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.

What is the content view and stacked view?

Description : What is the content view and stacked view?

Last Answer : A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned

Do a view contain data?

Description : Do a view contain data?

Last Answer : Views do not contain or store data.

Can you have more than one content canvas view attached with a window?

Description : Can you have more than one content canvas view attached with a window?

Last Answer : Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

How does one get the view definition of fixed views/tables?

Description : How does one get the view definition of fixed views/tables?

Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

Can a view based on another view?

Description : Can a view based on another view?

Last Answer : Yes.

What is a View ?

Description : What is a View ?

Last Answer : A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

Do View contain Data ?

Description : Do View contain Data ?

Last Answer : Views do not contain or store data.

Can a View based on another View ?

Description : Can a View based on another View ?

Last Answer : Yes.

What is an Oracle view?

Description : What is an Oracle view?

Last Answer : A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

What is VDL (View Definition Language)?

Description : What is VDL (View Definition Language)?

Last Answer : It specifies user views and their mappings to the conceptual schema.

What is a view? How it is related to data independence?

Description : What is a view? How it is related to data independence?

Last Answer : A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other ... users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

What is the difference between a view and a materialized view?

Description : What is the difference between a view and a materialized view?

Last Answer : A view is a select that is executed each time an user accesses to it. A materialized view stores the result of this query in memory for faster access purposes.

How can you view all the current users connected in your database in this moment?

Description : How can you view all the current users connected in your database in this moment?

Last Answer : SELECT COUNT(*),USERNAME FROM V$SESSION GROUP BY USERNAME;

How can you view all the users account in the database?

Description : How can you view all the users account in the database?

Last Answer : SELECT USERNAME FROM DBA_USERS

Give two methods you could use to determine what DDL changes have been made.

Description : Give two methods you could use to determine what DDL changes have been made.

Last Answer : You could use Logminer or Streams

Can a repeating frame be created without a data group as a base?

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Atleast how many set of data must a data model have before a data model can be base on it?

Description : Atleast how many set of data must a data model have before a data model can be base on it?

Last Answer : Four

What are the basic element of Base configuration of an oracle Database ?

Description : What are the basic element of Base configuration of an oracle Database ?

Last Answer : It consists of one or more data files. one or more control files. two or more redo log files. The Database contains multiple users/schemas one or more rollback segments one or more tablespaces ... (Data Base Write) ARCH (ARCHiver) CKPT (Check Point) RECO Dispatcher User Process with associated PGS

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

How can you gather statistics on a table?

Description : How can you gather statistics on a table?

Last Answer : The ANALYZE command.

How would you determine who has added a row to a table?

Description : How would you determine who has added a row to a table?

Last Answer : Turn on fine grain auditing for the table.

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.

What type of index should you use on a fact table?

Description : What type of index should you use on a fact table?

Last Answer : A Bitmap index.

Compare and contrast TRUNCATE and DELETE for a table.

Description : Compare and contrast TRUNCATE and DELETE for a table.

Last Answer : Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just ... other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

Give two examples of how you might determine the structure of the table DEPT.

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

How many columns can table have?

Description : How many columns can table have?

Last Answer : The number of columns in a table can range from 1 to 254.

Deleting the Duplicate rows in the table

Description : Deleting the Duplicate rows in the table

Last Answer : We can delete the duplicate rows in the table by using the Rowid

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

Find out nth highest salary from emp table?

Description : Find out nth highest salary from emp table?

Last Answer : SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

What are the data types allowed in a table ?

Description : What are the data types allowed in a table ?

Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

What is the fastest way of accessing a row in a table ?

Description : What is the fastest way of accessing a row in a table ?

Last Answer : Using ROWID.CONSTRAINTS

How do you find the numbert of rows in a Table ?

Description : How do you find the numbert of rows in a Table ?

Last Answer : A bad answer is count them (SELECT COUNT(*) FROM table_name) A good answer is :- 'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g ... utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

Write the order of precedence for validation of a column in a table ?

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?