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: 9)

Page 9 of 95
PDF with 380 Questions

Evaluate the following SQL statements that are issued in the given order:

CREATE TABLE emp
(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,
ename VARCHAR2(15),
salary NUMBER (8,2),
mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no));

ALTER TABLE emp
DISABLE CONSTRAINT emp_emp_no_pk CASCADE;

ALTER TABLE emp
ENABLE CONSTRAINT emp_emp_no_pk;

What would be the status of the foreign key EMP_MGR_PK?

  1. It would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.
  2. It would remain disabled and has to be enabled manually using the ALTER TABLE command.
  3. It would be automatically enabled and immediate.
  4. It would be automatically enabled and deferred.

Answer(s): B



Which three statements are true regarding the data types? (Choose three.)

  1. The minimum column width that can be specified for a VARCHAR2 data type column is one.
  2. Only one LONG column can be used per table.
  3. A TIMESTAMP data type column stores only time values with fractional seconds.
  4. The BLOB data type column is used to store binary data in an operating system file.
  5. The value for a CHAR data type column is blank-padded to the maximum defined column width.

Answer(s): A,B,E



Which three statements are true regarding subqueries? (Choose three.)

  1. Multiple columns or expressions can be compared between the main query and subquery.
  2. Subqueries can contain ORDER BY but not the GROUP BY clause.
  3. Main query and subquery can get data from different tables.
  4. Subqueries can contain GROUP BY and ORDER BY clauses.
  5. Main query and subquery must get data from the same tables.
  6. Only one column or expression can be compared between the main query and subquery.

Answer(s): A,C,D


Reference:

http://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html



Which statement is true regarding the default behavior of the ORDER BY clause?

  1. In a character sort, the values are case-sensitive.
  2. NULL values are not considered at all by the sort operation.
  3. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.
  4. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

Answer(s): A



Viewing page 9 of 95
Viewing questions 33 - 36 out of 380 questions



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

1Z0-071 Exam Discussions & Posts