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

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
by

1 Answer

Answer :

a) i& ii b) ii & iii
by

Related questions

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

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.

What is normalization?

Description : What is normalization?

Last Answer : It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties ∙ Minimizing redundancy ∙ Minimizing insertion, deletion and update anomalies.

…………………… is the process of organizing data into related tables. A) Normalization B) Generalization C) Specialization D) None of the above

Description : …………………… is the process of organizing data into related tables. A) Normalization B) Generalization C) Specialization D) None of the above

Last Answer : A

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Last Answer : (A) Number of tuples

Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 retains relation R, but deletes all tuples in R. III. C1 deletes not only all tuples of R, but also the schema for R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Description : Consider the following two commands C1 and C2 on the relation R from an SQL database:  C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Last Answer : (C) II and III only

What are various joins used while writing SUBQUERIES?

Description : What are various joins used while writing SUBQUERIES?

Last Answer : Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though ... in which one or more columns in one table are equal to one or more columns in the second table.

Which is the main function of transport layer? A) Node to node delivery B) End to end delivery C) Synchronization d) Updating and maintaining routing tables

Description : Which is the main function of transport layer? A) Node to node delivery B) End to end delivery C) Synchronization d) Updating and maintaining routing tables

Last Answer : B) End to end delivery

Which is the main function of transport layer? A) Node to node delivery B) End to end delivery C) Synchronization d) Updating and maintaining routing tables

Description : Which is the main function of transport layer? A) Node to node delivery B) End to end delivery C) Synchronization d) Updating and maintaining routing tables

Last Answer : B) End to end delivery

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

Arrange the following in correct order of their stability ? `(I) CH-=overset(Theta)C " "(II) CH_(2)=overset(Theta)CH " "(III) CH_(3)-overset(Theta)CH_

Description : Arrange the following in correct order of their stability ? `(I) CH-=overset(Theta)C " "(II) CH_(2)=overset(Theta)CH " "(III) CH_(3)-overset(Theta)CH_

Last Answer : Arrange the following in correct order of their stability ? `(I) CH-=overset(Theta)C " "(II) CH_(2)=overset( ... gt III gt I` D. `II gt I gt III`

If the P(E) = 1, it means event a. does not occur b. always occur c. no probability d. Normalization

Description : If the P(E) = 1, it means event a. does not occur b. always occur c. no probability d. Normalization

Last Answer : b. always occur

What is the use of TABLES option in EXP command ?

Description : What is the use of TABLES option in EXP command ?

Last Answer : List of tables should be exported.ze)

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.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

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.

What is in all those X$ tables? (for DBA

Description : What is in all those X$ tables? (for DBA

Last Answer : The following list attempts to describe some x$ tables. The list may not be complete or accurate, but represents an attempt to figure out what information they contain. One should generally not ... Fixed Table. It can predict the potential loss of decreasing the number of database buffers. The

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.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

How will you estimate the space required by a non- clustered tables?

Description : How will you estimate the space required by a non- clustered tables?

Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.

What are the dictionary tables used to monitor a database space?

Description : What are the dictionary tables used to monitor a database space?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

What are the dictionary tables used to monitor a database spaces ?

Description : What are the dictionary tables used to monitor a database spaces ?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

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';

Tables derived from the ERD

Description : Tables derived from the ERD

Last Answer : a) Are totally unnormalised b) Are always in 1NF c) Can be further denormalised d) May have multi-valued attributes (b) Are always in 1NF

How do you move tables from one tablespace to another tablespace?

Description : How do you move tables from one tablespace to another tablespace?

Last Answer : There are several methods to do this; 1) export the table, drop the table, create the table definition in the new tablespace, and then import the data (imp ignore=y). 2) Create ... table and rename the temporary table as the original: DROP TABLE real_table; RENAME temp_name TO real_table;

Can you make collection of Statistics for tables automatically?

Description : Can you make collection of Statistics for tables automatically?

Last Answer : YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two scheduled activities related to ... GATHER_STATS_JOB'); Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.

Name the seven types of Oracle tables

Description : Name the seven types of Oracle tables

Last Answer : Heap Organized Tables, Index Organized Tables, Index Clustered Tables, Hash Clustered Tables, Nested Tables, Global Temporary Tables, Object Tables.

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

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

Last Answer : Yes

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.

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

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.

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Quantitative data refers to (i) Graphs and tables (ii) Any data you present in your report (iii) Statistical analysis (iv) Numerical data that could be useful to answer your research question(s) and to meet your Objectives

Description : Quantitative data refers to (i) Graphs and tables (ii) Any data you present in your report (iii) Statistical analysis (iv) Numerical data that could be useful to answer your research question(s) and to meet your Objectives

Last Answer : (iv) Numerical data that could be useful to answer your research question(s) and to meet your Objectives

Solve the following equation `(i) 5cos2theta+2cos^(2)"(theta)/(2)+1=0`, `-(pi)/(2) lt theta lt (pi)/(2)` `(ii) sin7theta+sin4theta+sintheta=0`, `0 le

Description : Solve the following equation `(i) 5cos2theta+2cos^(2)"(theta)/(2)+1=0`, `-(pi)/(2) lt theta lt (pi)/(2)` `(ii) sin7theta+sin4theta+sintheta=0`, `0 le

Last Answer : Solve the following equation `(i) 5cos2theta+2cos^(2)"(theta)/(2)+1=0`, `-(pi)/(2) lt theta ... iii) tantheta+sectheta=sqrt(3)`, `0 le theta le 2pi`

Reaction I `Ph-overset(O)overset(||)(C)-NH_(2) overset(overset(Theta)(OD),Br_(2))rarrA` Reaction II `Ph-overset(O)overset(||)(C)-ND_(2) overset(overse

Description : Reaction I `Ph-overset(O)overset(||)(C)-NH_(2) overset(overset(Theta)(OD),Br_(2))rarrA` Reaction II `Ph-overset(O)overset(||)(C)-ND_(2) overset(overse

Last Answer : Reaction I `Ph-overset(O)overset(||)(C)-NH_(2) overset(overset(Theta)(OD),Br_(2))rarrA` Reaction II `Ph- ... Both `Ph-NH_(2)` D. Both `Ph-ND_(2)`

If sin theta equals 3/4 and theta is in quadrant II what is the value of tan theta?

Description : If sin theta equals 3/4 and theta is in quadrant II what is the value of tan theta?

Last Answer : 0.75

Spurious coins detected at the counter are sent to _____ A. RBI B. GOI C. IBRD D. Mint E. None of the Above

Description : Spurious coins detected at the counter are sent to _____ A. RBI B. GOI C. IBRD D. Mint E. None of the Above

Last Answer : D. Mint Explanation: when Spurious coins tendered over the counter, it should be cut and handed over to the tenderer. If the tenderer disputes it, the coins should be sent to the mint at his cost, for examination.

What mixer type has the lowest spurious signals? A. Double-balanced B. Single-balanced C. Super-heterodyner D. Heterodyner

Description : What mixer type has the lowest spurious signals? A. Double-balanced B. Single-balanced C. Super-heterodyner D. Heterodyner

Last Answer : A. Double-balanced

When no signal is being received, the loudspeaker is not entirely silent as a result of the presence of A. parasitic oscillations in some of the receiver stages. B. negative feedback in each stage. C. spurious frequencies as a result of improper neutralization. D. internal receiver noise.

Description : When no signal is being received, the loudspeaker is not entirely silent as a result of the presence of A. parasitic oscillations in some of the receiver stages. B. negative feedback in each stage. C. spurious frequencies as a result of improper neutralization. D. internal receiver noise.

Last Answer : D. internal receiver noise.

A modulation which does not follow the sine wave pattern, it produces undesirable harmonics such as spurious emission A. 0% modulated B. Over-modulated C. Unmodulated D. 100% modulated

Description : A modulation which does not follow the sine wave pattern, it produces undesirable harmonics such as spurious emission A. 0% modulated B. Over-modulated C. Unmodulated D. 100% modulated

Last Answer : B. Over-modulated

Emission on a frequency or frequencies immediately outside the necessary bandwidth which result from the modulation process except spurious emission. A. Radiation B. Noise C. Out of the band D. Interference

Description : Emission on a frequency or frequencies immediately outside the necessary bandwidth which result from the modulation process except spurious emission. A. Radiation B. Noise C. Out of the band D. Interference

Last Answer : C. Out of the band

Most often, the teacher - student communication is: (A) Spurious (B) Critical (C) Utilitarian (D) Confrontational

Description : Most often, the teacher - student communication is: (A) Spurious (B) Critical (C) Utilitarian (D) Confrontational

Last Answer : (C) Utilitarian

The sequential operations in scientific research are (A) Co-variation, Elimination of Spurious Relations, Generalisation, Theorisation (B) Generalisation, Co-variation, Theorisation, Elimination of Spurious Relations (C) Theorisation, Generalisation, Elimination of Spurious Relations, Covariation (D) Elimination of Spurious Relations, Theorisation, Generalisation, Covariation.

Description : The sequential operations in scientific research are (A) Co-variation, Elimination of Spurious Relations, Generalisation, Theorisation (B) Generalisation, Co-variation, Theorisation, ... Relations, Covariation (D) Elimination of Spurious Relations, Theorisation, Generalisation, Covariation.

Last Answer : (A) Co-variation, Elimination of Spurious Relations, Generalisation, Theorisation 

One of the aims of the scientific method in research is to: (A) improve data interpretation (B) eliminate spurious relations (C) confirm triangulation (D) introduce new variables

Description : One of the aims of the scientific method in research is to: (A) improve data interpretation (B) eliminate spurious relations (C) confirm triangulation (D) introduce new variables

Last Answer : Answer: B  aims of the scientific method in research is: Observe and Describe Predict Determination of the Causes Explain The aims of research can then be finetuned, or may serve to open up new areas of interest. Either way, the store of human knowledge has been enriched and increased.