Saturday, March 27, 2021

Multiple choice questions in Data structures and algorithms with answers set 10

Data structures and algorithms multiple choice questions with answers, important interview questions in data structures, data structures questions for entrance exams, frequently asked questions in data structures and algorithms, GATE questions in data structures with explained answers


Data Structures and Algorithms Multiple Choice Questions

SET 10

 

1. Consider a perfect binary tree of height 5. Which of the following are the minimum and maximum number of nodes in the right sub-tree of the root?

a) 32

b) 31

c) 16

d) 9

Click here to view answer and explanation


 

2. Rank the following functions by increasing order of growth; (For example, the correct ordering of n2, n4, n, n3 is n, n2, n3, n4.)

f1 = (n!)1/n

f2 = ((n)n)1/2

f3 = log nn

f4 = n log n

a) f1, f2, f3, f4

b) f1, f3, f4, f2

c) f1, f2, f4, f3

d) f2, f1, f3, f4

Click here to view answer and explanation


 

3. What is a collision in a hash table implementation of a symbol table? Choose the most appropriate one.

a) Two key-value pairs that have equal keys but different values.

b) Two key-value pairs that have different keys and hash to different indices.

c) Two key-value pairs that have different keys but hash to the same index.

d) Two key-value pairs that have equal keys but hash to different indices.

 

Click here to view answer and explanation


 

4. A linear-probing hash table of length 10 uses the hash function h(x) = x mod 10. After inserting six integer keys into an initially empty hash table, the array of keys is:

Which of the following insertion sequences resulting in the above hash table? Assume that the length of the hash table does not change during the insertions.

a) 46, 42, 34, 52, 23, 33

b) 34, 42, 23, 52, 33, 46

c) 46, 34, 42, 23, 52, 33

d) 42, 46, 33, 23, 34, 52

Click here to view answer and explanation


 

5. Which of the following algorithms is parsimonious?

a) Insertion sort

b) Selection sort

c) Heap sort

d) All of the above

Click here to view answer and explanation


 

*************************

Interview questions and answers in data structure and algorithms

DSA quiz questions with answers explained

Solved true or false questions in DSA

Practice questions in data structures

Data structures and algorithms GATE exam questions 

Why insertion sort is a parsimonious algorithm?

What is parsimonious sorting algorithm?

What is the time complexity of converting min heap into a max heap?

Saturday, March 20, 2021

CS6302 DBMS April May 2018 Regulation 2013 Anna University Questions with Answers

Anna University Questions with Answers - CS6302 Database Management Systems April May 2017, Computer Science and Engineering, Information Technology Questions, Third semester, fifth, and eighth semester, Regulation 2013

CS6302 Database Management Systems for B.E. Computer Science and Engineering

CS6302 Database Management Systems for B.Tech. Information Technology

CS6302 Database Management Systems for B.E. Mechanical and Automation Engineering

Exam

B.E/B.Tech. (Full Time) DEGREE END SEMESTER EXAMINATIONS

Academic Year

April May 2018

Subject Code

CS6302

Subject Name

Database Management Systems

Branch

Computer Science and Engineering

Semester

Third / Fifth / Eighth Semester

Regulation

2013

 

Question Paper Code : 40901

B.E./B.Tech. DEGREE EXAMINATION, APRIL/MAY 2018

Third/Fifth/Eighth Semester

Computer Science and Engineering

CS 6302 — DATABASE MANAGEMENT SYSTEMS

(Common to Mechanical and Automation Engineering, Mechatronics Engineering, Information Technology)

(Regulation 2013)

 

 

Time : Three hours                                                             Maximum : 100 marks

 

Answer ALL questions.

PART A — (10 × 2 = 20 marks)

 

1. What is weak entity? Give example.

2. Define a foreign key. Give example.

3. What is data definition language? Give example.

4. Outline the steps involved in query processing.

5. What is serializability?

6. State the difference between a shared lock and an exclusive lock.

7. What is hash function? Give example.

8. Define data mining.

9. What is a distributed database management system?

10. State the difference between classification and clustering.

 

PART B — (5 × 13 = 65 marks)

 

11. (a) Explain select, project, Cartesian product, and join operations in relational algebra with an example.

 

OR

(b) What is database normalization? Explain first normal form, second normal form, and third normal form with an example.

 

12. (a) Explain the aggregate functions in SQL with example.

OR

(b) What is query optimization? Outline the steps in query optimization.

 

13. (a) i) During execution, a transaction passes through several states, until it finally commits or aborts. List all possible sequences of states through which a transaction may pass. Explain why each state transition may occur? (6)

ii) Explain with an example the properties that must be satisfied by a transaction. (7)

OR

(b) i) What is concurrency control? Explain the two-phase locking protocol with an example. (7)

ii) Explain conflict serializability and view serializability. (6)

 

14. (a) What is hashing? Explain static hashing and dynamic hashing with an example.

OR

(b) Outline the features of the following databases:

i) Parallel databases (7)

ii) Multimedia databases (6)

 

15. (a) i) Present an overview of database security. (8)

ii) Explain with diagrammatic illustration the architecture of a distributed database management system. (5)

OR

(b) Explain the necessary characteristics a system must satisfy to be considered as an object oriented database management system.

PART C is skipped here.

*****************************


Go to Previous year University Exam Questions page.

 

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents