Jobs By Abekus

What default value gets stored in columns of the table?

1

0

2

1

3

more than 1

4

NULL

Solution:

Which SQL instruction is used to add a new row in a database table?

1

ADD

2

CREATE

3

MAKE

4

INSERT

Solution:

In inner join, result is produced by matching rows in one table with rows in another table.

1

True

2

False

Solution:

Which SQL keyword is used to select different/unique values from a table?

1

different

2

distinct

3

unique

4

separate

Solution:

The command which lists databases managed by the server is _____________

1

mysqld

2

mysqlshow

3

mysqllist

4

mysqldb

Solution:

What is xyz in the following statement?

DELETE FROM xyz WHERE abc = 5;

1

column name

2

table name

3

row name

4

database name

Solution:

Identify the table name in the following statement.

`INSERT INTO person VALUES('Kyle','M',NULL);`

1

Kyle

2

M

3

Values

4

person

Solution:

What is the host name in the command given below:

mysql -h root.dayum.net -p -u swarni

1

swarni

2

root

3

root.dayum

4

root.dayum.net

Solution:

What statement is used to show the definition of an existing database?

1

SHOW DATABASE

2

SHOW CREATE

3

SHOW CREATE DATABASE TABLE

4

SHOW CREATE DATABASE

Solution:

What does ‘abc’ & ‘xyz’ specify?

1

table name and column specs

2

column specs and table name

3

table name and number of columns

4

table name and number of rows

Mysql Questions Set 36:

What default value gets stored in columns of the table?

Solution:

Which SQL instruction is used to add a new row in a database table?

Solution:

In inner join, result is produced by matching rows in one table with rows in another table.

Solution:

Which SQL keyword is used to select different/unique values from a table?

Solution:

The command which lists databases managed by the server is _____________

Solution:

What is xyz in the following statement?

DELETE FROM xyz WHERE abc = 5;

Solution:

Identify the table name in the following statement.

`INSERT INTO person VALUES('Kyle','M',NULL);`

Solution:

What is the host name in the command given below:

mysql -h root.dayum.net -p -u swarni

Solution:

What statement is used to show the definition of an existing database?

Solution:

What does ‘abc’ & ‘xyz’ specify?

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 36:

What default value gets stored in columns of the table?

Solution:

Which SQL instruction is used to add a new row in a database table?

Solution:

In inner join, result is produced by matching rows in one table with rows in another table.

Solution:

Which SQL keyword is used to select different/unique values from a table?

Solution:

The command which lists databases managed by the server is _____________

Solution:

What is xyz in the following statement? DELETE FROM xyz WHERE abc = 5;

Solution:

Identify the table name in the following statement. INSERT INTO person VALUES('Kyle','M',NULL);

Solution:

What is the host name in the command given below: mysql -h root.dayum.net -p -u swarni

Solution:

What statement is used to show the definition of an existing database?

Solution:

What does ‘abc’ & ‘xyz’ specify?

Solution:

Related Question Sets:

Related Topics:

What is xyz in the following statement?

DELETE FROM xyz WHERE abc = 5;

Identify the table name in the following statement.

`INSERT INTO person VALUES('Kyle','M',NULL);`

What is the host name in the command given below:

mysql -h root.dayum.net -p -u swarni