Jobs By Abekus

The maximum number of elements allowed in SET() is ___________

1

16

2

32

3

64

4

128

Solution:

What is generally used as a synonym for CHARACTER SET?

1

CSET

2

CHSET

3

CHARSET

4

CHCSET

Solution:

If the storage engine InnoDB is not used, a foreign key cannot be used.

1

TRUE

2

FALSE

Solution:

Which SQL function is used to count the number of rows in a table?

1

COUNT()

2

COUNT(*)

3

NUMBER()

4

SUM()

Solution:

What will be returned length value?
SELECT CHARACTER_LENGTH("Abekus . com") AS LengthOfString;

1

12

2

11

3

13

4

10

Solution:

Which function returns a reference to a hash of row values?

1

fetchrow_array()

2

fetchrow_arrayref()

3

fetch()

4

fetchrow_hashref()

Solution:

The system variable in MySQL server that enables to configure the SQL mode is __________

1

sql_config

2

sql_mode

3

sql_server

4

sql_enable

Solution:

What is x in the following statement?

`DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;`

1

table name

2

column name

3

server name

4

database name

Solution:

Write the query to get the employee's first name and last name of the employee table.

1

SELECT * FROM employee;

2

SELECT first_name FROM employee;

3

SELECT First_name,Last_name,Salary FROM employee;

4

SELECT First_name,Last_name FROM employee;

Solution:

In the following query, what does “person_id” stands for?

CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));

1

Normal attribute of the table

2

Super key

3

Composite key

4

Primary key

Mysql Questions Set 47:

The maximum number of elements allowed in SET() is ___________

Solution:

What is generally used as a synonym for CHARACTER SET?

Solution:

If the storage engine InnoDB is not used, a foreign key cannot be used.

Solution:

Which SQL function is used to count the number of rows in a table?

Solution:

What will be returned length value?
SELECT CHARACTER_LENGTH("Abekus . com") AS LengthOfString;

Solution:

Which function returns a reference to a hash of row values?

Solution:

The system variable in MySQL server that enables to configure the SQL mode is __________

Solution:

What is x in the following statement?

`DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;`

Solution:

Write the query to get the employee's first name and last name of the employee table.

Solution:

In the following query, what does “person_id” stands for?

CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 47:

The maximum number of elements allowed in SET() is ___________

Solution:

What is generally used as a synonym for CHARACTER SET?

Solution:

If the storage engine InnoDB is not used, a foreign key cannot be used.

Solution:

Which SQL function is used to count the number of rows in a table?

Solution:

What will be returned length value?SELECT CHARACTER_LENGTH("Abekus . com") AS LengthOfString;

Solution:

Which function returns a reference to a hash of row values?

Solution:

The system variable in MySQL server that enables to configure the SQL mode is __________

Solution:

What is x in the following statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

Solution:

Write the query to get the employee's first name and last name of the employee table.

Solution:

In the following query, what does “person_id” stands for? CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));

Solution:

Related Question Sets:

Related Topics:

What will be returned length value?
SELECT CHARACTER_LENGTH("Abekus . com") AS LengthOfString;

What is x in the following statement?

`DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;`

In the following query, what does “person_id” stands for?

CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));