Jobs By Abekus

The BIGINT precision is of bit _________

1

32

2

64

3

128

4

16

Solution:

The escape sequence for carriage return is ___________

1

'\c'

2

'\a'

3

'\z'

4

'\r'

Solution:

Which of these is also known as a virtual table?

1

SCHEMA

2

DATABASE

3

JOIN

4

VIEW

Solution:

Which value will show an error when stored in float(4,2)?

1

12.11

2

14.2

3

1.22

4

135.65

Solution:

Which character does the mysql client program recognize as a statement delimiter?

1

:

2

.

3

;

4

,

Solution:

Which Clause is used to select a particular row from the set of row in an existing table?

1

WHERE

2

FROM

3

ALTER

4

NONE OF THE MENTIONED

Solution:

The statement that alters an existing event to have the given definition is _____________

1

ALTER EVENT

2

ALTER DATABASE

3

ALTER FUNCTION

4

ALTER DATABASE

Solution:

To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?

1

mysql exec.sql > sampdb

2

mysql sampdb < exec.sql

3

mysql exec.sql

4

mysql exec

Solution:

Identify the syntax for creating an index in MySQL.

1

CREATE INDEX index_name ON table_name(column1, column2, ...);

2

CREATE UNIQUE INDEX index_name ON table_name(column1, column2, ...);

3

Both 1 and 2 are correct.

4

None of these.

Mysql Questions Set 39:

The BIGINT precision is of bit _________

Solution:

The escape sequence for carriage return is ___________

Solution:

Which of these is also known as a virtual table?

Solution:

Which value will show an error when stored in float(4,2)?

Solution:

Which character does the mysql client program recognize as a statement delimiter?

Solution:

Which Clause is used to select a particular row from the set of row in an existing table?

Solution:

The statement that alters an existing event to have the given definition is _____________

Solution:

To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?

Solution:

Identify the syntax for creating an index in MySQL.

Solution:

Related Question Sets:

Related Topics: