IT Environmental Management Support | Mock Test
A cartesian product is
a. A group function
b. Produced as a result of a join select statement with no Where clause
c. The result of fuzzy logic
d. A special feature of oracle server
A relation in whom every determinant is a candidate key is
a. 1st Normal
b. 2nd Normal
c. Boyce Codd Normal
d. 3rd Normal
Consider the following SQL statement.SELECT qty FROM sales WHERE rate IN (300,800);Which of the following operators can be used to substitute the ‘IN’ operator?
Copy of Omitting the where clause from a delete statement has which of the following effects?
a. The delete statement will fail because of a syntax error.
b. The delete statement will prompt the user to enter criteria for the deletion.
c. The delete statement will fail because there are no records to delete.
d. The delete statement will remove all records from the table.
DISTINCT keyword is used for
a. Selecting all the duplicate rows
b. Eliminating all duplicate rows from the output
c. Both A and B
d. Eliminating all distinct rows
__________ is a command-line utility that can be used to stop, start, and restart IIS Internet services.
___________ describes how to improve performance between client computers and servers by reducing file sizes before the files are sent to the client computer
a. HTTP Keep-Alives
b. HTTP Compression
c. Limiting Connections
d. Throttling Bandwidth
Application pool settings do NOT apply to this type of applications
How to open IIS configuration Manager
c. Control Panel->IIS
HTTP compression only works with web browsers developed after: