Social 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

Dipti Thaker

Asked: 3 years agoIn: Mysql

Functions are called and pointers to structures are used while using DBI API.

(a) True

(b) False

I had been asked this question in an internship interview.

Question is taken from Making Database Backups in division Database Maintenance, Backups and Replication of MySQL

Bijoy Virk

Asked: 3 years agoIn: Mysql

If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________

(a) MEDIUMINT SIGNED

(b) MEDIUMINT UNSIGNED

(c) SMALLINT SIGNED

(d) SMALLINT UNSIGNED

Deep Ratan Usman

Asked: 3 years agoIn: Mysql

What is the best datatype for a column that is expected to store values up to 2 million?

(a) SMALLINT

(b) TINYINT

(c) MEDIUMINT

(d) BIGINT

Kanika Matthai

Asked: 3 years agoIn: Mysql

In MySQL databases, the structure representing the organizational views of the entire databases is ____________

(a) Schema

(b) View

(c) Instance

(d) Table

Siddharth Singh Mangat

Asked: 3 years agoIn: Mysql

The LOCAL capability for client library is enabled by ______________

(a) –enabled-local-file

(b) –enable-local-infile

(c) –enable-global-file

(d) –enable-local-file

Nupur Lala

Asked: 3 years agoIn: Mysql

Which clause is used to “filter out unwanted Groups”?

(a) HAVING

(b) FROM

(c) WHERE

(d) SELECT

Wafiq Lal Sachdev

Asked: 3 years agoIn: Mysql

Suppose run_me.sh is a script file. Which command is used to make it executable?

(a) chmod +e run_me.sh

(b) chmod +a run_me.sh

(c) chmod +y run_me.sh

(d) chmod +x run_me.sh

Preet Rao Nagarajan

Asked: 3 years agoIn: Mysql

A multiple-table delete cannot apply any join.

(a) True

(b) False

This question was addressed to me during an interview.

This key question is from Enabling or Disabling LOCAL Capability for LOAD DATA in section General MySQL Administration of MySQL

Alpa Koushtubh Samuel

Asked: 3 years agoIn: Mysql

Any client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients.

(a) True

(b) False

The question was asked in a national level competition.

My enquiry is from Server SQL Mode in portion Using SQL to Manage Data of MySQL

Abhinav Kaul

Asked: 3 years agoIn: Mysql

Which keyword is used to create a table as a temporary copy of itself?

(a) TEMP

(b) TEMPO

(c) TEMPR

(d) TEMPORARY

Load More Questions