Question 1 2 pts The one limitation of PROC SQL is that you cannot modify the table by adding or dropping columns. O True Fake Question 2 2 pts Null values in PROC SQL may only be missing or blank values. O True Fake Question 3 2 pts The difference between a PROC SQL table and SAS data file is O The PROC SQL columns do not include all the rows O There is no difference O The SAS data file correspond to variables in PROC SQL O The rows do not correspond to the observations None of the AboveQuestion 4 2 pts Place the following clauses in the correct order ORDER BY, FROM, WHERE, SELECT, GROUP BY, HAVING . SELECT V FROM WHERE GROUP BY V HAVING ORDER BY V Question 5 2 pts A PROC SQL statement contains a SELECT statement or query. True O Fake Question 6 2 pts A PROC SQL view contains table data. O True Fake Question 7 2 pts A SELECT Statement must include the SELECT and WHERE clause. O True FakeQuestion 8 2 pts Which of the following is false regarding the SQL procedure? O Column names are separated with commas. O The procedure ends with a QUIT statement. Formats can be specified in the FROM dause. O The SELECT and FROM clauses are required in the SELECT statement. Question 9 2 pts Which SELECT statement produces the given output? Name Height Thomas 57.5 Joyce 51.3 O select Name Height from sashelp.class where age-12 order by desc Height, O select Name, Height from sachelp.class where age-12 order by desc Height; select Name, Height from sachelp.class where age-12 order by Height desic; O select Name Height from sashelp.class where age-12 order by Height, Question 10 2 pts The SELECT statement creates a report. Which dause can be added before the SELECT clause to create a table? create table worknew as O create table-work.new as O create work. new = O create work new table Question 11 2 pts Which FROM clause is properly creating aliases? Q from empsauje) inner join phonecipl from empsou is c inner join phonec as p O from empsou-e inner join phonco-p 0 from empsou of c inner join phonec of pD Question 12 2 pts Which syntax is valid for creating a computed column in the SELECT clause? O Ratio as Height/ Weight O Ratio - Height/Weight Height/Weight as Ratio O Height/Wright - Ratio D Question 13 2 pts Which ON clause has valid qualifying syntax? O from empsau inner join phonec on first.empid-secondempid; Q from empsau inner join phonec on left.empid-right.empid, O from empsau inner join phonec on c.cupid-p.empid, from empsou inner join phonec on empsawtempid-phonec.cmpid, Question 14 2 pts Which statement has the correct syntax for performing an inner join? Q select ID, Name, Salary from one inner join two where ID-IDNO, Q select ID, Name, Salary from one join two where ID-IDNO, select 10, Name, Salary from one inner join two on ID-IONO, Q select ID, Name, Salary from one join two on ID-IDNO. D Question 15 2 pts Which SQL statement can delete tables? O DELETE DROP SELECT O VOID