Databases - Upwork

Question: Is it possible to insert several rows into a table with a single INSERT statement?
A
No

B
Yes

Note: Not available
1. Report
Question: Can you run multiple MySQL servers on a single machine?
A
Yes

B
No

Note: Not available
1. Report
Question: Which of the following formats does the date field accept by default?
A
DD-MM-YYYY

B
YYYY-DD-MM

C
YYYY-MM-DD

D
MM-DD-YY

E
MMDDYYYY

Note: Not available
1. Report
Question: State whether true or false: In the 'where clause' of a select statement, the AND operator displays a row if any of the conditions listed are true. The OR operator displays a row if all of the conditions listed are true.
A
True

B
False

Note: Not available
1. Report
Question: What is the name of the utility used to extract NDB configuration information?
A
ndb_config

B
cluster_config

C
ndb --config

D
configNd

E
None

Note: Not available
1. Report
Question: Which one of the following must be specified in every DELETE statement?
A
Table Name

B
Database name

C
LIMIT clause

D
WHERE clause

Note: Not available
1. Report
Question: Which of the following are not Numeric column types?
A
BIGINT

B
LARGEINT

C
SMALLINT

D
DOUBLE

E
DECIMAL

Note: Not available
1. Report
Question: Which of the following statements is true regarding multi-table querying in MySQL?
A
JOIN queries are faster than WHERE queries.

B
WHERE queries are faster than JOIN queries.

C
INNER queries are faster than JOIN queries.

D
WHERE & INNER offer the same performance in terms of speed.

Note: Not available
1. Report
Question: What is wrong with the following statement?
create table foo (id int auto_increment, name int);
A
Nothing

B
The id column cannot be auto incremented because it has not been defined as a primary key

C
It is not spelled correctly. It should be: CREATE TABLE foo (id int AUTO_INCREMENT, name int);

Note: Not available
1. Report
Question: Consider the following table definition:
CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT )
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?
A
ALTER TABLE table1 ADD column2a INT AFTER column2

B
MODIFY TABLE table1 ADD column2a AFTER column2

C
INSERT INTO table1 column2a AS INT AFTER column2

D
ALTER TABLE table1 INSERT column2a INT AFTER column2

E
CHANGE TABLE table1 INSERT column2a BEFORE column3

F
Columns are always added after the last column

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: Is it possible to insert several rows into a table with a single INSERT statement?

Question: Can you run multiple MySQL servers on a single machine?

Question: Which of the following formats does the date field accept by default?

Question: State whether true or false: In the 'where clause' of a select statement, the AND operator displays a row if any of the conditions listed are true. The OR operator displays a row if all of the conditions listed are true.

Question: What is the name of the utility used to extract NDB configuration information?

Question: Which one of the following must be specified in every DELETE statement?

Question: Which of the following are not Numeric column types?

Question: Which of the following statements is true regarding multi-table querying in MySQL?

Question: What is wrong with the following statement?
create table foo (id int auto_increment, name int);

Question: Consider the following table definition:
CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT )
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?

Question: Is it possible to insert several rows into a table with a single INSERT statement?

Question: Can you run multiple MySQL servers on a single machine?

Question: Which of the following formats does the date field accept by default?

Question: State whether true or false: In the 'where clause' of a select statement, the AND operator displays a row if any of the conditions listed are true. The OR operator displays a row if all of the conditions listed are true.

Question: What is the name of the utility used to extract NDB configuration information?

Question: Which one of the following must be specified in every DELETE statement?

Question: Which of the following are not Numeric column types?

Question: Which of the following statements is true regarding multi-table querying in MySQL?

Question: What is wrong with the following statement?create table foo (id int auto_increment, name int);

Question: Consider the following table definition:CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT ) Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?

Question: What is wrong with the following statement?
create table foo (id int auto_increment, name int);

Question: Consider the following table definition:
CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT )
Which one of the following is the correct syntax for adding the column, "column2a" after column2, to the table shown above?