Question no. 1:----------------------------
1.) P. SELECT
2.) T. UPDATE
3.) J. StreamReader
4.) H. Connection
5.) Q. close()
6.) G. try-catch block
7.) F. array
8.) L. SQL
9.) C. exception
10.) R. StreamWriter
Question no. 3:---------------------------------
1.) G
2.) F
3.) C
4.) E
5.) D
Question no. 4----------------------------------
1.) B. class
2.) A. object
3.) E. C# keyword
4.) D. constructor
5.) B. class
6.) F. property
7.) J. an accessor method
8.) H. mutator portion of property
9.) G. accessor portion of property
10.) E. C# keyword
QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C....
Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...
Customer (CustomerId, CustomerName) Employee (EmployeeId, EmployeeName, Salary, SupervisorId) Product(ProductId, ProductName, ListPrice) Orders (OrderId, OrderDate, CustomerId, EmployeeId, Total) OrderedProduct (OrderId, ProductId, Quantity, Price) Write the code to complete the methods in OrderJDBC.java (look for TODO items). <---**IN BOLD** throughout code. /* OrderJDBC.java - A JDBC program for accessing and updating an order database on MySQL. */ import java.io.File; import java.math.BigDecimal; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; /** * An application for...