Week 11 : Programming Assignment 1
Add whatever is missing and make the code runnable.
(Ignore the statements ~~~THERE IS SOME INVISIBLE CODE HERE~~~)
Public Test Cases | Input | Expected Output | Actual Output | Status |
---|---|---|---|---|
Test Case 1 | 0 | true | true | Passed |
Week 11 : Programming Assignment 2
Write the JDBC codes needed to create a Connection interface using the DriverManager class and the variable DB_URL.
Check whether the connection is successful using 'isAlive(timeout)' method to generate the output, which is either 'true' or 'false'.
Note the following points carefully:
§ Name the connection object as conn only.
§ Use timeout value as 1.
Public Test Cases | Input | Expected Output | Actual Output | Status |
---|---|---|---|---|
Test Case 1 | 0 | true | true | Passed |
Week 11 : Programming Assignment 3
Due to some mistakes in the below code, the code is not compiled/executable.
Modify and debug the JDBC code to make it execute successfully.
Public Test Cases | Input | Expected Output | Actual Output | Status |
---|---|---|---|---|
Test Case 1 | 0 | true | true | Passed |
Week 11 : Programming Assignment 4
Complete the code segment to create a new table named ‘STUDENTS’ in SQL database using the following information.
Column | UID | Name | Roll | Age |
Type | Integer | Varchar (45) | Varchar (12) | Integer |
Public Test Cases | Input | Expected Output | Actual Output | Status |
---|---|---|---|---|
Test Case 1 | 1 | No. of columns : 4\n
Column 1 Name: UID\n
Column 1 Type : INT\n
Column 2 Name: Name\n
Column 2 Type : VARCHAR\n
Column 3 Name: Roll\n
Column 3 Type : VARCHAR\n
Column 4 Name: Age\n
Column 5 Type : INT | No. of columns : 4\n
Column 1 Name: UID\n
Column 1 Type : INT\n
Column 2 Name: Name\n
Column 2 Type : VARCHAR\n
Column 3 Name: Roll\n
Column 3 Type : VARCHAR\n
Column 4 Name: Age\n
Column 5 Type : INT | Passed |
Week 11 : Programming Assignment 5
Complete the code segment to rename an already created table named ‘STUDENTS’ into ‘GRADUATES’.
Public Test Cases | Input | Expected Output | Actual Output | Status |
---|---|---|---|---|
Test Case 1 | 1 | TABLE NAME = GRADUATES | TABLE NAME = GRADUATES | Passed |