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

Describe in Detail Essay▾

What is an attribute?

Edit

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?

Edit

Explanation

  • 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.
  • 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

Edit

Answer

b.

Explanation

Compound Operator in Sql
  • 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)