Explore topic-wise InterviewSolutions in .

Right answer is (a) True

The best explanation: In MySQL, the stored routines cannot contain ARBITRARY SQL STATEMENTS. For example, the locking statements LOCK TABLES and UNLOCK TABLES are not PERMITTED in the stored routines.

The CORRECT answer is (a) SUPER

Explanation: In order to CREATE or alter a STORED function, the SUPER privilege should be given in addition to the CREATE ROUTINE privilege that is normally REQUIRED. Depending on the DEFINER value in the function definition SUPER might be required.

Correct option is (a) View

Easiest explanation: In MySQL, views are the STORED queries that when REFERENCED produce a result set. A view acts as a VIRTUAL table. A stored procedure is also a COMPONENT that can return result SETS.

The correct answer is (b) bad

Best EXPLANATION: The security context is bad if a user creates a STORED program that accesses SENSITIVE data but forgets that other PEOPLE who can invoke the object have the same access to that data as its definer.

Correct choice is (c) VIEW

To explain: When a stored program is CREATED, an OBJECT is created that is to be executed LATER. This also the case when a view is defined: It sets up a SELECT statement intended for later invocation.

The correct answer is (B) created the event

To EXPLAIN: Unless the event has been altered, the default definer of an event is the USER who created the event. In this CASE, the definer is the one who called the last ‘ALTER EVENT’ statement.

Right choice is (d) EVENT

The BEST explanation: In MySQL, all EVENTS belong to some DATABASE, so the EVENT privilege must be granted for that database in order to both create or DROP the events for it. An event is a stored PROGRAM.

Correct choice is (a) EVERY

The BEST I can EXPLAIN: The ‘EVERY n interval’ clause specifies the periodic execution at fixed INTERVALS. The interval values are like those used for the DATE_ADD() FUNCTION, such as HOUR, DAY or MONTH.

Right choice is (a) error

Explanation: In MySQL, the event scheduler WRITES to the error log of the server, which can be checked for information about what the scheduler is doing. It logs the EVENTS as it RUNS them.

The correct choice is (a) True

To explain: In MYSQL, if the event scheduler is stopped, no events are RUN. It is also possible to leave the scheduler running but disable the INDIVIDUAL events. This can be done with ‘DISABLED’.

Correct answer is (c) DISABLED

The EXPLANATION: In MySQL, if the event_scheduler is SET to ‘DISABLED’ at startup, its STATUS cannot be changed but can be checked at RUNTIME. The EVENTS can be created but they will not execute.

Correct option is (a) event_scheduler = ON

Explanation: The line ‘event_scheduler = ON’ is put in the option file that the server READS. The event scheduler does not run by DEFAULT. It must be turned on if events are to used in the DATABASE.

Right choice is (a) True

To elaborate: The EVENT scheduler does not run by default, so it MUST be turned on if events are to be used. An event is a STORED program that is ASSOCIATED with a SCHEDULE to perform database operations.

Correct choice is (b) EVENT

Easy explanation: The MySQL version 5.1.6 and above has an event scheduler. It enables us to PERFORM time activated database operations. An event is a stored program that is ASSOCIATED with a SCHEDULE.

The correct choice is (a) True

The explanation is: In MYSQL, because a trigger is associated with a table, the TRIGGER PRIVILEGE is a must for that table to be ABLE to CREATE and DROP triggers for it. The SUPER privilege was used pre 5.1.6.

Correct choice is (c) DROP

Explanation: In order to delete a TRIGGER, the DROP TRIGGER statement is used. The DROP TRIGGER CONSTRUCT is used by writing the phrase ‘DROP TRIGGER’ followed by the scheme NAME specification.

Right option is (d) VIEWS

Explanation: In MySQL, the triggers are run only after the table modifications like INSERT, UPDATE and delete are run. Triggers are not supported for views. In order to create a TRIGGER, the CREATE TRIGGER STATEMENT is used.

The correct option is (a) CREATE TRIGGER

Easy explanation: In order to create a trigger, the CREATE TRIGGER statement is used. The DEFINITION INDICATES the particular type of statement for which the trigger ACTIVATES and whether it activates before or after the rows are modified.

Right OPTION is (a) True

The explanation: In MySQL, a trigger can examine or CHANGE new DATA values to be inserted or used to update a ROW in a table. This enables the enforcement of the data integrity CONSTRAINTS.

Right choice is (C) INOUT

To EXPLAIN I would say: In an IN parameter, the CALLER passes a value into the procedure. An OUT parameter is exactly the opposite. The ‘INOUT’ parameter enables the caller to PASS in a value and also to get back a value.

The CORRECT ANSWER is (a) automatic_sp_privileges

Explanation: The automatic_sp_privileges system variable is set to zero when the automatic privilege GRANTING is not NEEDED and REVOCATION should not be allowed to occur. It is a crucial system variable.

Right OPTION is (b) sampdb.PI()

The BEST I can explain: When a stored FUNCTION is DEFINED with the same name as a built in function, the function name should be qualified with the database name when it is invoked. The function ‘PI()’ is built in.

The CORRECT answer is (b) 1

The best explanation: In MySQL, the stored function cannot return multiple values. Instead, multiple stored FUNCTIONS can be written and INVOKED from within a single statement HOWEVER, they are different from stored PROCEDURES.

Right choice is (a) True

Explanation: In MySQL, the stored routines is a limited term. It REFERS only to the stored FUNCTIONS and PROCEDURES. Both TYPES of objects are DEFINED using the similar syntax and are discussed together.

Right answer is (C) DELIMITER

To EXPLAIN: To redefine the mysql delimiter, the delimiter COMMAND is used. A delimiter is a sequence of characters. It specifies the boundary between the separate regions in DATA streams.

Right option is (c) ;

For explanation I WOULD SAY: By default, MYSQL itself recognizes the semicolon as a statement delimiter, so the delimiter must be redefined temporarily to CAUSE mysql to pass the ENTIRE stored program definition to the server.

Correct CHOICE is (a) True

Easy explanation: Stored programs improve database security because CONTROLLED access can be ENABLED to sensitive data by appropriate selection of the PRIVILEGES a program has when it executes.

The correct option is (b) Events

The best I can explain: In MYSQL, the events EXECUTE on a time ACTIVATED basis according to a schedule. Triggers are DEFINED to execute when the table is modified via INSERT, DELETE or UPDATE statements.

Correct option is (a) Stored FUNCTIONS

Easy EXPLANATION: Stored functions return a result from a calculation and can be USED in expressions. Stored procedures do not return a result DIRECTLY but can be used to perform GENERAL computations.