Which there statements describe valid reasons why queries that use "SELECT" construct are discouraged? A. SELECT * may cause more data than you need to be read from disk if your application needs only some columns. B. SELECT * causes…

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…

The tab-delimited file"/tmp/people,txt contains: 1636 Carsten Pederson Denmark 4672 Kai Voigt Germany 4628 Max Mether France This is the structure of the people table: Mysq1> DESCRIBE people; Which statement will load the first and last names into the Names column…

You wish to create a trigger on the ‘city’ table that will check the value of the ‘District’ field before any INSERT. The trigger needs to change it to"Unknown" for an empty string or NULL. CREATE TRIGGER City_bi BEFORE INSERT…

Which two Functions can be used in a C program to retrieve information about warning? A. mysql_info B. mysql_error C. mysql_warning_count D. mysql_errno

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 INSERTa row that exceeded max_allowed_packet. B. The network…

Which two code samples demonstrate valid methods for working with loops? A. DECLARE I INT DEFAULT 0;Test_loop: LOOPSET i =i +1;IF i> =5 THENLEAVE test_loop;END IF;END LOOP test_loop; B. DECLARE i INT DEFAULT 0;WHILE I < 5ITERATESET i = i…

In the office table, the city column is structured as shown: Mysql> show columns from office like ‘city’G -————————————————–1. row ———————__________________ Field: city Type: enum(‘paris’.’Amsterdam’.’New York’.’Tokyo’) Null: Yes Key: Default:NULL Extra: Consider the output of the SELECT query executed on…

Which three connector/J connection strings can be used to connect to the MYSQL server? A. Jdbc:mysq1://localhost/test?user =xxx&password=xxx B. Jdbc :mysqli://localhost/test?user=xxx&password=xxx C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx D. Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx

Which three are valid identifiers for the user table in the mysq1 database? A. myssq1. user B. ‘mysq1. user’ C. ‘mysq1’. ‘user’ D. Mysq1. ‘user’ E. ”mysq1. User”