Database-MySQL [3i Infotech Placement]: Sample Questions 140 - 141 of 162

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 140

Edit

Write in Short

Short Answer▾

What is indexing and what are the different kinds of indexing?

Explanation

  • Indexing is a technique for determining how quickly specific data can be found.

Types:

  • Binary search style indexing
  • B-Tree indexing
  • Inverted list indexing
  • Memory resident table
  • Table indexing

Question 141

Edit

Describe in Detail

Essay▾

What do you mean by flat file database?

Explanation

  • A flat file database is a type of database that stores data in a single table.
  • A flat file database is a large collection of data that is the tables and records have no relation between any other tables.
  • In, one could have a single table (e. g. , My Small Business Data) with everything stored in it, from customers to sales to orders to invoices.
  • Flat file is one type of computer file system that stores all data in a single directory.
  • Data, folders or paths are used organize the data.
  • While this is a simple way to store files, a flat file system becomes increasingly inefficient as more data is added.
  • Example of Flate file Example:
Table Shows the Example of Flate File
RunnerRaceAgeTime
Dev10k290: 42: 19
Parth10k311: 01: 20
Jony5k220: 16: 05
Biral10k260: 53: 17
Dev5k290: 19: 22
Anita5k260: 24: 17
Biren5k280: 32: 19
Parth5k310: 30: 03
  • We can see that some names repeat; or a small table this is a big problem- To change the record for Dev and add a last name, all records for “Dev” have to be found and updated.

Developed by: