Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.

What is ghi in the following MySQL statement?

A. trigger name
B. table name
C. trigger statement
D. update statement
Answer» D. update statement
Discussion
2.

What is def in the following MySQL statement?

A. action
B. condition value
C. statement
D.
Answer» C. statement
Discussion
3.

What is abc in the following MySQL statement?

A. action
B. condition value
C. statement
D.
Answer» B. condition value
Discussion
4.

Which statement is used to remove a trigger?

A. REMOVE
B. DELETE
C. DROP
D. CLEAR
Answer» D. CLEAR
Discussion
5.

The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

A. True
B. False
C. May be True or False
D. Can't say
Answer» B. False
Discussion
6.

What produces result sets?

A. View
B. SELECT
C. Stored function
D. Trigger
Answer» B. SELECT
Discussion
7.

Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?

A. PI()
B. sampdb.PI()
C. MySQL.PI()
D. db.PI()
Answer» C. MySQL.PI()
Discussion
8.

Which privilege is enabled to create of alter a stored function?

A. SUPER
B. PRIOR
C. TOP
D. SUPERIOR
Answer» B. PRIOR
Discussion
9.

When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________

A. good
B. bad
C. illegal
D. fare
Answer» C. illegal
Discussion
10.

Triggers and events are invoked automatically by the server.

A. True
B. False
C. May be True or False
D. Can't say
Answer» B. False
Discussion
11.

To create or drop events for a database, which privilege should be granted?

A. CREATE
B. DROP
C. PRIVILEGE
D. EVENT
Answer» E.
Discussion
12.

A stored procedure is invoked using the statement __________

A. INVOKE
B. SEE
C. CALL
D. RETURN
Answer» D. RETURN
Discussion
13.

For the same input parameters, if the stored function returns the same result, it is called _____________

A. deterministic
B. non deterministic
C. regular
D. monotonous
Answer» B. non deterministic
Discussion
14.

The IN, OUT and INOUT keywords do not apply to stored functions.

A. True
B. False
C. May be True or False
D. Can't say
Answer» B. False
Discussion
15.

Triggers enable to enforce data integrity constraints.

A. True
B. False
C. May be True or False
D. Can't say
Answer» B. False
Discussion
16.

The creation of a stored program is similar to the definition of a _______________

A. Trigger
B. Event
C. View
D. Table
Answer» D. Table
Discussion
17.

When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________

A. good
B. bad
C. illegal
D. fare
Answer» B. bad
Discussion
18.

How many of the following can be used in stored procedures?

A. 0
B. 1
C. 2
D. 3
Answer» E.
Discussion
19.

How many of the following can be used in stored functions?

A. 0
B. 1
C. 2
D. 3
Answer» B. 1
Discussion
20.

The default definer of an event is the user who _______________

A. created the database
B. created the event
C. created the table
D. created the column
Answer» C. created the table
Discussion
21.

Stored routines refers to stored functions and procedures.

A. True
B. False
C. May be True or False
D. Can't say
Answer» B. False
Discussion
22.

Stored programs refer to stored objects of how many of the following types?

A. 0
B. 1
C. 3
D. 4
Answer» E.
Discussion
23.

Which of the following statements does not modify the table?

A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer» E.
Discussion
Previous Next