Database Accp 2007

105 Questions | Total Attempts: 114

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Theory test is good for all of us.


Related Topics
Questions and Answers
  • 1. 
    Scalability is one of the advantages provided by ADO.Net.
    • A. 

      True

    • B. 

      False

  • 2. 
    ADO.NET provides extensive support for Extensible Markup Language(XML).
    • A. 

      True

    • B. 

      False

  • 3. 
    A DataSet object is one of components of the data provider.
    • A. 

      True

    • B. 

      False

  • 4. 
    Which objects are components of Data Provider.
    • A. 

      DataSet

    • B. 

      DataAdapter

    • C. 

      DataTable

    • D. 

      Command

    • E. 

      Connection , DataReader.

  • 5. 
    ADO.Net providers better programmbility because ADo.Net data components in Visual Studio lead to faster programming reduce the number of errors.
    • A. 

      True

    • B. 

      False

  • 6. 
    A DataSet object represents an in-memory, disconnected cache of data that can be manipulated.
    • A. 

      True

    • B. 

      False

  • 7. 
    An SQL Server 6.5 database can be accessed using .Net Framework Data Provider for OLE DB.
    • A. 

      True

    • B. 

      False

  • 8. 
    Both Oracle 8i and Oracle 9i database can be accessed using .Net Framework Data Provider for Oracle.
    • A. 

      True

    • B. 

      Fasle

  • 9. 
    .Net Framework Data Provider for SQL Server does not require an additional OLE DB or Open Database Connectity (ODBC) layer to access a SQL Server.
    • A. 

      True

    • B. 

      False

  • 10. 
    An SQL Server 2005 dataset can be accessed with an OLE DB data provider.
    • A. 

      True

    • B. 

      False

  • 11. 
    SQL Server database cannot be accessed using .NET Framework Data Provider for SQl Server.
    • A. 

      True

    • B. 

      False

  • 12. 
    Data binding is a method to bind the properties of the control to the user input.
    • A. 

      True

    • B. 

      False

  • 13. 
    Aind and Eval expressions are using with ASP.NET data binding.
    • A. 

      True

    • B. 

      False

  • 14. 
    ASP.NET 2.0 has no means no establish  a direct connection as a local file to a SQL Express database.
    • A. 

      True

    • B. 

      False

  • 15. 
    ASP.Net 2.0 does not need any code to written for some of the common data scenarios such as paging and sorting.
    • A. 

      True

    • B. 

      False

  • 16. 
    ASP.Net data binding typically involves declarative or inline binding rxpressions that are given in the form of <#..%>
    • A. 

      True

    • B. 

      False

  • 17. 
    A DataSet object makes use of a DataReader object to read the Data.
    • A. 

      True

    • B. 

      False

  • 18. 
    The SqlDataReader class allow you to read a stream of rows from an SQL Server database.
    • A. 

      True

    • B. 

      False

  • 19. 
    The SqlDataReader class is defined in the System.Data.Sql
    • A. 

      True

    • B. 

      Fasle

  • 20. 
    DataReader Object do not support paging or sorting functionality.
    • A. 

      True

    • B. 

      False

  • 21. 
    The SqlDataReader instance is created using the no-argument constructor.
    • A. 

      True

    • B. 

      False

  • 22. 
    The DataView class helps to generate dynamic customized views of your data for display purposes only.
    • A. 

      True

    • B. 

      False

  • 23. 
    The DataView class has three Constructors.
    • A. 

      True

    • B. 

      False

  • 24. 
    The Add() method of the DataView class helpd you to add new rows.
    • A. 

      True

    • B. 

      False

  • 25. 
    Rows of DataViw object can be filtered based on custom expressions or based on their row state.
    • A. 

      True

    • B. 

      False