Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 141:

  Examine the structure of the MEMBERS table.

  

  Which query can be used to display the last names and city names only for members from the states MO and MI?

  A. SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
  B. SELECT last_name, city FROM members WHERE state LIKE 'M%';
  C. SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
  D. SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';
  C. SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

• Question 142:

  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? (Choose two.)

  

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

• Question 143:

  Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?

  A. Relating data from a table with data from the same table is implemented with a self join.
  B. An inner join relates rows within the same table.
  C. Rows from unrelated tables cannot be joined.
  D. Implementing a relationship between two tables might require joining additional tables.
  E. Every relationship between the two tables must be implemented in a Join condition.
  A. Relating data from a table with data from the same table is implemented with a self join.
  D. Implementing a relationship between two tables might require joining additional tables.

• Question 144:

  Which three are true about scalar subquery expressions?

  A. A scalar subquery expression that returns zero rows evaluates to zoro
  B. They cannot be used in the values clause of an insert statement*
  C. They can be nested.
  D. A scalar subquery expression that returns zero rows evaluates to null.
  E. They cannot be used in group by clauses.
  F. They can be used as default values for columns in a create table statement.
  C. They can be nested.
  D. A scalar subquery expression that returns zero rows evaluates to null.
  E. They cannot be used in group by clauses.

  ---

  Explanation/Reference:

  Reference: https://docs oracle com/cd/B12037 _01/server.101/b10759/expressions010.htm

• Question 145:

  Which two statements are true about an Oracle database?

  A. A table can have multiple primary keys.
  B. A table can have multiple foreign keys.
  C. A NUMBER column without data has a zero value.
  D. A column definition can specify multiple data types.
  E. A VARCHAR2 column without data has a NULL value.
  B. A table can have multiple foreign keys.
  E. A VARCHAR2 column without data has a NULL value.

• Question 146:

  Examine the description of the BRICKS table;

  

  Examine the description of the BRICKS_STAGE table;

  

  Which two queries execute successfully?

  

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

• Question 147:

  Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

  A. changing the password for an existing database user
  B. connecting to a database instance
  C. querying data from tables in different databases
  D. starting up a database instance
  E. executing operating system (OS) commands in a session
  A. changing the password for an existing database user
  C. querying data from tables in different databases

  ---

  Explanation/Reference:

  References: http://www.techonthenet.com/oracle/password.php https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

• Question 148:

  Examine the description of the SALES1 table:

  

  SALES2 is a table with the same description as SALES1,

  Some sales data is duplicated In both tables.

  You want to display the rows from the SALES1 table Which are not present in the SALIES2 table.

  Which set operator generates the required output?

  A. SUBTRACT
  B. INTERSECT
  C. UNION ALL
  D. MINUS
  E. UNION
  D. MINUS

• Question 149:

  Which two statements execute successfully?

  

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

• Question 150:

  Evaluate these commands Which execute successfully Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

  

  A. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.
  B. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.explicit value is given for ORD_NO.
  C. Column ORD_NO gets the next number from sequence and ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.
  D. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.
  E. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.
  C. Column ORD_NO gets the next number from sequence and ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.
  E. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.