Free Oracle 1z1-882 Exam Dumps Questions & Answers

You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?

• A.  All rows from both tables exist in employeesMAIN.
• B.  An error is produced because you cannot create a TEMPORARY TABLE with a UNION.
• C.  The employees common to both tables exist in employees MAIN.
• D.  A unique list of employees exist in employeesMAIN.

When executing a stored routine, how is the SQL_MODE determined?

• A.  By the current SQL _MODE of the session
• B.  By the default SQL_MODE of the server
• C.  By the SQL_MODE that was set when the routine was defined
• D.  By using TRADITTIONAL regardless of any other settings

The tab-delimited file"/tmp/people,txt contains:
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France
This is the structure of the people table:
Mysq1> DESCRIBE people;

Which statement will load the first and last names into the Names column and the country into the country column?

• A.  LOAD DATA INFILE '/tmp/people.txt 'INTO TABLE People
  (@ Skip, @First , @Last, @Country
  SET Name=CONCAT (@First, ' ',@Last)
• B.  It is not possible to load the data from the file/tmp/people.txt into the people table,as shown.
• C.  LOAD DATA INFILE '/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4
  (CONCAT (@First, ' ',@Last) , @ Country)
• D.  LOAD DATA INFILE '/tmp/people,txt, INTO TABLE People.
  (@Skip. @First, @Last, @Country)
  Country=@country
• E.  LOAD DATA INFILE '/tmp/people.txt ' INTO TABLE People
  @ Skip=$1 , @ First=$2, @Last=$3, @ Country=4,
  (CONCAT (@First, ' ' .@ Last) , @ Country)

You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?

• A.  Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc
• B.  Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
• C.  defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
• D.  defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

In the office table, the city column is structured as shown:
Mysql> show columns from office like 'city'\G
---------------------------------------------------1. row ---------------------__________________
Field: city
Type: enum('paris'.'Amsterdam'.'New York'.'Tokyo')
Null: Yes
Key:
Default:NULL
Extra:
Consider the output of the SELECT query executed on the office table:
Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:
SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR)
In what order are the rows returned?

• A.  Amsterdam, New York, Paris, Tokyo
• B.  Paris, Amsterdam. New York, Tokyo
• C.  Tokyo, New York, Amsterdam, Paris
• D.  Tokyo, Paris, New York, Amsterdam