Database-MySQL [3i Infotech Placement]: Sample Questions 47 - 49 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 47
Explanation
- It is the name of the column.
- An attribute gives the characteristics of the entity.
- For example, A customer of bank may be described by: name, address, customer ID number.
- It is also called as data element, data field, a field, a data item, or an elementary item.
Types of attributes:
- Single valued Attributes:
- Multi valued Attributed:
- Compound Attribute:
- Simple Attribute:
- Stored Attribute:
- Derived Attribute.
Question 48
Describe in Detail Essay▾
What are the privileges that can be granted on a table by a user to others?
EditExplanation
- User requires ADMIN privilege to grant privileges to others. For example:
- Delete:
- Delete rows from tables within the schema.
- Insert:
- Insert rows of data into tables within the schema.
- Delete:
- References:
- Set up references to primary keys within the schema.
- Select:
- To select rows from tables within the schema.
- Trigger:
- To create triggers on tables within the schema.
- Update:
- Update rows in tables within the shaman.
- Execute:
- Execute functions or stored procedure within the shaman.
Question 49
Statement True-False▾
! = , <> , ^ = all denote the same operation.
Choices
Choice (4) | |
---|---|
a. | False |
b. | True |
c. | Question does not provide sufficient data or is vague |
d. | None of the above |
Answer
b.Explanation
- True
! = operator:
- Check if the values of two operands are equal or not.
- If values are not equal then condition becomes true.
(a! = b)
<> operator:
- Check if the values of two operands are equal or not.
- If values are not equal then condition becomes true.
(a <> b)
^ = operator
- In equality test
- If values are not equal then condition becomes true.
(a ^ = b)