Tag: technology

Questions Related to technology

  1. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  2. INSERT ('Jimmy', 'Jackson') INTO Persons

  3. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  4. None


Correct Option: C
  1. INSERT INTO Persons ('Olsen') INTO LastName

  2. INSERT ('Olsen') INTO Persons (LastName)

  3. INSERT INTO Persons (LastName) VALUES ('Olsen')

  4. None


Correct Option: C
  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. None


Correct Option: B
  1. SELECT COLUMNS() FROM Persons

  2. SELECT COUNT(*) FROM Persons

  3. SELECT COUNT() FROM Persons

  4. SELECT COLUMNS(*) FROM Persons


Correct Option: B
  1. SELECT UNIQUE

  2. SELECT DISTINCT

  3. SELECT DIFFERENT

  4. None


Correct Option: B
  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  2. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen

  3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  4. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen


Correct Option: B
  1. Reference types are stored on stack and value types are stored on heap area.

  2. Boxing allows you to convert value types to reference types.

  3. For boxing, during runtime it creates a temporary reference type box for the object on the heap

  4. Unboxing allows you to convert reference type to value type


Correct Option: B,C,D
  1. In C#, we can define one and only one main( ) method .

  2. If there is more than one main( ) method defined in your programme ,the compiler will return compile time error.

  3. If there is more than one main( ) method defined you can explicitely tell the compiler which main( ) method is to be used as the entry point.

  4. All the statements are wrong


Correct Option: B,C
  1. The granularity has to same as the business process

  2. The granularity must be an aggregate of the actual granularity of the business

  3. The granularity is decided based on the business needs and requirements from the data warehouse/mart

  4. None of the above


Correct Option: C