Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 11:

  Identity two ways to configure a PHP application to use the UTF8 character set.

  A. mysqli: :query (`'SET NAMES utfs'');
  B. mysqli : :set_charset (`utf8')
  C. spdo = new PDO (`'mysql:host=localhost;dbname=test;charset=utfs'', user'', `'pass'');
  D. PDO: :set_charset(`'utf8'')
  B. mysqli : :set_charset (`utf8')

• Question 12:

  Which two code samples demonstrate valid methods for working with loops?

  A. 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;
  B. DECLARE i INT DEFAULT 0; WHILE I < 5ITERATE SET i = i +1; END WHILE;
  C. DECLARE i INT DEFAULT 0; WHILE i < 5 Do SET i = i + 1; END WHILE;
  D. DECLARE i INT DEFAULT 0; Test _loop; LOOP SET i =i +1; IF i >=5 THEN LEAVE; END IF; END LOOP test_loop;
  C. DECLARE i INT DEFAULT 0; WHILE i < 5 Do SET i = i + 1; END WHILE;

• Question 13:

  A table country exists with a column Name. A user variable @ limitcount contains the value 20. Which two statements are valid uses of the LIMIT clause?

  A. SELECT Name FROM country LIMIT 100-50
  B. SELECT Name FROM country LIMIT 100,50
  C. SELECT Name FROM country LIMIT 35
  D. SELECT Name FROM country LIMIT @limitcount
  E. SELECT Name FROM country LIMIT RAND ()
  B. SELECT Name FROM country LIMIT 100,50
  C. SELECT Name FROM country LIMIT 35

• Question 14:

  You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted: @old _countryNames with the value of the Name field @old _countryName with the value of the code field

  You may assume that only one row is ever deleted at a time. CREATE TRIGGER Country_ad AFTER DELETE ON Country FOR EACH ROW SET

  

  @old _CountryName= NEW.Name,

  

  @ old _CountryCode=NEW.Code;

  What is the outcome of the CREATE TRIGGER statement?

  A. The trigger will be created successfully.
  B. An error results because the NEW keyword cannot be used in a DELETE trigger.
  C. An error results because FOR EACH ROW is invalid syntax.
  D. An error results because a BEGIN. . .END block is required.
  C. An error results because FOR EACH ROW is invalid syntax.

• Question 15:

  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;

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

• Question 16:

  Given the table City:

  SELECT Name FROM City WHERE CountryCode = `USA" OR WHERE CountryCode= `JPN'

  What does this statement procedure?

  A. A single result set with one column that contains the names of cities from country codes USA and JPN.
  B. Two result sets each containing a single column with the names of cities from country codes USA and JPN.
  C. A single result set with two columns containing the names from country codes USA and JPN.
  D. No result set is returned and an error message is given.
  A. A single result set with one column that contains the names of cities from country codes USA and JPN.

• Question 17:

  You attempt to create two new tables:

  CREATE TABLE `warehouse' (

  `id' int (11) NOT NULL AUTO_INCREMENT,

  `name' varchar (20) NOT NULL,

  `phone' varchar (20) NOT NULL,

  PRIMARY KEY (` id)

  ) ENGINE=MyISAM

  CREATE TABLE `warehouseitem' (

  `warehouse_id' bigint (11) NOT NULL,

  `item_id' int (11) NOT NULL,

  `count' int(11) NOT NULL DEFAULT `0',

  KEY "warehouse_id' (`warehouse-id) ,

  FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id) ) ENGINE= InnoDB You get this error :

  ERROR 1215 ( HYooo): cannot add foreign key constraint

  Which two changes are required to permit these statements to execute without any error?

  A. The `warehouseitem' table must be managed by the MySAm storage engine.
  B. The `warehouse-table must be managed by the InnoDB storage engine.
  C. The foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES (warehouse- id).
  D. The data types of the `warehouse'.'id' and ` warehouseitem.warehouse_is columns must match.
  E. The warehouse_id' column must be renamed `id' to match the definition on the `warehouse' table.
  F. A UNIQUE key must be defined for the columns (`item_id','warehouse_id').
  C. The foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES (warehouse- id).
  D. The data types of the `warehouse'.'id' and ` warehouseitem.warehouse_is columns must match.

• Question 18:

  You have two tables:

  CREATE TABLE department ( Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY, Department _Name varchar(12) NOT NULL ) ENGINE=InnoDB CREATE TABLE employee ( Employee_Number int unsigned NOT NULL PRIMARY KEY, Employee_Name varchar(10) NOT NULL, Department_ID int unsigned DEFAULT NULL, FOREIGN KEY (Department ID) REFERENCES Department (Department_ID) ON UPDATE SET NULL ON DELETE CASCADE ) ENGINE= InnoDB The tables have the data: Department

  

  You execute the statement:

  REPLACE INTO department (Department_ID, Department_Name) VALUES (1, `Admin');

  What data is in the employee table after the statement?

  

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

• Question 19:

  Which condition must be true in order that a view is considered updateable?

  A. The user must have the UPDATE or DELETE privilege for the underlying table.
  B. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.
  C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.
  D. The view must only refer to literal values.
  C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

• Question 20:

  As a developer, you inherit this table as part of a project:

  CREATE TABLE exam (

  Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,

  Examinee_id INTEGER UNSIGNED UNIQUE,

  Score INTEGER UNSIGNED

  )

  What change should you make to ensure that examinee_id is an integer value throughout the table?

  A. The examinee_id column should be designated as PRIMARY KEY.
  B. A NOT NULL qualifier should be moved from exam-id to examinee-id.
  C. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).
  D. A NOT NULL qualifier should be added to examinee_id.
  A. The examinee_id column should be designated as PRIMARY KEY.