Oracle 1Z0-071 Quiz 55 Topic 7 Questions 271-275

Question: 1

Evaluate the following ALTER TABLE statement:

ALTER TABLE orders

SET UNUSED (order_date);

Which statement is true?

AAfter executing the ALTER TABLE command, a new column called ORDER_DATE can be added to the ORDERS table.

BThe ORDER_DATE column must be empty for the ALTER TABLE command to execute successfully.

CROLLBACK can be used to restore the ORDER_DATE column.

DThe DESCRIBE command would still display the ORDER_DATE column.

Show Answer

Question: 2

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?

AIt would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.

BIt would remain disabled and has to be enabled manually using the ALTER TABLE command.

CIt would be automatically enabled and immediate.

DIt would be automatically enabled and deferred.

Show Answer

Question: 3

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

AThe minimum column width that can be specified for a varchar2 data type column is one.

BOnly one LONG column can be used per table.

CA TIMESTAMP data type column stores only time values with fractional seconds.

DThe BLOB data type column is used to store binary data in an operating system file.

EThe value for a CHAR data type column is blank-padded to the maximum defined column width.

Show Answer

Question: 4

Examine the structure of the MEMBERS table.

q4_1Z0-071

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

ASELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

BSELECT last_name, city FROM members WHERE state LIKE 'M%';

CSELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

DSELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';

Show Answer

Question: 5

Which statement is true about an inner join specified in a query's WHERE clause?

AIt only applies for equijoin conditions.

BIt applies for equijoin and nonequijoin conditions.

CIt requires column names to be the same in all tables being joined.

DIt must have primary-key and foreign-key constraints defined on the join columns.

Show Answer

Oracle 1Z0-071 Quiz:55 Topic:7 Questions:271-275