Jobs By Abekus

Which of these is not a comment specifying construct?

1

#

2

/* */

3

—

4

!#

Solution:

Which statement can produce the same output as ‘SHOW COLUMNS’?

1

DESCRIBE

2

DISPLAY

3

SEE

4

GET

Solution:

The MySQL server used in its client/server architecture is _______________

1

mysqla

2

mysqld

3

mysqlc

4

mysqlb

Solution:

To convert an int to string, the function is _________________

1

INET_ATON()

2

INET_NTOA()

3

INET_ITOS()

4

INET_STOI()

Solution:

Which key declares that an index in one table is related to that in another?

1

primary

2

secondary

3

foreign

4

cross

Solution:

Write the query to get the current date and time.

1

SELECT now();

2

SELECT date();

3

SELECT date&time();

4

SELECT time();

Solution:

Is it necessary to insert the value in each column of the table?

1

Yes

2

No

3

Depends on server

4

Depends on usage of table

Solution:

Suppose it is desired that UNION operation should return not more than 5 rows. Which keyword is used for this?

1

LIMIT

2

RESTRICT

3

COUNT

4

SORT

Solution:

Which of the following commands sets the SQL mode as TRADITIONAL?

1

–sqlmode=’TRADITIONAL’

2

–sql_mode=’TRADITIONAL’

3

–sql-mode=’TRADITIONAL’

4

–sql.mode=’TRADITIONAL’

Solution:

Which one is an example of shallow copy in MySQL?

1

create table copy_newtable select * from old_table;

2

create table new_table like old_table;

3

select * into new_table from old_table;

4

none of these

Mysql Questions Set 18:

Which of these is not a comment specifying construct?

Solution:

Which statement can produce the same output as ‘SHOW COLUMNS’?

Solution:

The MySQL server used in its client/server architecture is _______________

Solution:

To convert an int to string, the function is _________________

Solution:

Which key declares that an index in one table is related to that in another?

Solution:

Write the query to get the current date and time.

Solution:

Is it necessary to insert the value in each column of the table?

Solution:

Suppose it is desired that UNION operation should return not more than 5 rows. Which keyword is used for this?

Solution:

Which of the following commands sets the SQL mode as TRADITIONAL?

Solution:

Which one is an example of shallow copy in MySQL?

Solution:

Related Question Sets:

Related Topics: