As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED -
What change should you make to ensure that examinee_id is an integer value throughout the table?
Answer : D
Which two can be used to obtain information stored in the Diagnostics Area?
Answer : A,B
Reference: http://dev.mysql.com/doc/refman/5.6/en/diagnostics-area.html
You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?
A.
Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mys ql.jdbc
B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin
D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
Answer : A
Given the data:
Answer : E
You have a transaction that queries a table at the beginning of the transaction and performs the same query later.
Which two transaction isolation levels guarantee that you get the same results both times?
Answer : A,E
Reference: http://dev.mysql.com/doc/refman/5.0/en/commit.html
Inspect the SELECT query:
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees
JOIN title WHERE to_date > 2008-10-11;
Answer : C
Consider the query and its output:
Mysql> SELECT Language As Lang FROM countrylanguage
->WHERE countrycode =GBR;
Answer : D
Reference: http://dcsg.bcs.org/sites/default/files/mysql-certification-41addendum_0.pdf
(page 32, 1.9.)
The friends table has the columns and contents as shown:
Mysql> SELECT * FROM friends;
Answer : C
Explanation: http://stackoverflow.com/questions/14020924/strange-mysql-avg-anomaly- null-values
Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY
/*150611 ALGORITHM = 1*/
What does this statement do?
Answer : C
Cormcctor/Net supports a decoupled database connection mode, where a database
Connection is established only when needed.
'
Choose the three parts that are involved when working with decoupled data.
Answer : D
Reference: http://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data- adapter.html
Which Three options describe benefits of using the InnoDB memcached API?
Answer : C,D,E
Given the table City:
SELECT Name -
FROM City -
WHERE CountryCode = USA OR WHERE CountryCode= JPN
What does this statement procedure?
Answer : D
Which three connector/J connection strings can be used to connect to the MYSQL server?
Answer : A,C,E
Using the query:
SELECT Code FROM country WHERE Name = united states
Which statement executed in the mysql client would create a prepared statement?
Answer : C
Reference: http://www.timlin.net/csm/cis363/mysql18.html
Consider the content of the class and student tables:
Class -
Answer : B,D,E