SOCRATES

Which of the following SQL statements are included in the category of DML? (Choose 2 answers). SELECT. INSERT. CREATE TABLE. GRANT and REVOKE. DROP PROCEDURE.

Which of the following are HANA SQLScript extensions to ANSI SQL? (Choose 2 answers). UPSERT. CHAR and VARCHAR datatypes. Imperative SQL statements. GRANT and REVOKE. ABAP commands.

A primary key is a column or set of columns that uniquely identifies every row in a table. Determine whether this statement is true or false. True. False.

Which of the following objects is used to ensure data consistency? Choose the correct answer. Constraints. Stored Procedures. Tables. Triggers. Views.

Which of the following clauses is NOT in a SELECT statement? Choose the correct answer. GROUP BY. FROM. WHERE. SET. HAVING.

Only one column may be specified in the SELECT clause of a SELECT statement. Determine whether this statement is true or false. True. False.

How is a literal value specified in SQL? Choose the correct answer. By enclosing it in single quotes. By enclosing it in double quotes. By using single quotes if it is a string and without quotes if it is numeric. Quotes are not allowed in SQL.

Which clause is used in a SELECT statement to eliminate duplicate rows in a result set? Choose the correct answer. WHERE. DISTINCT. CASE. TOP. LIMIT.

A null is not greater than, less than, or equal to any column value. Determine whether this statement is true or false. True. False.

What is the difference between SUM and COUNT? Choose the correct answer. COUNT cannot be used in a SELECT clause. SUM can only be used in a WHERE clause. SUM can only be used on a numeric column. COUNT does not support the use of DISTINCT.

What is the result if the MIN aggregate is used on a string column? Choose the correct answer. The first value in alphabetic order is displayed. The last value in alphabetic order is displayed. A random value is displayed, depending on the sort order. An error is displayed.

What is the purpose of a UNION command? Choose the correct answer. To combine the result sets of multiple queries. To return only records that exist in all query results. To return results from the first query that don’t exist in the second. To connect every row of the left table to every row of the right.

Which of the following types of join will list all rows from one table and the matching rows from the other? Choose the correct answer. An inner join. A left outer join. A full outer join. A cross join.

A self join always requires the use of an alias. Determine whether this statement is true or false. True. False.

The only operator allowed in the join condition is an equality. Determine whether this statement is true or false. True. False.

What type of subquery returns exactly one row? Choose the correct answer. Quantified predicate. Expression. Correlated. Non-correlated.

A query that contains a join cannot contain a subquery. Determine whether this statement is true or false. True. False.

In what type of subquery does the inner query reference the outer query? Choose the correct answer. Quantified predicate. Expression. Correlated. Non-correlated.

If an UPDATE statement does not have a where clause, how many rows will be updated? Choose the correct answer. 0. 1. 2. All.

If an INSERT does not specify a value for a non-null column lacking a default, what is the result? Choose the correct answer. An error. A null value will be inserted in the column. All the other columns will be inserted, but not the non-null value. The primary key value will be inserted in the column.

How many rows will be inserted in a table by a standard INSERT? Choose the correct answers. (Choose 2 answers). 0. 1. 2. All.

In an UPSERT with a WHERE clause, if the WHERE clause does not match existing rows, the rows are inserted. Otherwise, the rows are deleted. Determine whether this statement is true or false. True. False.

Which of the following data types are numeric? Choose the correct answers (Choose 2 answers). SMALLINT. VARCHAR. DOUBLE. DATE. TIMESTAMP.

Which of the following will prevent duplicate values in a column? Choose the correct answers.(Choose 2 answers). Primary key. Default. Not null. Unique. VARCHAR.

The ALTER TABLE command can drop columns from a table unless those columns are part of the primary key. Determine whether this statement is true or false. True. False.

Which conditions suggest that a table should be a column table? Choose the correct answers. (Choose 2 answers). The table has frequent data changes. The table has a limited number of rows and columns. Queries against the table never use aggregates. A query is likely to access all the columns for a single row. The table is very large.

What benefits do views provide? Choose the correct answers. (Choose 2 answers). Simplify queries. Improve performance. Limit access to data. Allow the use of other languages than SQL.

If the view has a WHERE clause in which ColA = 100, and the select from the view has a WHERE clause in which ColA = 200, how much data will be selected? Choose the correct answer. 0 rows, but no error. 1 row. All the rows in the base table. An error will be generated.

Inserts, updates, and deletes can be performed against any view. Determine whether this statement is true or false. True. False.

What is the difference between GROUP BY CUBE and GROUP BY ROLLUP?. Choose the correct answer. GROUP BY CUBE is not part of the ANSI SQL-99 standard. GROUP BY CUBE aggregates in every dimension. GROUP BY ROLLUP cannot be used in a SELECT statement. GROUP BY ROLLUP cannot be used in a SELECT statement.

In a SELECT with an OVER() clause, which of the following statements are true? Choose the correct answers. (Choose 2 answers). PARTITIONED BY specifies the order of the rows in the result set. ORDER BY specifies the order of the rows in the result set. An OVER clause with ORDER BY cannot contain a PARTITIONED BY. The SELECT statement cannot return NULL values. The PARTITION BY clause is optional.

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING? Choose the correct answer. 1500. 1000 and 1500. 1500 and 3000. 1000, 1500, 3000, and 5000.

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in RANGE BETWEEN 3500 PRECEDING AND CURRENT ROW? Choose the correct answer. 1000, 1500, and 3000. 1000, 1500, 3000, and 5000. 1500, 3000, and 5000. 3000 and 5000. 5000.

Table User-Defined Functions can accept any number of input parameters and return any number of table results. Determine whether this statement is true or false. True. False.

Stored procedures must utilize only scalar parameters, or only table parameters. Determine whether this statement is true or false. True. False.

What kinds of error codes may be assigned to a declared CONDITION?. System error codes and user-defined error codes.

What commands can be used to associate custom error text with custom error conditions that lack error codes?. SIGNAL or RESIGNAL.

What are the major differences between SIGNAL and RESIGNAL?. RESIGNAL is used as part of an EXIT HANDLER and does not declare a particular exception to be active. By contrast, SIGNAL is executed as an independent command (although it may reference an EXIT HANDLER). SIGNAL indicates that a particular exception is in effect.

Which commands can be used to create an index? Choose the correct answers. (Choose 2 answers). CREATE INDEX. INSERT. GRANT. UPSERT. CREATE TABLE.

Every table is inside a schema. Determine whether this statement is true or false. True. False.

What effect will the GRANT SELECT ON SCHEMA command have? Choose the correct answers. (Choose 2 answers). The user will be able to select from any table in the schema. The user will be able to select from any view in the schema. The user will be able to execute any stored procedure in the schema. The user will be able to select, insert, update, or delete any table in the schema. The user will have no access to the schema.

If a user is not explicitly granted access to a table or a schema, they cannot select from the table. Determine whether this statement is true or false. True. False.

Which SQL commands explicitly end a transaction? Choose the correct answers (Choose 2 answers). SELECT. SELECT, INSERT, UPDATE, and DELETE. COMMIT. ROLLBACK.

Creating a column table causes an implicit commit. Determine whether this statement is true or false. True. False.

According to the ACID definitions, durability means that the entire transaction is completed, or none of it is. Determine whether this statement is true or false. True. False.

What is the default isolation level in HANA? Choose the correct answer. READ UNCOMMITTED. READ COMMITTED. REPEATABLE READ. SERIALIZABLE.