Database Accp 2007

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Vietha
V
Vietha
Community Contributor
Quizzes Created: 11 | Total Attempts: 9,901
| Attempts: 142
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/105 Questions

    Scalability is one of the advantages provided by ADO.Net.

    • True
    • False
Please wait...
About This Quiz

This quiz titled 'Database ACCP 2007' assesses knowledge in ADO. Net, focusing on scalability, XML support, data components, and DataSet objects. It's designed for learners to understand ADO. Net's role in enhancing programming efficiency and reducing errors, suitable for students and professionals in software development.

Database Accp 2007 - Quiz

Quiz Preview

  • 2. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the SqlDataReader class in .NET allows the programmer to retrieve a forward-only, read-only stream of rows from an SQL Server database. It provides a fast and efficient way to read data from the database in a sequential manner. This class is commonly used when there is a need to retrieve large amounts of data from the database and process it row by row. Hence, the statement "The SqlDataReader class allows you to read a stream of rows from an SQL Server database" is true.

    Rate this question:

  • 3. 

    A cached user control is referenced in the web page using @Register directive.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When a cached user control is referenced in a web page using the @Register directive, it means that the user control is being registered in the page's markup. This allows the user control to be used and accessed within the web page. By caching the user control, it can be stored in memory and reused multiple times, improving performance and reducing the need to recreate the control each time it is used. Therefore, the statement "A cached user control is referenced in the web page using @Register directive" is true.

    Rate this question:

  • 4. 

    The DetailsView control is used to displa, edit, insert and delete data in a single record.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The DetailsView control is a versatile tool in ASP.NET that allows users to display, edit, insert, and delete data for a single record. It provides an intuitive interface for interacting with individual records in a database, making it a useful tool for data management tasks.

    Rate this question:

  • 5. 

    SiteMaps create in ASP.Net contain XML

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In ASP.Net, SiteMaps are used to define the structure and navigation of a website. These SiteMaps are typically created in XML format. XML (eXtensible Markup Language) is a markup language that is commonly used for structuring and organizing data. Therefore, it is true that SiteMaps created in ASP.Net contain XML.

    Rate this question:

  • 6. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    ADO.Net providers offer better programmability because they provide a set of data components in Visual Studio that enable faster programming and reduce the likelihood of errors. These components simplify the process of connecting to databases, retrieving data, and performing database operations. By using ADO.Net providers, developers can write code more efficiently and effectively, resulting in improved productivity and fewer programming mistakes.

    Rate this question:

  • 7. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Aind and Eval expressions are commonly used with ASP.NET data binding. These expressions allow developers to access and manipulate data in a flexible and dynamic manner. Aind expressions are used to bind data to controls and evaluate expressions during data binding. Eval expressions, on the other hand, are used to evaluate data-bound expressions and display the results in controls. Therefore, the statement "Aind and Eval expressions are using with ASP.NET data binding" is true.

    Rate this question:

  • 8. 

    Data source are new group of controls that acts as a bridge between an external data source and data-bound controls on a web form.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because data source controls are indeed a new group of controls that serve as a link between an external data source and data-bound controls on a web form. These controls provide a way to connect to databases, XML files, and other data sources, and allow for easy binding of data to various controls on the web form. This helps in simplifying the process of retrieving and displaying data from external sources on the web page.

    Rate this question:

  • 9. 

    The Xml data present in string form or xml files can be bound to the XmlDataSource control

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The XmlDataSource control in ASP.NET allows for binding XML data, whether it is in string form or stored in XML files. This control provides a convenient way to work with XML data and can be used to populate other controls such as GridView or Repeater. By setting the DataFile or Data property of the XmlDataSource control, the XML data can be easily bound and manipulated in the web application. Therefore, the statement "The Xml data present in string form or xml files can be bound to the XmlDataSource control" is true.

    Rate this question:

  • 10. 

    Caching enables caching of web pages as well as application data.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Caching allows for the storage of both web pages and application data, which improves the performance and speed of accessing these resources. By storing frequently accessed content in a cache, subsequent requests for the same content can be served faster, reducing the load on the server and improving the overall user experience. Therefore, the statement "Caching enables caching of web pages as well as application data" is true.

    Rate this question:

  • 11. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    ADO.NET does indeed provide extensive support for Extensible Markup Language (XML). ADO.NET includes classes and methods that allow developers to easily work with XML data, such as reading, writing, and manipulating XML documents. This support enables seamless integration of XML data with relational databases, making it easier to exchange and process data between different systems.

    Rate this question:

  • 12. 

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

    • True

    • Fasle

    Correct Answer
    A. True
    Explanation
    The statement is true because both Oracle 8i and Oracle 9i databases can be accessed using the .Net Framework Data Provider for Oracle. This means that developers using .Net can connect to and interact with both versions of the Oracle database using the same data provider.

    Rate this question:

  • 13. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given statement is true. In a DataViw object, rows can be filtered based on custom expressions or based on their row state. This means that you can apply filters to display only the rows that meet specific criteria or conditions. This functionality allows for more efficient data analysis and manipulation, as it allows users to focus on relevant data and exclude unnecessary information.

    Rate this question:

  • 14. 

    The XmlDataSource control enables you to work with data from XMl file.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The XmlDataSource control is a built-in control in ASP.NET that allows developers to easily work with data from XML files. It provides a convenient way to bind XML data to various data-bound controls, such as GridView or Repeater. By setting the XmlDataSource control's DataFile property to the path of an XML file, developers can retrieve and manipulate the XML data within their application. Therefore, the statement "The XmlDataSource control enables you to work with data from XML file" is true.

    Rate this question:

  • 15. 

    You can add the SqlDataSource control and configure its properties through the properties window.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the SqlDataSource control is a data source control in ASP.NET that can be used to connect to a SQL database and retrieve data. By adding the SqlDataSource control to a web form and configuring its properties through the properties window, developers can easily set up the connection string, select statement, and other settings required to retrieve data from the database. This allows for a simplified and efficient way to retrieve data in ASP.NET applications.

    Rate this question:

  • 16. 

    In GridView, the property gets or sets whether paging is enable.

    • AllowPaging

    • PagerSettings.Position

    • AllowSorting

    Correct Answer
    A. AllowPaging
    Explanation
    The correct answer is "AllowPaging". This property in GridView determines whether paging is enabled or not. If set to true, it allows the GridView to display multiple pages and the user can navigate through them. If set to false, all the data will be displayed on a single page.

    Rate this question:

  • 17. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A DataSet object is a data structure in .NET that represents an in-memory cache of data. It is disconnected from the underlying data source, meaning that any changes made to the DataSet do not affect the original data source. The DataSet can be manipulated using various methods and properties to perform operations such as filtering, sorting, and updating the data. Therefore, the statement "A DataSet object represents an in-memory, disconnected cache of data that can be manipulated" is true.

    Rate this question:

  • 18. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Data binding is a process that connects the properties of a control, such as a textbox or dropdown, to the user input. This allows any changes made by the user to automatically update the underlying data source, and vice versa. By binding the control's properties to the user input, developers can create dynamic and interactive user interfaces. Therefore, the statement "Data binding is a method to bind the properties of the control to the user input" is true.

    Rate this question:

  • 19. 

    The DataView class has three Constructors.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the DataView class does indeed have three constructors. Constructors are special methods in a class that are used to initialize the object of that class. Having multiple constructors allows for different ways to create an instance of the DataView class, depending on the arguments passed to the constructor.

    Rate this question:

  • 20. 

    Data source controls help to boost productivity in Web applications.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Data source controls are components in web development frameworks that simplify the process of connecting to and retrieving data from a data source, such as a database. These controls provide a layer of abstraction that reduces the amount of code and complexity required to interact with data. By handling many of the repetitive and tedious tasks involved in data access, data source controls help developers save time and effort, thereby boosting productivity in web applications. Therefore, the statement that data source controls help to boost productivity in web applications is true.

    Rate this question:

  • 21. 

    The SiteMapDataSource control can be bound to navigation controls such as TreeView or menu

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The SiteMapDataSource control is a data source control in ASP.NET that is used to retrieve site map data. It can be bound to navigation controls such as TreeView or menu, which allows the navigation controls to display the site map data and provide a hierarchical structure for navigation. This enables easy navigation and organization of the website's content. Therefore, the statement "The SiteMapDataSource control can be bound to navigation controls such as TreeView or menu" is true.

    Rate this question:

  • 22. 

    A User control is stored in a separate file with the extension .ascx

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A user control is a reusable component in ASP.NET that is stored in a separate file with the extension .ascx. This allows the user control to be easily added to multiple pages within a web application. By separating the user control into its own file, it promotes code reusability and maintainability. Therefore, the statement "A User control is stored in a separate file with the extension .ascx" is true.

    Rate this question:

  • 23. 

    The Xml file that you want to associate with the XmlDataSource control must be present in the current application folder or its sub-folder.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the XmlDataSource control in an application can only associate with an XML file that is located in the current application folder or its sub-folder. This ensures that the control can access and retrieve data from the XML file effectively. If the XML file is not present in the specified location, the control will not be able to establish a connection and retrieve data, resulting in an error. Therefore, it is necessary for the XML file to be present in the current application folder or its sub-folder for the XmlDataSource control to function correctly.

    Rate this question:

  • 24. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false. SQL Server database can be accessed using .NET Framework Data Provider for SQL Server. The .NET Framework provides a data provider specifically designed for SQL Server, which allows developers to connect to and interact with SQL Server databases using .NET applications. This data provider offers various classes and methods that enable seamless integration between SQL Server and .NET applications, making it possible to perform database operations such as querying, inserting, updating, and deleting data.

    Rate this question:

  • 25. 

    It is possible to change the starting node while generating the site map tree structure using the SiteMapDataSource control.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the SiteMapDataSource control allows for flexibility in changing the starting node while generating the site map tree structure. This means that users can choose a different starting point for the site map, allowing for customization and adaptation to specific needs or requirements.

    Rate this question:

  • 26. 

    The Table property of the DataView class returns the DataTable associated with the view.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The Table property of the DataView class returns the DataTable associated with the view. This means that when we access the Table property of a DataView object, it will give us the DataTable object that the DataView is based on. This can be useful when we want to perform operations on the original DataTable using the DataView. Therefore, the statement "The Table property of the DataView class returns the DataTable associated with the view" is true.

    Rate this question:

  • 27. 

    The SqlDataSource control allows you to retrieve data and modify in the MS SQL Server databases, OLEDB databses as well as ODBC or Oracle databases,

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The SqlDataSource control is a feature in ASP.NET that allows developers to retrieve data from and modify data in various types of databases, including MS SQL Server, OLEDB, ODBC, and Oracle. This control provides a convenient way to connect to and interact with different database systems, making it a versatile tool for database operations in ASP.NET applications. Therefore, the statement "The SqlDataSource control allows you to retrieve data and modify in the MS SQL Server databases, OLEDB databases as well as ODBC or Oracle databases" is true.

    Rate this question:

  • 28. 

    You can auto-generate data bindings for the XmlDataSource control or you can manually assign data bindings for specific fields in the control.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because when using the XmlDataSource control, you have the option to either auto-generate data bindings or manually assign data bindings for specific fields. This flexibility allows developers to choose the most suitable approach based on their specific requirements and preferences.

    Rate this question:

  • 29. 

    This specifies where the cached page will be placed.

    • Location

    • Duration

    • VaryByParam

    Correct Answer
    A. Location
    Explanation
    The "Location" parameter specifies where the cached page will be placed. It determines the storage location for the cached version of the page, allowing the developer to choose whether the cache should be stored on the client's browser or on the server. This parameter is useful for optimizing performance and reducing server load by caching frequently accessed pages.

    Rate this question:

  • 30. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A DataSet object is a disconnected, in-memory representation of data that can hold multiple tables, relationships, and constraints. It does not directly interact with a data source. On the other hand, a DataReader object is a forward-only, read-only stream of data from a data source. In order for a DataSet object to retrieve data from a data source, it needs to use a DataReader object. Therefore, the statement "A DataSet object makes use of a DataReader object to read the Data" is true.

    Rate this question:

  • 31. 

    A user control is cached by including an @OutputCache directive in the .ascx file of the control.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When an @OutputCache directive is included in the .ascx file of a user control, it means that the user control can be cached. Caching a user control means that the control's output is stored in memory or on disk, so that subsequent requests for the control can be served more quickly. This can improve the performance of the application by reducing the amount of processing required to generate the control's output. Therefore, the statement "A user control is cached by including an @OutputCache directive in the .ascx file of the control" is true.

    Rate this question:

  • 32. 

    Enable sorting columns.

    • AllowSort

    • AllowSorting

    • PageSorting

    Correct Answer
    A. AllowSorting
    Explanation
    The correct answer is "AllowSorting" because it is a clear and concise term that accurately describes the action of enabling the sorting of columns. It is also consistent with common naming conventions for similar functionality in software applications.

    Rate this question:

  • 33. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    ASP.Net 2.0 introduced the GridView control, which provides built-in functionality for common data scenarios such as paging and sorting. This means that developers do not need to write any additional code to implement these features. The GridView control automatically handles the logic for paging and sorting data, making it easier and more efficient for developers to work with data in ASP.Net 2.0. Therefore, the statement is true.

    Rate this question:

  • 34. 

    The Insert() method is used to add an item  to the cache.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The Insert() method is used to add an item to the cache. This means that when we want to add a new item to the cache, we can use the Insert() method to do so.

    Rate this question:

  • 35. 

    The LabelFiled property of ObjectList is typically set to a column name from the data source.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The LabelField property of ObjectList is typically set to a column name from the data source. This means that the ObjectList control will use the values from that column as labels for each item in the list. By setting the LabelField property to a specific column name, developers can easily display relevant information from the data source in the ObjectList control. Therefore, the statement "The LabelField property of ObjectList is typically set to a column name from the data source" is true.

    Rate this question:

  • 36. 

    The FormView and DetailView controls can have customized style similar to GridView control

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because both the FormView and DetailView controls in ASP.NET allow for customization of their styles, just like the GridView control. This means that developers can modify the appearance and layout of these controls to match the design of their application or website.

    Rate this question:

  • 37. 

    Creates versions of a page based on the request's header.

    • VarHeader

    • RequestHeader

    • VaryByHeader

    Correct Answer
    A. VaryByHeader
    Explanation
    The correct answer is "VaryByHeader". This option suggests that the system creates different versions of a page based on the request's header. This means that the content of the page may vary depending on the specific header information provided in the request. This can be useful for delivering personalized or customized content to different users based on their preferences or characteristics indicated in the header.

    Rate this question:

  • 38. 

    This object represents the data type of columns property of DataTable

    • DataColumn

    • DataColumnCollection

    Correct Answer
    A. DataColumnCollection
    Explanation
    The given correct answer is DataColumnCollection. This object represents the collection of DataColumn objects, which defines the schema or structure of a DataTable. It allows you to add, remove, and access DataColumn objects within a DataTable. By using DataColumnCollection, you can define the data type, name, and other properties of each column in a DataTable.

    Rate this question:

  • 39. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because SQL Server 6.5 database can indeed be accessed using .Net Framework Data Provider for OLE DB. The .Net Framework Data Provider for OLE DB allows developers to access SQL Server databases using the OLE DB technology, which is a set of COM-based interfaces that provide access to a variety of data sources. This means that developers can use the .Net Framework and its associated libraries to interact with SQL Server 6.5 databases, enabling them to perform tasks such as querying, inserting, updating, and deleting data.

    Rate this question:

  • 40. 

    The SqlDataReader class is defined in the System.Data.Sql

    • True

    • Fasle

    Correct Answer
    A. Fasle
    Explanation
    The given answer, "Fasle", is incorrect. The correct answer is "False". The SqlDataReader class is not defined in the System.Data.Sql namespace. It is actually defined in the System.Data.SqlClient namespace.

    Rate this question:

  • 41. 

    DataReader Object do not support paging or sorting functionality.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because a DataReader object in programming does not have built-in functionality for paging or sorting data. The DataReader is a forward-only, read-only data retrieval mechanism that allows efficient access to data in a database. It is typically used when we need to quickly read and process large amounts of data, but it does not provide methods for sorting or paging through the data. To perform paging or sorting, we would need to use other data access objects or techniques.

    Rate this question:

  • 42. 

    You must always create a new connection when specifying a connection in the Configure Data Source dialog.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    In the Configure Data Source dialog, you do not always have to create a new connection when specifying a connection. You can choose an existing connection that has already been established. Therefore, the statement is false.

    Rate this question:

  • 43. 

    This option is preferable when you need to pass in a value for a parameter from another page.

    • QueryString

    • Form

    • StringQuery

    • Cookie

    • Control

    Correct Answer
    A. QueryString
    Explanation
    The QueryString option is preferable when you need to pass in a value for a parameter from another page. This is because the QueryString allows you to append parameters to the URL, which can then be accessed on the receiving page. By using the QueryString, you can easily pass data between pages without the need for complex form submissions or storing values in cookies.

    Rate this question:

  • 44. 

    Specifies or retrieves the time in seconds for which the control caches the data.

    • CacheTimer

    • CachDuration

    Correct Answer
    A. CachDuration
    Explanation
    The correct answer is "CacheDuration". This option is the most appropriate because it accurately reflects the purpose of the control, which is to specify or retrieve the time in seconds for which the data is cached. The term "CacheDuration" implies a duration or time period, which aligns with the given description. "CacheTimer" does not accurately convey the purpose of the control, as it suggests a mechanism for measuring time rather than specifying a duration.

    Rate this question:

  • 45. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    ASP.Net data binding typically involves declarative or inline binding expressions that are given in the form of . This statement is false because the correct syntax for declarative or inline binding expressions in ASP.Net is . The # symbol is missing in the given statement, making it incorrect.

    Rate this question:

  • 46. 

    Specifies whether caching is enabled or not

    • EnabledCaching

    • EnableCaching

    • CachDuration

    Correct Answer
    A. EnableCaching
    Explanation
    The given correct answer, "EnableCaching," suggests that it is a property or variable that determines whether caching is enabled or not. It implies that this particular setting controls the caching functionality within a system or software.

    Rate this question:

  • 47. 

    This contains actual data.

    • DataColumn

    • DataRow

    • DataTable

    Correct Answer
    A. DataRow
    Explanation
    A DataRow is a single row of data in a DataTable. It represents a record or a set of values for a specific entity. It contains the actual data values for each column in the DataTable.

    Rate this question:

  • 48. 

    This property specifies how many records will be repeated on the same line or row.

    • RepeateLayout

    • RepeateColumns

    • RepeateDirection

    Correct Answer
    A. RepeateColumns
    Explanation
    The correct answer is "RepeateColumns." This property determines the number of records that will be repeated on the same line or row. It specifies the number of columns in which the records will be displayed, allowing for a horizontal repetition of records.

    Rate this question:

  • 49. 

    This property gets or sets the grid line style in DataList.

    • GridLines

    • RepeateColumn

    • CellPadding

    Correct Answer
    A. GridLines
    Explanation
    The property "GridLines" is used to get or set the grid line style in a DataList. This property determines whether grid lines are displayed between the cells in the DataList. By setting this property to different values, such as "None", "Horizontal", "Vertical", or "Both", the developer can control the appearance of the grid lines in the DataList.

    Rate this question:

Quiz Review Timeline (Updated): Aug 9, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 09, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 23, 2009
    Quiz Created by
    Vietha
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.