Jobs By Abekus

Which statement is used to remove a trigger?

1

REMOVE

2

DROP

3

DELETE

4

CLEAR

Solution:

Which header should be included first?

1

my_global.h

2

my_sys.h

3

mysql.h

4

my_local.h

Solution:

Which clause is used to rename the existing table?

1

ALTER

2

MODIFY

3

RENAME

4

NONE OF THE ABOVE

Solution:

What enables encrypted connections to be established?

1

exec_stmt_ssl

2

exec_ssl_stmt

3

exec_stmnt_ssl

4

exec_ssl_stmnt

Solution:

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

1

Triggers

2

Events

3

Stored Procedures

4

Stored Functions

Solution:

What is the built-in MySQL function that gives you the current time in an SQL statement?

1

DATE(false)

2

CURR_DATE()

3

TODAY()

4

NOW()

Solution:

What is the command to disable autocommit and launch a transaction?

1

INITIATE TRANSACTION

2

DISABLE AUTOCOMMIT

3

TRANSACTION

4

START TRANSACTION

Solution:

What does ‘name’ represent in the following code snippet?

CREATE TABLE student

  (

      name CHAR(30),

     roll_num INT,

   address CHAR(30),

     phone CHAR(12)

  );

1

A table

2

A row

3

A column

4

An object

Solution:

If the 'fruit' attribute in the 'person' table stores data as 'apple, mango, banana', what will be the output of the following SQL command?

`SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;`

1

apple, mango, banana

2

apple, banana, mango

3

mango, apple, banana

4

none of the mentioned

Solution:

What is the significance of “ORDER BY emp_id DESC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

1

Data of emp_id will be sorted in descending order

2

Data of emp_id will be sorted in ascending order

3

Data of emp_id will be sorted in either ascending or descending order

4

All of the mentioned

Mysql Questions Set 11:

Which statement is used to remove a trigger?

Solution:

Which header should be included first?

Solution:

Which clause is used to rename the existing table?

Solution:

What enables encrypted connections to be established?

Solution:

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

Solution:

What is the built-in MySQL function that gives you the current time in an SQL statement?

Solution:

What is the command to disable autocommit and launch a transaction?

Solution:

What does ‘name’ represent in the following code snippet?

CREATE TABLE student

  (

      name CHAR(30),

     roll_num INT,

   address CHAR(30),

     phone CHAR(12)

  );

Solution:

If the 'fruit' attribute in the 'person' table stores data as 'apple, mango, banana', what will be the output of the following SQL command?

`SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;`

Solution:

What is the significance of “ORDER BY emp_id DESC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 11:

Which statement is used to remove a trigger?

Solution:

Which header should be included first?

Solution:

Which clause is used to rename the existing table?

Solution:

What enables encrypted connections to be established?

Solution:

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

Solution:

What is the built-in MySQL function that gives you the current time in an SQL statement?

Solution:

What is the command to disable autocommit and launch a transaction?

Solution:

What does ‘name’ represent in the following code snippet? CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

Solution:

If the 'fruit' attribute in the 'person' table stores data as 'apple, mango, banana', what will be the output of the following SQL command? SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;

Solution:

What is the significance of “ORDER BY emp_id DESC” in the given query? SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

Solution:

Related Question Sets:

Related Topics:

What does ‘name’ represent in the following code snippet?

CREATE TABLE student

(

name CHAR(30),

roll_num INT,

address CHAR(30),

phone CHAR(12)

);

If the 'fruit' attribute in the 'person' table stores data as 'apple, mango, banana', what will be the output of the following SQL command?

`SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;`

What is the significance of “ORDER BY emp_id DESC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;