No. Line 3 should be modified to:
VARCHAR(32) CUS_NAME,INTEGER SUP_ID ,FLOAT PRICE , INTEGER SALES
'CUS_NAME VARCHAR(32)','SUP_ID INTEGER',' PRICE FLOAT', 'SALES INTEGER'
'CUS_NAME' VARCHAR(32),'SUP_ID' INTEGER,'PRICE' FLOAT, 'SALES' INTEGER
Correct Answer: Yes. The table will be created successfully.
Explanation:
Note: This Question is unanswered, help us to find answer for this one
JDBC Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More JDBC MCQ Questions
Your project leader has given you a new task. You have to work on a module in which the transaction has to be extended across multiple page requests and multiple servlets. How will you implement this?
Which is the syntax for creating a CallableStatement?
Which is not true?
After executing the following code, resultvar contains false. What should the next step be? boolean resultvar=stmt.execute(sql);
You want to execute the following query string, using the connection named 'con': String query = 'SELECT * FROM CUSTOMER'; What should the syntax be?
A ________ is used to mark intermediate points inside a transaction in order to get a more fine-grained control.
boolean execute (String SQL) returns:
To jump back to a specific point in the program, create a:
A ______ is not contained in an SQLException.
Which is not an overloaded DriverManager.getConnection () method?