Q1. 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?

A. The examinee_id column should be designated as PRIMARY KEY.

B. A NOT NULL qualifier should be moved from exam-id to examinee-id.

C. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).

D. A NOT NULL qualifier should be added to examinee_id.

View Answer

Q2. Consider the my_table table with two integer columns, a and b, and the contents as shown; Mysql > SELECT a, b FROM my_table;

1 row in set result of this query? SELECT a—b

FROM my_table;

A. 0

B. 2

C. 4

D. An error message

View Answer

Q3. The application logs contain many entries of the following:

ERROR 1153 (OSSO1): Got a packet bigger than ‘max_allowed_packet’ bytes With two scenarios can (Hibernate this error message?

A. The application tried to INSERT a row that exceeded max_allowed_packet.

B. The network caused an error Inducing the max_allowed_packet error.

C. The application did not use the COMPRESS () function for a large result set.

D. The application tried to SELECT many rows together that exceeded max allowed_packet.

E. The application tried to SELECT a row that exceeded max_allowed_packet.

F. The operating system caused an error inducing the max_allowed_packet error.

View Answer

Q4. A statement exists that can duplicate the definition of the ‘world’table.

What is missing?

CREATE TABLE t1 world

A. FROM

B. USING

C. COPY

D. LIKE

View Answer

Q5. A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?

A. The results are in ascending order.

B. The results are in descending order.

C. The results are in the order inserted.

D. The results are not in a set order.

View Answer

Q6. What are two ways in which normalizing your tables helps improve performance In MySQL?

A. Smaller table sizes and row lengths improve sorting operations.

B. Separate tables allow indexing more columns.

C. Fewer nullable column improve index usage.

D. Normalizing Improves the performance of innodb_file_per _table.

View Answer

Q7. Which statement is true about the difference between HASH and BTREE INDEXES?

A. HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.

B. HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.

C. HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can also be used for range searches (>or<).

D. HASH indexes are much faster than BTREE indexes but can only be used for a single column.

View Answer

Q8. The data from t1 table is:

Assuming You want to see this output:

Which query achieves the preceding result?

A. SELECT name FROM t1 WHERE name LIKE ,_e%

B. SELECT name FROM t1 WHERE name LIKE,e%.;

C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;

D. SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

View Answer