Advanced SQL Questions

MCQ bookmark_border

61.

Which of the following closely resembles Create view?

A

Create table . . .like

B

Create table . . . as

C

With data

D

Create view as

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

62.

In contemporary databases, the top level of the hierarchy consists of ______ each of which can contain _____

A

Catalogs, schemas

B

Schemas, catalogs

C

Environment, schemas

D

Schemas, Environment

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

63.

Which of the following statements creates a new table temp instructor that has the same schema as an instructor.

A

create table temp_instructor

B

Create table temp_instructor like instructor

C

Create Table as temp_instructor

D

Create table like temp_instructor

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

64.

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

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

65.

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.

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

66.

DriverManager.getConnection(_______ , ______ , ______) What are the two parameters that are included?

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

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

67.

Which of the following invokes functions in sql?

A

Prepared Statements

B

Connection statement

C

Callable statements

D

All of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

68.

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

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

69.

Which of the following is a following statement is a prepared statements?

A

Insert into department values

B

Insert into department values

C

SQLSetConnectOption

D

SQLTransact

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

70.

Which of the following is used as the embedded SQL in COBOL?

A

EXEC SQL

B

EXEC SQL

C

EXEC SQL

D

EXEC SQL

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion