I have the Following Questions These are all Questions in Visual Basic 2012 1. A
ID: 3849856 • Letter: I
Question
I have the Following Questions These are all Questions in Visual Basic 2012
1. ADO.NET 4.5 can only connect to local databases stored on a USB drive. True or false?
2. Define ADO. 3. Define SQL.
4. What is the name of a unique field that must be present in each relational database?
5. Name three types of databases that can connect with ADO.NET 4.5.
6. What is a DataSet object?
7. Does a row in a database table represent a record or a field?
8. Name five types of objects that can be dragged from a data field in the Data Sources window to the Windows Form object without using the Customize option.
9. What is the object name of the navigation toolbar?
10. When you add a record to a database using the Add new button on the navigation toolbar, the record is not added to the original database. What action must take place to add the record to the original data source?
11. How many records does the database table named SouthernStates displayed in Figure 10-58 contain?
12. In the table in Figure 10-58 on the previous page, name the field labels.
13. For the table in Figure 10-58, write a statement that references the North Carolina state capital city and assign the value to the strCapitalCity variable.
14. What properties under the Data Binding Mode must you set when you bind a ComboBox object to a Windows form?
15. What procedure places data in the Data Table?
16. What command disconnects a database connection?
17. Write a line of code to initialize a String variable named strOrder to a Select SQL statement that would select all the fields from a table named Coffee.
18. Which wildcard symbol is used in a Select statement?
19. What does the wildcard symbol mean in the Select statement?
20. Write the statement that would fill a DataTable object named datCoins if an instance of the OleDbDataAdapter is named odaCollection.
APPROXIMATE POPULATION OF THE SOUTHERN STATES PROJECTED FOR 2025 State Capital State Name Auto Number Population Tallahassee Florida 20,066,000 Georgia 10,962,000 Atlanta 3 South Carolina Columbia 4,574,000 Raleigh North Carolina 9,916,000 8,165,000 Richmon irginia Alabama 5,224,000 Montgomery Louisiana 5,111,000 Baton Rouge 8 Tennessee 7,249,000 Nashville West Virginia Charleston 1,864,000 Mississippi 3,413,000 ackson 4,314,000 Kentucky Lexington Source: htt o 2014 Cengage LearningExplanation / Answer
1. Flase
ADO.NET can also connect to the remote databases.
2. ADO means ActiveX Data Object. This has one major object called recordset to reference the data. Using ADO we can do different operations on database in connected manner. This provides many features when it implements along side with .NET which is called ADO.NET.
3. SQL is a structured Query language which is used to retrieve the data From the database in which ever way we want. Using SQL we can do anything to the database. We can store, delete, retrieve etc in the form of queries.
4. The unique must be maintained in any table in relational database is Primary Key field. This primary key field means that this field doesn't allow null and same values which already given to this filed i.e. the values given must be not null and that too must be unique.