Which SQL statement can Mary use to accomplish that task?

Correct Answer for the Question – Which SQL statement can Mary use to accomplish that task? is given below User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view … Read more

Which three statements insert a row into the table?

Correct Answer for the Question – Which three statements insert a row into the table? is given below Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert a row into the table? (Choose three.) . EMPLOYEE_ID is a primary key.Incorrect answer:A. EMPLOYEE_ID cannot be nullB. EMPLOYEE_ID cannot be nullD. mismatch … Read more

Which four are valid Oracle constraint types?

Correct Answer for the Question – Which four are valid Oracle constraint types? is given below Which four are valid Oracle constraint types? (Choose four.)Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and UniqueIncorrect answer:A. Is not Oracle constraintC. Is not Oracle constraintF. Is not Oracle constraintRefer: Introduction to Oracle9i: SQL, Oracle University … Read more

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

Correct Answer for the Question – Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema? is given below Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?DROP VIEW viewname;Incorrect answer:A. Not a valid drop view statementB. Not a valid drop view statementC. Not a … Read more

Which values are displayed?

Correct Answer for the Question – Which values are displayed? is given below Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?ROUND (45.953, -1) will round value to 1 decimal places to the left.TRUNC (45.936, 2) will truncate value to 2 decimalThe answer will be 50 and 45.93Incorrect Answers:A. Does not meet round … Read more

Which two statements about sub queries are true?

Correct Answer for the Question – Which two statements about sub queries are true? is given below Which two statements about sub queries are true? (Choose two.) sub query can retrieve zero or more rows, sub query is used with an inequality comparison operator in the outer SQL statement, and the column list in the SELECT … Read more

Which three statements are true regarding sub queries?

Correct Answer for the Question – Which three statements are true regarding sub queries? is given below Which three statements are true regarding sub queries? (Choose three.) Multiple columns or expressions can be compared between the main query and sub query Main query and sub query can get data from different tables Sub queries can contain … Read more

Which two are true?

Correct Answer for the Question – Which two are true? is given below Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true? (Choose two.)GRANT ROLE to ROLE/USERIncorrect answer:A. Role can be grant to userC. Create table privilege is not grantedD. Execute privilege is not grantedF. Delete privilege is not grantedRefer: Introduction to … Read more