1Z0-071 pdf

Pass Guarantee 1Z0-071 Exam By Taking New 1Z0-071 VCE And PDF Braindumps

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 exam dumps. With We latest 1Z0-071 pdf dumps, 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.geekcert.com/1z0-071.html (431 QAs Dumps)
Question 1:

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?

A. Only the primary key can be defined at the column and table level.

B. The foreign key columns and parent table primary key columns must have the same names.

C. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

D. A table can have only one primary key but multiple foreign keys.

E. Primary key and foreign key constraints can be defined at both the column and table level.

F. A table can have only one primary key and one foreign key.

G. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

Correct Answer: CDEG


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 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 6:

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

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 8:

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

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 10:

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 11:

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 12:

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 13:

Which two statements are true about the COUNT function?

A. It can only be used for NUMBER data types.

B. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column

C. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

D. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

E. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

Correct Answer: BC


Question 14:

In Which three situations does a new transaction always start?

A. When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B. When issuing a CREATE INDEX statement after a CREATE TABLE statement completed unsuccessfully in the same session

C. When issuing a TRUNCATE statement after a SELECT statement was issued in the same session

D. When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

E. When issuing the first Data Manipulation Language (OML) statement after a COMMIT or ROLLBACK statement was issued in the same session

F. When issuing a DML statement after a DML statement filed in the same session.

Correct Answer: ABE


Question 15:

You execute these commands:

CREATE TABLE customers (customer id INTEGER, customer name VARCHAR2 (20));

INSERT INTO customers VALUES (1`Custmoer1 `);

SAVEPOINT post insert;

INSERT INTO customers VALUES (2, \’Customer2 `);

SELECTCOUNT (*) FROM customers;

Which two, used independently, can replace so the query retums 1?

A. ROLLBACK;

B. COMMIT;

C. ROLIBACK TO SAVEPOINT post_ insert;

D. CONOIT TO SAVEPOINT post_ insert;

E. ROLLEBACK TO post_ insert;

Correct Answer: CE


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