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

Edit

Describe in Detail

Essay▾

What is an attribute?

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

Edit

Describe in Detail

Essay▾

What are the privileges that can be granted on a table by a user to others?

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

Edit

Statement

True-False▾

! = , <> , ^ = all denote the same operation.

Answer

TRUE

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)

Developed by: