Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-071

Oracle 1Z0-071 Exam (page: 6)
Oracle Database SQL
Updated on: 31-Aug-2025

Viewing Page 6 of 77
1Z0-071 PDF 380 Questions

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

  1. second normal form
  2. first normal form
  3. third normal form
  4. fourth normal form

Answer(s): A


Reference:

https://blog.udemy.com/database-normal-forms/



Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.

Which set operator generates the required output?

  1. INTERSECT
  2. UNION
  3. PLUS
  4. MINUS
  5. SUBTRACT

Answer(s): D


Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm



Evaluate the following ALTER TABLE statement:

ALTER TABLE orders
SET UNUSED (order_date);

Which statement is true?

  1. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the
    ORDERS table.
  2. The ORDER_DATE column must be empty for the ALTER TABLE command to execute successfully.
  3. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
  4. The DESCRIBE command would still display the ORDER_DATE column.

Answer(s): A



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



Viewing Page 6 of 77



Share your comments for Oracle 1Z0-071 exam with other users:

Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA