Free Oracle 1z0-883 Exam Dumps Questions & Answers

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

• A.The command prints all parameters for the login-path. The password is shown only when you provide the -password option.
• B.The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
• C.The command prints all parameter for the login-path. The password is replaced with stars.
• D.The command prints all parameters for the login-path. The password is printed in plain text.

Which three statements are characteristic of the MEMORY storage engine?

• A.Table contents are not saved if the server is restarted.
• B.It can support transactions
• C.Each table has a corresponding.MYI and .MYD file.
• D.It can support foreign keys.
• E.Each table is represented on disk as an.frm file.
• F.It cannot contain text or BLOB columns.

Which two events will cause a slave server to create a new relay log file?

• A.Reaching the slave_pendign _jobs_size_max limit
• B.Execution of the FLUSH LOGS statement
• C.Starting of the I/O thread
• D.Starting of the SQL thread
• E.Execution of FULSH TABLES WITH READ LOCK

Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?

• A.12; only top-level statements and stored procedure events are logged.
• B.111; top-level statements and all lower-level statements are logged.
• C.3; only the top-level statements are logged.
• D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.

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.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);
• B.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';
• C.SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv
  FROM mysql.user
  WHERE CONCAT (user,'s', host) = CURRENT_USER();
• D.SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4,
  charcol5, charcol6, charcol7, charcol8, charcol9, charcol10
  FROM t1
  WHERE id = 's';