最新的OCP認證 1z0-882考試題庫

問題1

A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown:

You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN.
What is the effect of adding STRAIGHT JOINs to the query?

A. The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.

B. The optimizer will only JOIN the tables in sequence from smallest to largest.

C. The optimizer processes only the JOINs in the sequence listed in the query.

D. The optimizer ignores all terms in the WHERE clause until all JOINs have been completed.

正確答案: C

問題2

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 :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx

E. Jdbc:mysq1://localhost/test?user =xxx&password=xxx

正確答案: C,D,E

問題3

The people table contains the data as shown:

Which two statements return two rows each?

A. SELECT first _name, last_name FROM people LIMIT 1, 2

B. SELECT DISTINCT last_name, first_name FROM people

C. SELECT first_name, last _name FROM people WHERE age LIKE '2'

D. SELECT 1,2 FROM people GROUP BY last_name

E. SELECT 1, 2 FROM people WHERE last _name ='smith'

正確答案: A,D

問題4

A floating- point column defined as FLOAT(7,5)allows___________

A. 7 digits to the left of the decimal point and 5 digits to the right

B. 7 digits in total, of which 5 are to the left of the decimal point

C. 5 digits to the left of the decimal point and 7 digits to the right

D. 7 digits in total, of which 5 are to the right of the decimal point

正確答案: D

問題5

Which two queries return a value of NULL?

A. SELECT NULL <= > NULL

B. SELECT NULL =NULL

C. SELECT COUNT (NULL);

D. SELECT 1 > NULL

E. SELECT NULL is NULL

正確答案: B,D

問題6

Identity two ways to configure a PHP application to use the UTF8 character set.

A. mysqli: :query (''SET NAMES utfs'');

B. PDO: :set_charset(''utf8'')

C. mysqli : :set_charset ('utf8')

D. spdo = new PDO (''mysql:host=localhost;dbname=test;charset=utfs'', user'', ''pass'');

正確答案: C,D

說明：（僅 VCESoft 成員可見）

問題7

You started a MySQL command -line session with sq1_ mode (empty), and created the person table with the
structure:
Mysql> DESC person;

You issue:
INSERT INTO person VALUES ('casper', 'undefined')
What is the effect?

正確答案:

問題8

Which two PHP modules provide APIs for developing MYSQL applications?

A. Mysqli

B. PDO

C. PDO_mysql

D. Mysqlnd

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題9

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 syslog on Linux/UNIX or the Event view on windows

B. The general query log file

C. The slow query log file

D. The MYSQL server error log file

E. The binary log file

正確答案: D,E

問題10

Examine the fruit and wine tables:
Fruit

You execute this query:
SELECT fruited, fruitname FROM fruit
UNION
SELECT id, name, country FROM wine;
What is the result?

A. The query falls because the number of columns in the SELECT in the SELECT clauses are not equal.

B. The query succeeds and returns two columns of data.

C. The query falls because UNION does not work on tables with different number of columns.

D. The query succeeds and returns five columns of data.

正確答案: A

最新的Oracle Certified Professional, MySQL 5.6 Developer - 1z0-882免費考試真題

最新更新

站內鏈接

聯系我們