Database-MySQL [PCS Infotech Placement]: Sample Questions 18 - 19 of 23

Get unlimited access to the best preparation resource for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 18

Edit

Question

Fill-Blanks▾

A overloaded function can differ by ________

Answer

Explanation

Overloaded function can differ in:

  • Arguments- when query is executed, the server will determine function based on the data types.
  • Simulate functions with a variable number of arguments up to finite maximum number.

Question 19

Edit

Write in Short

Short Answer▾

In a PL/SQL block a variable and a table name both are same then which will get highest precedence.

Explanation

  • In a PL/SQL block, a variable and a table name with same name results in error because PL/SQL checks the database first for a column in the table.
  • The name of variable takes higher precedence over the name of database table.
  • The name of database table column takes precedence over the names of variable.
  • In a PL/SQL block two variables can have the same name, provide they are in different block.

Rules for Variable Names

  • The name of variable should not be longer than 30 characters.
  • The first character must be a letter, the remaining characters are letters, numbers or special symbols.
  • Pl/SQL supports declaring the variable to store intermediate results of query for later use.
  • Variables can be uses anywhere in the same PL/SQL block.

Developed by: