1Z0-007

这些题目你都会做吗?

[单项选择题]Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? ()

看答案

[多项选择题]Which two statements are true about constraints? ()

看答案

[单项选择题]A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? ()

看答案

[多项选择题]Which four are types of functions available in SQL? ()

看答案