The join defined by the default data link is an outer join yes or no?

The join defined by the default data link is an outer join
yes or no?
by

1 Answer

Answer :

Yes
by

Related questions

What is a OUTER JOIN?

Description : What is a OUTER JOIN?

Last Answer : Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Can u set default font in forms?

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

What are the default extensions of the files created by forms modules?

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

What are the default extensions of the files created by menu module?

Description : What are the default extensions of the files created by menu module?

Last Answer : .mmb, .mmx

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What are the default extensions of the files created by library module?

Description : What are the default extensions of the files created by library module?

Last Answer : The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

What is default tablespace ?

Description : What is default tablespace ?

Last Answer : The Tablespace to contain schema objects created without specifying a tablespace name.

Which default Database roles are created when you create a Database?

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

Which are the default passwords of SYSTEM/SYS?

Description : Which are the default passwords of SYSTEM/SYS?

Last Answer : MANAGER / CHANGE_ON_INSTALL

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.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Description : If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Last Answer : For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.

Can you make a Datafile auto extendible? If yes how?

Description : Can you make a Datafile auto extendible? If yes how?

Last Answer : YES. A Datafile can be auto extendible. Here's how to enable auto extend on a Datafile: SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on; ... 'alter database datafile '|| file_name|| ' '|| ' autoextend on;' from dba_data_files; SQL>@runts

Given the potential V = 25 sin θ, in free space, determine whether V satisfies Laplace’s equation. a) Yes b) No c) Data sufficient d) Potential is not defined

Description : Given the potential V = 25 sin θ, in free space, determine whether V satisfies Laplace’s equation. a) Yes b) No c) Data sufficient d) Potential is not defined

Last Answer : a) Yes

State true or false for Java Program. i) Data members of an interface are by default final ii) An abstract class has implementations of all methods defined inside it. A) i-false, ii-false B) i-false, ii-true C) i-true, ii-false D) i-true, ii-true

Description : State true or false for Java Program. i) Data members of an interface are by default final ii) An abstract class has implementations of all methods defined inside it. A) i-false, ii-false B) i-false, ii-true C) i-true, ii-false D) i-true, ii-true

Last Answer : C) i-true, ii-false

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

What are the different types of JOIN operations?

Description : What are the different types of JOIN operations?

Last Answer : Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there

Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Last Answer : a) i& ii b) ii & iii

Are the resulting relations of PRODUCT and JOIN operation the same?

Description : Are the resulting relations of PRODUCT and JOIN operation the same?

Last Answer : No. PRODUCT: Concatenation of every row in one relation with every row in another. JOIN: Concatenation of rows from one relation and related rows from another

What is join dependency and inclusion dependency?

Description : What is join dependency and inclusion dependency?

Last Answer : Join Dependency: A Join dependency is generalization of Multivalued dependency.A JD {R1, R2, ,Rn} is said to hold over a relation R if R1, R2, R3, , Rn is a lossless-join ... columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.

What is Lossless join property?

Description : What is Lossless join property?

Last Answer : It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.

............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Description : ............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Last Answer : B) Inner

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What is use of a cursor variable? How it is defined?

Description : What is use of a cursor variable? How it is defined?

Last Answer : A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor ... indicating the types of the select list that will eventually be returned by the cursor variable.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

What is network database link?

Description : What is network database link?

Last Answer : Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

What is public database link?

Description : What is public database link?

Last Answer : Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

What is private database link?

Description : What is private database link?

Last Answer : Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

What is Database Link ?

Description : What is Database Link ?

Last Answer : A database link is a named object that describes a "path" from one database to another.

What is a database link ?

Description : What is a database link ?

Last Answer : Database Link is a named path through which a remote database can be accessed.

How is link tool operation different bet. reports 2 & 2.5?

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

What are the sql clauses supported in the link property sheet?

Description : What are the sql clauses supported in the link property sheet?

Last Answer : Where start with having.

The ............ operator preserves unmatched rows of the relations being joined. A) Inner join B) Outer join C) Union D) Union join

Description : The ............ operator preserves unmatched rows of the relations being joined. A) Inner join B) Outer join C) Union D) Union join

Last Answer : B) Outer join

Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are equivalent. (A) I and II are correct. (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Description : Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are ... (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Last Answer : (D) Only I is correct.

The _______ layer provides a well defined service interface to the network layer, determining how the bits of the physical layer are grouped into frames A. Data Link B. Physical C. Network D. Session

Description : The _______ layer provides a well defined service interface to the network layer, determining how the bits of the physical layer are grouped into frames A. Data Link B. Physical C. Network D. Session

Last Answer : A. Data Link

IEEE has defined the specifications for a wireless LAN, called _______, which covers the physical and data link layers.

Description : IEEE has defined the specifications for a wireless LAN, called _______, which covers the physical and data link layers.

Last Answer : . IEEE 802.11

Difference between NO DATA FOUND and %NOTFOUND?

Description : Difference between NO DATA FOUND and %NOTFOUND?

Last Answer : NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

Why is it preferable to create a fewer no. of queries in the data model?

Description : Why is it preferable to create a fewer no. of queries in the data model?

Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

Pitch of coil is defined as axial distance in compressed state of the coil. a) Yes b) It is measured in uncompressed state c) It is same in uncompressed or compressed state d) None of the listed

Description : Pitch of coil is defined as axial distance in compressed state of the coil. a) Yes b) It is measured in uncompressed state c) It is same in uncompressed or compressed state d) None of the listed

Last Answer : b) It is measured in uncompressed state

The yield moment of a cross section is defined as the moment that will just produce the yield stress in (A) The outer most fibre of the section (B) The inner most fibre of the section (C) The neutral fibre of the section (D) The fibre everywhere

Description : The yield moment of a cross section is defined as the moment that will just produce the yield  stress in  (A) The outer most fibre of the section  (B) The inner most fibre of the section  (C) The neutral fibre of the section  (D) The fibre everywhere 

Last Answer : (A) The outer most fibre of the section