Free Oracle 1z0-882 Exam Dumps Questions & Answers

Which two Functions can be used in a C program to retrieve information about warning?

• A.mysql_errno
• B.mysql_error
• C.mysql_warning_count
• D.mysql_info

Consider the my_table table with two integer columns, a and b, and the contents as shown;
Mysql > SELECT a, b FROM my_table;

1 row in set result of this query?
SELECT a-b
FROM my_table;

• A.2
• B.An error message
• C.0
• D.4

Inspect the CREATE TABLE below:
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
Query Ok, 0 rows affected, 2 warnings (0.11 sec)
Mysql> SHOW WARNINGS;

Which two is true connecting the meaning of the warnings?

• A.Global variable skip _innodb was set to ON after the server had started.
• B.Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB
• C.The InnoDB storage engine was disabled during server startup.
• D.MYSQL server was not started with the option default -storage -engine=InnoDB
• E.The default storage engine MYISAM was used for the table created.

Examine the fruit and wine tables:
Fruit

You execute this query:
SELECT fruited, fruitname FROM fruit
UNION
SELECT id, name, country FROM wine;
What is the result?

• A.The query falls because UNION does not work on tables with different number of columns.
• B.The query falls because the number of columns in the SELECT in the SELECT clauses are not equal.
• C.The query succeeds and returns five columns of data.
• D.The query succeeds and returns two columns of data.

You have two tables: news_source and news_feed.

Here is some sample data from the news _feed table:

• A.Option A
• B.Option B
• C.Option D
• D.Option C