ISA SQL Test

Which statement is wrong about Primary key constraint in SQL?

• Primary key can be made based on multiple columns

• The Primary key uniquely identifies each record in a SQL database table

• Primary keys must contain unique value

• Primary key must be made of any single column

Database normalisation typically -

• Reduces number of tables

• Reduces database size

• Reduces data constraints

• None of the above

You can add a row using SQL in database with which of the following?

• ADD

• CREATE

• INSERT

• MAKE

The correct query to remove a column from a table is-

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct

Which of the following SQL commands is used to retrieve data?

• DELETE

• INSERT

• JOIN

• SELECT

The SQL WHERE clause:

• Limits the row data that are returned

• Limits The column data that are returned

• Both the above statements are correct

• Neither of the above statements are correct

Which of these has special automatic update behavior?

• DATE

• TIME

• TIMESTAMP

• YEAR

The number of rows that will be returned by the SQL query is _________.

SELECT S. Student_Name, sum(P.Marks)

FROM Student S, Performance P

WHERE S.Roll_No = P.Roll_No

GROUP BY S.Student_Name

• 0

• 1

• 2

• 3

To search for a specified pattern in a column we use -

• MATCH

• LIKE

• PATTERN

• SEARCH

The SQL keyword BETWEEN is used ____________________.

• limit the columns displayed

• for ranges

• as a wildcard

• None of the above