Friday, 13 November 2015

Accp (pro) HDSE II Comprehensive Exam Part 1

1)    To switch from the GUI environment to the shell, console, we need to use the Ctrl+F1 keys.
a)      True
b)      False
2)    Identify the two components in the architecture of the Apache Web Server.
a)      Multi-Processing Module
b)      Authentication Module
c)      Core Module
d)      Authorization Module
3)    Which of the following statement regarding making changes in the http.conf file is true?
a)      Apache server must be restarted to implement  changes made to the configuration file
b)      Apache server must include directives to implement changes made to the configuration file
c)      Aptech server must also implement changes in .htaccess file before restarting to implement changes made to the configuration file.
d)      To implement the changes. Apache processes the directives line by line in the http.conf
4)    Which statement is used to add a new record in table?
a)      Insert
b)      Add
c)      Record
d)      Update
5)    The _____________ symbol starts a process in the background.
a)      $
b)      ^
c)      &
d)      *
6)    Which is the default order of sort in ORDER by clause?
a)      Ascending
b)      Descending
7)    Which of the following utilities is used to render a private key for Apache server?
a)      Mod_ssl
b)      Http
c)      Crypto-utils
d)      Openssl
8)    Which of the following commands in entered at the command prompt to start apache web server?
a)      Apachectl –k start
b)      Etc/int:d/http start
c)      Load Apachectl
d)      /usr/local/apache2/bin/Apachectl start
9)    The _____________ option of insert command causes insertion of records to be postponed unless all clients finished reading from the tables.
a)      Default
b)      Low_priority
c)      Ignore
d)      Delayed
10)           Which of the following types of proxies can be configured on Aptech server?
a)      Reverse
b)      Forward
c)      Backward
d)      Filtered
11)           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
12)           Which of the following command is used to configure mod_ssl?
a)      ./configure –prefix-ssl
b)      ./configure –enable-ssl
c)      ./config –prefix-ssl
d)      ./config –enable-ssl
13)           Which of the following queries will display all the employees whose last end with? On? String?
a)      SELECT Employees, EmployeeFirstName, EmployeeLastName FROM Employees Where INSERT(EMPLOYEELastName,?2?) LIKE ?on?
b)      SELECT Employees, EmployeeFirstName, EmployeeLastName FROM Employees Where EmployeeLastName LIKE ?on?
c)      SELECT Employees, EmployeeFirstName, EmployeeLastName FROM Employees Where LOCATE(EMPLOYEELastName, 2) = ?on?
d)      SELECT Employees, EmployeeFirstName, EmployeeLastName FROM Employees Where RIGHT(EMPLOYEELastName, 2) = ?on?
14)           Which of the following modules displays information related to the activities and performance of apache web server?
a)      Mod_include
b)      Mod_userdir
c)      Mod_dir
d)      Mod_status
15)           Which of the following displays the lists of included directories instead of the actual web pages?
a)      DirectorySlash
b)      DirectoryIndex
c)      Options
d)      ScriptsAlias
16)           If you want to assign a read permission to file, the octal value that will be used to assign the ‘read; permission is _________
a)      3
b)      4
c)      1
d)      2
17)           Which of the following storage engines is default to handle tables in MYSQL?
a)      EXAMPLE
b)      innoDB
c)      MYISAM
d)      BLACKHOLE
18)           _____________ is the process of converting data into scrambled code while deciphering it at the other end.
a)      Certificates
b)      Digital Signature
c)      Cryptography
d)      Message digest
19)           _____________ exists between a computer and a network and provides protection to networks against outside attackers.
a)      Firewall
b)      Proxy
c)      Security
d)      Protocol
20)           _____________ is used to establish a relationship between two tables.
a)      Foreign key
b)      Composite key
c)      Primary key
d)      Candidate key
21)           A query used inside another select query is known as _____________
a)      Subquery
b)      Join query
c)      Inner query
d)      Group query
22)           The STRCMP function return -1 if _____________.
a)      Str1 < Str2
b)      Str1 = Str2
c)      Str1 > Str2
d)      Str1 <> Str2
23)           The _____________ controls the working of the desktop.
a)      GNOME
b)      KDE
c)      Window Manager
d)      Editor
24)           Which of the following option of the data command displays the time in HH:MM:SS format?
a)      %M
b)      %HK
c)      %m
d)      %T
25)           Which of the following commands displays detailed list of files and directories?
a)      Is ?a
b)      Is -l
c)      Is ?r
d)      Is
26)           Which of the following command prints only the login name of all the users currently logged in to the system and the number of users logged in?
a)      Is
b)      Users
c)      Man
d)      Who –q
27)           The _________ command displays the name of the terminals.
a)      Ytt
b)      Tty
c)      Tyt
d)      Try
28)           ___________ Command searches a file for a specific pattern.
a)      Pattern
b)      Grep –n
c)      Is –a
d)      Cat c
29)           Ps – a command is to
a)      Lists additional information such as process status, user id, process id, etc about the process
b)      Lists basic details about the process such as process id, terminal, process status, process time, and process command
c)      List all processes
d)      List all the process and the respective environment in which these processes are running
30)           Which of the following are dynamic modules in apache?
a)      Mod_actions
b)      Mod_dev
c)      Mod_perl
d)      All of the above
31)           Which of the following commands will display the indexes created on employee table of the payroll database?
a)      SHOW INDEX FROM Employee FROM Payroll
b)      SHOW INDEXES FROM Payroll.Employee
c)      SHOW INDEX FROM Employee IN Payroll
d)      SHOW INDEX FROM Payroll.Employee
32)           This is referred to as root in Linux
a)      Master user
b)      Superuser
c)      Normal user
d)      None of them
33)           Which of the following ways below is correct way to get the current date?
a)      SELECT CURRENTTIME();
b)      SELECT CUR_TIME();
c)      SELECT CURDATE();
d)      SELECT SYSDATE();
34)           Which of the following option of the uname command prints all the basic information available from the system?
a)      –v
b)      –r
c)      –p
d)      –a
35)           Which of the following protocols runs above TCP/IP and below higher-level Protocols?
a)      SMTP
b)      HTTP
c)      SSL
d)      FTP
36)           A query used inside another select query is known as ______________.
a)      Subquery
b)      Join query
c)      Inner query
d)      Group query
37)           The ______________ in Linux is an interactive spell checker.
a)      Spellcheck
b)      Spell
c)      aspell
d)      None of the above
38)           Which of the following command removes a job from print.
a)      Rm
b)      Iprm
c)      Ipq
d)      Ipr
39)           ________________ Command is used to count no. of lines in a file.
a)      Wc -1
b)      Count
c)      Wordcount –l
d)      Length
40)           The ________________ command accesses the network configuration window at the spell prompt.
a)      System-config
b)      System-network-config
c)      System-config-network
d)      System-config-networkwindow
41)           PHPMyAdmin is an administrative interface for MYSQL databases
a)      True
b)      False
42)           The location where the received mail message are storage is _____________.
a)      /var/mqueue
b)      /var/log
c)      /etc/mail
d)      /var/spool/mail
e)      Mail
43)           The username and uid are stored in the ________ file.
a)      /etc/data
b)      /etc/password
c)      /etc/username
d)      /etc/uid
44)           Which of the following keys is used to auto-complete the command name or file name on the command line?
a)      TAB
b)      CTRL
c)      ALT
d)      ESC
45)           Which of the following defines the types of the data that will be stored in column of tables?
a)      Privileges
b)      Variables
c)      Data type
d)      Constraint
46)           Which of the following vi editor content of the file to disk and quits the editors?
a)      :w!
b)      :ql
c)      :wq!
d)      :wq
47)           The output of floor(9.85) would be_____________
a)      10
b)      8
c)      9
d)      Null
48)           PHP is an Open-source language.
a)      True
b)      False
49)           Which of the following method requires authentication and authorization with a username and a password?
a)      Digest
b)      Basic
c)      Digital Signing
d)      Client verity
50)           Which of the following statement id true about the different folders used in Linux?
a)      /proc directory is not physically present on disk. It is a real time, memory resident file system that tracks the processes running on your machine and the status of the system resources.
b)      All of the above.
c)      /bin directory contains the entire configuration file for the system.
d)      /mont directory usually contains mount points or sub-directories where you mount your floppy and your CD
51)           _______________ is required to execute Perl and PHP Script on the Apache Web Server.
a)      Prefork
b)      Worker module
c)      CGI Daemon
d)      Threaded multi-processing module
52)           Which of the following command is used to compare the contents of two files?
a)      Compare
b)      Cmp
c)      Diff
d)      Comp
53)           _________________ is the default window manager for KDE
a)      Kwin
b)      Metacity
c)      Twm
d)      Mwm
54)           What is location of a default configuration file of the samba Server?
a)      /home/samba/smb.conf
b)      /etc/samba/smb.conf
c)      /samba/etc/smb.conf
d)      /smb.conf
55)           Which of the following modules specifies the proxy or the gate way for Apache Server?
a)      Mod_proxy_ftp
b)      Mod_proxy
c)      Mod_proxy_connect
d)      Mod_proxy_http
56)           Which command is used to display the details of all the files in directory
a)      Touch
b)      Tree
c)      Cat
d)      Is –l
57)           USAGE is used when a user created without any privileges.
a)      True
b)      False
58)           Which of the following command displays the content of a files on screen or stores it in another files?
a)      View
b)      Display
c)      Cat
d)      Touch
59)           Which of the following directives defines the e-mail address that is included in every error message sent from the server?
a)      ServerAdmin
b)      ErrorDocument
c)      ServerRoot
d)      DocumentRoot
60)           ______________ is the process of structuring the data in a table to minimize duplication and inconsistency.
a)      Indexes
b)      Normalization
c)      Views
d)      E –R Diagram

8 comments:

  1. Great Effort Dear. Please post exams for all Semesters of ACCP-Pro

    ReplyDelete
    Replies
    1. plz bro send me 5th or 6th semester dums on this gmail
      shahabsb123@gmail.com

      Delete
  2. Nice one. Please post that of semester 6b .Net thanks

    ReplyDelete
  3. assalamu alaikum sir mujha adse 1 or 2 kay notes chahiya han
    Please send me notes adse 1 or 2

    ReplyDelete
  4. Great job .. Keep it up. Well done bro.

    ReplyDelete
  5. is this also included in 2018

    ReplyDelete
  6. ADSE Ka Bhi Banao Yaar

    ReplyDelete