Menu

Question Discussion & Solution

MCQ

Q.

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

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

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

A

EXEC SQL

B

EXEC SQL

C

EXEC SQL

D

EXEC SQL

Discussion

MCQ

2.

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

Discussion

MCQ

3.

In the query given above which one of the following is a temporary relation?

A

Budget

B

Department

C

Value

D

Max_budget

Discussion

MCQ

4.

Which prefixes are available to Oracle triggers?

C

Both

D

Neither

Discussion

MCQ

5.

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

A

Procedures

B

Triggers

C

Functions

D

None of the mentioned

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs