Online Access Free 1z1-071 Exam Questions

Which two statements are true about single row functions?

• A.MOD: returns the quotient of a division operation
• B.CONCAT: can be used to combine any number of values
• C.TRUNC: can be used with NUMBER and DATE values
• D.CEIL: can be used for positive and negative numbers
• E.FLOOR: returns the smallest integer greater than or equal to a specified number

Which two are true about queries using set operators such as UNION?

• A.Queries using set operators do not perform implicit conversion across data type groups (e.g. character, numeric)
• B.CHAR columns of different lengths used with a set operator retum a vAacsua mhtoe e equals the longest CHAR value.
• C.In a query containing multiple set operators INTERSECT always takes precedence over UNION and UNION ALL
• D.All set operators are valid on columns all data types.
• E.An expression in the first SELECT list must have a column alias for the expression

Examine the description of the countries table:

Examine the description of the departments table:

Examine the description of the locations table:

Which two queries will return a list of countries with no departments?

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

Which three statements are true about Data Manipulation Language (DML)?

• A.delete statements can remove multiple rows based on multiple conditions.
• B.insert into. . .select. . .from statements automatically commit.
• C.DML statements require a primary key be defined on a table.
• D.insert statements can insert nulls explicitly into a column.
• E.update statements can have different subqueries to specify the values for each updated column.

Which two queries execute successfully?

• A.SELECT * FROM products
  UNION
  SELECT * FROM new_products;
• B.SELECT prod_id, prod_name FROM products
  INTERSECT
  SELECT 100, prod_name FROM newproducts;
• C.SELECT prod_id, exp_date FROM products
  UNION ALL
  SELECT prod_id, NULL FROM new_products;
• D.SELECT prod_id FROM products
  UNION ALL
  SELECT prod_id, prod_name FROM new_products;
• E.SELECT k FROM products
  MINUS
  SELECT prod_id FROM new_products;