Online Access Free 1z0-071 Exam Questions

You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

• A.INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.
• B.INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.
• C.INSERT INTO rate_list VALUES (0.999) produces an error.
• D.INSERT INTO rate_list VALUES (-10) produces an error.
• E.INSERT INTO rate_list VALUES (0.551) inserts the value as .55.
• F.INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

Examine the description products table:

Examine the description of the new_projects table;

Which two queries execute successfully?

• A.
• B.
• C.
• D.
• E.

Which two are true about creating tables in an Oracle database?

• A.A create table statement can specify the maximum number of rows the table will contain.
• B.A primary key constraint is manadatory.
• C.Creating an external table will automatically create a file using the specified directory and file name.
• D.A system privilege is required.
• E.The same table name can be used for tables in different schemas.

Which two statements are true about conditional INSERT ALL?

• A.A single WHEN condition can be used for multiple INTO clauses.
• B.The total number of rows inserted is always equal to the number of rows returned by the subquery
• C.It cannot have an ELSE clause.
• D.Each row returned by the subquery can be inserted into only a single target table.
• E.Each WHEN condition is tested for each row returned by the subquery.

Examine this statement which executes successfully:
Which statement will violate the CHECK constraint?

• A.DELETE FROM emp80
  WHERE department_id=90;
• B.SELECT *
  FROM emp80
  WHERE department_id=90;
• C.SELECT *
  FROM emp80
  WHERE department_id=80;
• D.UPDATE emp80
  SET department_id=90
  WHERE department_id=80;