Jobs By Abekus

INFORMATION_SCHEMA is based on the SQL standard.

1

TRUE

2

FALSE

Solution:

The statement used to select the default database is ____

1

CREATE

2

USE

3

DROP

4

SCHEMA

Solution:

Which Clause is used to sort the stored data in alphabetical order?

1

UPDATE

2

MODIFY

3

ORDER by CLAUSE

Solution:

Which statement is used to remove indexes on tables?

1

DROP INDEX

2

DELETE INDEX

3

REMOVE INDEX

4

FLUSH INDEX

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

1

SPECIFY

2

SET

3

ASSIGN

4

CHANGE

Solution:

Is there any error in executing the following query?

SELECT USER (), VERSION (), DATABASE ();

1

Yes, “FROM” is not used

2

No

3

Depends

4

None of the mentioned

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

1

True

2

False

Solution:

Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

1

ENGINES, PLUGINS

2

FILES, PLUGINS

3

ENGINES, FILES

4

PLUGINS, STATISTICS

Solution:

Which SQL statement is used to delete all the rows of a table named 'xyz' without deleting the table?

1

DELETE * FROM xyz;

2

DELETE FROM xyz;

3

DELETE FROM xyz WHERE rows = *;

4

DROP TABLE xyz;

Solution:

Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 90. The next row added will have value _____________

1

33

2

32

3

91

4

90

Mysql Questions Set 29:

INFORMATION_SCHEMA is based on the SQL standard.

Solution:

The statement used to select the default database is ____

Solution:

Which Clause is used to sort the stored data in alphabetical order?

Solution:

Which statement is used to remove indexes on tables?

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

Solution:

Is there any error in executing the following query?

SELECT USER (), VERSION (), DATABASE ();

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Solution:

Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

Solution:

Which SQL statement is used to delete all the rows of a table named 'xyz' without deleting the table?

Solution:

Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 90. The next row added will have value _____________

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 29:

INFORMATION_SCHEMA is based on the SQL standard.

Solution:

The statement used to select the default database is ____

Solution:

Which Clause is used to sort the stored data in alphabetical order?

Solution:

Which statement is used to remove indexes on tables?

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

Solution:

Is there any error in executing the following query? SELECT USER (), VERSION (), DATABASE ();

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Solution:

Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

Solution:

Which SQL statement is used to delete all the rows of a table named 'xyz' without deleting the table?

Solution:

Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 90. The next row added will have value _____________

Solution:

Related Question Sets:

Related Topics:

Is there any error in executing the following query?

SELECT USER (), VERSION (), DATABASE ();