Mysql Archives - mcqoptions.com

Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search

Ask A Question

Shanti Balay

Asked: 3 years agoIn: Mysql

What is the meaning of “SELECT” clause in Mysql?

(a) Show me all Columns and rows

(b) Show me all columns

(c) Show me all rows

(d) None of the mentioned

Varun Narula

Asked: 3 years agoIn: Mysql

A DEFAULT value cannot be supplied to spatial types.

(a) True

(b) False

This question was posed to me in an interview.

Origin of the question is MySQL Data Types in section Data Types of MySQL

Aarushi Bharat Khosla

Asked: 3 years agoIn: Mysql

The SQL mode to check for divide by zero error is ________________

(a) STRICT_ALL_TABLES

(b) ERROR_FOR_DIVISION_BY_ZERO

(c) ERROR_DIVIDE_BY_ZERO

(d) ERROR_WHEN_DIVIDE_BY_ZERO

Javed Rao Balasubramanian

Asked: 3 years agoIn: Mysql

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

(a) 0

(b) 1

(c) 2

(d) 3

Pinky Nigam

Asked: 3 years agoIn: Mysql

Which mode does not remove trailing spaces when CHAR values are retrieved?

(a) PAD_CHAR_TO_FULL_LENGTH

(b) TO_FULL_LENGTH_CHAR_PAD

(c) CHAR_PAD_TO_FULL_LENGTH

(d) PAD_CHAR_TO_LENGTH

Babita Bali

Asked: 3 years agoIn: Mysql

For which of these storage engines are configuration options always built?

(a) Falcon

(b) FEDERATED

(c) InnoDB

(d) MyISAM

Namita Aatif Sangha

Asked: 3 years agoIn: Mysql

When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________

(a) good

(b) bad

(c) illegal

(d) fare

Sid Behl

Asked: 3 years agoIn: Mysql

The facility that allows nesting one select statement into another is called __________

(a) nesting

(b) binding

(c) subquerying

(d) encapsulating

Mustafa Johal

Asked: 3 years agoIn: Mysql

Hexadecimal numbers can be used in scientific notation.

(a) True

(b) False

I have been asked this question in my homework.

Question is from Perl DBI Overview in portion MySQL Programs Using Perl DBI and PHP of MySQL

Sapna Sule

Asked: 3 years agoIn: Mysql

The LOCAL capability for LOAD DATA does not need to be enabled explicitly.

(a) True

(b) False

This question was posed to me in examination.

The origin of the question is Enabling or Disabling LOCAL Capability for LOAD DATA topic in section General MySQL Administration of MySQL

Load More Questions