MySQL, Databases

Question: What is NDB?
A
An in-memory storage engine offering high-availability and data-persistence features

B
A filesystem

C
An SQL superset

D
MySQL scripting language

E
None

Note: Not available
1. Report
Question: Which of the following statements are true?
A
Names of databases, tables and columns can be up to 64 characters in length

B
Alias names can be up to 255 characters in length

C
Names of databases, tables and columns can be up to 256 characters in length

D
Alias names can be up to 64 characters in length

Note: Not available
1. Report
Question: Which of the following statements is used to change the structure of a table once it has been created?
A
CHANGE TABLE

B
MODIFY TABLE

C
ALTER TABLE

D
UPDATE TABLE

Note: Not available
1. Report
Question: What does DETERMINISTIC mean in the creation of a function?
A
The function returns no value

B
The function always returns the same value for the same input

C
The function returns the input value

D
None

Note: Not available
1. Report
Question: Which of the following statements grants permission to Peter with password Software?
A
GRANT ALL ON testdb.* TO peter PASSWORD 'Software'

B
GRANT ALL ON testdb.* TO peter IDENTIFIED by 'Software'

C
GRANT ALL OF testdb.* TO peter PASSWORD 'Software'

D
GRANT ALL OF testdb.* TO peter IDENTIFIED by 'Software'

Note: Not available
1. Report
Question: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;
A
EMPNO, unique value of ENAME and then SALARY are displayed

B
EMPNO, unique value ENAME and unique value of SALARY are displayed

C
DISTINCT is not a valid keyword in SQL

D
No values will be displayed because the statement will return an error

Note: Not available
1. Report
Question: Which of the following is the best way to disable caching for a query?
A
Add the /*!no_query_cache*/ comment to the query.

B
Flush the whole cache with the command: FLUSH QUERY CACHE

C
Reset the query cache with the command: RESET QUERY CACHE

D
Use the SQL_NO_CACHE option in the query.

Note: Not available
1. Report
Question: What is the maximum size of a row in a MyISAM table?
A
No limit

B
OS specific

C
65,534

D
2'147'483'648

E
128

Note: Not available
1. Report
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

First Prev 2 3 4 5 6 Next Last

Question: What is NDB?

Question: Which of the following statements are true?

Question: Which of the following statements is used to change the structure of a table once it has been created?

Question: What does DETERMINISTIC mean in the creation of a function?

Question: Which of the following statements grants permission to Peter with password Software?

Question: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;

Question: Which of the following is the best way to disable caching for a query?

Question: What is the maximum size of a row in a MyISAM table?

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: What is NDB?

Question: Which of the following statements are true?

Question: Which of the following statements is used to change the structure of a table once it has been created?

Question: What does DETERMINISTIC mean in the creation of a function?

Question: Which of the following statements grants permission to Peter with password Software?

Question: What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

Question: Which of the following is the best way to disable caching for a query?

Question: What is the maximum size of a row in a MyISAM table?

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: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;