Explore topic-wise InterviewSolutions in .

The correct option 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.

Right option is (d) BIGINT

For explanation I would say: The different NUMERIC types used in MySQL are used to store a different RANGE of values. To store values of the order of a million, the MEDIUMINT or BIGINT DATATYPE is SUFFICIENT.

Correct choice is (a) True

For EXPLANATION: In MYSQL, there is no data type provided which has an optional time part. The ‘DATE’ type values never have a time part. The ‘DATETIME’ type values MUST have a time part in them.

Correct answer is (a) have_ssl

Easy explanation: After the SSL-capable SERVER is started, to VERIFY that it SUPPORTS SSL, connection is established with ‘mysql’ and the following query is issued: SHOW VARIABLES LIKE ‘have_ssl’.

The CORRECT option is (a) HOST

To EXPLAIN: ‘Db’ and ‘Table_name’ values are always treated as case sensitive even though treatment of database and table NAMES in SQL statements depends on the filesystem case sensitivity of the host.

Right choice is (b) transport LAYER security

Best explanation: MYSQL supports encrypted connections between CLIENTS and the SERVER USING the TLS protocol. It is also referred to as SSL but MySQL does not actually use the SSL protocol for encrypted connections.

Correct option is (d) 3

The best I can EXPLAIN: With a MySQL installation that includes SSL support the SERVER and its clients can communicate securely. Each end of a connection USES three FILES to set up secure communications.

Correct option is (c) DISABLED

For explanation I would SAY: 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.

Right choice is (d) SHOW VARIABLES LIKE ‘event_scheduler’

The explanation is: In MySQL, in order to CHECK the status of the event scheduler at runtime, the statement: SHOW VARIABLES LIKE ‘event_scheduler’; is used. The event_scheduler is a SYSTEM VARIABLE.

Correct choice is (a) event_scheduler = ON

Easiest 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.

The correct OPTION is (a) True

The explanation is: MySQL PROVIDES PATTERN matching based on the ‘REGEXP’ operator and regular expressions that are similar to those used in Unix programs, namely, GREP, sed and vi. REGEXP does not TAKE collation into account.

The correct answer is (c) ABCXYZ

Explanation: If the SQL mode PIPES_AS_CONCAT has been enabled, the SQL standard ‘||’ operation for string concatenation BECOMES VALID in MYSQL. Both operands are concatenated to give ‘abcxyz’.

The correct choice is (a) RESET MASTER LOGS

Explanation: ‘RESET MASTER LOGS’ causes a replication master server to DELETE all binary log files even if they are in use which REMOVES the information NECESSARY to maintain the replication INTEGRITY.

The CORRECT choice is (a) Host

Best EXPLANATION: ‘Db’ and ‘Table_name’ values are always treated as case sensitive even THOUGH the treatment of DATABASE and table NAMES in SQL statements depends on the filesystem case sensitivity of the host.

The correct CHOICE is (B) db

For explanation I would SAY: The ‘db’ table lists which accounts have PRIVILEGES for which databases. If a privilege is granted here, it APPLIES to all objects in a database (tables, stored routines and so on).

Correct OPTION is (c) CALL

Easy explanation: In MYSQL, a stored PROCEDURE is INVOKED using the CALL statement. A stored procedure does not have a return value but can modify its parameters. It also returns some result sets.

Right choice is (b) False

Explanation: The triggers and EVENTS are invoked AUTOMATICALLY by the server, so the concept of invoking user is not APPLIED. Thus, they have no SQL SECURITY CHARACTERISTIC and always execute with definer privileges.

The correct OPTION is (d) views

For 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.

Right answer is (b) 0

Explanation: The ‘LAST_INSERT_ID()’ FUNCTION returns zero when no ‘AUTO_INCREMENT’ value has been generated during the CURRENT CONNECTION with the server. It is tied to the current connection.

Correct choice is (a) LAST_INSERT_ID()

For explanation I would say: The value of most recently GENERATED sequence number can be OBTAINED by calling the LAST_INSERT_ID() function. This ENABLES to reference the AUTO_INCREMENT value in the SUBSEQUENT statement.

The correct answer is (C) myisamchk

For explanation: The program ‘myisamchk’ is a UTILITY for the table maintenance. ‘innochecksum’ is USED for offline InnoDB file checksum utility. To DISPLAY full TEXT index information ‘myisam_ftdump’ is used.

Correct option is (a) True

Easiest explanation: The server uses a Unix domain socket FILE for connections by clients to LOCALHOST. The socket file NORMALLY is publicly ACCESSIBLE so that client programs can use it again properly.

The correct answer is (a) drwxrwxr-x

Explanation: Some database directories have the proper permissions LIKE ‘drwx——‘ ENABLES READ, write, and EXECUTE access to the owner, but no access to anyone else. Other directories have an overly permissive access MODE like ‘drwxrwxr-x’.

The CORRECT ANSWER is (c) ls -la

Explanation: It can be determined whether the data directory contains INSECURE files or directories by executing ‘ls -la’. Then the lookup for files or directories that have the “group” or “other” permissions TURNED on.