an two different users own tables with the same name?

an two different users own tables with the same name?
by

1 Answer

Answer :

Yes, tables are unique by username.tablename.
by

Related questions

What are mutating tables?

Description : What are mutating tables?

Last Answer : When a table is in state of transition it is said to be mutating. eg : If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.

What is the difference between deleting and truncating of tables?

Description : What is the difference between deleting and truncating of tables?

Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.

Can objects of the same Schema reside in different tablespaces? –

Description : Can objects of the same Schema reside in different tablespaces? –

Last Answer : Yes.

What are different types of column in reports?

Description : What are different types of column in reports?

Last Answer : There are three types of columns in the report 6i these are: 1) Placeholder Column – Placeholder column is used to store a value for a variable. 2) Formula Column 3) Summary Column

How many different triggers are available in Report?

Description : How many different triggers are available in Report?

Last Answer : There are five types of triggers in report 6i 1) Before report trigger 2) After report trigger 3) Before Parameter trigger 4) After parameter trigger 5) Between pages trigger

What are the different approaches used by Optimizer in choosing an execution plan?

Description : What are the different approaches used by Optimizer in choosing an execution plan?

Last Answer : Rule-based and Cost-based.

What are the different type of Segments?

Description : What are the different type of Segments?

Last Answer : Data Segment, Index Segment, Rollback Segment and Temporary Segment.

Can a Tablespace hold objects from different Schemes?

Description : Can a Tablespace hold objects from different Schemes?

Last Answer : Yes.

What are the different modes of mounting a Database with the Parallel Server?

Description : What are the different modes of mounting a Database with the Parallel Server?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is ... parallel mode, other instances that are started in parallel mode can also mount the database.

Can you have two stored functions with the same name ?

Description : Can you have two stored functions with the same name ?

Last Answer : Yes.

Can you have two functions with the same name in a PL/SQL block

Description : Can you have two functions with the same name in a PL/SQL block

Last Answer : Yes.

Can 2 functions have same name & input parameters but differ only by return datatype

Description : Can 2 functions have same name & input parameters but differ only by return datatype

Last Answer : No.

Can we define exceptions twice in same block ?

Description : Can we define exceptions twice in same block ?

Last Answer : No.

How can a new view be created from two old views that have common field names?

Description : How can a new view be created from two old views that have common field names?

Last Answer : Use aliases in the fields. For example: CREATE VIEW x AS SELECT tab1.fld1 afld1, tab2.fld1 bfld1

How many rows will the following SQL return

Description : How many rows will the following SQL return

Last Answer : Select * from emp Where rownum < 10; 9 rows.

Can you use %RowCount as a parameter to a cursor

Description : Can you use %RowCount as a parameter to a cursor

Last Answer : Yes

What are the various types of RollBack Segments ?

Description : What are the various types of RollBack Segments ?

Last Answer : Public Available to all instances Private Available to specific instance

Can you pass a parameter to a cursor ?

Description : Can you pass a parameter to a cursor ?

Last Answer : Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median

What is the significance of the & and && operators in PL SQL ?

Description : What is the significance of the & and && operators in PL SQL ?

Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).

What is the maximum no. of columns a table can have ?

Description : What is the maximum no. of columns a table can have ?

Last Answer : 254.

Can you Rollback to any savepoint ?

Description : Can you Rollback to any savepoint ?

Last Answer : Yes.

Can you define multiple savepoints ?

Description : Can you define multiple savepoints ?

Last Answer : Yes.

An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Last Answer : No.

What is the difference between unique key and primary key ?

Description : What is the difference between unique key and primary key ?

Last Answer : Unique key can be null; Primary key cannot be null.

What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

Description : What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

Last Answer : The various states of a rollback segment are : ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.

What are the min. extents allocated to a rollback extent ?

Description : What are the min. extents allocated to a rollback extent ?

Last Answer : Two

Can Check constraint be used for self referential integrity ? How ?

Description : Can Check constraint be used for self referential integrity ? How ?

Last Answer : ? Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.

Can null keys be entered in cluster index, normal index ?

Description : Can null keys be entered in cluster index, normal index ?

Last Answer : Yes.

Can Long/Long RAW be clustered ?

Description : Can Long/Long RAW be clustered ?

Last Answer : No.

What are the disadvantages of clusters ?

Description : What are the disadvantages of clusters ?

Last Answer : The time for Insert increases.

What are the advantages of clusters ?

Description : What are the advantages of clusters ?

Last Answer : Access time reduced for joins.

What is the use of Data Dictionary ?

Description : What is the use of Data Dictionary ?

Last Answer : Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, et

What is the use of Control files ?

Description : What is the use of Control files ?

Last Answer : Contains pointers to locations of various data files, redo log files, etc.

Can you increase the size of datafiles ? How ?

Description : Can you increase the size of datafiles ? How ?

Last Answer : No (for Oracle 7.0)

Can you increase the size of a tablespace ? How ?

Description : Can you increase the size of a tablespace ? How ?

Last Answer : Yes, by adding datafiles to it.

Describe Oracle database's physical and logical structure

Description : Describe Oracle database's physical and logical structure

Last Answer : Physical : Data files, Redo Log files, Control file. Logical : Tables, Views, Tablespaces, etc.

What are constraining triggers ?

Description : What are constraining triggers ?

Last Answer : A trigger giving an Insert/Updat e on a table having referential integrity constraint on the triggering table.

What are mutating triggers ?

Description : What are mutating triggers ?

Last Answer : A trigger giving a SELECT on the table on which the trigger is written.

What are cascading triggers? What is the maximum no of cascading triggers at a time?

Description : What are cascading triggers? What is the maximum no of cascading triggers at a time?

Last Answer : When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.

Can views be specified in a trigger statement ?

Description : Can views be specified in a trigger statement ?

Last Answer : No

What is the maximum no. of statements that can be specified in a trigger statement?

Description : What is the maximum no. of statements that can be specified in a trigger statement?

Last Answer : One.

What is the advantage of a stored procedure over a database trigger ?

Description : What is the advantage of a stored procedure over a database trigger ?

Last Answer : We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

What are the various types of database triggers ?

Description : What are the various types of database triggers ?

Last Answer : There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12)

What are the parts of a database trigger ?

Description : What are the parts of a database trigger ?

Last Answer : The parts of a trigger are: A triggering event or statement A trigger restriction A trigger action

Can you pass parameters in packages ? How ?

Description : Can you pass parameters in packages ? How ?

Last Answer : Yes. You can pass parameters to procedures or functions in a package.

Why Create or Replace and not Drop and recreate procedures ?

Description : Why Create or Replace and not Drop and recreate procedures ?

Last Answer : So that Grants are not dropped.

What are the constructs of a procedure, function or a package ?

Description : What are the constructs of a procedure, function or a package ?

Last Answer : The constructs of a procedure, function or a package are : variables and constants cursors exceptions

Can functions be overloaded ?

Description : Can functions be overloaded ?

Last Answer : Yes.

What is Over Loading and what are its restrictions ?

Description : What is Over Loading and what are its restrictions ?

Last Answer : OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.

What are the various types of parameter modes in a procedure ?

Description : What are the various types of parameter modes in a procedure ?

Last Answer : IN, OUT AND INOUT.