Recent questions and answers in Exam Queries

0 votes

0 answers

1

UGCNET-June-2019-Iaa-1
The relational DBMS is constructed on relational principles which are based on The matrix theory Axiomatic principles Primary key Primary & foreign key relationship

asked Jul 24 in GATE by Arjun Veteran (400k points) | 1 view

0 votes

0 answers

2

UGCNET-June-2019-Iaa-2
In relational DBMS, the closure of functional dependencies facilitates To determine the candidate key To determine the foreign key To determine the dependency of an attribute with other attribute/s None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

3

UGCNET-June-2019-Iaa-3
The process of normalization is used to Enhance the number of relations Determine the relationship between different relations Minimize the redundancies & eliminate anomalies Ease the computational work.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

4

UGCNET-June-2019-Iaa-4
The schema for the entire database is based on designed using Data definitional language Structured query language Data manipulation language Schema structure language

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

5

UGCNET-June-2019-Iaa-5
The difference between the structured query language and the programming relationship language is that Structured query language does not contain answer to how ? about computation Programming language does not contain the answer to how? about computation Only structured query language uses strict semiotics Only programming language uses strict semiotics.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

6

UGCNET-June-2019-Iaa-6
One of the differences between Object-Oriented Paradigm (OOP) and Database Management System (DBMS) is that In DBMS, null values & redundancies are completely eliminated In OOP, null values & redundancies are completely eliminated In OOP, only null values are minimized In DBMS, only null values are eliminated.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

7

UGCNET-June-2019-Iaa-7
The diagramming language suitable for object-oriented paradigm is Data Flow Diagramming Language Entity-Relationship Language Object-Oriented Language Unified Modeling Language

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

8

UGCNET-June-2019-Iaa-8
Couple of the good database design principles suggest that preservation and minimization of functional dependencies. These issues can be resolved by Eliminating transitive functional dependencies Eliminating all interrelationship between all attributes Minimizing candidate keys None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

9

UGCNET-June-2019-Iaa-9
The normalization is a way to implement Good software engineering principles Good database design principles Structured Query Language Database Schema

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

10

UGCNET-June-2019-Iaa-10
Object-oriented paradigm is used in the analysis stage of SDLC to Structure the behavioural part of the business process Design the structural part of Computer memory Design the object-oriented programming language Design the structure of the database.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

11

UGCNET-June-2019-Iaa-12
The Software Development Life Cycle (SDLC) is used in all Process models Design models Programming models None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

12

UGCNET-June-2019-Iaa-11
The signature of the object method clause present in class diagram contains All definitional attributes of the class used in the method All referential attributes of the class/es used in the method All definitional attributes of related classes All attributes of related classes

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

13

UGCNET-June-2019-Iaa-13
The success rate of the software development is pathetically low because Most of the techniques are human skill dependent guidelines The development methodology is not using object-oriented technology Design of software comprises interrelated cluster of software. Inconsistency in the values of related data.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

14

UGCNET-June-2019-Iaa-14
The Ford-Fulkerson method of finding maximum flow from source to sink is An iterative method A recursive method A direct determination method A methodology of linked methods

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

15

UGCNET-June-2019-Iaa-15
The complexity of algorithms is comparatively more accurate in the use of Asymptotic analysis Amortized analysis Both of these Not dependent on the nature of analysis.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

16

UGCNET-June-2019-Iaa-16
The matrices represented for transformations in homogeneous co-ordinate system are used to transform Multiplication into addition Addition into multiplication Division into subtraction Subtraction into division

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

17

UGCNET-June-2019-Iaa-17
The good software engineering principles are used in object-oriented paradigm to Streamline the structural part of the business process Streamline the security of the business process Streamline the structure of the class Streamline the object methods of the class

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

18

UGCNET-June-2019-Iaa-18
The picture definition, stored in the 24 frame buffers of which each 8 frame buffers are reserved for the primary colours viz., red, blue & green displays the picture in 67,77,216 77,216 1,67,77,216 3

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

19

UGCNET-June-2019-Iaa-19
In the parallel projection, the picture definition of the window to the view port, the parallel projection lines are Parallel to the viewport Perpendicular to the viewport Parallel to the window Perpendicular to the window

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

20

UGCNET-June-2019-Iaa-20
In isometric projection of picture definition, the object is projected on the screen which cuts the x-,y- & Z- coordinate axes at Equidistance from the origin Any distance from the origin Equidistance from the screen Any distance from the screen

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

21

UGCNET-June-2019-Iaa-21
The scaling transformation of the object with uniform scaling factors greater than 1, Retains the size and shape of the object Retains only the size of the object Changes only the shape of the object Enhances the size of the object retaining the shape

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

22

UGCNET-June-2019-Iaa-22
The scaling factors equals to 2 in any direction Retains the distance of the defining point of the object from the origin, but doubles the size of the object in that direction Doubles the distance of the defining point of the object from the origin, but ... both the distance of the defining point of the object from the origin and the size of the object in that direction

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

23

UGCNET-June-2019-Iaa-23
The normals to the plane surface ax + by + czd = 0 is represented by which of the following where (i, j, k) are unit normal respectively along x-, y-, and z- directions. ai + bj + ck ai + bj +dk ai + cj + dk bi + cj + dk

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

24

UGCNET-June-2019-Iaa-24
The transitive dependencies between attributes of a relation (relational DBMS file) is eliminated by the application of 1st normal form 2nd normal form 3rd normal form 4th normal form rule on the relation.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

25

UGCNET-June-2019-Iaa-25
The concatenation of three or more matrices is Associative and also commutative Associative but not commutative Commutative but not associative Neither associative nor commutative

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

26

UGCNET-June-2019-Iaa-26
The normalization of relations in DBMS is based on Divide and conquer algorithm Axioms of probability Greedy algorithm Armstrong's axioms

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

27

UGCNET-June-2019-Iaa-27
The undesirable multivalued dependency in a relation arises if there exist Two one-to-many relationships between attributes of a relation One one-to-one and one one-to many one relationships between attributes within a relation Two one-to-one relationships between attributes of a relation One one-to-many relationship between attributes across relation

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

28

UGCNET-June-2019-Iaa-28
The software is developed using One of the process models, whose stages are iterative in nature because Their pedestal software development life cycle needs iteration The activities in software time is obtained by developmental stages are human skill dependent. The involved automated activities need iterations. None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

29

UGCNET-June-2019-Iaa-29
The running time of amortized stack of the most n elements is Push = 2, pop = 0, Make Empty = 0 Push = 1, pop = 1, Make Empty = n Push = 1 or n, pop = 1 or (n − 1), Make Empty = 1 Push = 3, pop = 2, Make Empty = 1

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

30

UGCNET-June-2019-Iaa-31
The running time of an algorithm of n interdependent operations is computed with both the asymptotic & amortized analyses. The most accurate running time obtained by Asymptotic analysis Amortized analysis Both analyses None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

31

UGCNET-June-2019-Iaa-30
The tower of Hanoi puzzle with n (n > 1) different dimensional disks stacked on peg A in the decreasing order of their size with largest dimensional disk at the bottom and smallest dimensional disk at the top. The disks are to be transferred from peg A to Peg B using peg C with one disk at ... of disk transfers is given by 2T(n − 1) +2 2T(n-1) + 1 T(n-1) +T(n − 2) 2T(n)

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

32

UGCNET-June-2019-Iaa-32
In a banking system, where customers transact randomly for the storage & accession of desired data,the most appropriate file for storage of records could be sequential file Indexed sequential file Hash file random file

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

33

UGCNET-June-2019-Iaa-33
The least running time of creating spanning tree from connected graph in G(E, V) is given by which of the following Where E, V are respectively number of edges & vertices in the graph. O (V log V) O (E + V log V) O (E log V) O (V log V + E log V)

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

34

UGCNET-June-2019-Iaa-34
When a programming system and software are developed separately for the same business process, & the development cost of A) programming system is more on than the software. B) software is more than the programming system. C) Both are ... Only eliminate errors of previous iterations in the current iteration Only accommodate the change in business process None of these

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

35

UGCNET-June-2019-Iaa-35
The average number of access to access the desired record stored in a sequential file containing n records is (n+1)/2 n/2 (n − 1)/2 n

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

36

UGCNET-June-2019-Iaa-36
During the implementation stage of Software Development Life Cycle, the following UML diagram is designed to determine the correctness & Completeness of integration of different software Class diagram Object diagram Usecase diagram Component diagram

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

37

UGCNET-June-2019-Iaa-37
In DBMS, the only association would satiate the complete interrelationships set of business processes and in object oriented paradigm, the inter relationships are enhanced by additional aggregation & super-sub class hierarchy. This ... following from the object-oriented paradigm null values only redundancies only both null values & redundancies inconsistencies

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

38

UGCNET-June-2019-Iaa-38
Relational Algebra is integral part of DBMS because it contains operators analogous to query language queries. contains relational operators analogous to query language queries. is used as intermediate language in translating programming language programs ... queries is used as intermediate language in translating query language queries into programming language programs.

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

39

UGCNET-June-2019-Iaa-39
The following relational algebra operators form complete set of operators. The other operators can be represented by any combinations of these :

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

0 votes

0 answers

40

UGCNET-June-2019-Iaa-40
The ‘divide’ operator in the relational algebra is categorized as A mathematical operator A relational operator A mathematical cum relational operator Neither relational nor mathematical operator

asked Jul 24 in GATE by Arjun Veteran (400k points) | 0 views

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Recent questions and answers in Exam Queries

Recent Posts

Recent Blog Comments