0x61 + 0 results in _____________
1.0
2.'a'
3.97
4.arbitrary
Posted Date:-2021-07-18 11:41:57
'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in ____________
1.0
2.1
3.abcxyz
4.xyzabc
Posted Date:-2021-07-18 11:41:57
A stored procedure is invoked using the statement __________
1.INVOKE
2.SEE
3.CALL
4.RETURN
Posted Date:-2021-07-18 11:41:57
Before MySQL 5.1.6 which privilege was required to create and drop triggers?
1.PRIVILEGE
2.TRIGGER
3.SUPER
4.MACRO
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
For which of the following are triggers not supported?
1.delete
2.update
3.insert
4.views
Posted Date:-2021-07-18 11:41:57
How many values can be returned from a given stored function?
1.0
2.1
3.2
4.3
Posted Date:-2021-07-18 11:41:57
How many values can be returned from a stored procedure?
1.0
2.1
3.2
4.3
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in ____________
1.1
2.0
3.error
4.-1
Posted Date:-2021-07-18 11:41:57
INT2 maps to MySQL type _____________
1.TINYINT
2.SMALLINT
3.MEDIUMINT
4.BIGINT
Posted Date:-2021-07-18 11:41:57
INT3 maps to MySQL type _____________
1.TINYINT
2.SMALLINT
3.MEDIUMINT
4.BIGINT
Posted Date:-2021-07-18 11:41:57
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()
Posted Date:-2021-07-18 11:41:57
The AUTO_INCREMENT column attribute is best used with which type?
1.FLOAT
2.INT
3.CHARACTER
4.DOUBLE
Posted Date:-2021-07-18 11:41:57
The creation of a stored program is similar to the definition of a _______________
1.Trigger
2.Event
3.View
4.Table
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
The expression 12 DIV 5 evaluates to ____________
1.2.4
2.2
3.error
4.0
Posted Date:-2021-07-18 11:41:57
The expression 2 BETWEEN 2 AND 5 results in ____________
1.TRUE
2.FALSE
3.-1
4.2
Posted Date:-2021-07-18 11:41:57
The expression HI LIKE NULL results in _____________
1.TRUE
2.FALSE
3.NULL
4.0
Posted Date:-2021-07-18 11:41:57
To create or drop events for a database, which privilege should be granted?
1.CREATE
2.DROP
3.PRIVILEGE
4.EVENT
Posted Date:-2021-07-18 11:41:57
To produce a stored function, which statement is used?
1.PRODUCE FUNCTION
2.CREATE FUNCTION
3.PRODUCE PROCEDURE
4.CREATE PROCEDURE
Posted Date:-2021-07-18 11:41:57
What executes on a time activated basis according to a schedule?
1.Stored program
2.Events
3.Triggers
4.Stored procedures
Posted Date:-2021-07-18 11:41:57
What is abc in the following MySQL statement?
1.action
2.condition value
3.statement
4.null
Posted Date:-2021-07-18 11:41:57
What is abc in the following MySQL statement?
1.trigger name
2.table name
3.trigger statement
4.update statement
Posted Date:-2021-07-18 11:41:57
What produces result sets?
1.View
2.SELECT
3.Stored function
4.Trigger
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
Which character does the mysql client program recognize as a statement delimiter?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Posted Date:-2021-07-18 11:41:57
Which clause specifies periodic execution at fixed intervals?
1.EVERY
2.ALL
3.AT
4.ALTERNATE
Posted Date:-2021-07-18 11:41:57
Which command is used to redefined the mysql delimiter?
1.redefine_delim
2.delim_redefine
3.delimiter
4.redefine
Posted Date:-2021-07-18 11:41:57
Which datatype is best suited to store currency values?
1.INT
2.FLOAT
3.DOUBLE
4.DECIMAL
Posted Date:-2021-07-18 11:41:57
Which log does the event scheduler log to?
1.error
2.record
3.library
4.update
Posted Date:-2021-07-18 11:41:57
Which of the following is the correct order of precedence (high to low)?
1.!, ^, <<, XOR
2.^, !, <<, XOR
3.!, <<, XOR, ^
4.!, ^, XOR, <<
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
Which of the following statements does not modify the table?
1.INSERT
2.UPDATE
3.DELETE
4.SELECT
Posted Date:-2021-07-18 11:41:57
Which of these is a stored program associated with a schedule?
1.Trigger
2.Event
3.Stored function
4.Stored procedure
Posted Date:-2021-07-18 11:41:57
Which of these is defined to execute when the table is modified only?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Posted Date:-2021-07-18 11:41:57
Which of these return a result to the client?
1.Stored functions
2.Stored procedures
3.Triggers
4.Events
Posted Date:-2021-07-18 11:41:57
Which of these types store the longest length of strings?
1.CHAR
2.VARCHAR
3.TINYTEXT
4.TEXT
Posted Date:-2021-07-18 11:41:57
Which of these values is not valid as an AUTO_INCREMENT value?
1.0
2.1
3.2
4.3
Posted Date:-2021-07-18 11:41:57
Which privilege is enabled to create of alter a stored function?
1.SUPER
2.PRIOR
3.TOP
4.SUPERIOR
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57
Which procedure parameter enables the caller to pass in a value and get back a value?
1.IN
2.OUT
3.INOUT
4.GETINOUT
Posted Date:-2021-07-18 11:41:57
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'
Posted Date:-2021-07-18 11:41:57
Which statement is used to create a trigger?
1.CREATE TRIGGER
2.CREATE TRIGGERS
3.PRODUCE TRIGGER
4.PRODUCE TRIGGERS
Posted Date:-2021-07-18 11:41:57
Which statement is used to remove a trigger?
1.REMOVE
2.DELETE
3.DROP
4.CLEAR
Posted Date:-2021-07-18 11:41:57
Which value of event_scheduler enables checking status but not changing it at runtime?
1.ON
2.OFF
3.DISABLED
4.ENABLED
Posted Date:-2021-07-18 11:41:57
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
Posted Date:-2021-07-18 11:41:57