M

Manisha Agrawal • 9.32K Points
Tutor III 

Q. Which option is supplied to ensure TCP/IP connection to local server?

  • (A) –connectlocal
  • (B) –hostlocal
  • (C) –localhost
  • (D) –host

Correct answer: Option(D)

MySQL Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. What is the significance of the statement "GROUP BY d.name" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject, subject_value. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} Subject_value = {0, 0, 1, 1, 2, 2, 3, 3} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject IN (SELECT subject FROM db_name WHERE subject_value IN (3, 2));

Q. What will be the output of the following MySQL command? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;

Q. Which statement can be used for modifying the definition for an existing table?

Q. Select the sequence for how the query mechanism works?

Q. Which keyword suppresses errors?

Q. MySQL Access security is controlled through

Q. What will be the output of the following query:Select round(59999.99,-2);

Q. Find the error in the following SQL statement? CREATE TABLE person ( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST, Birth_date) (1,’s’,’p’, 24-1991-01);

Q. Packages HTF and HTP allow your PL/SQL programs to generate HTML tags.

Learn All MySQL MCQs