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....
QUESTION 5 Suppose there are two tables: A and B. and we run command SELECT * from A LEFT JOIN B on A.orderid = B.orderid. What would be the code output? only the records from table A where tables A and B have the same orderid only the records from table B where tables A and B have the same orderid the complete set of records from table A, along with the matching records (depending on the availability) from table...
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...