Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, September 12, 2011

Data Structure Faqs

  1. What is data structure?

A data structure is a way of organizing data that considers not only the items stored, but also their relationship to each other. Advance knowledge about the relationship between data items allows designing of efficient algorithms for the manipulation of data.


  1. List out the areas in which data structures are applied extensively?

  • Compiler Design,

  • Operating System,

  • Database Management System,

  • Statistical analysis package,

  • Numerical Analysis,

  • Graphics,

  • Artificial Intelligence,

  • Simulation


  1. What are the major data structures used in the following areas : RDBMS, Network data model & Hierarchical data model.

  • RDBMS – Array (i.e. Array of structures)

  • Network data model – Graph

  • Hierarchical data model – Trees


  1. If you are using C language to implement the heterogeneous linked list, what pointer type will you use?

The heterogeneous linked list contains different data types in its nodes and we need a link, pointer to connect them. It is not possible to use ordinary pointers for this. So we go for void pointer. Void pointer is capable of storing pointer to any type as it is a generic pointer type.

  1. Minimum number of queues needed to implement the priority queue?

Two. One queue is used for actual storing of data and another for storing priorities.


  1. What is the data structures used to perform recursion?

Stack. Because of its LIFO (Last In First Out) property it remembers its ‘caller’ so knows whom to return when the function has to return. Recursion makes use of system stack for storing the return addresses of the function calls.

Every recursive function has its equivalent iterative (non-recursive) function. Even when such equivalent iterative procedures are written, explicit stack is to be used.




  1. What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?

Polish and Reverse Polish notations.


  1. Convert the expression ((A + B) * C – (D – E) ^ (F + G)) to equivalent Prefix and Postfix notations.

Prefix Notation:

^ - * +ABC - DE + FG

Postfix Notation:

AB + C * DE - - FG + ^


  1. Sorting is not possible by using which of the following methods?

(a) Insertion

(b) Selection

(c) Exchange

(d) Deletion


(d) Deletion.

Using insertion we can perform insertion sort, using selection we can perform selection sort, using exchange we can perform the bubble sort (and other similar sorting methods). But no sorting method can be done just using deletion.


  1. A binary tree with 20 nodes has null branches?

21

Let us take a tree with 5 nodes (n=5)











It will have only 6 (ie,5+1) null branches. In general,

A binary tree with n nodes has exactly n+1 null nodes.


  1. What are the methods available in storing sequential files ?

  • Straight merging,

  • Natural merging,

  • Polyphase sort,

  • Distribution of Initial runs.





  1. How many different trees are possible with 10 nodes ?

1014

For example, consider a tree with 3 nodes(n=3), it will have the maximum combination of 5 different (ie, 23 - 3 = 5) trees.










i ii iii iv v



In general:

If there are n nodes, there exist 2n-n different trees.


  1. List out few of the Application of tree data-structure?

  • The manipulation of Arithmetic expression,

  • Symbol Table construction,

  • Syntax analysis.


  1. List out few of the applications that make use of Multilinked Structures?

  • Sparse matrix,

  • Index generation.


  1. In tree construction which is the suitable efficient data structure?

(a) Array (b) Linked list (c) Stack (d) Queue (e) none


(b) Linked list


  1. What is the type of the algorithm used in solving the 8 Queens problem?

Backtracking


  1. In an AVL tree, at what condition the balancing is to be done?

If the ‘pivotal value’ (or the ‘Height factor’) is greater than 1 or less than –1.


  1. What is the bucket size, when the overlapping and collision occur at same time?

One. If there is only one entry possible in the bucket, when the collision occurs, there is no way to accommodate the colliding value. This results in the overlapping of values.



  1. Traverse the given tree using Inorder, Preorder and Postorder traversals.



















  • Inorder : D H B E A F C I G J

  • Preorder: A B D H E C F G I J

  • Postorder: H D E B F I J G C A


  1. There are 8, 15, 13, 14 nodes were there in 4 different trees. Which of them could have formed a full binary tree?

15.

In general:

There are 2n-1 nodes in a full binary tree.

By the method of elimination:

Full binary trees contain odd number of nodes. So there cannot be full binary trees with 8 or 14 nodes, so rejected. With 13 nodes you can form a complete binary tree but not a full binary tree. So the correct answer is 15.

Note:

Full and Complete binary trees are different. All full binary trees are complete binary trees but not vice versa.


  1. In the given binary tree, using array you can store the node 4 at which location?










At location 6


1

2

3

-

-

4

-

-

5

Root

LC1

RC1

LC2

RC2

LC3

RC3

LC4

RC4


where LCn means Left Child of node n and RCn means Right Child of node n


  1. Sort the given values using Quick Sort?


65

70

75

80

85

60

55

50

45


Sorting takes place from the pivot value, which is the first value of the given elements, this is marked bold. The values at the left pointer and right pointer are indicated using L and R respectively.


65

70L

75

80

85

60

55

50

45R


Since pivot is not yet changed the same process is continued after interchanging the values at L and R positions


65

45

75 L

80

85

60

55

50 R

70

65

45

50

80 L

85

60

55 R

75

70


65

45

50

55

85 L

60 R

80

75

70



65

45

50

55

60 R

85 L

80

75

70

When the L and R pointers cross each other the pivot value is interchanged with the value at right pointer. If the pivot is changed it means that the pivot has occupied its original position in the sorted order (shown in bold italics) and hence two different arrays are formed, one from start of the original array to the pivot position-1 and the other from pivot position+1 to end.


60 L

45

50

55 R

65

85 L

80

75

70 R


55 L

45

50 R

60

65

70 R

80 L

75

85


50 L

45 R

55

60

65

70

80 L

75 R

85


In the next pass we get the sorted form of the array.


45

50

55

60

65

70

75

80

85



  1. For the given graph, draw the DFS and BFS?













  • BFS: A X G H P E M Y J


  • DFS: A X H P E Y M J G


  1. Classify the Hashing Functions based on the various methods by which the key value is found.

  • Direct method,

  • Subtraction method,

  • Modulo-Division method,

  • Digit-Extraction method,

  • Mid-Square method,

  • Folding method,

  • Pseudo-random method.


  1. What are the types of Collision Resolution Techniques and the methods used in each of the type?

  • Open addressing (closed hashing),

The methods used include:

Overflow block,

  • Closed addressing (open hashing)

The methods used include:

Linked list,

Binary tree…




  1. In RDBMS, what is the efficient data structure used in the internal storage representation?

B+ tree. Because in B+ tree, all the data is stored only in leaf nodes, that makes searching easier. This corresponds to the records that shall be stored in leaf nodes.


  1. Draw the B-tree of order 3 created by inserting the following data arriving in sequence – 92 24 6 7 11 8 22 4 5 16 19 20 78













  1. Of the following tree structure, which is, efficient considering space and time complexities?

  1. Incomplete Binary Tree

  2. Complete Binary Tree

  3. Full Binary Tree


(b) Complete Binary Tree.

By the method of elimination:

Full binary tree loses its nature when operations of insertions and deletions are done. For incomplete binary trees, extra storage is required and overhead of NULL node checking takes place. So complete binary tree is the better one since the property of complete binary tree is maintained even after operations like additions and deletions are done on it.


  1. What is a spanning Tree?

A spanning tree is a tree associated with a network. All the nodes of the graph appear on the tree once. A minimum spanning tree is a spanning tree organized so that the total edge weight between nodes is minimized.


  1. Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?

No.

Minimal spanning tree assures that the total weight of the tree is kept at its minimum. But it doesn’t mean that the distance between any two nodes involved in the minimum-spanning tree is minimum.


  1. Convert the given graph with weighted edges to minimal spanning tree.










the equivalent minimal spanning tree is:











  1. Which is the simplest file structure?

  1. Sequential

  2. Indexed

  3. Random

(a) Sequential


  1. Whether Linked List is linear or Non-linear data structure?

According to Access strategies Linked list is a linear one.

According to Storage Linked List is a Non-linear one.


  1. Draw a binary Tree for the expression :

A * B - (C + D) * (P / Q)












  1. For the following COBOL code, draw the Binary tree?


01 STUDENT_REC.

02 NAME.

03 FIRST_NAME PIC X(10).

03 LAST_NAME PIC X(10).

02 YEAR_OF_STUDY.

03 FIRST_SEM PIC XX.

03 SECOND_SEM PIC XX.


















No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect