wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Sec BCD 21-7-2023 Quiz-2

Total questions: 149

Worksheet time: 1hrs 15mins

Name
Class
Date
1.

Which driver is efficient and always preferable for using JDBC applications?

a)

Type-4

b)

Type-3

c)

Type-2

d)

Type-1

2.

Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

a)

Type 1

b)

Type 2

c)

Type 3

d)

Type 4

3.

Which packages contain the JDBC classes?

a)

java.jdbc and javax.jdbc

b)

java.jdbc and java.jdbc.sql

c)

java.sql and javax.sql

d)

java.rdb and javax.rdb

4.

Which type of Statement can execute parameterized queries?

a)

PreparedStatement

b)

ParameterizedStatement

c)

ParameterizedStatement and CallableStatement

d)

All kinds of Statements (i.e. which implement a sub interface of Statement)

5.

How can you retrieve information from a ResultSet?

a)

By invoking the method get(…, String type) on the ResultSet, where type is the database type

b)

By invoking the method get(…, Type type) on the ResultSet, where Type is an object which represents a database type

c)

By invoking the method getValue(…), and cast the result to the desired Java type.

d)

By invoking the special getter methods on the ResultSet: getString(…), getInt (…), getDouble(…),…

6.

How can you execute a stored procedure in the database?

a)

Call method execute() on a CallableStatement object

b)

Call method executeProcedure() on a Statement object

c)

Call method execute() on a StoredProcedure object

d)

Call method run() on a ProcedureCommand object

7.

Which method is used to perform DML statements in JDBC?

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeResult()

8.

Which of the following is correct about PreparedStatement?

a)

Prepared statements offer better performance, as they are pre-compiled.

b)

Prepared statements reuse the same execution plan for different arguments rather than creating a new execution plan every time.

c)

Prepared statements use bind arguments, which are sent to the database engine.

d)

All of the above.

9.

In order to transfer data between a database and an application written in the Java programming language, the JDBC API provides which of these methods?

a)

Methods on the ResultSet class for retrieving SQL SELECT results as Java types.

b)

Methods on the PreparedStatement class for sending Java types as SQL statement parameters.

c)

Methods on the CallableStatement class for retrieving SQL OUT parameters as Java types.

d)

All mentioned above

10.

The performance of the application will be faster if you use PreparedStatement interface because query is compiled only once.

a)

True

b)

False

11.

Which method is used to establish the connection with the specified url in a Driver Manager class?

a)

public static void registerDriver(Driver driver)

b)

public static void deregisterDriver(Driver driver)

c)

public static Connection getConnection(String url)

d)

public static Connection getConnection(String url,String userName,String password)

12.

Which driver Network connection is indirect that a JDBC client makes to a middleware process that acts as a bridge to the DBMS server?

a)

JDBC-Net

b)

JDBC-ODBC bridge

c)

Native API as basis

d)

Native protocol as basis

13.

Which is used to call the stored procedures and functions?

a)

CallableStatement Interface

b)

PreparedStatement Interface

c)

All the above

d)

None of the above

14.

What is used to execute parameterized query?

a)

Statement interface

b)

PreparedStatement interface

c)

ResultSet interface

d)

None of the above

15.

ODBC stands for?

a)

Open database connection

b)

Open database concept

c)

Open database communications

d)

None of the above

16.

Which models do the JDBC API support for the database access?

a)

Two-tier models

b)

Three-tier models

c)

Both A & B

d)

None of the above

17.

Which of the following is used to rollback a JDBC transaction?

a)

rollback()

b)

rollforward()

c)

deleteTransaction()

d)

RemoveTransaction()

18.

The method on the result set that tests whether or not there remains at least one unfetched tuple in the result set, is said to be

a)

Fetch method

b)

Current method

c)

Next method

d)

Access method

19.

Which method is used to perform DML statements in JDBC?

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeResult()

20.

Which of the following describes the correct sequence of the steps involved in making a connection with a database.

1. Loading the driver

2. Process the results.

3. Making the connection with the database.

4. Executing the SQL statements.

a)

1 ,3,4,2

b)

1,2,3,4

c)

1,4,3,2

d)

1,2,4,3

21.

Which of the following tasks are associated with JDBC library?

a)

Making a connection to a database.

b)

Creating SQL or MySQL statements.

c)

Executing SQL or MySQL queries in the database.

d)

All of these

22.

Expand JDBC

(a)  

23.

_____________ interface handles the communications with the database server

a)

DriverManager

b)

Driver

c)

Statement

d)

None of these

24.

___________ interface with all methods for contacting a database.

a)

ResultSet

b)

Statement

c)

Connection

d)

Driver

25.

The third step involved in JDBC application is ____________

a)

Execute Query

b)

Establish Connection

c)

importing packages

d)

Register the Driver

26.

In Type 2 Driver, JDBC API calls are converted into native _____________ API calls, which are unique to the database

a)

C/C++

b)

Java

c)

JavaScript

d)

Visual Programming

27.

Type 4 Driver is also called as (a)  

28.

_____________ driver talks with server-side middleware which then talks to the database

a)

Type 1

b)

Type 2

c)

Type 3

d)

Type 4

29.

(a)   should be imported to use SQL statements

30.

The most common approach to register a driver is to use Java's (a)   method.

31.

To open a connection, DriverManager. (a)   () is to be used.

32.

Which method returns an integer as its result?

a)

execute()

b)

executeUpdate()

c)

executeQuery()

d)

extract()

33.

Which interface will NOT accept input parameters

a)

Statement

b)

PreparedStatement

c)

CallableStatement

d)

PrepareStatement

34.

All parameters in JDBC are represented by the ? symbol, which is known as the (a)   .

35.

in a ResultSet object, the ___________ methods to retrieve the value of a given column.

a)

POST()

b)

GET()

c)

setXXX()

d)

getXXX()

36.

We bind values to _________ parameters with the setXXX methods

a)

OUT

b)

IN

c)

INPUT

d)

OUTPUT

37.

The corresponding SQL type for the boolean JAVA type is_____

a)

BOOLEAN

b)

BIT

c)

BOOL

d)

BYTE

38.

(a)   method returns the total number of columns in the ResultSet object.

39.

_____________interface is used to execute stored procedures.

a)

Statement

b)

PreparedStatement

c)

CallableStatement

d)

execute

40.

(a)   method is used to create an object of the class ResultSetMetaData.

41.

What is the return type of executeUpdate() method?

a)

byte

b)

short

c)

int

d)

long

42.

What is the return type of executeQuery() method?

a)

int

b)

ResultSet

c)

array

d)

none of the above

43.

what is the package name of "Class"?

a)

java.util

b)

java.sql

c)

java.lang

d)

java.io

44.

What is true about DriverManager class?

a)

It is class from java.lang package

b)

It is a class from java.sql package

c)

It is a interface from java.sql package

d)

It is a class from java.lang package

45.

What is JDBC?

a)

JDBC is a java based protocol.

b)

JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

c)

JDBC is a specification to tell how to connect to a database.

d)

Joint Driver for Basic Connection

46.

Which of the following encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed?

a)

DriverManager

b)

JDBC driver

c)

Connection

d)

Statement

47.

Which of the following is not a valid type of statement in JDBC?

a)

Statement

b)

PreparedStatement

c)

CallableStatement

d)

QueryStatement

48.

Which of the following is correct about PreparedStatement?

a)

Used when you plan to use the SQL statements many times.

b)

The PreparedStatement interface accepts input parameters at runtime.

c)

Both of the above.

d)

None of the above.

49.

what is true about getConnection() method?

a)

It is a static method from DriverManager class

b)

It is a non static method from DriverManager class

c)

It is a static method from DriverManager interface

d)

It is a non static method from DriverManager interface

50.

Which package contains JDBC classes and interfaces?

a)

java.lang

b)

java.io

c)

java.sql

d)

java.jdbc

51.

JDBC Stands for _________

a)

Java Database Connectivity

b)

Java Driver Connectivity

c)

Java Developer Connectivity

d)

None of the above

52.

Select the packages in which JDBC classes and interfaces are defined?

a)

java.jdbc

b)

java.sql

c)

java.io

d)

java.jdbc.sql

53.

Which of the following is the correct method to make a connection with database?

a)

Driver.getConnection()

b)

Driver.connection()

c)

DriverManager.getConnection()

d)

DriverManager.connection()

54.

Which of the following method will load the driver?

a)

Class.forName()

b)

Class.loadDriver()

c)

Class.load()

d)

Class.driverName()

55.

Which of the following method is used to execute insert query in JDBC?

a)

executeUpdate()

b)

executeQuery()

c)

execute()

d)

executeInsert()

56.

Which of the following method is used execute select query in JDBC?

a)

executeUpdate()

b)

executeQuery()

c)

execute()

d)

executeSelect()

57.

Which of the following method will create prepared statement object in JDBC?

a)

con.prepareStatement()

b)

con.statement()

c)

con.createStatement()

d)

con.createPStatement()

58.

What is the return type of ResultSet next() method?

a)

boolean

b)

int

c)

String

d)

long

59.

Which of the following is the class from JDBC API?

a)

DriverManager

b)

ResultSet

c)

PreparedStatement

d)

Connection

60.

Which of the following is the correct order to write a JBDC program?

a)

Load the driver, Making Connection, Statement Creation and Executing the Query

b)

Load the driver, Statement Creation, Making Connection, and Executing the Query

c)

Statement Creation, Load the driver, Making Connection, and Executing the Query

d)

Making Connection, Statement Creation, Load the driver and Executing the Query

61.

Predict the output:

a)

Compiletime Error at line 6

b)

Compiletime Error at line 7 : Unhandled IOException

c)

accepts string and displays on the screen

d)

None of the above

62.

Predict the output:

a)

Compile time error

b)

Run time error

c)

Java

Unix

d)

Java

Unix

Oracle

C++

Perl

63.

Predict the output:

a)

Hello from Parent

b)

Hello from Child

c)

Compilation Error

d)

None of the above

64.

Predict the output:

a)

Compile Time Error : Array size is negative

b)

Runtime Exception : Array size is negative

c)

0

d)

-0

65.

Predict the output

a)

Kucu Kucu

b)

I speak

c)

compile time error

d)

runtime exception

66.

Predict the output:

a)

Java

PJP

b)

Compile time error

c)

Runtime Exception : IndexOutOfBoundsException

d)

None of the above

67.

Predict the output:

a)

10

11

b)

10

10

c)

11

11

d)

11

10

68.

What is the return type of setter method?

a)

void

b)

It depends on the instance variable's data type whose value we are trying to retrieve.

69.

Which of the below options is correct to load the Oracle JDBC driver?

a)

Class.forName("oracle.jdbc.driver.OracleDBDriver");

b)

Class.forName("Oracle.Jdbc.Driver.OracleDriver");

c)

Class.forName("jdbc.oracle.driver.OracleDriver");

d)

Class.forName("oracle.jdbc.driver.OracleDriver");

70.

Which of the below queries is correct to display the Employee details such as empno, ename, sal from emp table whose empno contains 77 in it?

a)

select empno,ename,sal from emp where empno is 77;

b)

select empno,ename,sal from emp where empno like '_77%';

c)

select empno,ename,sal from emp where empno like '%77%';

d)

select empno,ename,sal from emp where empno like '_77_';

71.

What JDBC stands for ?

a)

Java Database Connectivity

b)

Java Driver for Basic Connection

c)

Joint Database Connectivity

d)

Joint Driver for Basic Connection

72.

How many Types of JDBC-Drivers available ?

a)

5

b)

4

c)

3

d)

6

73.

Which JDBC Driver Type is the JDBC-ODBC bridge ?

a)

Type-4

b)

Type-3

c)

Type-2

d)

Type-1

74.

Which driver is called as thin-driver in JDBC ?

a)

Type-2

b)

Type-4

c)

Type-3

d)

Type-1

75.

Which driver is callled Native-API driver ?

a)

Type-4

b)

Type-2

c)

Type-3

d)

Type-1

76.

What are the correct sequence of steps to connect any database using JDBC ?

a)

import packages,load or register the driver class,establish connection,create the statement,execute queries,close the connection

b)

establish connection,import packages,load or register the driver class,execute queries,create the statement,close the connection

c)

create the statement,import the packages,establish connection,import packages,load or register the driver class,execute queries,close the connection

d)

establish connection,create the statement,import the packages,import packages,load or register the driver class,execute queries,close the connection

77.

Which of the following method is needed for loading a database driver in JDBC ?

a)

registerDriver() method

b)

Class.forName() method

c)

Both 1 and 2

d)

None of the above

78.

Which packages contain the JDBC classes?

a)

java.jdbc and javax.jdbc

b)

java.jdbc and java.jdbc.sql

c)

java.sql and javax.sql

d)

java.rdb and javax.rdb

79.

------------- method is used to execute any SQL Statement with a SELECT clause, that return the result of the query as a

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeBatch()

80.

Which method is used to execute INSERT,DELETE,UPDATE and other SQL DDL commands such as CREATE or DROP Table?

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeBatch()

81.

What is return type of executeUpdate() method ?

a)

int

b)

String

c)

Date

d)

ResultSet

82.

What are the different types of Statements available in JDBC?

a)

Statement

b)

PreparedStatement

c)

CallableStatement

d)

All of the above

83.

Which type of Statement can execute parameterized queries ?

a)

ParameterizedStatement

b)

PreparedStatement

c)

CallableStatement

d)

All kinds of Statements (i.e. which implement a sub interface of Statement)

84.

Which method returns ResultSet as output?

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeBatch()

85.

Which java.sql class or interface contains methods that enable you to find out the number of columns this is returned in a ResultSet and the name or label for a given column?

a)

Statement

b)

CallableStatement

c)

ResultSetMetaData

d)

MetaData

86.

What are the Interfaces available in JDBC?

a)

Connection interface

b)

PreparedStatement interface

c)

ResultSet interface

d)

ResultSet interface

87.

What are the methods in Statement Interface?

a)

public ResultSet executeQuery(String sql): is used to execute SELECT query. It returns the object of ResultSet.

b)

public int executeUpdate(String sql): is used to execute specified query, it may be create, drop, insert, update, delete etc.

c)

public boolean execute(String sql): is used to execute queries that may return multiple results.

d)

public int[] executeBatch(): is used to execute batch of commands.

88.

This method is for retrieving a String Value(SQL type VARCHAR) and assigning to String Object.

a)

getVarchar()

b)

getString()

c)

getObject()

d)

getInt()

89.

How can you retrieve information from a ResultSet?

a)

By invoking the method get(…, String type) on the ResultSet, where type is the database type

b)

By invoking the method get(…, Type type) on the ResultSet, where Type is an object which represents a database type

c)

By invoking the method getValue(…), and cast the result to the desired Java type.

d)

By invoking the special getter methods on the ResultSet: getString(…), getInt (…), getDouble(…),…

90.

Which type of Statement can execute parameterized queries?

a)

PreparedStatement

b)

ParameterizedStatement

c)

ParameterizedStatement and CallableStatement

d)

All kinds of Statements (i.e. which implement a sub interface of Statement)

91.

Which packages contain the JDBC classes?

a)

java.jdbc and javax.jdbc

b)

java.jdbc and java.jdbc.sql

c)

java.sql and javax.sql

d)

java.rdb and javax.rdb

92.

How can you execute a stored procedure in the database?

a)

Call method execute() on a CallableStatement object

b)

Call method executeProcedure() on a Statement object

c)

Call method execute() on a StoredProcedure object

d)

Call method run() on a ProcedureCommand object

93.

Which method is used to perform DML statements in JDBC?

a)

execute()

b)

executeQuery()

c)

executeUpdate()

d)

executeResult()

94.

Which of the following is correct about PreparedStatement?

a)

Prepared statements offer better performance, as they are pre-compiled.

b)

Prepared statements reuse the same execution plan for different arguments rather than creating a new execution plan every time.

c)

Prepared statements use bind arguments, which are sent to the database engine.

d)

All of the above.

95.

In order to transfer data between a database and an application written in the Java programming language, the JDBC API provides which of these methods?

a)

Methods on the ResultSet class for retrieving SQL SELECT results as Java types.

b)

Methods on the PreparedStatement class for sending Java types as SQL statement parameters.

c)

Methods on the CallableStatement class for retrieving SQL OUT parameters as Java types.

d)

All mentioned above

96.

The performance of the application will be faster if you use PreparedStatement interface because query is compiled only once.

a)

True

b)

False

97.

Which method is used to establish the connection with the specified url in a Driver Manager class?

a)

public static void registerDriver(Driver driver)

b)

public static void deregisterDriver(Driver driver)

c)

public static Connection getConnection(String url)

d)

public static Connection getConnection(String url,String userName,String password)

98.

Which is used to call the stored procedures and functions?

a)

CallableStatement Interface

b)

PreparedStatement Interface

c)

All the above

d)

None of the above

99.

Which of the following is correct about Statement class of JDBC?

a)

A - Statement encapsulates an SQL statement which is passed to the database to be parsed and compiled.

b)

B - Statement encapsulates an SQL statement which is passed to the database to be planned and executed.

c)

C - Both of the above.

d)

D - none of the above.

100.

Which of the following type of JDBC driver, uses database native protocol?

a)

A - JDBC-ODBC Bridge plus ODBC driver

b)

B - Native-API, partly Java driver

c)

C - JDBC-Net, pure Java driver

d)

D - Native-protocol, pure Java driver

101.

Which of the following is not a valid type of statement in JDBC?

a)

A - Statement

b)

B - PreparedStatement

c)

C - CallableStatement

d)

D - QueryStatement

102.

Which of the following is correct about PreparedStatement?

a)

A - PreparedStatement allows mapping different requests with same prepared statement but different arguments to execute the same execution plan.

b)

B - Prepared statements are more secure because they use bind variables, which can prevent SQL injection attack.

c)

C - Both of the above.

d)

D - None of the above.

103.

What are the major components of the JDBC?

a)

DriverManager, Driver, Connection, Statement, and ResultSet

b)

DriverManager, Driver, Connection, and Statement

c)

DriverManager, Statement, and ResultSet

d)

DriverManager, Connection, Statement, and ResultSet

104.

Select the packages in which JDBC classes are defined?

a)

jdbc and javax.jdbc

b)

rdb and javax.rdb

c)

jdbc and java.jdbc.sql

d)

sql and javax.sql

105.

Thin driver is also known as?

a)

Type 3 Driver

b)

Type-2 Driver

c)

Type-4 Driver

d)

Type-1 Driver

106.

Which of the following method is used to perform DML statements in JDBC?

a)

executeResult()

b)

executeQuery()

c)

executeUpdate()

d)

execute()

107.

How many transaction isolation levels provide the JDBC through the Connection interface?

a)

3

b)

4

c)

7

d)

2

108.

Which of the following method is static and synchronized in JDBC API?

a)

getConnection()

b)

prepareCall()

c)

executeUpdate()

d)

executeQuery()

109.

JDBC stands for

(a)  

110.

Which is the first step for connecting Java and database

a)

Establish Connection

b)

Create Statement object

c)

Load and Register JDBC Driver

d)

Execute SQL statements

111.

JDBC Driver is same to all database softwares.

a)

True

b)

False

112.

Which of the following is Type 1 JDBC Driver

a)

Middleware

b)

Native

c)

Bridge

d)

Pure

113.

Which of the following manages all the Drivers found in JDBC environment?

a)

Connection

b)

ResutSet

c)

Statement

d)

DriverManager

114.

Which of the following is used to store the result of SQL query?

a)

Statement

b)

ResultSet

c)

Connection

d)

DriverManager

115.

Class.forName() is used to

a)

establish connection

b)

execute SQL statements

c)

load and register Driver

d)

set the database

116.

Which function is used to execute SQL SELECT statement?

a)

executeQuery()

b)

executeUpdate()

c)

executeSelect()

d)

executeAll()

117.

Fill in the blanks

Class.forName( (a)   );

118.

Fill in the blanks:

Connection con=DriverManager.getConnection( " (a)   /databasename" , "username", "password" );

119.

Fill in the blanks.

Statement st = con. (a)   ;

120.

st. (a)   ("CREATE TABLE stud1(roll int, name varchar(15))");

121.

PreparedStatement represents a precompiled SQL statement

a)

True

b)

False

122.

Which class is used to represent error or warning during access from database or during connectivity?

a)

SQLError

b)

SQL command

c)

Statement object

d)

SQLException

123.

JDBC API helps to provide universal data access from the Java programming language

a)

True

b)

False

124.

(a)   should be imported to use SQL statements

125.

To open a connection, DriverManager. (a)   () is to be used.

126.

Which method returns an integer as its result?

a)

execute()

b)

executeUpdate()

c)

executeQuery()

d)

extract()

127.

We bind values to _________ parameters with the setXXX methods

a)

OUT

b)

IN

c)

INPUT

d)

OUTPUT

128.

The corresponding SQL type for the boolean JAVA type is_____

a)

BOOLEAN

b)

BIT

c)

BOOL

d)

BYTE

129.

Which of the following is correct about JDBC?

a)

The JDBC API provides the abstraction and the JDBC drivers provide the implementation.

b)

The JDBC API provides the abstraction and the JDBC drivers provide the implementation.

c)

Both of the above.

d)

Both of the above.

130.

What are the major components of the JDBC?

a)

DriverManager, Driver, Connection, Statement, and ResultSet

b)

DriverManager, Driver, Connection, and Statement

c)

DriverManager, Statement, and ResultSet

d)

DriverManager, Connection, Statement, and ResultSet

131.

Select the packages in which JDBC classes are defined?

a)

jdbc and javax.jdbc

b)

rdb and javax.rdb

c)

jdbc and java.jdbc.sql

d)

sql and javax.sql

132.

Which of the following method is used to perform DML statements in JDBC?

a)

executeResult()

b)

executeQuery()

c)

executeUpdate()

d)

execute()

133.

Which methods are required to load a database driver in JDBC?

a)

getConnection()

b)

registerDriver()

c)

forName()

d)

Both b and c

134.

Which of the following is not a valid statement in JDBC?

a)

Statement

b)

PreparedStatement

c)

QueryStatement

d)

CallableStatement

135.

A good way to debug JDBC-related problems is to enable?

a)

JDBC tracing

b)

Exception handling

c)

Both a and b

d)

Only b

136.

Which data type is used to store files in the database table?

a)

BLOB

b)

CLOB

c)

File

d)

Both a and b

137.

New drivers can be plugged-in to the JDBC API without changing the client code.

a)

TRUE

b)

FALSE

138.

Which JDBC type represents a "single precision" floating point number that supports seven digits of mantissa?

a)

REAL

b)

DOUBLE

c)

FLOAT

d)

INTEGER

139.

Abbreviate the term UDA?

a)

Unified Data Access

b)

Universal Data Access

c)

Universal Digital Access

d)

Uniform Data Access

140.

Which methods returns a stream that simply provides the raw bytes from the database without any conversion?

a)

getCharacterStream

b)

getBinaryStream

c)

getAsciiStream

d)

getUnicodeStream

141.

The ACID properties does not describes the transaction management well.

a)

TRUE

b)

FALSE

142.

Which interfaces provide methods for batch processing in JDBC?

a)

java.sql.Statement

b)

java.sql.PreparedStatement

c)

All the above

d)

None of the above

143.

Which JDBC type represents a 64-bit signed integer value between -9223372036854775808 and 9223372036854775807?

a)

SMALLINT

b)

BIGINT

c)

TINYINT

d)

INTEGER

144.

Which method is used for an SQL statement that is executed frequently?

a)

prepareStatement

b)

prepareCall

c)

createStatement

d)

None of the above

145.

Which statement is wrong about PRIMARY KEY constraint in SQL?

a)

The PRIMARY KEY uniquely identifies each record in a SQL database table

b)

Primary key can be made based on multiple columns

c)

Primary key must be made of any single columns

d)

Primary keys must contain UNIQUE values.

146.

In existing table, ALTER TABLE statement is used to

a)

Add columns or constraints

b)

Delete columns or constraints

c)

All the above

147.

Logical operators used in SQL are

a)

AND, OR , NOT

b)

&&, ||, !

c)

&,|,!

d)

None of the above

148.

Which clause is used to combine rows from two or more tables based on a related column between them.

a)

SQL MATCH

b)

SQL JOIN

c)

SQL PATTERN

d)

NONE

149.

Correct SQL query syntax to update a record from a table is

UPDATE table_name

SET column1 = value1, column2 = value2, … WHERE condition;

a)

UPDATE table_name SET COLUMN column1 = value1, column2 = value2, … WHERE condition;

b)

UPDATE table_name UPDATE column1 = value1, column2 = value2, … WHERE condition;

c)

UPDATE table_name column1 = value1, column2 = value2, … WHERE condition;

d)

None

Similar Resources on Wayground

Page 1

150 questions

Page 1

quiz

Worksheet

•

University

Advanced Data Structure

153 questions

Advanced Data Structure

quiz

Worksheet

•

University

PM 2025-FINAL

150 questions

PM 2025-FINAL

quiz

Worksheet

•

9th Grade - University

Software Engineering

154 questions

Software Engineering

quiz

Worksheet

•

University

open code source

154 questions

open code source

quiz

Worksheet

•

University

C-programming(Theory)

146 questions

C-programming(Theory)

quiz

Worksheet

•

9th Grade - University

Taetaetae

153 questions

Taetaetae

quiz

Worksheet

•

University

Tin Học Căn Bản: Phần Cứng và Phần Mềm

150 questions

Tin Học Căn Bản: Phần Cứng và Phần Mềm

quiz

Worksheet

•

University