Bulk Operations With Db_10 July

10 Questions

SettingsSettingsSettings
Please wait...
Bulk Operations With Db_10 July

Questions and Answers
  • 1. 
    In which version of MS SQL Server, Table UDT was introduced :
    • A. 

      SQL Server 2005

    • B. 

      SQL Server 2008

    • C. 

      SQL Server 2012

  • 2. 
    Table type parameter passed to SQL Server Stored Procedure can be modified?
    • A. 

      Yes

    • B. 

      No

  • 3. 
    Table Type can be passed from one stored procedure to another stored procedure?
    • A. 

      Yes

    • B. 

      No

  • 4. 
    SqlDbType for sending the Table Type parameter to SQL Server Stored Procedure :
    • A. 

      Text

    • B. 

      Structured

    • C. 

      XML

  • 5. 
    Can we pass ‘DataSet’ as a Table Type parameter to the SQL Server Stored Procedure?
    • A. 

      Yes

    • B. 

      No

  • 6. 
    In SqlBulkCopy can we directly update the existing record in SQL Server table?
    • A. 

      Yes

    • B. 

      No

  • 7. 
    In which version of Oracle database ODP.Net support for Table Data Type
    • A. 

      Oracle 9i

    • B. 

      Oracle 10g

    • C. 

      Oracle 11g

  • 8. 
    Is it require to create a wrapper class in .Net application for Oracle Custom Data Type
    • A. 

      Yes

    • B. 

      No

  • 9. 
    Which of these Interface is NOT required to implement ODP.Net Custom Data Type:
    • A. 

      INullable

    • B. 

      ICloneable

    • C. 

      IOracleCustomeType

  • 10. 
    Is Factory class required in .Net application for Oracle Custom defined data type:
    • A. 

      Yes

    • B. 

      No

Back to Top Back to top