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 |
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 |
Answer
c.Explanation
1st Normal From example.
Product ID | Color | Price |
1 | Red, green | 15 |
2 | Yellow | 22 |
3 | Green | 17 |
4 | Yellow, blue | 10 |
5 | red | 25 |
- 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.
Product ID | Price |
1 | 15 |
2 | 22 |
3 | 17 |
4 | 10 |
5 | 25 |
Product ID | Color |
1 | Red |
1 | Green |
2 | Yellow |
3 | Green |
4 | Yellow |
4 | Blue |
5 | red |