Olete.in – MCQs, Mock Tests & Government Job Prep

The expression 12 DIV 5 evaluates to ____________

1. 2.4
2. 2
3. error
4. 0

✅ Correct Answer: 2

If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in ____________

1. 1
2. 0
3. error
4. -1

✅ Correct Answer: 2

'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in ____________

1. 0
2. 1
3. abcxyz
4. xyzabc

✅ Correct Answer: 3

The expression 2 BETWEEN 2 AND 5 results in ____________

1. TRUE
2. FALSE
3. -1
4. 2

✅ Correct Answer: 1

The expression HI LIKE NULL results in _____________

1. TRUE
2. FALSE
3. NULL
4. 0

✅ Correct Answer: 3

Which of the following is the correct order of precedence (high to low)?

1. !, ^, <<, XOR
2. ^, !, <<, XOR
3. !, <<, XOR, ^
4. !, ^, XOR, <<

✅ Correct Answer: 1

0x61 + 0 results in _____________

1. 0
2. 'a'
3. 97
4. arbitrary

✅ Correct Answer: 3

The AUTO_INCREMENT column attribute is best used with which type?

1. FLOAT
2. INT
3. CHARACTER
4. DOUBLE

✅ Correct Answer: 2

Which datatype is best suited to store currency values?

1. INT
2. FLOAT
3. DOUBLE
4. DECIMAL

✅ Correct Answer: 4

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

✅ Correct Answer: 4

Which of these types store the longest length of strings?

1. CHAR
2. VARCHAR
3. TINYTEXT
4. TEXT

✅ Correct Answer: 4

Which of these values is not valid as an AUTO_INCREMENT value?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 1

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

✅ Correct Answer: 2

INT2 maps to MySQL type _____________

1. TINYINT
2. SMALLINT
3. MEDIUMINT
4. BIGINT

✅ Correct Answer: 2

INT3 maps to MySQL type _____________

1. TINYINT
2. SMALLINT
3. MEDIUMINT
4. BIGINT

✅ Correct Answer: 3

Which of these return a result to the client?

1. Stored functions
2. Stored procedures
3. Triggers
4. Events

✅ Correct Answer: 1

Which of these is defined to execute when the table is modified only?

1. Stored functions
2. Stored procedures
3. Triggers
4. Events

✅ Correct Answer: 3

What executes on a time activated basis according to a schedule?

1. Stored program
2. Events
3. Triggers
4. Stored procedures

✅ Correct Answer: 2

Which character does the mysql client program recognize as a statement delimiter?

1. Stored functions
2. Stored procedures
3. Triggers
4. Events

✅ Correct Answer: 3

Which command is used to redefined the mysql delimiter?

1. redefine_delim
2. delim_redefine
3. delimiter
4. redefine

✅ Correct Answer: 3

Which of the following statements does not modify the table?

1. INSERT
2. UPDATE
3. DELETE
4. SELECT

✅ Correct Answer: 4

To produce a stored function, which statement is used?

1. PRODUCE FUNCTION
2. CREATE FUNCTION
3. PRODUCE PROCEDURE
4. CREATE PROCEDURE

✅ Correct Answer: 2

How many values can be returned from a given stored function?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 2

How many values can be returned from a stored procedure?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 1

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()

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

Which procedure parameter enables the caller to pass in a value and get back a value?

1. IN
2. OUT
3. INOUT
4. GETINOUT

✅ Correct Answer: 3

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

✅ Correct Answer: 1

What is abc in the following MySQL statement?

1. action
2. condition value
3. statement
4. null

✅ Correct Answer: 1

Which statement is used to create a trigger?

1. CREATE TRIGGER
2. CREATE TRIGGERS
3. PRODUCE TRIGGER
4. PRODUCE TRIGGERS

✅ Correct Answer: 1

For which of the following are triggers not supported?

1. delete
2. update
3. insert
4. views

✅ Correct Answer: 4

Which statement is used to remove a trigger?

1. REMOVE
2. DELETE
3. DROP
4. CLEAR

✅ Correct Answer: 3

Before MySQL 5.1.6 which privilege was required to create and drop triggers?

1. PRIVILEGE
2. TRIGGER
3. SUPER
4. MACRO

✅ Correct Answer: 3

What is abc in the following MySQL statement?

1. trigger name
2. table name
3. trigger statement
4. update statement

✅ Correct Answer: 1

Which of these is a stored program associated with a schedule?

1. Trigger
2. Event
3. Stored function
4. Stored procedure

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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'

✅ Correct Answer: 4

Which value of event_scheduler enables checking status but not changing it at runtime?

1. ON
2. OFF
3. DISABLED
4. ENABLED

✅ Correct Answer: 3

Which log does the event scheduler log to?

1. error
2. record
3. library
4. update

✅ Correct Answer: 1

Which clause specifies periodic execution at fixed intervals?

1. EVERY
2. ALL
3. AT
4. ALTERNATE

✅ Correct Answer: 1

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

1. CREATE
2. DROP
3. PRIVILEGE
4. EVENT

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

1. Trigger
2. Event
3. View
4. Table

✅ Correct Answer: 3

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

A stored procedure is invoked using the statement __________

1. INVOKE
2. SEE
3. CALL
4. RETURN

✅ Correct Answer: 3

What produces result sets?

1. View
2. SELECT
3. Stored function
4. Trigger

✅ Correct Answer: 1

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

1. SUPER
2. PRIOR
3. TOP
4. SUPERIOR

✅ Correct Answer: 1

🧪 SQL MCQ Quiz Hub

SQL MCQ SET 1