Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: https://assets.asklib.com/images/image2/201808011552157673.jpg Which MERGE statement is valid?()
时间:2022-10-19
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?()
Which best describes an inline view? ()
时间:2022-10-18
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()
Which two statements are true about WHERE and HAVING clauses? ()
Which two tasks can you perform using only the TO_CHAR function? ()
Examine the structure of the EMPLOYEES table: https://assets.asklib.com/images/image2/2018080116355281637.jpg You issue these statements: https://assets.asklib.com/images/image2/2018080116355826082.jpg At the end of this transaction, what is true?()
时间:2022-10-16
Which four statements correctly describe functions that are available in SQL? ()
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? ()
Which statement explicitly names a constraint? ()
时间:2022-10-15
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables. You need to find the percentage tax applicable for each employee. Which SQL statement would you use?() https://assets.asklib.com/images/image2/2018080114273930960.jpg
Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?() https://assets.asklib.com/images/image2/2018080114250059182.jpg
Which two are attributes of iSQL*Plus? ()
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?()
时间:2022-10-14