Sql Set 2

Which of the following do you need to consider when you make a table in SQL?

• A. Data types

• B. Primary keys

• C. Default values

• D. All of the above.

SQL query and modification commands make up a(n) ________ .

• A. DDL

• B. DML

• C. HTML

• D. XML

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

• A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

• B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

• C. SELECT NAME IN CUSTOMER WHERE STATE = 'V';

• D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

To define what columns should be displayed in an SQL SELECT statement:

• A. use FROM to name the source table(s) and list the columns to be shown after SELECT.

• B. use USING to name the source table(s) and list the columns to be shown after SELECT.

• C. use SELECT to name the source table(s) and list the columns to be shown after USING.

• D. use USING to name the source table(s) and list the columns to be shown after WHERE.

Which of the following is not a DDL command?

• A.UPDATE

• B.TRUNCATE

• C.ALTER

• D.None of the mentioned

Which of the following statement is true?

• A.DELETE does not free the space containing the table and TRUNCATE free the space containing the table

• B.Both DELETE and TRUNCATE free the space containing the table

• C.Both DELETE and TRUNCATE does not free the space containing the table

• D.DELETE free the space containing the table and TRUNCATE does not free the space containing the table

The COUNT function in SQL returns the number of _____

• A.Values

• B.Distinct values

• C.Group by

• D.Columns

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.

So, What the below SQL statement will return: SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);

• A.10

• B.9

• C.5

• D.0

The SQL statement - SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL; Prints

• A.gh

• B. 23

• C.bc

• D. ab

The SQL statement - SELECT ROUND(45.926, -1) FROM DUAL;

• A.is illegal

• B.prints garbage

• C.prints 045.926

• D.prints 50