Question

Multiple Choice 1 . Which of the following is an aggregate function in SQL ? a . AVG b . ORDER BY c . SELECT d . None of these 2 . Count function in SQL returns the number of a . NON NULL values b . distinct values C. NULL values d . columns 3 . The statement in SQL which allows to change the definition of a table is a . ALTER b . UPDATE C. CREATE d SELECT 4 . Which of the following is correct : a . A SQL query automatically eliminates duplicates . b SQL permits attribute names to be repeated in the same relation . CA SQL query will not work if there are no indexes on the relations d . SQL query does not allow from and where is any order . 5 . The full form of DDL is a . Dynamic Data Language b . Detailed Data Language c . Data Definition Language d . Data Derivation Language 6 . Which of the following is a legal expression in SQL ? a . SELECT NULL FROM EMPLOYEE ; b SELECT NAME FROM EMPLOYEE ; C. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL ; d . SELECT WHERE SALARY IS NULL FROM EMPLOYEE 7 . Which of the following is a comparison operator in SQL ? a . Like b . = C. Between d . All of the above 8 . A file manipulation command that extracts some of the records from a file is called a . SELECT b b . PROJECT c . JOIN d . PRODUCT 9 . To delete a particular column in a relation the command used is : a . UPDATE b . DROP C. ALTER d . DELETE 10 . The operator is used to compare a value to a list of literals values that have been specified . a . BETWEEN b . ANY C. IN d . ALL​

Answer 1

Answer:

1 c select

2b distinct value