Practice More Questions From: Using SQL in SAS
Q:
Which of the following statements is true concerning the SELECT clause?
Q:
Which of the following clauses are required in an SQL query? Select all that apply.
Q:
What is the correct order of the following four clauses?
Q:
Which SELECT statement does not include a syntax error?
Q:
Which of the following is false regarding the SQL procedure?
Q:
Which statements are true regarding the SQL procedure? Select all that apply.
Q:
Which syntax is valid for adding a FORMAT= option to the Hired column in the SELECT statement?
Q:
Which syntax is valid for creating a computed column in the SELECT clause?
Q:
Which of the following expressions selects all columns from the input table in the FROM clause?
Q:
Which procedure will produce a table from the query?
Q:
The SELECT statement creates a table by default.
Q:
The SELECT statement creates a report. Which clause can be added before the SELECT clause to create a table?
Q:
Which SELECT statement produces the given output? Name Height Thomas 57.5 Joyce 51.3
Q:
Which SELECT statement will include only the rows where the column Group is equal to 2?
Q:
Which SELECT statement sorts the rows by Hired in descending order?
Q:
The DROP TABLE clause in a SELECT statement deletes tables.
Q:
Which SQL statement can delete tables?
Q:
Which of the following statements about the DROP statement in PROC SQL is true?
Q:
If an inner join is performed on the following tables based on the ID and IDNO columns, how many rows will be in the PROC SQL report? Name ID Jack 111 Mary 333 Jane 555 IDNO Salary 111 75000 222 83000 333 82000
Q:
Which of the following tables is the outcome of performing an inner join on the tables below based on the Postal Code and Postal Code columns? Postal Code State 85001 AZ 78593 TX 80204 CO Postal Code City 85001 Phoenix 78593 Santa Rosa 10024 Manhattan
Q:
Which of the following tables is the outcome of performing an inner join on the tables below based on the Name and Name columns? Name Age Jessica 12 Maverick 9 Ashley 6 Name Height Jessica 60.2 Ashley 55 Shawn 57.8
Q:
Which statement has the correct syntax for performing an inner join?
Q:
This query produces an inner join between table1 and table2 based on matching values in columns ActNum and ID. select ActNum, ID, Value from table1 inner join table2 where ActNum=ID;
Q:
Which statement has the correct syntax for performing an inner join?
Q:
The Name column occurs in both the class and gradebook tables. Which of the following queries has valid qualifying syntax? Select all that apply.
Q:
When is the qualifying syntax of table.column required?
Q:
Which ON clause has valid qualifying syntax?
Q:
Which of the following is false concerning aliases?
Q:
Which FROM clause properly creates aliases?
Q:
Aliases are created in which of the following clauses?
Subscribe
0 Comments
