Question

Question 30

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID	SupplierID	CategoryID	ProductName
1	1	1	Chai
2	1	1	Chang
3	1	2	Aniseed Syrup
4	2	2	Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID, CategoryID and ProductName of all the products and order the results by CategoryID?

Select one:

a. Select ProductID, ProductName from tblProducts Order By CategoryID;

b. Select ProductID, CategoryID, ProductName from tblProducts Order By CategoryID;

c. Select ProductID, CategoryID, ProductName from tblProducts Where CategoryID=1 Order By CategoryID;

d. Select ProductID, CategoryID, ProductName Order By CategoryID;

Clear my choice

Question 31

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID	SupplierID	CategoryID	ProductName
1	1	1	Chai
2	1	1	Chang
3	1	2	Aniseed Syrup
4	2	2	Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID, CategoryID and ProductName of all the products whose ProductID is NOT 2?

Select one:

a. Select ProductID, CategoryID, ProductName from tblProducts;

b. Select ProductID =1, ProductID=3, ProductID=4 from tblProducts;

c. Select ProductID, CategoryID, ProductName from tblProducts Where ProductID <>2;

d. Select ProductID, CategoryID, ProductName from tblProducts Where ProductID = 2;

Clear my choice

Question 32

Not yet answered

Marked out of 1.00

Flag question

Question text

Database systems are used by users, however, users are not considered as a part of a database system.

Select one:

True

False

Question 33

Not yet answered

Marked out of 1.00

Flag question

Question text

Assume that you are dealing with money and you do a lot of calculations that you want them to be exact. Which of the following data types is the best option to store this in a relation?

Select one:

a. integer

b. decimal(10,2)

c. varchar(12)

d. char(12)

Clear my choice

Question 34

Not yet answered

Marked out of 1.00

Flag question

Question text

The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a relational database.

Select one:

True

False

Question 35

Not yet answered

Marked out of 1.00

Flag question

Question text

Students Table

Surname	First_Name	Student_No	Dept_No	Year
Duke	Fitzroy	1	4	2
Al-Essawy	Zaid	2	4	2
Ayton	Phil	3	3	1
Patel	Mahesh	4	2	1
Jones	Gareth	5	2	1
Scott	Gavin	6	2	2

CREATE VIEW Freshman
AS Select * From Students Where Year = 2;

Considering the above Students table and Freshman view, what will be the result of the following SQL query:

Select * From Freshman Where Dept_No=2;

Select one:

a.

Surname	First_Name	Student_No	Dept_No	Year
Duke	Fitzroy	1	4	2
Al-Essawy	Zaid	2	4	2

b.

Surname	First_Name	Student_No	Dept_No	Year
Patel	Mahesh	4	2	1
Jones	Gareth	5	2	1
Scott	Gavin	6	2	2

c.

Surname	First_Name	Student_No	Dept_No	Year
Scott	Gavin	6	2	2

d.

Surname	First_Name	Student_No	Dept_No	Year
Patel	Mahesh	4	2	1
Jones	Gareth	5	2	1

Clear my choice

Question 36

Answer 1

//Solution (30)?

//Option (b) is correct✔

Select ProductID, CategoryID, ProductName from tblProducts Order By CategoryID;

Reason :- > The select statement select the three columns from table tblProducts and returns the query result ordered by Category ID

//Option(a) id incorrect because this query takes only two columns

//Option (c) is incorrect since it returns only those rows which have CatagoryId =1

//Option (d) Wrong query

//Solution (31)?

//Option (C) is correct✔

Select ProductID, CategoryID, ProductName from tblProducts Where ProductID <>2;

//Option (a) is wrong since returns all products Id.

//Option (b) is incorrect

//Option (d) is incorrect (where condition is wrong)

//Solution (32)?

False ✔

//Solution (33) ?

decimal(10,2)✔

//Solution (34) ?

True ✔

//Solution (35)?

Select * From Freshman Where Dept_No=2;

//It means this query select all the freshman whose department number is 2

//So the Correct answer is (b)✔