Jobs By Abekus

In SQL, identifier names may start with a digit.

1

TRUE

2

FALSE

Solution:

How is a stored procedure invoked?

1

INVOKE

2

SEE

3

CALL

4

RETURN

Solution:

Which clause is used to remove a foreign key constraint?

1

DROP

2

REMOVE

3

EXCLUDE

4

DELETE

Solution:

Which of these return a result to the client?

1

Stored functions

2

Stored procedures

3

Triggers

4

Events

Solution:

Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?

1

ORDER BY

2

GROUP BY

3

SELECT

4

HAVING

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

Solution:

Which clause names the parent table and the index columns in the table?

1

ON DELETE

2

CONSTRAINT

3

FOREIGN KEY

4

REFERENCES

Solution:

When building a new database, which keyword is used to uniquely identify new records without using a primary key?

1

Increment

2

Auto Increment

3

Both 1 and 2

4

Plus

Solution:

What does ‘name’ represent in the following code?

`CREATE TABLE Person ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );`

1

Table

2

Row

3

Column

4

Object

Solution:

Two cars cover the same distance at the speed of 60 and 64 kmps respectively. Find the distance traveled by them if the slower car takes 1 hour more than the faster car.

1

906 km

2

960 km

3

609 km

4

690 km

Mysql Questions Set 37:

In SQL, identifier names may start with a digit.

Solution:

How is a stored procedure invoked?

Solution:

Which clause is used to remove a foreign key constraint?

Solution:

Which of these return a result to the client?

Solution:

Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?

Solution:

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

Solution:

Which clause names the parent table and the index columns in the table?

Solution:

When building a new database, which keyword is used to uniquely identify new records without using a primary key?

Solution:

What does ‘name’ represent in the following code?

`CREATE TABLE Person ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );`

Solution:

Two cars cover the same distance at the speed of 60 and 64 kmps respectively. Find the distance traveled by them if the slower car takes 1 hour more than the faster car.

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 37:

In SQL, identifier names may start with a digit.

Solution:

How is a stored procedure invoked?

Solution:

Which clause is used to remove a foreign key constraint?

Solution:

Which of these return a result to the client?

Solution:

Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?

Solution:

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

Solution:

Which clause names the parent table and the index columns in the table?

Solution:

When building a new database, which keyword is used to uniquely identify new records without using a primary key?

Solution:

What does ‘name’ represent in the following code? CREATE TABLE Person ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

Solution:

Two cars cover the same distance at the speed of 60 and 64 kmps respectively. Find the distance traveled by them if the slower car takes 1 hour more than the faster car.

Solution:

Related Question Sets:

Related Topics:

What does ‘name’ represent in the following code?

`CREATE TABLE Person ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );`