SQL-TEST

Which data manipulation command is used to combines the records from one or more tables?

• SELECT

• PROJECT

• JOIN

• PRODUCT

Which operator is used to compare a value to a specified list of values?

• BETWEEN

• ANY

• IN

• ALL

Which of the following operations requires the relations to be union compatible?

• UNION

• INTERSECTION

• DIFFERENCE

• ALL OF THESE

DCL provides commands to perform actions like

• Change the structure of Tables

• Insert, Update or Delete Records and Values

• Authorizing Access and other control over Database

• None of Above

Which function is used to divides one numeric expression by another and get the remainder ?

• POWER

• MOD

• ROUND

• REMAINDER

A database language used for defining the whole data base structure and schema is called

• DCL

• DML

• DDL

• All Of Above

Which statement in SQL allows us to change the definition of a table is?

• ALTER

• UPDATE

• CREATE

• SELECT

Which operator performs pattern matching?

• BETWEEN operator

• LIKE operator

• EXISTS operator

• None of these

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT DIFFERENT

• All of the above

Which SQL keyword is used to

retrieve a maximum value?

• TOP

• MOST

• UPPER

• MAX