Free Oracle 1z1-882 Practice Test & Real Exam Questions
Examine this table that contains over two million rows of data:
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?
Correct Answer: B
Vote an answer
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
Correct Answer: A,B,C
Vote an answer
Consider the query and its output:
Mysql> SELECT Language As Lang FROM countrylanguage
->WHERE countrycode ='GBR';
A user wants to have an output as shown:
What query would achieve this?
Mysql> SELECT Language As Lang FROM countrylanguage
->WHERE countrycode ='GBR';
A user wants to have an output as shown:
What query would achieve this?
Correct Answer: A
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Which statement is true about the difference between HASH and BTREE INDEXES?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?
What is the result of the query SELECT @ a?
Correct Answer: C
Vote an answer
Inspect the query:
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';
How can this query be optimized?
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';
How can this query be optimized?
Correct Answer: D
Vote an answer
You have created your connector/Net object to connect to MySQL.
What are three valid database operations you can call?
What are three valid database operations you can call?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than 'max_allowed_packet' bytes
With two scenarios can (Hibernate this error message?
ERROR 1153 (OSSO1): Got a packet bigger than 'max_allowed_packet' bytes
With two scenarios can (Hibernate this error message?
Correct Answer: B,F
Vote an answer
Consider the table t1 created with this statement:
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
After inserting three rows, the table contains:
These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):
Which data set is inserted in the table?
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
After inserting three rows, the table contains:
These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):
Which data set is inserted in the table?
Correct Answer: D
Vote an answer
Inspect the SELECT query:
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';
2 rows in set (0.00 sec)
Which action will optimize the query?
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';
2 rows in set (0.00 sec)
Which action will optimize the query?
Correct Answer: A
Vote an answer
