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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Produced as a result of a join select statement with no Where clause[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Boyce Codd Normal [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : OR [/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : The delete statement will remove all records from the table. [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Eliminating all duplicate rows from the output [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : IISreset.exe [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : HTTP Compression [/bg_collapse]
8
Application pool settings do NOT apply to this type of applications
a. ISAPI
b. CGI
c. ASP
d. ASP.NET
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : CGI [/bg_collapse]
9
How to open IIS configuration Manager
a. Run->iisconfig
b. Run->iisnetmgr
c. Control Panel->IIS
d. Run->inetmgr
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Run->inetmgr [/bg_collapse]
10
HTTP compression only works with web browsers developed after:
a. 1996
b. 1997
c. 1998
d. 2000
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : 1998 [/bg_collapse]