MySQL, Databases

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
Question: Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?
A
SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

B
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

C
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

D
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

E
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Note: Not available
1. Report
Question: What privilege do you need to create a function?
A
UPDATE

B
CREATE ROUTINE

C
SELECT

D
CREATE FUNCTION

E
No specific privilege

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

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: Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?

Question: What privilege do you need to create a function?

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: Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?

Question: What privilege do you need to create a function?

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?