Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    FEDT VB - Net Unit-4 Assignment

    Uploaded by

    anand sehgal

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    FEDT VB - Net Unit-4 Assignment

    Uploaded by

    anand sehgal
    4 views4 pages

    Original Title

    FEDT VB.net Unit-4 Assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    4 views4 pages

    FEDT VB - Net Unit-4 Assignment

    Uploaded by

    anand sehgal

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    Institute of Innovation in Technology and Management, New Delhi

    Assignment for (Front End Design Tool VB.Net) Unit IV

    1.
    Programme:
    2. Date of BCA Semester:of classes:
    commencement III 23rd Paper
    July’ Code:
    2007 205 Academic Year: 2014-

    Q1.Write a program in VB.NET to connect to a database and add record in table named
    STUDENT, taking details from the user
    Q2. Write a program to connect to a database and display the records in a Data grid control.
    Multiple Choice Questions
    1. Where is a single element of data stored?

    a.) Field

    b.) Record

    c.) Table

    d.) Both a and b.

    e.) All of the above.

    2. Where is a collection of related data elements stored?

    a.) Field

    b.) Record

    c.) Table

    d.) Both a and b.

    e.) All of the above.

    3. Which clause is required in an SQL query for getting information from a database?

    a.) JOIN

    b.) ON

    c.) ORDER BY

    d.) SELECT

    e.) WHERE

    4. Which database is the ADO.NET SqlConnection object designed for?

    a.) Access
    b.) Microsoft SQL Server

    c.) MySQL

    d.) Oracle

    e.) None of the above.

    5. Which property of the database must the connection object contain?

    a.) Location

    b.) Type

    c.) Query

    d.) Both a and b.

    e.) All of the above

    6. Which is not a tab on the DataLink Property window?

    a.) Advanced

    b.) All

    c.) Adapter

    d.) Connection

    e.) Provider

    7. The first step of configuring a DataAdapter is to select:

    a.) an adapter object.

    b.) a connection object.

    c.) a database object.

    d.) a dataset object.

    e.) None of the above.

    8. Which is not an ADO.NET DataAdapter Object?

    a.) OleDbDataAdapter

    b.) SQLDataAdapter

    c.) QueryDataAdapter

    d.) Both a and b.


    e.) All of the above.

    9. Which type of object has the Generate Dataset method?

    a.) Adapter object

    b.) Connection object

    c.) Database object

    d.) Dataset object

    e.) None of the above.

    10. Which object contains the Position property of the current record in a dataset?

    a.) BindingContext

    b.) BindingData

    c.) DataBinding

    d.) DataBound

    11. Which is a property of the DataGrid control?

    a.) DataMember

    b.) DataSource

    c.) DataQuery

    d.) Both a and b.

    e.) All of the above.

    12. Which below is specified by the DataMember Property?

    a.) Connection object

    b.) DataAdapter object

    c.) Database field

    d.) Database table

    e.) Dataset object

    13. The first record in a dataset has a position property of:

    a.) zero.
    b.) one.

    c.) any value defined by the programmer.

    d.) Both a and b.

    e.) All of the above.

    14. What is the proper code to put data into the dataset called CustomerDataset using the
    CustomerDataAdapter object?

    a.) CustomerDataset.Fill(CustomerDataAdapter)

    b.) CustomerDataAdapter.Fill(CustomerDataset)

    c.) CustomerDataset.Load(CustomerDataAdapter)

    d.) CustomerDataAdapter.Load(CustomerDataset)

    e.) None of the above.

    15. The normalization process is:

    a.) used to remove redundant data.

    b.) used to make the storage of data more efficient.

    c.) not recommended for most databases.

    d.) Both a and b.

    e.) All of the above.

    You might also like