2018 CertQueen Oracle 1Z0-061 Exam Dumps

1. www.certqueen.com Full version: 339 Q&As https://www.certqueen.com/1Z0-061.html Share Oracle 1Z0-061 Questions and Answers Below. 1.Which three statements are true about the ALTER TABLE …. DROP COLUMN …. command? A. A column can be dropped only if it does not contain any data. B. A column can be dropped only if another column exists in the table. C. A dropped column can be rolled back. D. The column in a composite PRIMARY KEY with the CASCADE option can be dropped. E. A parent key column in the table cannot be dropped. Answer: B,D,E Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

2. www.certqueen.com 2.You want to write a query that accepts user input for columns and conditions every time it is executed.The user needs to be promoted only once for the table input.Which query provides the required result? A. SELECT &col1, col2FROM &&tableWHERE &condition = &cond; B. SELECT &col1, col2FROM “&&table”WHERE &condition = &cond; C. SELECT &col1, col2FROM &&tableWHERE &condition = &&cond; D. SELECT &col1, ‘col2’FROM &tableWHERE &&condition = ‘&cond’; Answer: A 3.What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models? A. OODB supports multiple objects in the same database, whereas RDB supports only tables. Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

3. www.certqueen.com B. RDB supports E.F. Codd’s rules, whereas OODB does not support them. C. OODB incorporates methods with data structure definition, whereas RDB does not allow this. D. RDB allows the definition of relationships between different tables, whereas OODB does not allow this. Answer: C 4.Which two statements are true regarding savepoints? (Choose two.) A. Savepoints are effective only for COMMIT. B. Savepoints may be used to ROLLBACK. C. Savepoints can be used for only DML statements. D. Savepoints are effective for both COMMIT and ROLLBACK. E. Savepoints can be used for both DML and DDL statements. Answer: B,C Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

4. www.certqueen.com 5.Which statement is true regarding transactions? (Choose all that apply.) A. A transaction can consist only of a set of DML and DDL statements. B. A part or an entire transaction can be undone by using ROLLBACK command. C. A transaction consists of a set of DML or DCL statements. D. A part or an entire transaction can be made permanent with a COMMIT. E. A transaction can consist of only a set of queries or DML or DDL statements. Answer: B,C 6.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.) A. DELETE can be used to remove only rows from only one table at a time. B. DELETE can be used to remove only rows from multiple tables at a time. Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

5. www.certqueen.com C. DELETE can be used only on a table that is a parent of a referential integrity constraint. D. DELETE can be used to remove data from specific columns as well as complete rows. E. DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule. Answer: A,E 7.Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.) A. It locks only the columns specified in the SELECT list. B. It locks the rows that satisfy the condition in the SELECT statement. C. It can be used only in SELECT statements that are based on a single table. D. It can be used in SELECT statements that are based on a single or multiple tables. Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

6. www.certqueen.com E. After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued. Answer: B,D 8.Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses. B. Main query and subquery can get data from different tables. C. Main query and subquery must get data from the same tables. D. Subqueries can contain ORDER BY but not the GROUP BY clause. E. Only one column or expression can be compared between the main query and subquery. F. Multiple columns or expressions can be compared between the main query and subquery. Answer: A,B,F Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

7. www.certqueen.com 9.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.) A. The HAVING clause can be used with aggregate functions in subqueries. B. The WHERE clause can be used to exclude rows after dividing them into groups. C. The WHERE clause can be used to exclude rows before dividing them into groups. D. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query. E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table. Answer: A,C 10.Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.) A. finding the remainder of a division Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html

8. www.certqueen.com B. adding a number to a date for a resultant date value C. comparing two expressions to check whether they are equal D. checking whether a specified character exists in a given string E. removing trailing, leading, and embedded characters from a character string Answer: A,C,D Get full 1Z0-061 Exam Version: https://www.certqueen.com/1Z0-061.html