Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 61:

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

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

• Question 62:

  You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb database.

  The mydb database.

  The mydb t1 table has five rows of data.

  You use the statement below to remove all rows in the t1 table:

  Mysql> TRUNCATE TABLE mysql.t1;

  What is the result?

  A. The command succeeds and o rows are affected.
  B. The command succeeds and five rows are affected.
  C. The command fails owing to syntax error.
  D. The command fails owing to permissions error.
  A. The command succeeds and o rows are affected.

• Question 63:

  Given the data from table t1:

  

  This DELETE command is executed:

  DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;

  Which set of rows will be deleted by the command?

  A. (7,1) and (1,4)
  B. (2,8) and (1,4)
  C. (7,1) and (10,8)
  D. (2,8) and (10,8)
  B. (2,8) and (1,4)

• Question 64:

  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?

  A. The procedure completes, and 15 is returned
  B. The procedure's IF condition is not satisfied, and 0 is returned.
  C. The procedure's loop is not entered, and 1 is returned.
  D. An infinite loop will be running until the command is killed.
  D. An infinite loop will be running until the command is killed.

• Question 65:

  You attempt to create a temporary table by using the following statement:

  CREATE TEMPORARY TABLE employeesMAIN SELECT * FROM employees1 UNION ALL SELECT * FROM employees2;

  What is the result?

  A. An error is produced because you cannot create a TEMPORARY TABLE with a UNION.
  B. The employees common to both tables exist in employees MAIN.
  C. A unique list of employees exist in employeesMAIN.
  D. All rows from both tables exist in employeesMAIN.
  A. An error is produced because you cannot create a TEMPORARY TABLE with a UNION.

• Question 66:

  You have two tables: news_source and news_feed.

  

  Here is some sample data from the news _feed table:

  

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

• Question 67:

  What is true about the contents of the INFORMATION_SCHEMATA table?

  A. It contains information about the table structure for all databases.
  B. It contains information about all the tables, triggers, and views for all databases.
  C. It contains information such as name, character set, and collation for all the databases on the server.
  D. It contains information including tables, trigger, stored routines, and views for all databases
  B. It contains information about all the tables, triggers, and views for all databases.

• Question 68:

  Examine the fruit and wine tables: Fruit

  

  You execute this query:

  SELECT fruited, fruitname FROM fruit

  UNION

  SELECT id, name, country FROM wine;

  What is the result?

  A. The query succeeds and returns five columns of data.
  B. The query succeeds and returns two columns of data.
  C. The query falls because UNION does not work on tables with different number of columns.
  D. The query falls because the number of columns in the SELECT in the SELECT clauses are not equal.
  B. The query succeeds and returns two columns of data.

• Question 69:

  A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown:

  

  You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the effect of adding STRAIGHT JOINs to the query?

  A. The optimizer processes only the JOINs in the sequence listed in the query.
  B. The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.
  C. The optimizer will only JOIN the tables in sequence from smallest to largest.
  D. The optimizer ignores all terms in the WHERE clause until all JOINs have been completed.
  B. The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.

• Question 70:

  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. SELECT 1, 2 FROM Countrylanguage;
  B. SELECT * FROM Counytrylanguage LIMIT 1, 2,
  C. SELECT *{1,2} FROM Countrylanguage;
  D. SELECT * (1), *[2] FROM Counyrylanguage;
  E. It is not possible without using the column names or without using any other tables or queries.
  B. SELECT * FROM Counytrylanguage LIMIT 1, 2,