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. 1)

  • 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 #1
The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than max_allowed_packet bytes
With two scenarios can (Hibernate this error message?
  1. A
    The application tried to INSERT a row that exceeded max_allowed_packet.
  2. B
    The network caused an error Inducing the max_allowed_packet error.
  3. C
    The application did not use the COMPRESS () function for a large result set.
  4. D
    The application tried to SELECT many rows together that exceeded max__allowed_packet.
  5. E
    The application tried to SELECT a row that exceeded max_allowed_packet.
  6. F
    The operating system caused an error inducing the max_allowed_packet error.

Correct Answer:
AF

Question #2
Which two Functions can be used in a C program to retrieve information about warning?
  1. A
    mysql_info
  2. B
    mysql_error
  3. C
    mysql_warning_count
  4. D
    mysql_errno

Correct Answer:
AC
http://dev.mysql.com/doc/refman/5.6/en/c-api-function-overview.html

Question #3
You wish to create a trigger on the ‘city’ table that will check the value of the ‘District’ field before any INSERT. The trigger needs to change it to" Unknown" for an empty string or NULL.

CREATE TRIGGER City_bi -

BEFORE INSERT ON CITY -

FOR EACH ROW -

BEGIN -
IF OLD. District IS NULL OR OLD.District= . .

THEN -
SET NEW.District=Unknown;
END IF :
END;
Does the CREATE TRIGGER statement accomplish this goal?
  1. A
    Yes; the trigger works correctly.
  2. B
    No; FOR EACH ROW is invalid syntax.
  3. C
    No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT….
  4. D
    No; the OLD keyword cannot be used in an INSERT trigger.

Correct Answer:
D

Question #4
The tab-delimited file"/tmp/people,txt contains:
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France

This is the structure of the people table:
Mysq1> DESCRIBE people;

Which statement will load the first and last names into the Names column and the country into the country column?
  1. A
    LOAD DATA INFILE ‘/tmp/people.txt’INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4 (CONCAT (@First, ‘ ‘,@Last) , @ Country)
  2. B
    LOAD DATA INFILE /tmp/people.txt INTO TABLE People @Skip=$1 , @ First=$2, @Last=$3, @ Country=4, (CONCAT (@First, .@ Last) , @ Country)
  3. C
    LOAD DATA INFILE /tmp/people.txt INTO TABLE People (@ Skip, @First , @Last, @Country SET Name=CONCAT (@First, ,@Last)
  4. D
    LOAD DATA INFILE /tmp/people,txt, INTO TABLE People. (@Skip. @First, @Last, @Country) Country=@country
  5. E
    It is not possible to load the data from the file/tmp/people.txt into the people table, as shown.

Correct Answer:
C

Question #5
What are two ways in which normalizing your tables helps improve performance In MySQL?
  1. A
    Smaller table sizes and row lengths improve sorting operations.
  2. B
    Separate tables allow indexing more columns.
  3. C
    Fewer nullable column improve index usage.
  4. D
    Normalizing Improves the performance of innodb_file_per _table.

Correct Answer:
D

Next Questions

All Pages