IT Environmental Management Support | Mock Test

1
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
Show Answer

2
A relation in whom every determinant is a candidate key is
a. 1st Normal
b. 2nd Normal
c. Boyce Codd Normal
d. 3rd Normal
Show Answer
3
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?
a. AND
b. OR
c. BETWEEN
d. LIKE
Show Answer
4
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.
Show Answer
5
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
Show Answer
6
__________ is a command-line utility that can be used to stop, start, and restart IIS Internet services.
a. IISstart.exe
b. IISreset.exe
c. IISStop.exe
d. IISadmin.exe
Show Answer
7
___________ 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
Show Answer
8
Application pool settings do NOT apply to this type of applications
a. ISAPI
b. CGI
c. ASP
d. ASP.NET
Show Answer
9
How to open IIS configuration Manager
a. Run->iisconfig
b. Run->iisnetmgr
c. Control Panel->IIS
d. Run->inetmgr
Show Answer
10
HTTP compression only works with web browsers developed after:
a. 1996
b. 1997
c. 1998
d. 2000
Show Answer