Assignment for MSE+CIE-2

1. Which of the following is not a built in aggregate function in SQL?

• avg

• max

• total

• count

Observe the given SQL query and choose the correct option.

SELECT branch_name, COUNT (DISTINCT customer_name) FROM depositor, account WHERE depositor.account_number = account.account_number GROUP BY branch_id

• a) The query is syntactically correct but gives the wrong answer
  

• b) The query is syntactically wrong
  

• c) The query is syntactically correct and gives the correct answer
  

• d) The query contains one or more wrongly named clauses.
  

State true or false: We can rename the resulting attribute after the aggregation function has been applied

• true

• false

• none

What values does the count(*) function ignore?

• a) Repetitive values
  

• b) Null values
  

• c) Characters

• d) Integers

Which of the following is a good database management practice?

• a) Adding redundant attributes
  

• b) Not specifying primary keys
  

• c) Removing redundant attributes
  

• d) None of the mentioned
  

Which of the following command is used to obtain the structure of an Oracle table?

• a) DESC TABLE [TableName].
  

• b) STRUCTURE [TableName].
  

• d) DESCRIBE STRUCTURE [TableName].
  

• c) DESC [TableName].
  

What would be printed when the following code is executed?

DECLARE x NUMBER;

BEGIN

x := 5;

x := 10;

dbms_output.put_line(-x);

dbms_output.put_line(+x);

x := -10;

dbms_output.put_line(-x);

dbms_output.put_line(+x);

END;

• -10

  10

  10

  -10

• -10

  10

  -10

  10

• 10

  10

  -10

  -10

• -5

  10

  10

  -10

  10

Which of the following is true about the execution section of a PL/SQL block?

• A - It is enclosed between the keywords BEGIN and END.

• B - It is a mandatory section.

• C - It consists of the executable PL/SQL statements.

• D - All of the above

What does PL/SQL stand for?

• PL/SQL stands for Procedural Language Extension of SQ

• 1. PL/SQL stands for Primary Language Extension of SQL

• 1. PL/SQL stands for Pattern Language Extension of SQL

• 1. PL/SQL stands for Private Language Extension of SQL

PL/SQL text is made up of lexical units, which are groups of characters and can be classified as –

• 1. Delimiters

• 1. Identifiers

• 1. Literals

• 1. All of the above