Free and Premium Oracle 1z0-882 Dumps Questions Answers

SHOW WARNINGS

GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;

SELECT @errno, @msg;

SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1

SHOW GLOBAL STATUS LIKE ‘Diagnostics’

The general query log file

The syslog on Linux/UNIX or the Event view on windows

The slow query log file

The MYSQL server error log file

The binary log file

The statement exists, but will need to be deallocated and re-created.

The statement exists, but the user variables need to be redefined.

The statement can be used, if the MySQL server hasn’t been restarted.

The statement no longer exists.

DECLARE I INT DEFAULT 0;

Test_loop: LOOP

SET i =i +1;

IF i> =5 THEN

LEAVE test_loop;

END IF;

END LOOP test_loop;

DECLARE i INT DEFAULT 0;

WHILE I < 5ITERATE

SET i = i +1;

END WHILE;

DECLARE i INT DEFAULT 0;

WHILE i < 5 Do

SET i = i + 1;

END WHILE;

DECLARE i INT DEFAULT 0;

Test _loop; LOOP

SET i =i +1;

IF i >=5 THEN LEAVE;

END IF;

END LOOP test_loop;

LOAD DATA INFILE

CREATE TABLE

CREATE VIEW

ALTER VIEW

CALL

(0,0,0) and (0,0,0)

(0,0,0,) and (0,200,300)

(0,NULL,0) and(0,200,300)

(0,NULL,0) and (100,200,300)

‘Casper’ and ‘ undefined values are inserted into the ‘name’ and gender’ column.

The server returns an error indicating that ‘undefined’ cannot be inserted into a column of ENUM type

The server returns a warning and the empty string is inserted to the ‘gender’ column.

The server returns a warning and the first specified value ,”male” is inserted to the gender column.

SELECT DISTINCT last_name, first_name FROM people

SELECT 1,2 FROM people GROUP BY last_name

SELECT first_name, last _name FROM people WHERE age LIKE ‘2’

SELECT 1, 2 FROM people WHERE last _name =’smith’

SELECT first _name, last_name FROM people LIMIT 1, 2

The examinee_id column should be designated as PRIMARY KEY.

A NOT NULL qualifier should be moved from exam-id to examinee-id.

The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).

A NOT NULL qualifier should be added to examinee_id.

A view created with the TEMPTABLE algorithm

A view containing a GROUP BY clause

A view containing a WHERE clause

A view containing a HAVING clause

A view that contains a literal column

Results in an error

Updates every row in the specified table(s)

Results in - -safe-updates being enabled automatically

Causes a syntax error

An error is produced because you cannot create a TEMPORARY TABLE with a UNION.

The employees common to both tables exist in employees MAIN.

A unique list of employees exist in employeesMAIN.

All rows from both tables exist in employeesMAIN.

The query succeeds and returns five columns of data.

The query succeeds and returns two columns of data.

The query falls because UNION does not work on tables with different number of columns.

The query falls because the number of columns in the SELECT in the SELECT clauses are not equal.

Option A

Option B

Option C

Option D

SELECT * may cause more data than you need to be read from disk if your application needs only some columns.

SELECT * causes more data than you need to be sent via the client/server protocol if your application needs only some columns.

SELECT * prevents the use of indexes, so a full table scan for every query.

SELECT *causes your application to depend on the columns present when you wrote it , so your application could break if the table structure changes.

SELECT * causes the statements to return all rows from the table.