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-883

Oracle 1z0-883 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
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') '

Skip_Counter: 0 -
Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8

Auto _Position: 1 -
You execute a "SHOW CREATE TABLE mytable" on the slave:
CREATE TABLE mytable (
ID int(11) NOT NULL DEFAULT 0,
name char(10) DEFAULT NULL,
PRIMARY KEY (ID)
)
The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.
Which statement should be used?
  1. A
    SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
  2. B
    SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT=" AUTOMATIC’;
  3. C
    SET GLOBAL enforce_gtid_consistency=ON
  4. D
    SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";
  5. E
    SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

Correct Answer:
A

Question #2
Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?
  1. A
    Only the first partition (p1) will be dropped as only one can be dropped at any time.
  2. B
    All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
  3. C
    A syntax error will result as you cannot specify more than one partition in the same statement.
  4. D
    All data in pi and p3 partitions are removed and the table definition is changed.

Correct Answer:
D
Reference:
https://dev.mysql.com/doc/refman/5.5/en/partitioning-management.html

Question #3
You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2, @count);
ERROR 1449 (HY000): The user specified as a definer (bon@localhost) does not exist
How would you identify all stored procedures that pose the same problem?
  1. A
    Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.
  2. B
    Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.
  3. C
    Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER=’bob@localhost’;.
  4. D
    Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’ and HOST=’ localhost’;.
  5. E
    Examine the Mysql error log for other ERROR 1449 messages.

Correct Answer:
C
The processlist table has only the connected session info. The mysql.proc and information_schema.routines has the SP/routines and functions info including the definer and definition code.

Question #4
When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.
  1. A
    BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.
  2. B
    Multiple BIT columns pack tightly into a row, using less space.
  3. C
    BIT (8) takes less space than eight TINYINT fields.
  4. D
    The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.

Correct Answer:
B

Question #5
ROW-based replication has stopped working. You investigate the error log file and find the following entries:
2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Cant find record in t1, Error_code: 1032; handler error
HA_ERR_KEY_NOT_FOUND; the events master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032
2013-08-27 14:15:47 9056 [warning] Slave: Cant find record in t1 Error_code: 1032
2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 56_master-bin. 000003 position 684
Why did you receive this error?
  1. A
    The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
  2. B
    The table definition on the slave -litters from the master.
  3. C
    Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
  4. D
    The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.

Correct Answer:
D

Next Questions

All Pages