0x61 + 0 results in _____________
1.0
2.'a'
3.97
4.arbitrary
'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in ____________
1.0
2.1
3.abcxyz
4.xyzabc
A stored procedure is invoked using the statement __________
1.INVOKE
2.SEE
3.CALL
4.RETURN
Before MySQL 5.1.6 which privilege was required to create and drop triggers?
1.PRIVILEGE
2.TRIGGER
3.SUPER
4.MACRO
For the same input parameters, if the stored function returns the same result, it is called _____________
1.deterministic
2.non deterministic
3.regular
4.monotonous
For which of the following are triggers not supported?
1.delete
2.update
3.insert
4.views
How many values can be returned from a given stored function?
1.0
2.1
3.2
4.3
How many values can be returned from a stored procedure?
1.0
2.1
3.2
4.3
If a column is expected to store values up to 2 million, the best datatype for it is _____________
1.SMALLINT
2.TINYINT
3.MEDIUMINT
4.BIGINT
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________
1.MEDIUMINT SIGNED
2.MEDIUMINT UNSIGNED
3.SMALLINT SIGNED
4.SMALLINT UNSIGNED
If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in ____________
1.1
2.0
3.error
4.-1
INT2 maps to MySQL type _____________
1.TINYINT
2.SMALLINT
3.MEDIUMINT
4.BIGINT
INT3 maps to MySQL type _____________
1.TINYINT
2.SMALLINT
3.MEDIUMINT
4.BIGINT
Suppose a stored function named PI() is written in the database sampdb. How would it be called?
1.PI()
2.sampdb.PI()
3.MySQL.PI()
4.db.PI()
The AUTO_INCREMENT column attribute is best used with which type?
1.FLOAT
2.INT
3.CHARACTER
4.DOUBLE
The creation of a stored program is similar to the definition of a _______________
1.Trigger
2.Event
3.View
4.Table
The default definer of an event is the user who _______________
1.created the database
2.created the event
3.created the table
4.created the column
The expression 12 DIV 5 evaluates to ____________
1.2.4
2.2
3.error
4.0
The expression 2 BETWEEN 2 AND 5 results in ____________
1.TRUE
2.FALSE
3.-1
4.2
The expression HI LIKE NULL results in _____________
1.TRUE
2.FALSE
3.NULL
4.0
To create or drop events for a database, which privilege should be granted?
1.CREATE
2.DROP
3.PRIVILEGE
4.EVENT
To produce a stored function, which statement is used?
1.PRODUCE FUNCTION
2.CREATE FUNCTION
3.PRODUCE PROCEDURE
4.CREATE PROCEDURE
What executes on a time activated basis according to a schedule?
1.Stored program
2.Events
3.Triggers
4.Stored procedures
What is abc in the following MySQL statement?
1.action
2.condition value
3.statement
4.null
What is abc in the following MySQL statement?
1.trigger name
2.table name
3.trigger statement
4.update statement
What produces result sets?
1.View
2.SELECT
3.Stored function
4.Trigger
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 __________
1.good
2.bad
3.illegal
4.fare
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________
1.good
2.bad
3.illegal
4.fare
Which character does the mysql client program recognize as a statement delimiter?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Which clause specifies periodic execution at fixed intervals?
1.EVERY
2.ALL
3.AT
4.ALTERNATE
Which command is used to redefined the mysql delimiter?
1.redefine_delim
2.delim_redefine
3.delimiter
4.redefine
Which datatype is best suited to store currency values?
1.INT
2.FLOAT
3.DOUBLE
4.DECIMAL
Which log does the event scheduler log to?
1.error
2.record
3.library
4.update
Which of the following is the correct order of precedence (high to low)?
1.!, ^, <<, XOR
2.^, !, <<, XOR
3.!, <<, XOR, ^
4.!, ^, XOR, <<
Which of the following lines is used to turn on the event scheduler?
1.event_scheduler = ON
2.eventscheduler = ON
3.event_scheduler_ON
4.events_scheduler_ON
Which of the following statements does not modify the table?
1.INSERT
2.UPDATE
3.DELETE
4.SELECT
Which of these is a stored program associated with a schedule?
1.Trigger
2.Event
3.Stored function
4.Stored procedure
Which of these is defined to execute when the table is modified only?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Which of these return a result to the client?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Which of these types store the longest length of strings?
1.CHAR
2.VARCHAR
3.TINYTEXT
4.TEXT
Which of these values is not valid as an AUTO_INCREMENT value?
1.0
2.1
3.2
4.3
Which privilege is enabled to create of alter a stored function?
1.SUPER
2.PRIOR
3.TOP
4.SUPERIOR
Which privilege must be given to the database to create a stored function or procedure?
1.CREATE ROUTINE
2.CREATE METHOD
3.CREATE FUNCTION
4.CREATE PROCEDURE
Which procedure parameter enables the caller to pass in a value and get back a value?
1.IN
2.OUT
3.INOUT
4.GETINOUT
Which statement is used to check the status of the event scheduler at runtime?
1.SHOW STATUS OF 'event_scheduler'
2.SHOW VARIABLES OF 'event_scheduler'
3.SHOW STATUS LIKE 'event_scheduler'
4.SHOW VARIABLES LIKE 'event_scheduler'
Which statement is used to create a trigger?
1.CREATE TRIGGER
2.CREATE TRIGGERS
3.PRODUCE TRIGGER
4.PRODUCE TRIGGERS
Which statement is used to remove a trigger?
1.REMOVE
2.DELETE
3.DROP
4.CLEAR
Which value of event_scheduler enables checking status but not changing it at runtime?
1.ON
2.OFF
3.DISABLED
4.ENABLED
Which variable is set to zero when automatic privilege granting is not needed?
1.automatic_sp_privileges
2.automatic_ps_privileges
3.automatic_pg_privileges
4.automatic_gp_privileges