Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 31:

  What are three methods to reduce Mysql server exposure to remote connections?

  A. Setting -- skip-networking when remote connections are not required
  B. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
  C. Setting specific GRANT privilege to limit remote authentication
  D. Setting mysql_secure_configuration to enable paranoid mode
  E. Using SSL when transporting data over remote networks
  B. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
  C. Setting specific GRANT privilege to limit remote authentication
  D. Setting mysql_secure_configuration to enable paranoid mode

• Question 32:

  The following commands are available in the Linux binary distributions of Mysql:

  

  Mysqld

  

  

  Mysqld_safe

  

  

  Mysql.server

  What is the correct description of each of these commands?

  A. Mysqld is the server. Mysqld_safe is a shell script that invokes mysqld. Mysql.server is a wrapper for mysql_safe.
  B. Mysqld is a shell script that starts mysql.server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is the server.
  C. Mysqld is the server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is a wrapper for mysqld_safe.
  D. Mysql, mysqld.safe, and mysql.server reside in different locations but are all symlinked to the same script.
  B. Mysqld is a shell script that starts mysql.server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is the server.

• Question 33:

  Consider the following: Mysql> EXPLAIN SELECT * FROM City WHERE Name = `Jacksonville' AND CountryCode = `USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where

  Which statement best describes the meaning of the value for the key_len column?

  A. It shows the total size of the index row.
  B. It shows how many columns in the index are examined.
  C. It shows the number of characters indexed in the key.
  D. It shows how many bytes will be used from each index row.
  C. It shows the number of characters indexed in the key.

• Question 34:

  The InnoDB engine has a feature known as clustered indexes.

  Which three statements are true about clustered indexes as used in InnoDB?

  A. A primary key must exist for creation of a clustered index.
  B. A primary key is used as a clustered index.
  C. A clustered index is a grouping of indexes from different tables into a global index for faster searching.
  D. If no indexes exist, a hidden clustered index is generated based on row IDs.
  E. A clustered index provides direct access to a page containing row data.
  F. The first unique index is always used as a clustered index and not a primary key.
  G. A clustered index allows fulltext searching within InnoDB,
  B. A primary key is used as a clustered index.
  D. If no indexes exist, a hidden clustered index is generated based on row IDs.
  G. A clustered index allows fulltext searching within InnoDB,

• Question 35:

  You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?

  A. Use the replicate-do-db, -- replicate-do-table, or replicate-wild-do-table option with the value equal to OLD_INVENTORY.
  B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
  C. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
  D. Set binlog_format=MIXED with the replicate-ignore-temp-table option.
  E. Use the replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
  A. Use the replicate-do-db, -- replicate-do-table, or replicate-wild-do-table option with the value equal to OLD_INVENTORY.
  D. Set binlog_format=MIXED with the replicate-ignore-temp-table option.

• Question 36:

  A Mysql Server has been running an existing application successfully for six months.

  The my.cnf is adjusted to contain the following additional configuration:

  [mysqld]

  Default-authentication-plugin=sha256_password

  The Mysql Server is restarted without error.

  What effect will the new configuration have in existing accounts?

  A. They will have their passwords updated on start-up to sha256_password format.
  B. They will have to change their password the next time they login to the server.
  C. They are not affected by this configuration change.
  D. They all connect via the secure sha256_password algorithm without any configuration change.
  D. They all connect via the secure sha256_password algorithm without any configuration change.

• Question 37:

  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';
  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);

• Question 38:

  Which three statements describe how the strict SQL mode provides added security?

  A. It rejects statements that try to insert out-of-range values
  B. It rejects invalid dates.
  C. It limits the operations that the server can perform.
  D. It rejects queries that produce out-of-range values.
  E. It rejects dates with zero day or month values.
  C. It limits the operations that the server can perform.
  D. It rejects queries that produce out-of-range values.
  E. It rejects dates with zero day or month values.

• Question 39:

  The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE `validate_password%';

  

  When attempting to set your password, you get the following error:

  Mysql> SET PASSWORD = PASSWORD (`Hoverl@%');

  ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

  What is the cause of the error?

  A. The password is eight characters long, but needs to exceed validate_password_length to be valid.
  B. All of the MEDIUM password policy requirements have not been honored.
  C. The password matches a substring Hover as a dictionary word.
  D. The password does not match the validate_passoword_number_count requirement.
  E. There is no dictionary file defined, so password validation cannot work as expected.
  B. All of the MEDIUM password policy requirements have not been honored.

• Question 40:

  Consider the events_% tables in performance Schema.

  Which two methods will clear or reset the collected events in the tables?

  A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;
  B. Using the statement RESET PERFORMANCE CACHE;
  C. Using the statement FLUSH PERFORMANCE CACHE;
  D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current;
  E. Disabling and re-enabling all instruments F. Restarting Mysql
  D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current;
  E. Disabling and re-enabling all instruments F. Restarting Mysql