Database-MySQL [3i Infotech Placement]: Sample Questions 13 - 15 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 13

Edit

Write in Short

Short Answer▾

What are “HINTS” ? What is “index covering” of a query?

Explanation

HINTS: a hint is an addition to the SQL standard that instructs the database engine on how to execute the query.

3 types of HINTS

  • Query Hints
  • Index hints
  • lock hints

Used for forcing the behaviour of the statement as per our expectation.

Covering index will cover will have same columns in the select and where cause and index covers all the columns.

Question 14

Edit

Write in Short

Short Answer▾

What is DDL Interpreter?

Explanation

It interprets DDL statements and record them in tables containing metadata.

Question 15

Edit

Describe in Detail

Essay▾

What is disadvantage in File Processing System?

Explanation

File Processing System

The file processing system has the following major disadvantages:

  1. Data redundancy and inconsistency.
  2. Integrity Problems.
  3. Security Problems
  4. Difficulty in accessing data.
  5. Data isolation.

1) Data redundancy and inconsistency.

  • Data redundancy means duplication՚s data and inconsistency means that the duplicated values are different.

2) Integrity problems:

  • Data integrity means that the data values in the data base should be accurate in the sense that the value must satisfy some rules.

3) Security Problem:

  • Data security means prevention of data accession by unauthorized users.

4) Difficulty in accessing data:

  • Difficulty in accessing data arises whenever there is no application program for a specific task.

5) Data isolation:

  • This problem arises due to the scattering of data in various files with various formats.
  • Due to the above disadvantages of the earlier data processing system, the necessity for an effective data processing system arises.
  • Only at that time the concept of DBMS emerges for the rescue of a large number of organizations.

Developed by: