Oracle 1z0-883 Actual Free Exam Questions & Community Discussion

In a test database, you issue the SELECT ... INTO OUTFILE statement to create a file with your t1 table data.
You then TRUNCATE this table to empty it.
Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;
mysql> TRUNCATE t1;
Which two methods will restore data to the t1 table?

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?

Consider the Mysql Enterprise Audit plugin.
Which statement is true when you identify a connection event that has used external authentication?

When backing up a replication slave, which three should also be backed up in addition to data?

Consider the Mysql Enterprise Audit plugin.
The following event detail is found in the audit log:
<AUDIT_RECORD
TIMESTAMP="2013-04-09t01:54:17"
NAME="Connect"
CONNECTION_ID="3"
STATUS="1045"
USER="kate"
PROXY_USER=""
HOST="localhost"
IP=""
DB=""/>
Which two points can be concluded from the given event?

User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

Which three statements are true about memory buffer allocation by a MySQL Server?

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