Latest Oracle 1z0-071 Actual Free Exam Questions & Community Discussion, Page 6

Question #66

Which three statements are true about single-row functions?

A. They can be nested to any level.

B. The data type returned can be different from the data type of the argument.

C. They can accept only one argument.

D. They can be used only in the WHERE clause of a SELECT statement.

E. The argument can be a column name, variable, literal or an expression.

F. They return a single result row per table.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #67

Examine this statement:

Which two statements are true?

A. The names of employees maximum salary will appear fist to ascending order

B. The names of employees remaining the maximum salary will appear first in an ascending order

C. All remaining employee names will appear in an ascending order

D. The names of employees maximum salary will appear fist to descending order

E. All remaining employee names will appear in descending order

F. All remaining employee names will appear in ascending order

Discussion 0

Correct Answer: D,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #68

Which three statements are true about indexes and their administration in an Oracle database?

A. A DROP INDEX statement always prevents updates to the table during the drop operation

B. A UNIQUE and non-unique index can be created on the same table column

C. A descending index is a type of function-based index

D. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

E. If a query filters on an indexed column then it will always be used during execution of the query

F. An index can be created as part of a CREATE TABLE statement.

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #69

Which three are true about system and object privileges

A. Adding a foreign key constraint pointing to a table in another schema requires the REFERENCEs object privilege

B. Revoking a system privilege that was granted with the WITH ADMIN OPTION has a cascading effect.

C. Adding a primary key constraint to an existing table in another schema requires a system privilege

D. WITH GRANT OPTION can be used when granting an object privilege to both users and roles

E. WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

F. Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect

Discussion 0

Correct Answer: A,D,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #70

Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

A. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.

B. EXPIRY_ DATE cannot be used in arithmetic expressions.

C. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.

D. PRODUCT_ NAME cannot contain duplicate values.

E. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

F. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

Discussion 0

Correct Answer: B,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #71

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

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

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

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

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

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

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

Discussion 0

Correct Answer: B,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #72

Which three are true about the CREATE TABLE command?

A. The owner of the table should have space quota available on the tablespace where the table is defined.

B. A user must have the CREATE ANY TABLE privilege to create tables.

C. It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

D. It implicitly rolls back any pending transactions.

E. It implicitly executes a commit.

F. The owner of the table must have the UNLIMITED TABLESPACE system privilege.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #73

Which two statements execute successfully?

A. SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE
=AMERICAN' ) FROM DUAL;

B. SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI')) FROM DUAL

C. SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')
FROM DUAL

D. SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI')) FROM DUAL;

E. SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE = AMERICAN') FROM DUAL;

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #74

Examine these requirements:
1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used?

A. SELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;

B. SELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;

C. SELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;

D. SELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #75

Which four statements are true about constraints on Oracle tables?

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

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

C. A FOREIGN KEY Column can contain NULLS.

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

E. A Column can have only one CHECK Constraint.

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

G. A UNIQUE constraint permits NULLS.

Discussion 0

Correct Answer: A,B,C,G Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #76

The PROD_ID column is the foreign key in the SALES table.Which references the PRODUCTS table.
Similarly,the CUST_ID and TIME_ID columns are Also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales(prod_id, I cust_id, order_date DEFAULT SYSDATE)
AS SELECT I prod_id,cust_id,time_id FROM sales.
Which statement is true regarding the above command?

A. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

C. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

D. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause I do not match.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #77

Which statement is true about TRUNCATE and DELETE?

A. You can never TRUNCATE a table if foreign key constraints will be violated.

B. For tables with multiple indexes and triggers is faster than TRUNCATE.

C. For large tables TRUNCATE is faster than DELETE.

D. You can never tows from a table if foreign key constraints will be violated.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #78

Which three statements are true about single row functions?

A. They can be nested to any level.

B. They can accept only one argument.

C. The date type returned can be different from the data type of the argument.

D. They can be used only in the where clause of a select statement.

E. The argument can be a column name, variable, literal or an expression.

F. They return a single result row per table.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1z0-071 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-071 Demo