0

Data Base Management System

Description: Complete study material for DBMS, RDBMS, Data Base Management System, Relational Data Base Management System, Primary Key, Foreign Key, Data, Information to prepare for B.Sc-IT, M.Sc-IT, BCA, MCA, MCa Entrance
Number of Questions: 30
Created by:
Tags: DBMS Data Base RDBMS Relational Data Base Primary Key B.Sc-IT M.Sc-IT MCA BCA MCA Entrance Basic Computer C C++ ASP PHP HTML database management system notes advantages of database management system Data Base Management System Relational Data Base Management System Letter A Synonyms Letter B Letter C General Awareness and Computer Applications Computer Applications (New) Database Management System
Attempted 0/30 Correct 0 Score 0

What is the time required to search an element in a linked list of length 'n'?

  1. O(log2 n)

  2. O(n)

  3. O(1)

  4. O(n2)


Correct Option: B

Consider a linked list of 'n' elements which is pointed by an external pointer. What is the time taken to delete the element, which is successor of the element pointed to by a given pointer?

  1. O(1)

  2. O(log2 n)

  3. O(n)

  4. O(n log2 n)


Correct Option: A

In what kind of storage structure for strings, can one easily insert, delete, concatenate and rearrange sub-strings?

  1. Fixed length storage structure

  2. Variable length storage with fixed maximum

  3. Linked list storage

  4. Array type storage


Correct Option: C

Consider a linked list of 'n' elements. What is the time taken to insert an element after pointed by some pointers?

  1. O(1)

  2. O(log2 n)

  3. O(n)

  4. O(n log2 n)


Correct Option: A

Which of the following statements is false?

  1. Every tree is a bipartite graph.

  2. A tree contains a cycle.

  3. A tree with 'n' nodes contains 'n-1' edges.

  4. A tree is a connected graph.


Correct Option: B

An undirected graph G with 'n' vertices and 'e' edges is represented by adjacency list. What is the time required to generate all the connected components?

  1. O(n)

  2. O(e)

  3. O(e + n)

  4. O(e2)


Correct Option: C

Pre-order is nothing but

  1. depth first order

  2. breadth first order

  3. topological order

  4. linear order


Correct Option: A

Which traversal technique lists the notes of a binary search tree in ascending order?

  1. Post order

  2. In order

  3. Pre order

  4. None of these


Correct Option: B

Consider an undirected graph G with 'n' vertices and 'e' edges. What is the time taken by Depth First Search (DFS), if the graph is represented by: (i) adjacency matrix, and (ii) adjacency list?

  1. O(n2), O(n)

  2. O(n2), O(e)

  3. O(e), O(n2)

  4. O(e + n), O(e)


Correct Option: B

Consider a sorted binary insertion tree. What must be done to produce a sorted array of numbers (for printing) from the sorted binary insertion tree?

  1. Pre oder traversal

  2. Post order traversal

  3. In order traversal

  4. Top-down traversal


Correct Option: A

The concatenation of two lists is to be performed in O (1) time. Which of the following implementations of a list should be used?

  1. Singly linked list

  2. Doubly linked list

  3. Circular doubly linked list

  4. Array implementation


Correct Option: D

Which of the following algorithms solves all pairs shortest path problem?

  1. Greedy

  2. Depth-First Search

  3. Dyanamic Programming

  4. Divide & Conquer


Correct Option: B

Which of the following algorithms solves the quick sort problem?

  1. Greedy

  2. Depth-First Search

  3. Dyanamic Programming

  4. Divide & Conquer


Correct Option: D

Which of the following algorithms solves the minimum weight spanning tree problem?

  1. Greedy

  2. Depth-first Search

  3. Dynamic Programming

  4. Divide & Conquer


Correct Option: C

Selection sort's worst case space complexity is

  1. O

  2. O(n)

  3. O (logn)

  4. None of these


Correct Option: A

Bubble sort's worst case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: A

A full binary tree with 'n' non-leaf nodes contains

  1. log2 n nodes

  2. n + 1 nodes

  3. 2 n nodes

  4. 2n + 1 nodes


Correct Option: D

Which of the following algorithms solves the connected components problem?

  1. Greedy

  2. Depth-First Search

  3. Dynamic Programming

  4. Divide & Conquer


Correct Option: B

Insertion sort's worst case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: A

Quick sort's worst case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: B

Insertion sort's average case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: A

Bubble sort's average case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: A

Merge sort's worst case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: B

Selection sort's average case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: A

A graph G with 'n' nodes is bipartite if it contains

  1. n edges

  2. a cycle of odd length

  3. no cycle of odd length

  4. n2 edges


Correct Option: C

A complete binary tree with the property that the value at each node is at least as large as the values at its children, is known as

  1. Binary search tree

  2. AVL tree

  3. Completely balanced tree

  4. Heap


Correct Option: D

A full binary tree with 'n' leaves contains

  1. n nodes

  2. log2 n nodes

  3. 2n-1 nodes

  4. 2n nodes


Correct Option: C

Merge sort's average case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: B

In which tree, for every node the heights of its left sub-tree and right sub-tree differ at least by one?

  1. Binary search tree

  2. AVL tree

  3. Complete tree

  4. Threaded binary tree


Correct Option: B

Quick sort's average case space complexity is

  1. 0

  2. O(n)

  3. O(logn)

  4. None of these


Correct Option: B
- Hide questions