Whаt соmmаnd іs usеd іn Lіnuх tо соunt thе tоtаl numbеr оf lіnеs, wоrds, аnd сhаrасtеrs соntаіnеd іn а fіlе?

1.      Assume a schema of

EMP(Id,

Name, DeptId), Dept(Id, Name).

If there are 10 records in the Emp table and 5 records in the Dept

table, how many rows will be

displayed in the result of the following SQL query?

SELECT * FROM Emp, Dept

What

are the different types of outer joins? Choose all correct options.

Table

Category has a field 'Id' (integer data type). Which of the following queries

returns the same results as the  query

below?

SELECT * FROM Category WHERE Id BETWEEN 2 AND 4