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

Question

MCQ▾

Which of the following is NOT VALID in PL/SQL?

Choices

Choice (4)

a.

Select … into

b.

Delete

c.

Update

d.

Create

Answer

d.

Explanation

  • Create is NOT VALID in PL/SQL.
  • We use INSERT, UPDATE, and DELETE, SELECT and LOCK TABLE commands.
  • INSET: adds new rows of data to database table.
  • UPDATE: modifies rows.
  • DELETE: removes unwanted rows
  • SELECT: Retrieves rows that search criteria
  • LOCK TABLE: temporarily limits access to a table.

Question 45

Edit

Describe in Detail

Essay▾

What is database?

Explanation

Structure of Database
  • Database is a systematic collection of data.
  • Databases support storage and manipulation of data.
  • Databases make data management easy.
  • For, example an online telephone directory would definitely use database to store data pertaining to people, phone numbers, other contact details, etc.
  • Your electricity service provider is obviously using a database to manage billing , client related issues, to handle fault data, etc.
  • Now, consider the Facebook. It needs to store, manipulate and present data related to members, their friends, member activities, messages, advertisements and lot more.
  • We can provide countless number of examples for usage of databases.

Developed by: