Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-071

Free Oracle 1Z0-071 Exam Braindumps (page: 15)

Page 15 of 95
PDF with 380 Questions

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables.


Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Answer(s): C



Which three statements are correct regarding indexes? (Choose three.)

  1. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to create a unique index.
  2. Indexes should be created on columns that are frequently referenced as part of any expression.
  3. When a table is dropped, corresponding indexes are automatically dropped.
  4. For each DML operation performed on a table, the corresponding indexes are automatically updated if required.

Answer(s): A,C,D


Reference:

http://viralpatel.net/blogs/understanding-primary-keypk-constraint-in-oracle/



View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.


You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:

SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;

The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

  1. The table prefix is missing for the column names in the SELECT clause.
  2. The NATURAL JOIN clause is missing the USING clause.
  3. The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
  4. The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.

Answer(s): D

Explanation:

Natural join needs only one column to be the same in each table. The EMPLOYEES and DEPARTMENTS tables have two columns that are the same (Department_ID and Manager_ID)



Which two statements are true about sequences created in a single instance Oracle database? (Choose two.)

  1. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
  2. DELETE <sequencename> would remove a sequence from the database.
  3. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
  4. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
  5. When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Answer(s): A,D


Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2012.htm#SQLRF00817 https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm



Viewing page 15 of 95
Viewing questions 57 - 60 out of 380 questions



Post your Comments and Discuss Oracle 1Z0-071 exam prep with other Community members:

1Z0-071 Exam Discussions & Posts