Oracle 1z1-883 실제 시험문제 및 답변

문제1
Which three are properties of the MyISAM storage engine?

A. Geospatial indexing

B. Foreign key support

C. Table and page level locking support

D. FULLTEXT indexing for text matching

E. Table level locking only

F. Transaction support

G. HASH index support

정답: A,D,E

문제2
You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

A. The server was not started with the - enable--ssl-plugin option.

B. -- ssl is not a valid server option.

C. The --- ssl level was not specified.

D. The server's SSL certificate was invalid.

E. The mysqld binary was not compiled with SSL support.

정답: E

문제3
You have enabled the Slow Query Log for a short period.
When you process the Slow Query Log, you receive the following snip of output:
Count: 100 Time=0 .22a (22s) Lock=0.00s (0s) Rows=0.0 (0), root[root] @localhost
CREATE TABLE 't1' (id serial,id0 varchar(N) unique key,intcaoll INT (N)
,intco12 INT(N) ,intco13 INT(N) ,intco14 INT(N) ,intco15 INT(N)
,charcol1 VARVHAR(N) ,charcol2 VARCHAR(N) charcol3 VARCHAR (N)
,charcol4 VARVHAR(N) ,charcol5 VARCHAR(N) charcol6 VARCHAR (N)
,charcol7 VARVHAR(N) ,charcol8 VARCHAR(N) charcol9 VARCHAR (N) .charcol 10 VACHAR
(N) )
Count: 64000 Time-0.02s (1213s) Lock=0.00s (6s) Rows=1.0 (64000), root [root]@ localhost
SELECT intocl1, intco12, intco13, intco14, intco15, intco16,intco17, intco18
,intcol9, intcol10, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6
,charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'
Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=1.0 (1) agent [agent] @localhost
SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv,
Process_priv FROM mysql.user WHERE CONCAT (user, 's', host) = CURRENT_USER ()
Count: 48000 Time=0.02s (778s) Lock=0.00 (3s) Rows=1.0 (48000), root[root]@localhost
SELECT intocl1,intcol2,intcol3, intcol4, intcol5, charcol1, charcol2, charcol3
,charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'
You want to tune the query such that it provides the greatest overall time savings.
Which query will accomplish this?

A. SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv
FROM mysql.user
WHERE CONCAT (user,'s', host) = CURRENT_USER();

B. CHEATE TABLE 't1' (id serial, id0 varchar (N) unique key, intcol1 INT (N)
,intcol2 INT (N), intcol3 INT(N) ,intcol4 INT(N), intcol5 INT(N), charool1 VARCHAR
(N)
,charcol2 VARCHAR (N), charcol3 VARCHAR(N), charcol4 VARCHAR(N), charcol5 VARCHAR
(N)
,charcol6 VARCHAR (N), charcol7 VARCHAR(N), charcol8 VARCHAR(N), charcol9 VARCHAR
(N)
,charcol10 VARCHAR (N);

C. SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4,
charcol5, charcol6, charcol7, charcol8, charcol9, charcol10
FROM t1
WHERE id = 's';

D. SELECT intcol1, intcol2, intcol3, intcol4, intcol5, intcol6, intcol7, intcol8, intcol9,
Intcol10, intcol11, intcol12, intcol13, intcol14, intcol15, intcol16, intcol17, intcol18, intcol19,
charcol10
FROM t1
WHERE id = 's';

정답: B

문제4
Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?

A. Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;

B. Disabling and re-enabling all instruments

C. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;

D. Using the statement RESET PERFORMANCE CACHE;

E. Using the statement FLUSH PERFORMANCE CACHE;

F. Restarting Mysql

정답: A,B

설명: (ExamPassdump 회원만 볼 수 있음)

문제5
You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead.
You execute the following commands:
ServerB commands:
Shell> mysqldump -u root -h server -no-data apps userdata | mysql -u root -p apps
Shell> mysql -u root -p -h server -e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;'
Shell> mysqldump -u root -p -h server -no-create-info -order-by-primary apps userdata | mysql -u root -p apps
What effect does the - order-by-primary argument have on the mysqldump command?

A. It orders by primary key to assist in speeding up importing to InnoDB tables.

B. It must be specified so index data is dumped correctly when -on-create-info is used.

C. It ensures that unique indexes have no conflicts when the data is dumped.

D. It exports tables with the most indexes first to assist with import speeds.

정답: A

문제6
Consider the MySQL Enterprise Audit plugin,
You add the following lines to the my.cnf configuration tile:
[mysqld]
Plugin-load=audit_log.so
Audit-log=FORCE_PLUS_PERMANENT
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?

A. The audit_log.so library is not an executable file.

B. The audit log file does not exist in which to write audit events.

C. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

D. The audit_log.so library does not exist.

E. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

F. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

정답: D,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제7
Review the definition of the phone_list view.
CHEATE OR REPLACE
ALGORITHM=MERGE
DEFINER= 'root'@localhost'
SQL SECURITY DEFINER
VIEW 'phone_list' AS
SELECT
e . id as id
'e . first_name AS 'first_name'
'e . last_name AS 'last_name'
'coalesce ( ph1.phone_no, '--') AS 'office_no'
'coalesce (ph2 .phone_no, '--') AS 'cell_no'
FROM employees e
LEFT JOIN employee_phone ph1
ON ph1.emp_id = e.id AND ph1.type = 'office'
LEFT JOIN employee_phone ph2
ON ph2 .emp_id = e.id AND ph2 .type = 'mobile'
The tables employees and employee_phone are InnoDB tables; all columns are used in this view.
The contents of the phone_list view are as follows:
Mysql> select * from phone_list;

1 row in set (0.00 sec)
Which method can you use to change the cell_no value to '555-8888' for John Doe?

A. INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile');

B. DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888);

C. UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe';

D. UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1;

정답: A

문제8
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.
Which statement will accomplish this?

A. SELECT * FROM INFORMATION_SCHEMPROCESSLIST WHERE HOST='192.168.1.15';

B. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';

C. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';

D. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

정답: A

문제9
Which two are true regarding MySQL binary and text backups?

A. Binary backups are not portable across different operating systems.

B. Binary backups are usually faster than text backups.

C. Text backups are human-readable while binary backups are not.

D. Binary backups are usually slower than text backups.

정답: A,C

문제10
Which two options describe how MySQL Server allocates memory?

A. Each connection may have its own per-thread memory allocations.

B. Thread memory is pre-allocated up to thread_cache_size for performance.

C. Global memory resources are allocated at server startup.

D. Each thread allocates memory from a global pool.

정답: A,C

최신Oracle MySQL 5.6 Database Administrator - 1z1-883무료샘플문제

자격증의 중요성:

ExamPassdump 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: