Try and practice the latest Oracle : 1z0-882 real questions & answers

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

A floating- point column defined as FLOAT(7,5)allows___________

• A. 5 digits to the left of the decimal point and 7 digits to the right
• B. 7 digits in total, of which 5 are to the left of the decimal point
• C. 7 digits to the left of the decimal point and 5 digits to the right
• D. 7 digits in total, of which 5 are to the right of the decimal point

Assume that the current database has a table with the following structure (the values for the Field column have been
removed for the purpose of this question)
Mysql > DEBS count trylanguage;

How can you select only the first two columns?

• A. It is not possible without using the column names or without using any other tables or queries.
• B. SELECT *{1,2} FROM Countrylanguage;
• C. SELECT * (1), *[2] FROM Counyrylanguage;
• D. SELECT * FROM Counytrylanguage LIMIT 1, 2,
• E. SELECT 1, 2 FROM Countrylanguage;

You have been tasked to create a database that will store a list of all managers and the employees who report directly
to them. The following is stipulated:
No manage is managing more than three people.
No employee can work for more than one manage.
Which of these designs represents a normalized schema that meets the project requirements?

• A. CREATE TABLE 'managers' (
  "id' int(11) NOT NULL AUTO_INCREMENT,
  'manager' varchar (50) DEFAULT NULL ,
  PRIMARY KEY ('id')
  )
  CREATE TABLE "employees' (
  'id' int(11) NOT NULL AUTO _INCREMENT,
  'manager_id' int(11) DEFAULT NULL,
  'employee varchar (25) DEFAULT NULL,
  PRIMARY KEY ('id')
  )
• B. CREATE TABLE 'message' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'manager' varchar(50) DEFAULT NULL,
  PRIMARY KEY ("id')
  )
  CREATE TABLE 'employees' (
  'id int (11) NOT NULL AUTO _INCREMENT,
  'employees' varchar(25) DEFAULT NULL,
  )
• C. CREATE TABLE 'manager'
  'manager' varchar (50) DEFAULT NULL,
  'employee2' varchar (50) DEFAULT NULL,
  'employee' varchar (50) DEFAULT NULL,
  UNIQUE ( 'manager ', 'employee1', 'employee2, 'employee3')
  )
• D. CREATE TABLE 'manager' (
  'manager' varchar (50) DEFAULT NULL,
  'employee_list'varchar (150) DEFAULT NULL,
  )

You try to add a foreign key to the InnoDB table employees:
Mysq1> ALTER TABLE employees ADD FOREIGN KEY (Department_ID) REFERENCES departments (Department_ID);
ERROR 1215 (HY000): cannot add foreign key constraint
Which command will provide additional information about the error?

• A. SHOW ENGINE INNODB STATUS
• B. SHOW ERRORS
• C. SELECT FROM information_schema.INNODB_SYS_FOREIGN
• D. Error 1215