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

Question MCQ▾

What is the maximum size of the page?

Choices

Choice (4)

a.

Characters wide & 260 characters length

b.

Characters wide & 265 characters length

c.

Characters wide & 80 characters length

d.

Question does not provide sufficient data or is vague

Edit

Answer

b.

Explanation

  • The value of page size is the number of output lines to produce on each page.
  • Used in the initialization section of program.
  • The value of page size is automatically saved for the default outline.
  • Characters wide & 265 characters length is the maximum size of the page.
  • Page size option specifies the size of a page- the number of line produced on page.
  • Page size is used in the initialization section of report program.
  • When page size is changed- oracle change OLAP
  • Memory paging system depends on OS and ranges from 512 to 4096.

Syntax

SET PAGESIZE lines_on_page

Question 52

Question MCQ▾

Tables derived from the ERD

Choices

Choice (4)

a.

May have multi-valued attributes

b.

Are totally normalised

c.

Are always in 1NF

d.

Can be further demoralised

Edit

Answer

c.

Explanation

1st Normal From example.

Table Shows the Product ID and Price
Product IDColorPrice
1Red, green15
2Yellow22
3Green17
4Yellow, blue10
5red25
  • This table is not in first normal form because the [color] column can contain multiple values
  • For ex. The first row includes value “red” and “green” .
  • To bring this table to first normal form, we split the table into two tables.
Table Shows the Product ID and Price
Product IDPrice
115
222
317
410
525
Table Shows the Product ID and Color
Product IDColor
1Red
1Green
2Yellow
3Green
4Yellow
4Blue
5red