Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 21:

  Assume your connection uses SQL mode ANSI_QUOTES. Which two statements cause a syntax error?

  A. CREATE TABLE FRIENDS (NAME CHAR (10))
  B. CREATE TABLE BINARY (PRIMARY SMALLINT)
  C. CREATE TABLE `TABLE' (COLUMN' INTEGER)
  D. CREATE TABLE "CONDITION" ("DESCRIBE" TEXT)
  E. CREATE TABLE INTERVAL (ELAPSED_TIME TIME)
  A. CREATE TABLE FRIENDS (NAME CHAR (10))
  B. CREATE TABLE BINARY (PRIMARY SMALLINT)

• Question 22:

  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 ERRORS
  B. Error 1215
  C. SHOW ENGINE INNODB STATUS
  D. SELECT FROM information_schema.INNODB_SYS_FOREIGN
  C. SHOW ENGINE INNODB STATUS

• Question 23:

  Consider the CREATE FUNCTION statement:

  CREATE FUNCTION countrycount ()

  BEGIN

  DECLARE count INT;

  SELECT COUNT (*) INTO count FROM country;

  RETURN count ;

  END

  What is the outcome when you try to create the function?

  A. An error results as the SELECT must assign the return values to a user variable.
  B. An error results as the count variable is not initialized with a value.
  C. An error result as the function must be defined with the CONTAINS SQL clause.
  D. An error result as the variable type returned by the function must be defined with a RETURNS clause.
  D. An error result as the variable type returned by the function must be defined with a RETURNS clause.

• Question 24:

  In MYSQL 5.6 you have the table t1:

  CREATE TABLE t1 (

  id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;

  There are two connections to the server. They execute in this order:

  Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Connection 1> START TRANSACTION;

  Connection 1> SELECT * FROM t1 WHERE id =1;

  Connection 2> TRUNCATE TABLE t1;

  What happens to the TRUNCATE TABLE command in connection 2?

  A. It immediately proceeds and causes an implicit commit of the transaction in connection1.
  B. It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1 table.
  C. It blocks waiting for a metadata lock until the transaction in connection 1 ends.
  D. It blocks waiting for a table lock until the transaction in connection 1 ends.
  A. It immediately proceeds and causes an implicit commit of the transaction in connection1.

• Question 25:

  Consider the structures of the country and countrylanguage tables. mysql >DESCRIBE country;

  

  mysql> DESCRIBE countrylanguage;

  

  Which query will give you the list of all European countries where German is spoken?

  A. SELECT Code AS c, Name FROM Country WHERE Continent = `Europe' AND EXISTS ( SELECT * FROM CountryLanguage WHERE CountryCode = Code And Language= `German' )
  B. SELECT Code AS c, Name FROM Country WHERE Continent = `Europe' AND Name IN ( SELECT * FROM CountryLanguage WHERE CountryCode = Code AND Language ='German' )
  C. SELECT Code AS c, Name FROM Country WHERE Continent = ` Europe' AND EXIST ANY ( SELECT Language, CountryCode FROM CountryLanguage WHERE CountryCode =Code AND Language = `German' )
  D. SELECT Code AS c, Name FROM Country WHERE Continent = `Europe' AND ( SELECT * FROM CountryLanguage WHERE CountryCode =Code AND Language ='German' )
  C. SELECT Code AS c, Name FROM Country WHERE Continent = ` Europe' AND EXIST ANY ( SELECT Language, CountryCode FROM CountryLanguage WHERE CountryCode =Code AND Language = `German' )

• Question 26:

  The contents of the parent and child tables are:

  

  The child table has the parent_id column that has a foreign key constraint to the id column of the parent table with ON DELETE CASCADE clause. Consider the command WHERE id =1;

  What is the effect of the above command?

  A. It does not delete anything from any table but returns an error.
  B. It deletes one row from the parent table but does not affect the child table.
  C. It deletes one row from the parent table and two rows from the child table.
  D. It deletes one row from the parent table and sets the parent _id column to NULL in the child.
  A. It does not delete anything from any table but returns an error.

• Question 27:

  Consider the table structure shown by this output: Mysql> desc city:

  

  5 rows in set (0.00 sec)

  You execute this statement:

  SELECT -,-, city. * FROM city LIMIT 1

  What is returned?

  A. An error message
  B. One row with 5 columns
  C. One row with 10 columns
  D. One row with 15 columns
  A. An error message

• Question 28:

  You have two test tables:

  

  Code_innodb as InnoDB engine

  

  Code_ myisam as MYISAM engine The tables have the same structure:

  

  The tables have one row of data:

  

  You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:

  mysql> INSERT INTO code_innodb VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie,),(4, `Delta'); ERROR 1062 (23000): Duplicate entry `3' for key `PRIMARY'

  Mysql> INSERT INTO code_myisam VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie'), (4, `Delta'); ERROR 1062 (23000); Duplicate entry `3' for key `PRIMARY'

  What is the expected output of the SELECT statements?

  

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

• Question 29:

  Which statement is true when working with PHP and prepared statement?

  A. The mysql extension supports only client-side emulation.
  B. The mysql1 extension support client-side emulation.
  C. The PDO_MySQL extension supports both client side and server side emulation.
  D. The PDO_MySQL extension supports only server side emulation.
  C. The PDO_MySQL extension supports both client side and server side emulation.

• Question 30:

  Which three connector/J connection strings can be used to connect to the MYSQL server?

  A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx
  B. Jdbc :mysqli://localhost/test?user=xxxandpassword=xxx
  C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx
  D. Jdbc:mysql:proxy://localhost/test?user=xxxandpassword=xxx
  E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx
  A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx
  C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx
  E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx