1z0-882 試験問題を無料オンラインアクセス

Which three view types are not updateable?

• A.A view containing a HAVING clause
• B.A view that contains a literal column
• C.A view containing a WHERE clause
• D.A view containing a GROUP BY clause
• E.A view created with the TEMPTABLE algorithm

Which two queries return a value of NULL?

• A.SELECT NULL is NULL
• B.SELECT NULL <= > NULL
• C.SELECT NULL =NULL
• D.SELECT COUNT (NULL);
• E.SELECT 1 > NULL

Which Three options describe benefits of using the InnoDB memcached API?

• A.Provides a total in -memory storage system that eliminates disk1/0 overhead.
• B.Bypasses the SQL layer thus avoiding extra processing.
• C.Implements a fast caching mechanism to replace the query cache.
• D.Provides protection via InnoDB buffers and crash recovery.
• E.Provides a simple, well supported method for accessing and updating data.

Which three connector/J connection strings can be used to connect to the MYSQL server?

• A.Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx
• B.Jdbc:mysq1://localhost/test?user =xxx&password=xxx
• C.Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx
• D.Jdbc :mysqli://localhost/test?user=xxx&password=xxx
• E.Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx

Which two PHP modules provide APIs for developing MYSQL applications?

• A.Mysqli
• B.PDO
• C.PDO_mysql
• D.Mysqlnd