Your success in Oracle 1z0-882 is our sole target and we develop all our 1z0-882 braindumps in a way that facilitates the attainment of this target. Not only is our 1z0-882 study material the best you can find, it is also the most detailed and the most updated. 1z0-882 Practice Exams for Oracle 1z0-882 are written to the highest standards of technical accuracy.
Q21. What are two ways in which normalizing your tables helps improve performance In MySQL?
A. Smaller table sizes and row lengths improve sorting operations.
B. Separate tables allow indexing more columns.
C. Fewer nullable column improve index usage.
D. Normalizing Improves the performance of innodb_file_per _table.
Q22. The city table has the following structure:
Consider the statement with an incorrect field name:
PREPARE countryBYID FROM ‘SELECT country FROM city WHERE ID=?,
What happens if a prepared statement named countryByID already exists when the above statement is executed?
A. A duplicate name error will result because a prepared statement with the same name already exists.
B. An unknown column error will result and the old prepared statement definition will remain in effect.
C. An unknown column error will result and no prepared statement named countryByID will exist.
D. A warning will result and the old prepared statement definition will remain in effect.
Q23. Inspect the query:
Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no’d004’;
4 rows in set (0.00 sec)
Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no=’d004’;
2 rows in set (0.00 sec)
Which two statements are true about the EXPLAIN output?
A. All data for the result is read from the indexex.
B. The PRIMARY KEY is used for filtering in both tables.
C. The minimal number of rows possible are read.
D. The dept_manager table has 4 times as many rows than the employees table.
Q24. The people table contains the data as shown:
Which two statements return two rows each?
A. SELECT DISTINCT last_name, first_name FROM people
B. SELECT 1,2 FROM people GROUP BY last_name
C. SELECT first_name, last _name FROM people WHERE age LIKE ‘2’
D. SELECT 1, 2 FROM people WHERE last _name =’smith’
E. SELECT first _name, last_name FROM people LIMIT 1, 2
Q25. You want to load data directly from a file into MYSQL by using the SOURCE command. Which types of data can the file contains to perform this?
A. SQL commands
B. Comma-delimited data
C. Tab-delimited data
D. MyISAM or InnoDB data files
Q26. Which two queries return a value of NULL?
A. SELECT NULL =NULL
B. SELECT NULL is NULL
C. SELECT NULL <= > NULL
D. SELECT 1 > NULL
E. SELECT COUNT (NULL);
Q27. A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.
You execute this query:
SELECT col1 FROM t1 WHERE col1< 100 UNION
SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200
SELECT col1 FROM t1 WHERE col 1 >=900
What is the output?
A. A list of unique values within the ranges of 1-200 and 900-1000
B. A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the range of 900-1000
C. A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000
D. A list of all values, including duplicates, in the ranges of 1-200 and 900-1000
E. An error, because mixing UNION and UNION ALL in the same query is not permitted
Q28. Which statement describes the process of normalizing databases?
A. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
B. Redundant tables are combined into one larger table to simplify the schema design.
C. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
D. Columns that contain repeating data values are split into separate tables to reduce item duplication.
E. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.