1) The
_______________ function returns the version of MySQL.
a) BENCHMARK
b) VERSION
c) CURDATE
d) NONE OF THEM
2) The
_______________ function returns the current date in the format YYYYY-MM-DD or
YYYYYMMDD format.
a) CURDATE
b) ADDATE
c) DATEDIFF
d) NONE OF THEM
3) The
______________ function returns the sing of the argument. It returns a -1,0, or 1 depending on the argument is
positive ,zero, negative.
a) SIGN
b) POWER
c) MOD
d) LOG
4) The
____________ Function compresses a string.
a) Compress
b) Zip
c) Merge
d) None of them
5) The
____________ Function executes the expression entered as the argument
repeatedly the times specified in the argument.
a) Benchmark
b) Charset
c) Connection
d) None of them
6) The grant
option enable privileges to be granted to the user.
a) True
b) False
7) Usage is
used when a user is created without any privileges.
a) True
b) False
8) Usage
privileges is used only to establish a connection.
a) True
b) False
9) _____________
Return the name of the browser the client is using.
a) http_user_agent
b) http_from
c) server_name
d) none of them
10) The
_____________ data type stores true or false values.
a) String
b) Integer
c) Floating
point
d) Boolean
11) The
_____________ variable retain its value throughout the lifetime of the program.
a) Local
b) Static
c) Global
d) Environment
12) The
_____________ operators enable us to combine two or more test expression in a
condition.
a) Bitwise
b) Logical
c) Relational
d) Arithmetic
13) _____________
simplifies complex conditions into one line statements.
a) If statement
b) Switch
statement
c) Conditional
statement
d) Ternary
Operator
14) The
_____________ statement ends the loop and the control is passed to the
statement following the loop body.
a) Exit
b) Break
c) Continue
d) None of them
15) Recursion is
_____________
a) One function
calling another function several time
b) A
function calling itself number of times
c) Two
functions calling the same function
16) Persistent
cookies are stored in the web browser for a period specified during the time of
its creation.
a) True
b) False
17) _____________
Function operates on numerical data.
a) Mathematical
b) String
c) Date
d) None of them
18) Which of the following option are true regarding name-based
virtual hosting?
a)
Name-based
virtual hosting allow different host to share the same IP address.
b)
In
name-bassed virtual hosting, user need to configure Apache web server to map
each host name to the correct P address
c) In
name-based virtual hosting, the client has to send the HTTP host header
d) Name-based
virtual hosting is compatible with SSL secure servers
19) Which of the following modules implements a hybrid server, is
stable, and processes multiple requests
with threads
a) Mod_status
b) mod_rewrite
c)
worker
d) mod_ssl
20) Which of the following directives defines the maximum number of
server processes that must be created by Apache web server
a)
ServerLimit
b) MaxSpareServers
c) StartServers
d) MaxClients
21) Which of the following modules handles the file-based cache
a) mod_mem_cache
b) Mod_cache
c)
mod_disk_cache
d) Mod_proxy
22) Which of the following directives defines alternatives name for
the hosts used in the name_based virtual host
a) ServerPath
b)
ServerAlias
c) Server Name
d) Name virtual
Host
23) Which of the following directives can be used to customize the
saner response to errors?
a) Errorlog
b)
ErrorDocument
c) Format Log
d) Transfer Log
24) Which of the following ways are used by apache web server to
authenticate a HTTP request?
a)
Access
Control
b)
Authentication
c)
Authorization
d) Validation
25) Which of the following is the correct use of the server Root
directive?
a) Specifies
the hostname and port for the server
b) Instructs
the server to listen to the specific IP addresses and ports
c)
Specifies
the directory path where the server is installed
d) Specifies
the directory path form where the server processes the files
26) Which of the following is
the default number of threads by Thread per Child drive?
a) 20
b) 45
c)
25
d) 50
27) Which of the following command is used to retrieve data form one
tables?
a)
SELECT
b) VIEW
c) COMPUTER
d) SHOW
28) ________________clause is used to restrict the record retrieved by
using a condition.
a) WHEN
b) FROM
c) HAVING
d)
WHERE
29) Which of the following option compares a table with itself?
a) INNER JOIN
b) CROSS JOIN
c) OUTER JOIN
d)
SELF
JOIN
30) Which of the following mathematical function returns the integer
value greater than the argument?
a)
CEILING
b) ROUND
c) FLOOR
d) TRUNCATE
31) ____________ Command is used to remove right from user account.
a) CANCEL
b)
REVOKE
c) REMOVE
d) DROP
32) Which of the following command is used to select a particular
database?
a)
USE
b) SELECT
c) SHOW
d) DISPLAY
33) Which of the following data is used to stored image in MySQL?
a) VARBINARY
b) BLOB
c) BINARY
d) IMAGE
e)
34) WHICH OF THE FOLLOWING COMMAND AND WILL HEIP TO REBOOT THE SYSTEM?
a) SHUTDOWN-H
b) EXIT-S
c)
SHUTDOWN-R
d) EXIT-C
35) WHICH OF THE FOLLOWING COMMANDS ANDS DISPLAY THE AMOUT OF SPACE
USED AND THE AMOUNT OF FEE DISK SPACE AVAILABLE ON THE CURRENTLY MOUNTED THE
SYSTEM?
a)
DF
b) FEE
c) SIZE
d) MAN
36) WHICH OF THE FOLLOWING COMMANDS REMOVES A JOB FROM A PRINT QUEUE?
a) IPR
b)
IPRM
c) IPQ
d) M
37) WHICH OF THE FOLLOWING DIRECTORY IN THE LINUX FILE SYSTEM IS NOT
PHYSICALLY PRESENT ON THE DISK?
a) /BIN
b)
/PROC
c) /DEC
d) HOME
38) WHICH OF THE FOLLOWING COMMAND COMPARES THE CONTENT OF TWO FILES
AND REPORTS THE FIRST CHARACTER THAT DIFFERS?
a)
CMP
b) CP
c) DF
d) COMPARE
39) WHICH OF THE FOLLOWING COMMAND DISPLAY THE CONTENTS OF A FILE ON
THE SCREEN OR STORE IT IN ANOTHER FILE?
a) DISPLAY
b)
CAT
c) VIEW
d) TOUCH
40) Which of the following defines the type of the data that will be
stored in a column of tables?
a) Privileges
b) Variations
c) Data types
d) Constraint
41) Which of the following statement regarding making changes in the
http.conf files is true?
a) Apaches server must be restarted to implement changes
made to configuration file.
b) Apaches
server must include directives to implement changes made to the configuration
file.
c) Apaches
server must also implement changes in htaccess file before restarting to file
implement changes made to the configuration
d) To implement
the changes apaches processes the directive line by line in the http.conf
42) Which of the following directives of the mod_alias module
transmits an external redirect to obtain a different url?
a) RedirectPermanenr
b) RedirectMatch
c) RedirectTemp
d)
Redirect
43) _____________ Command searches a file for a specific pattern.
a) Pattern
b)
grep
-n
c) Is -a
d) Cat -c
44) Which of the following queries will display all the employees
whose last name ends with? On? String?
a) Select employeed
employeefirst name employeelast name from employees where insert employeelast
name?
b) Select
employeed employee firstname employee lastname from employees where employees
last name like? On%?
c) Select
employee firstname last name from employee where locate employee last name?
d)
Select
employee first name employee last name from employee where right employee last
name=?or
45) Which of the following commands is used to configure mod_ssl?
a)
/configure_prefix_
ssl
b) /configure_enable_ssl
c) /config_prefix_ssl
d) /config _enable_ssl
d) /config _enable_ssl
No comments:
Post a Comment