Database management System NTA UGC NET Question Analysis Part-2
| Q62➡ | UGC NET November 2017 Paper-III Suppose a database schedule S involves transactions T1, T2, ………….,Tn. Consider the precedence graph of S with vertices representing the transactions and edges representing the conflicts. If S is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule ? |
| i ➥ Topological order |
| ii ➥ Depth – first order |
| iii ➥ Breadth – first order |
| iv ➥ Ascending order of transaction indices |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q63➡ | UGC NET November 2017 Paper-III If every non-key attribute is functionally dependent on the primary key, then the relation is in ________ . |
| i ➥ First normal form |
| ii ➥ Second normal form |
| iii ➥ Third normal form |
| iv ➥ Fourth normal form |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q64➡ | UGC NET November 2017 Paper-III Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist. CH → G A → BC B → CFH E → A F → EG The relation R is __ . |
| i ➥ in 1NF but not in 2NF |
| ii ➥ in 2NF but not in 3NF |
| iii ➥ in 3NF but not in BCNF |
| iv ➥ in BCNF |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q65➡ | UGC NET November 2017 Paper-III Given two relations R1(A, B) and R2(C, D), the result of following query Select distinct A, B from R1, R2 is guaranteed to be same as R1 provided one of the following condition is satisfied. |
| i ➥ R1 has no duplicates and R2 is empty. |
| ii ➥ R1 has no duplicates and R2 is non – empty. |
| iii ➥ Both R1 and R2 have no duplicates. |
| iv ➥ R2 has no duplicates and R1 is non – empty. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q66➡ | UGC NET November 2017 Paper-III Consider a schema R(A, B, C, D) and following functional dependencies. A → B B → C C → D D → B Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) is __ . |
| i ➥ Dependency preserving and lossless join. |
| ii ➥ Lossless join but not dependency preserving. |
| iii ➥ Dependency preserving but not lossless join. |
| iv ➥ Not dependency preserving and not lossless join. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q67➡ | UGC NET January 2017 Paper-II An attribute A of data type varchar (20) has value ‘Ram’ and the attribute B of data type char (20) has value ‘Sita’ in oracle. The attribute A has_______memory spaces and B has_______ memory spaces. |
| i ➥ 20,20 |
| ii ➥ 3,20 |
| iii ➥ 3,4 |
| iv ➥ 20,4 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q68➡ | UGC NET January 2017 Paper-II Integrity constraints ensure that changes made to the database by authorized users do not result into loss of data consistency. Which of the following statement(s) is (are) true w.r.t. the examples of integrity constraints ? (1) An instructor Id. No. cannot be null, provided Instructor Id No. being primary key. (2) No two citizens have same Adhar-Id. (3) Budget of a company must be zero. |
| i ➥ (1), (2) and (3) are true |
| ii ➥ (1) false, (2) and (3) are true. |
| iii ➥ (1) and (2) are true; (3) false. |
| iv ➥ (1), (2) and (3) are false |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q69➡ | UGC NET January 2017 Paper-II Let M and N be two entities in an E-R diagram with simple single value attributes. R1 and R2 are two relationship between M and N, where as R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are ______. |
| i ➥ 4 |
| ii ➥ 6 |
| iii ➥ 7 |
| iv ➥ 3 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q70➡ | UGC NET January 2017 Paper-II Consider a schema R(MNPQ) and functional dependencies M → N, P → Q. Then the decomposition of R into R1 (MN) and R2 (PQ) is________. |
| i ➥ Dependency preserving but not lossless join |
| ii ➥ Dependency preserving and lossless join |
| iii ➥ Lossless join but not dependency preserving |
| iv ➥ Neither dependency preserving nor lossless join. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q71➡ | UGC NET January 2017 Paper-II The order of a leaf node in a B+ tree is the maximum number of children it can have. Suppose that block size is 1 kilobytes, the child pointer takes 7 bytes long and search field value takes 14 bytes long. The order of the leaf node is __. |
| i ➥ 16 |
| ii ➥ 63 |
| iii ➥ 64 |
| iv ➥ 69 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q72➡ | UGC NET January 2017 Paper-II _____refers loosely to the process of semi-automatically analyzing large databases to find useful patterns. |
| i ➥ Datamining |
| ii ➥ Data warehousing |
| iii ➥ DBMS |
| iv ➥ Data mirroring |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q73➡ | UGC NET January 2017 Paper-II Which of the following statements is/are true w.r.t. Enterprise Resource Planning (ERP) ? (A) ERP automates and integrates majority of business processes. (B) ERP provides access to information in a Real Time Environment. (C) ERP is inexpensive to implement |
| i ➥ (A), (B) and (C) are false. |
| ii ➥ (A) and (B) false; (C) true. |
| iii ➥ (A) and (B) true; (C) false. |
| iv ➥ (A) true ; (B) and (C) are false. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q74➡ | UGC NET January 2017 Paper-III Consider following schedules involving two transactions: S1 : r1(X); r1(Y); r2(X); r2(Y); w2(Y); w1(X) S2 : r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X) Which of the following statement is true? |
| i ➥ Both S1 and S2 are conflict serializable. |
| ii ➥ S1 is conflict serializable and S2 is not conflict serializable. |
| iii ➥ S1 is not conflict serializable and S2 is conflict serializable. |
| iv ➥ Both S1 and S2 are not conflict |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q75➡ | UGC NET January 2017 Paper-III Which one is correct w.r.t. RDBMS ? |
| i ➥ primary key ⊆ super key ⊆ candidate key |
| ii ➥ primary key ⊆ candidate key ⊆ super key |
| iii ➥ super key ⊆ candidate key ⊆ primary key |
| iv ➥ super key ⊆ primary key ⊆ candidate key |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q76➡ | UGC NET January 2017 Paper-III Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows : |
| i ➥ pk(R2) → pk(R1) |
| ii ➥ pk(R1) → pk(R2) |
| iii ➥ pk(R2) → R1 ∩ R2 |
| iv ➥ pk(R1) → R1 ∩ R2 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q77➡ | UGC NET January 2017 Paper-III For a database relation R(A, B, C, D) where the domains of A, B, C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are : A → C B → D The relation R is in________. |
| i ➥ First normal form but not in second normal form. |
| ii ➥ Both in first normal form as well as in second normal form. |
| iii ➥ Second normal form but not in third normal form. |
| iv ➥ Both in second normal form as well as in third normal form. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q78➡ | UGC NET January 2017 Paper-III Works (emp name, company name, salary) Here, emp_name is primary key. Consider the following SQL query Select emp name From works T Where salary > (select avg (salary) from works S where T.company _ name = S.company _name) The above query is for following : |
| i ➥ Find the highest paid employee who earns more than the average salary of all employees of his company |
| ii ➥ Find the highest paid employee who earns more than the average salary of all the employees of all the companies. |
| iii ➥ Find all employees who earn more than the average salary of all employees of all the companies. |
| iv ➥ Find all employees who earn more than the Average salary of all employees of their company. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q79➡ | UGC NET January 2017 Paper-III If following sequence of keys are inserted in a B+ tree with K(=3) pointers: 8, 5, 1, 7, 3, 12, 9, 6 Which of the following shall be correct B+ tree? |
A ➥  |
B ➥  |
C ➥  |
D ➥  |
Show Answer With Best Explanation
| Q80➡ | UGC NET July 2016 Paper-II In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: |
| i ➥ Referential integrity |
| ii ➥ Multi-valued dependency |
| iii ➥ Entity Integrity |
| iv ➥ Functional dependency |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q81➡ | UGC NET July 2016 Paper-II Which of the following statement(s) is/are FALSE in the context of Relational DBMS ? I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data in the database. II. E-R diagrams are useful to logically model concepts. III. An update anomaly is when it is not possible to store information unless some other, unrelated information is stored as well. IV. SQL is a procedural language. |
| i ➥ I and IV only |
| ii ➥ III and IV only |
| iii ➥ I, II and III only |
| iv ➥ II, III and IV only |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q82➡ | UGC NET July 2016 Paper-II In a relational database model, NULL values can be used for all but which one of the following ? |
| i ➥ To allow duplicate tuples in the table by filling the primary key column(s) with NULL. |
| ii ➥ To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ’’ (the empty string) for string columns. |
| iii ➥ To leave columns in a tuple marked as ’’unknown’’ when the actual value is unknown. |
| iv ➥ To fill a column in a tuple when that column does not really ”exist” for that particular tuple. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q83➡ | UGC NET July 2016 Paper-II 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. |
| i ➥ I only |
| ii ➥ I and II only |
| iii ➥ II and III only |
| iv ➥ I, II and III |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q84➡ | UGC NET July 2016 Paper-II Consider the following database table having A, B, C and D as its four attributes and four possible candidate keys (I, II,III and IV) for this table :  I : {B} II : {B, C} III : {A, D} IV : {C, D} If different symbols stand for different values in the table (e.g., d1 is definitely not equal to d2 ), then which of the above could not be the candidate key for the database table ? |
| i ➥ I and III only |
| ii ➥ III and IV only |
| iii ➥ II only |
| iv ➥ I only |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q85➡ | UGC NET July 2016 Paper-II Consider the following two statements : (A) Business intelligence and Data warehousing is used for forecasting and Data mining. (B) Business intelligence and Data warehousing is used for analysis of large volumes of sales data. Which one of the following options is correct ? |
| i ➥ (A) is true, (B) is false. |
| ii ➥ Both (A) and (B) are true. |
| iii ➥ (A) is false, (B) is true. |
| iv ➥ Both (A) and (B) are false. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q86➡ | UGC NET July 2016 Paper-II Consider the following two statements : (A) Data scrubling is a process to upgrade the quality of data, before it is moved into Data warehouse. (B) Data scrubling is a process of rejecting data from data warehouse to create indexes. Which one of the following options is correct ? |
| i ➥ (A) is true, (B) is false. |
| ii ➥ (A) is false, (B) is true. |
| iii ➥ Both (A) and (B) are false. |
| iv ➥ Both (A) and (B) are true. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q87➡ | UGC NET July 2016 Paper-II Given the following statements: (A) Strategic value of data mining is timestamping. (B) Information collection is an expensive process in building an expert system. Which of the following options is correct? |
| i ➥ Both (A) and (B) are false. |
| ii ➥ Both (A) and (B) are true. |
| iii ➥ (A) is true, (B) is false. |
| iv ➥ (A) is false, (B) is true. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
Database management System NTA UGC NET Question Analysis Part-2
| Q88➡ | UGC NET July 2016 Paper-III Which of the following statements is/are True regarding some advantages that an object-oriented DBMS (OODBMS) offers over a relational database ? I. An OODBMS avoids the“impedance mismatch” problem. II. An OODBMS avoids the “phantom” problem. III. An OODBMS provides higher performance concurrency control than most relational databases. IV. An OODBMS provides faster access to individual data objects once they have been read from disk. |
| i ➥ II and III only |
| ii ➥ I and IV only |
| iii ➥ I, II, and III only |
| iv ➥ I, III and IV only |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q89➡ | UGC NET July 2016 Paper-III The Global conceptual Schema in a distributed database contains information about global relations. The condition that all the data of the global relation must be mapped into the fragments, that is, it must not happen that a data item which belongs to a global relation does not belong to any fragment, is called: |
| i ➥ Disjointness condition |
| ii ➥ Completeness condition |
| iii ➥ Reconstruction condition |
| iv ➥ Aggregation condition |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | E-R Diagram | Help-Line |
| Q90➡ | UGC NET July 2016 Paper-III Suppose database table T1(P,R) currently has tuples (10,5),(15,8),(25,6) and table T2(A,C) currently has (10,6),(25,3),(10,5). Consider the following three relational algebra queries RA1,RA2 and RA3:  The number of tuples in the resulting table of RA1, RA2 and RA3 are given by : |
| i ➥ 2,4,2 respectively |
| ii ➥ 2,3,2 respectively |
| iii ➥ 3,3,1 respectively |
| iv ➥ 3,4,1 respectively |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q91➡ | UGC NET July 2016 Paper-III Consider the table R with attributes A, B and C. The functional dependencies that hold on R are : A → B, C → AB. Which of the following statements is/are True ? I. The decomposition of R into R1(C, A) and R2(A, B) is lossless. II. The decomposition of R into R1(A, B) and R2(B, C) is lossy. |
| i ➥ Only I |
| ii ➥ Only II |
| iii ➥ Both I and II |
| iv ➥ Neither I nor II |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q92➡ | UGC NET July 2016 Paper-III Consider the following ORACLE relations : One (x, y) = {<2, 5>, <1, 6>, <1, 6>, <1, 6>, <4, 8>, <4, 8>} Two (x, y) = {<2, 55>, <1, 1>, <4, 4>, <1, 6>, <4, 8>, <4, 8>, <9, 9>, <1, 6>} Consider the following two SQL queries SQ1 and SQ2 : SQ1 : SELECT * FROM One) EXCEPT (SELECT * FROM Two); SQ2 : SELECT * FROM One) EXCEPT ALL (SELECT * FROM Two); For each of the SQL queries, what is the cardinality (number of rows) of the result obtained when applied to the instances above ? |
| i ➥ 2 and 1 respectively |
| ii ➥ 1 and 2 respectively |
| iii ➥ 2 and 2 respectively |
| iv ➥ 1 and 1 respectively |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q93➡ | UGC NET July 2016 Paper-III Which one of the following pairs is correctly matched in the context of design?  |
| i ➥ A I-D, II-A, III-B, IV-C |
| ii ➥ I-D, II-C, III-B, IV-A |
| iii ➥ I-C, II-D, III-A, IV-B |
| iv ➥ I-C, II-A, III-D, IV-B |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | E-R Diagram | Help-Line |
| Q94➡ | UGC NET August 2016 Paper-II DBMS provides the facility of accessing data from a database through |
| i ➥ DDL |
| ii ➥ DML |
| iii ➥ DBA |
| iv ➥ Schema |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q95➡ | UGC NET August 2016 Paper-II Relational database schema normalization is NOT for: |
| i ➥ reducing the number of joins required to satisfy a query. |
| ii ➥ eliminating uncontrolled redundancy of data stored in the database. |
| iii ➥ eliminating number of anomalies that could otherwise occur with inserts and deletes. |
| iv ➥ ensuring that functional dependencies are enforced. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q96➡ | UGC NET August 2016 Paper-II Consider the following statements regarding relational database model: (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF. (c) The difference between the project operator (Π) in relational algebra and the SELECT keyword in SQL is that if the resulting table/set has more than one occurrences of the same tuple, then Π will return only one of them, while SQL SELECT will return all. One can determine that: |
| i ➥ (a) and (b) are true. |
| ii ➥ (a) and (b) are true |
| iii ➥ (b) and (c) are true |
| iv ➥ (a), (b) and (c) are true |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
Database management System NTA UGC NET Question Analysis Part-2
| Q97➡ | UGC NET August 2016 Paper-II Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram:  If different symbols stand for different values (e.g., t1 is definitely not equal to t2 ) , then which of the above could not be the relationship set for the E-R diagram ? |
| i ➥ I only |
| ii ➥ I and II only |
| iii ➥ II only |
| iv ➥ I, II and III |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q98➡ | UGC NET August 2016 Paper-II Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? |
| i ➥ SELECT A FROM R; |
| ii ➥ SELECT A, COUNT(*) FROM R; |
| iii ➥ SELECT A, COUNT(*) FROM R GROUP BY A; |
| iv ➥ SELECT A, B, COUNT(*) FROM R GROUP BY A, B; |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q99➡ | UGC NET August 2016 Paper-II __________ is subject oriented, integrated, time variant, nonvolatile collection of data in support of management decisions. |
| i ➥ Data mining |
| ii ➥ Web mining |
| iii ➥ Data warehouse |
| iv ➥ Database Management System |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q100➡ | UGC NET August 2016 Paper-II In Data mining, classification rules are extracted from________. |
| i ➥ Data |
| ii ➥ Information |
| iii ➥ Decision Tree |
| iv ➥ Database |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q101➡ | UGC NET August 2016 Paper-II In Data mining,_____________is a method of incremental conceptual clustering. |
| i ➥ STRING |
| ii ➥ COBWEB |
| iii ➥ CORBA |
| iv ➥ OLAD |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q102➡ | UGC NET August 2016 Paper-III Which of the following statements concerning Object-Oriented databases is FALSE? |
| i ➥ Objects in an object-oriented database contain not only data but also methods for processing the data. |
| ii ➥ Object-oriented databases store computational instructions in the same place as the data. |
| iii ➥ Object-oriented databases are more adept at handling structured (analytical) data than relational databases. |
| iv ➥ Object-oriented databases store more types of data than relational databases and access that data faster. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q103➡ | UGC NET August 2016 Paper-III In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: |
| i ➥ Inheritances |
| ii ➥ Fragments |
| iii ➥ Locations |
| iv ➥ Local formats |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q104➡ | UGC NET August 2016 Paper-III Consider the relations R(A, B) and S(B, C) and the following four relational algebra queries over R and S: I. ΠA, B (R ⨝ S) II. R ⨝ ΠB(S) III. R ∩ (ΠA(R) × ΠB(S)) IV. ΠA, R.B (R × S) where R⋅B refers to the column B in table R. One can determine that: |
| i ➥ I, III and IV are the same query. |
| ii ➥ II, III and IV are the same query. |
| iii ➥ I, II and IV are the same query. |
| iv ➥ I, II and III are the same query. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q105➡ | UGC NET August 2016 Paper-III Which of the following statements is TRUE? D1 : The decomposition of the schema R(A, B, C) into R1(A, B) and R2 (A, C) is always lossless. D2 : The decomposition of the schema R(A, B, C, D, E) having AD → B, C → DE, B → AE and AE → C, into R1 (A, B, D) and R2 (A, C, D, E) is lossless. |
| i ➥ Both D1 and D2 |
| ii ➥ Neither D1 nor D2 |
| iii ➥ Only D1 |
| iv ➥ Only D2 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q106➡ | UGC NET August 2016 Paper-III Consider the following ORACLE relations : R (A, B, C) = {<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4> } S (B, C, D) = {<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, 4>, <3, 1, 4>}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : SELECT R⋅B, AVG (S⋅B) FROM R, S WHERE R⋅A = S⋅C AND S⋅D < 7 GROUP BY R⋅B; SQ2 : SELECT DISTINCT S⋅B, MIN (S⋅C) FROM S GROUP BY S⋅B HAVING COUNT (DISTINCT S⋅D) > 1; If M is the number of tuples returned by SQ1 and N is the number of tuples returned by SQ2 then |
| i ➥ M = 4, N = 2 |
| ii ➥ M = 5, N = 3 |
| iii ➥ M = 2, N = 2 |
| iv ➥ M = 3, N = 3 |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q107➡ UGC NET August 2016 Paper-III Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique ? |
| i ➥ Only the joining attributes are sent from one site to another and then all of the rows are returned. |
| ii ➥ All of the attributes are sent from one site to another and then only the required rows are returned. |
| iii ➥ Only the joining attributes are sent from one site to another and then only the required rows are returned. |
| iv ➥ All of the attributes are sent from one site to another and then only the required rows are returned. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |
| Q108➡ | UGC NET August 2016 Paper-III Which of the following is characteristic of an MIS? |
| i ➥ Provides guidance in identifying problems, finding and evaluating alternative solutions, and selecting or comparing alternatives. |
| ii ➥ Draws on diverse yet predictable data resources to aggregate and summarize data. |
| iii ➥ High volume, data capture focus. |
| iv ➥ Has as its goal the efficiency of data movement and processing and interfacing different TPS. |
Show Answer With Best Explanation
| More Discussion | Explanation On YouTube | Learn Topic Wise | Help-Line |