Create Next App

Exam contains 287 questions

Page 4 of 48

Question 19 🔥

Which four are types of functions available in SQL? (Choose 4)

Which database solution meets these requirements?

Discussion of the question

Question 20 🔥

Which two statements are true about WHERE and HAVING clauses? (Choose two)

Which database solution meets these requirements?

A. A WHERE clause can be used to restrict both rows and groups.

Highly voted

B. A WHERE clause can be used to restrict rows only.

Highly voted

C. A HAVING clause can be used to restrict both rows and groups.

Highly voted

D. A HAVING clause can be used to restrict groups only.

Highly voted

E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

Highly voted

F. A HAVING clause CANNOT be used in sub queries.

Highly voted

Discussion of the question

Question 21 🔥

EMPLOYEES and DEPARTMENTS data:EMPLOYEES -DEPARTMENTS -On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.On the DEPARTMENTS table DEPARTMENT_ID is the primary key.Evaluate this UPDATE statement.UPDATE employees -SET mgr_id =(SELECT mgr_idFROMemployees -WHERE dept_id=(SELECT department_idFROM departments -WHERE department_name = 'Administration')),Salary = (SELECT salary -FROM employees -WHERE emp_name = 'Smith')WHERE job_id = 'IT_ADMIN';What happens when the statement is executed?

Which database solution meets these requirements?

A. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.

Highly voted

B. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.

Highly voted

C. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.

Highly voted

D. The statement fails because there is more than one row matching the employee name Smith.

Highly voted

E. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.

Highly voted

F. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

Highly voted

Discussion of the question

Question 22 🔥

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which MERGE statement is valid?

Which database solution meets these requirements?

A. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

Highly voted

B. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

C. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

Highly voted

D. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

E. MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

Highly voted

F. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

G. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

Highly voted

H. name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

Discussion of the question

Question 23 🔥

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

Which database solution meets these requirements?

A. SELECT &1, "&2"FROM &3WHERE last_name = '&4';

Highly voted

B. SELECT &1, '&2'FROM &3WHERE '&last_name = '&4' ';

Highly voted

C. SELECT &1, &2FROM &3WHERE last_name = '&4';

Highly voted

D. SELECT &1, '&2'FROM EMPWHERE last_name = '&4';

Highly voted

Discussion of the question

Question 24 🔥

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)

Which database solution meets these requirements?

A. It releases the storage space used by the table.

Highly voted

B. It does not release the storage space used by the table.

Highly voted

C. You can roll back the deletion of rows after the statement executes.

Highly voted

D. You can NOT roll back the deletion of rows after the statement executes.

Highly voted

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

Highly voted

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_051

Exam contains 287 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us