Jobs By Abekus

Which of these is also known as a virtual table?

1

SCHEMA

2

DATABASE

3

JOIN

4

VIEW

Solution:

The clause that filters JOIN results is called _________

1

WHERE

2

SORT

3

GROUP BY

4

ORDER BY

Solution:

What is generally done if an error occurs during the transaction?

1

delete

2

commit

3

update

4

rollback

Solution:

Which statement can be used for modifying the definition for an existing table?

1

ALTER

2

Modified

3

SELECT

4

FROM

Solution:

What is xyz in the following statement?

CREATE VIEW xyz AS SELECT a, b FROM t;

1

row name

2

column name

3

view

4

database

Solution:

Which statement is used to access an existing Database?

1

Use

2

use database.name

3

USE databasename;

4

None of the mentioned

Solution:

The indicator of presence or absence of a word in search is used in which mode?

1

Natural language

2

Boolean mode

3

Query expansion

4

Cross mode

Solution:

Which statement does not use the same number of bytes and the byte usage depends on the input data?

1

Char

2

Varchar

3

Both Varchar and Char

4

None of the above

Solution:

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

1

SET

2

MATCH

3

ALTER TABLE

4

SPECIFY

Solution:

Identify the correct syntax for creating a table in MySQL/SQL.

1

CREATE tablename ( arg 1, arg 2,. . . . . ,arg n);

2

CREATE TABLE tablename (column1, column2, . . . . ,column n);

3

USE TABLE tablename (arg 1, arg 2, . . . . . .,arg n);

4

CREATE TABLE tablename;

Mysql Questions Set 41:

Which of these is also known as a virtual table?

Solution:

The clause that filters JOIN results is called _________

Solution:

What is generally done if an error occurs during the transaction?

Solution:

Which statement can be used for modifying the definition for an existing table?

Solution:

What is xyz in the following statement?

CREATE VIEW xyz AS SELECT a, b FROM t;

Solution:

Which statement is used to access an existing Database?

Solution:

The indicator of presence or absence of a word in search is used in which mode?

Solution:

Which statement does not use the same number of bytes and the byte usage depends on the input data?

Solution:

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

Solution:

Identify the correct syntax for creating a table in MySQL/SQL.

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 41:

Which of these is also known as a virtual table?

Solution:

The clause that filters JOIN results is called _________

Solution:

What is generally done if an error occurs during the transaction?

Solution:

Which statement can be used for modifying the definition for an existing table?

Solution:

What is xyz in the following statement? CREATE VIEW xyz AS SELECT a, b FROM t;

Solution:

Which statement is used to access an existing Database?

Solution:

The indicator of presence or absence of a word in search is used in which mode?

Solution:

Which statement does not use the same number of bytes and the byte usage depends on the input data?

Solution:

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

Solution:

Identify the correct syntax for creating a table in MySQL/SQL.

Solution:

Related Question Sets:

Related Topics:

What is xyz in the following statement?

CREATE VIEW xyz AS SELECT a, b FROM t;