Q.1
Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
  • a) Embedded SQL
  • b) Dynamic SQL
  • c) SQL declarations
  • d) SQL data analysis
Q.2
Which of the following header must be included in java program to establish database connectivity using JDBC ?
  • a) Import java.sql.*;
  • b) Import java.sql.odbc.jdbc.*;
  • c) Import java.jdbc.*;
  • d) Import java.sql.jdbc.*;
Q.3
DriverManager.getConnection(_______ , ______ , ______)
  • a) URL or machine name where server runs, Password, User ID
  • b) URL or machine name where server runs, User ID, Password
  • c) User ID, Password, URL or machine name where server runs
  • d) Password, URL or machine name where server runs, User ID
Q.4
Which of the following invokes functions in sql?
  • a) Prepared Statements
  • b) Connection statement
  • c) Callable statements
  • d) All of the mentioned
Q.5
Which of the following function is used to find the column count of the particular resultset?
  • a) getMetaData()
  • b) Metadata()
  • c) getColumn()
  • d) get Count()
Q.6
Which of the following is a following statement is a prepared statements?
  • a) Insert into department values(?,?,?)
  • b) Insert into department values(x,x,x)
  • c) SQLSetConnectOption(conn, SQL AUTOCOMMIT, 0)
  • d) SQLTransact(conn, SQL ROLLBACK)
Q.7
Which of the following is used as the embedded SQL in COBOL?
  • a) EXEC SQL <embedded SQL statement >;
  • b) EXEC SQL <embedded SQL statement > END-EXEC
  • c) EXEC SQL <embedded SQL statement >
  • d) EXEC SQL <embedded SQL statement > END EXEC;
Q.8
Which of the following is used to distinguish the variables in SQL from the host language variables?
  • a) .
  • b) –
  • c) :
  • d) ,
Q.9
The update statement can be executed in host language using
  • a) EXEC SQL update c;
  • b) EXEC SQL update c into :si, :sn;
  • c)
  • d) EXEC SQL update END-SQL
Q.10
Which of the following is used to access large objects from a database ?
  • a) setBlob()
  • b) getBlob()
  • c) getClob()
  • d) all of the mentioned
0 h : 0 m : 1 s