1Z0-071 practice exam

[PDF and VCE] Free 1Z0-071 VCE and PDF, Exam Materials Instant Download

Attention please! Here is the shortcut to pass your 1Z0-071 exam! Get yourself well prepared for the Oracle Database 1Z0-071 Oracle Database SQL exam is really a hard job. But don’t worry! We We, provides the most update 1Z0-071 practice tests. With We latest 1Z0-071 new questions, you’ll pass the Oracle Database 1Z0-071 Oracle Database SQL exam in an easy way

Visit our site to get more 1Z0-071 Q and As:https://www.thriamdigitomation.com/1z0-071.html (431 QAs Dumps)
Question 1:

Which three statements are true about performing Data Manipulation Language (DML) operations on a view In an Oracle Database?

A. Insert statements can always be done on a table through a view.

B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

C. Views cannot be used to query rows from an underlying table if the table has a PRIPOARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

E. Views cannot be used to add on modify rows in an underlying table if the defining query of the view contains aggregating functions.

F. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values Which are not referenced in the defining query of the view.

Correct Answer: DEF


Question 2:

Which four statements are true about constraints on Oracle tables?

A. A Column can have only one CHECK Constraint.

B. A NOT NULL Constraint can be defined at the table level.

C. A UNIQUE constraint permits NULLS.

D. A PRIMARY KEY Constraint can be added after a table has been created and populated.

E. A CHECK Constraint can refer to values in other rows.

F. A UNIQUE Constraint can use a pre-existing index on the constrained column or columns.

G. A FOREIGN KEY Column can contain NULLS.

Correct Answer: CDFG


Question 3:

Which two queries execute successfully?

A. SELECT NULLIF(100, 100) FROM DUAL

B. SELECT COALESCE(100, NULL, 200) FROM DUAL

C. SELECT NULLIF(100, \’A\’) FROM DUAL

D. SELECT NULLIF(NULL, 100) FROM DUAL

E. SELECT COALESCE(100, \’A\’ ) FROM DUAL

Correct Answer: AB


Question 4:

Which three are true about multiple INSERT statements?

A. They can be performed only by using a subquery.

B. They can be performed on relational tables.

C. They can be performed on views.

D. They can be performed on remote tables.

E. They can be performed on external tables using SQL*Loader.

F. They can insert each computed row into more than one table.

Correct Answer: ABD


Question 5:

Which three statements are true about GLOBAL TEMPORARY TABLES?

A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

B. A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

D. A GLOBAL TEMPORARY TABLE\’s definition is available to multiple sessions.

E. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

F. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Correct Answer: BDF


Question 6:

Which two statements are true about CURRENT_TIMEITAMP?

A. The date is in the time zone of DBTIMEZONE.

B. The value varies depending on the setting of SESSIONTIMEZONE.

C. It returns the same date as CURRENT_DATE.

D. The time is in the time zone of DBTIMEZONE.

E. It returns a value of data type TIMESTAMP

F. It always returns the same value as SYSTIMESTAMP

Correct Answer: DF


Question 7:

Which three are true about granting object privileges on tables, views, and sequences?

A. UPDATE can be granted only on tables and views.

B. DELETE can be granted on tables, views, and sequences.

C. REFERENCES can be granted only on tables and views.

D. INSERT can be granted on tables, views, and sequences.

E. SELECT can be granted only on tables and views.

F. ALTER can be granted only on tables and sequences.

Correct Answer: ACF


Question 8:

Examine the description of the PRODUCTS table Which contains data:

Which two are true?

A. The PROD ID column can be renamed.

B. The PROD_ ID column data type can be changed to VARCHAR2 (2).

C. The EXPIRY DATE column data type can be changed to TIME STAMP.

D. The EXPIRY DATE column cannot be dropped.

E. The PROD NAME column cannot have a DEFAULT clause added to it.

Correct Answer: AC


Question 9:

Which two are true about the WITH GRANT OPTION clause?

A. The grantee can grant the object privilege to any user in the database, with of without including this option.

B. The grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to use this option.

C. It can be used when granting privileges to roles.

D. It can be used for system and object privileges.

E. It cannot be used to pass on privileges to PUBLIC by the grantee.

F. It can be used to pass on privileges to other users by the grantee.

Correct Answer: AF


Question 10:

Which two statements are true about INTERVAL data types

A. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

B. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

C. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

D. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

E. INTERVAL DAY TO SECOND columns support fractions of seconds.

F. INTERVAL YEAR TO MONTH columns support yearly intervals.

Correct Answer: EF


Question 11:

Which three statements are true about a self join?

A. It must be an inner join.

B. It can be an outer join.

C. The ON clause must be used.

D. It must be an equation.

E. The query must use two different aliases for the table.

F. The ON clause can be used.

Correct Answer: BEF


Question 12:

Which two statements are true about Oracle synonyms?

A. A synonym can have a synonym.

B. A synonym has an object number.

C. Any user can create a public synonym.

D. All private synonym names must be unique in the database.

E. A synonym can be created on an object in a package.

Correct Answer: AB


Question 13:

The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number.

Which two queries execute successfully?

A. SELECT TO_CHAR(NVL(cust_credit_limit * .15,\’Not Available\’)) FROM customers;

B. SELECT NVL2(cust_credit_limit * .15,\’Not Available\’) FROM customers;

C. SELECT NVL(cust_credit_limit * .15,\’Not Available\’) FROM customers;

D. SLECT NVL(TO_CHAR(cust_credit_limit * .15),\’Not available\’) from customers;

E. SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),\’NOT Available\’) FROM customers;

Correct Answer: DE


Question 14:

Which statement is true about aggregate functions?

A. The AVG function implicitly converts NULLS to zero

B. The MAX and MIN functions can be used on columns with character data types

C. Aggregate functions can be used in any clause of a SELECT statement

D. Aggregate functions can be nested to any number of levels

Correct Answer: B


Question 15:

Which three statements are true about defining relations between tables in a relational database?

A. Foreign key columns allow null values.

B. Unique key columns allow null values

C. Primary key columns allow null values.

D. Every primary or unique key value must refer to a matching foreign key value.

E. Every foreign key value must refer to a matching primary or unique key value.

Correct Answer: ABE


Visit our site to get more 1Z0-071 Q and As:https://www.thriamdigitomation.com/1z0-071.html (431 QAs Dumps)