Oracle 1z0-882 問題集

質問 1：
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 SELECT a row that exceeded max_allowed_packet.
B. The network caused an error Inducing the max_allowed_packet error.
C. The application tried to INSERT a row that exceeded max_allowed_packet.
D. The application did not use the COMPRESS () function for a large result set.
E. The application tried to SELECT many rows together that exceeded max__allowed_packet.
F. The operating system caused an error inducing the max_allowed_packet error.
正解：B,C

質問 2：
A statement exists that can duplicate the definition of the 'world'table.
What is missing?
CREATE TABLE t1 ___________world
A. FROM
B. COPY
C. USING
D. LIKE
正解：D

質問 3：
Which three database objects have non-case-sensitive names on all operating system?
A. Index
B. Trigger
C. Stored procedure
D. Table
E. Column
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two PHP modules provide APIs for developing MYSQL applications?
A. PDO_mysql
B. PDO
C. Mysqli
D. Mysqlnd
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

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

質問 6：
Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no mysqld
process is running.
Which two may provide diagnostic information to help determine why the MYSQL server stopped?
A. The general query log file
B. The MYSQL server error log file
C. The binary log file
D. The syslog on Linux/UNIX or the Event view on windows
E. The slow query log file
正解：B,C

質問 7：
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
A. SELECT * prevents the use of indexes, so a full table scan for every query.
B. SELECT * causes more data than you need to be sent via the client/server protocol if your application needs only
some columns.
C. SELECT *causes your application to depend on the columns present when you wrote it , so your application could
break if the table structure changes.
D. SELECT * may cause more data than you need to be read from disk if your application needs only some columns.
E. SELECT * causes the statements to return all rows from the table.
正解：B,C,D