Jobs By Abekus

How can view refer to multiple tables?

1

UNION

2

JOIN

3

GROUP

4

SELECT

Solution:

ORDER BY Clause always sorts in lexicographical order.

1

True

2

False

Solution:

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

1

True

2

False

Solution:

How many storage engines among the following are transaction-safe?

`InnoDB, Falcon, MyISAM, MEMORY`

1

0

2

1

3

2

4

3

Solution:

The file that can be used to execute multiple compile statements is _________________

1

makefile

2

dofile

3

putfile

4

pushfile

Solution:

Which data type character merges the “Check Constraint” into a data type definition?

1

ENUM1

2

ENUM2

3

ENUM

4

None of the mentioned

Solution:

In MySQL databases, the structure representing the organizational views of all databases is _________ ?

1

View

2

Instance

3

Table

4

Schema

Solution:

The program that copies the databases from one server to another is ____________

1

mysqldbcopy

2

mysqlcopydb

3

mysqlflushdb

4

mysqldbflush

Solution:

The physical location of a record determined by a formula that transforms a file key into a record location is called a:

1

Hashed file

2

B-Tree file

3

Indexed file

4

Sequential file

Solution:

The SQL statement to insert a new record into the 'student' table is:

1

INSERT INTO student ('Varun', 'M', NULL);

2

INSERT INTO student VALUES ('Varun', 'M', NULL);

3

INSERT student VALUES ('Varun', 'M', NULL);

4

INSERT INTO 'student' VALUES ('Varun', 'M', NULL);

Mysql Questions Set 31:

How can view refer to multiple tables?

Solution:

ORDER BY Clause always sorts in lexicographical order.

Solution:

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

Solution:

How many storage engines among the following are transaction-safe?

`InnoDB, Falcon, MyISAM, MEMORY`

Solution:

The file that can be used to execute multiple compile statements is _________________

Solution:

Which data type character merges the “Check Constraint” into a data type definition?

Solution:

In MySQL databases, the structure representing the organizational views of all databases is _________ ?

Solution:

The program that copies the databases from one server to another is ____________

Solution:

The physical location of a record determined by a formula that transforms a file key into a record location is called a:

Solution:

The SQL statement to insert a new record into the 'student' table is:

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 31:

How can view refer to multiple tables?

Solution:

ORDER BY Clause always sorts in lexicographical order.

Solution:

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

Solution:

How many storage engines among the following are transaction-safe? InnoDB, Falcon, MyISAM, MEMORY

Solution:

The file that can be used to execute multiple compile statements is _________________

Solution:

Which data type character merges the “Check Constraint” into a data type definition?

Solution:

In MySQL databases, the structure representing the organizational views of all databases is _________ ?

Solution:

The program that copies the databases from one server to another is ____________

Solution:

The physical location of a record determined by a formula that transforms a file key into a record location is called a:

Solution:

The SQL statement to insert a new record into the 'student' table is:

Solution:

Related Question Sets:

Related Topics:

How many storage engines among the following are transaction-safe?

`InnoDB, Falcon, MyISAM, MEMORY`