1Z0-071 Exam Dumps 2023 Latest Updated 15 Free Questions
Are you looking for free 1Z0-071 exam questions and answers to prepare for the Oracle Database 12c SQL exam in 2023? PassITDump has prepared 1Z0-071 dumps 2023 for you and prepared 15 free 1Z0-071 exam questions to help you easily pass the Oracle 1Z0-071 exam.
PassITDump offers 1Z0-071 exam questions for free: People who want to help prepare for certification have the best chance of success. Make the exam process less intimidating and easier to pass by providing practice questions.
Get started now with the latest 1Z0-071 dumps 2023.
All the following questions are from the latest real 1Z0-071 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 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 3:
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 4:
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 5:
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: ABF
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 two queries execute successfully?
A. SELECT INTERVAL \’1\’ DAY – SYSDATE FROM DUAL;
B. SELECT SYSTIMESTAMP + INTERVAL \’1\’ DAY FROM DUAL;
C. SELECT INTERVAL \’1\’ DAY – INTERVAL \’1\’ MINUTE FROM DUAL;
D. select INTERVAL \’1\’ DAY +INTERVAL \’1\’ MONTH FROM DUAL;
E. SELECT SYSDATE “INTERRVAL \’1\’ DAY FROM DUAL;
Correct Answer: BC
Question 15:
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