Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-882

Oracle 1z0-882 Exam Practice Questions (P. 2)

  • Full Access (100 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
You create a table and a stored procedure:
CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()

BEGIN -
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;

REPEAT -
FETCH cur INTO va1;

IF NOT done THEN -
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;

END -
CALL sum_t1();
What is the result of the CALL statement?
  1. A
    The procedure completes, and 15 is returned
  2. B
    The procedure’s IF condition is not satisfied, and 0 is returned.
  3. C
    The procedure’s loop is not entered, and 1 is returned.
  4. D
    An infinite loop will be running until the command is killed.

Correct Answer:
D

Question #7
A floating- point column defined as FLOAT(7,5)allows___________
  1. A
    7 digits to the left of the decimal point and 5 digits to the right
  2. B
    5 digits to the left of the decimal point and 7 digits to the right
  3. C
    7 digits in total, of which 5 are to the right of the decimal point
  4. D
    7 digits in total, of which 5 are to the left of the decimal point

Correct Answer:
C

Question #8
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?
  1. A
    SHOW ERRORS
  2. B
    Error 1215
  3. C
    SHOW ENGINE INNODB STATUS
  4. D
    SELECT FROM information_schema.INNODB_SYS_FOREIGN

Correct Answer:
A
Reference:
http://zeering.com/LoadAnswers.aspx?q=Foreign%20Key%20constraint
(see update)

Question #9
Identity two ways to configure a PHP application to use the UTF8 character set.
  1. A
    mysqli: :query (‘’SET NAMES utfs’’);
  2. B
    mysqli : :set_charset (‘utf8’)
  3. C
    spdo = new PDO (‘’mysql:host=localhost;dbname=test;charset=utfs’’, user’’, ‘’pass’’);
  4. D
    PDO: :set_charset(‘’utf8’’)

Correct Answer:
B
Reference:
http://stackoverflow.com/questions/5842980/a-permanent-way-of-doing-mysqli-set-charset

Question #10
The data from t1 table is:

Assuming You want to see this output:

Which query achieves the preceding result?
  1. A
    SELECT name FROM t1 WHERE name LIKE ,_e%
  2. B
    SELECT name FROM t1 WHERE name LIKE,e%.;
  3. C
    SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
  4. D
    SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

Correct Answer:
C

Previous Questions Next Questions

All Pages