Wednesday, June 26, 2013

Networking MCQ Test – 2


Que.1. A network router joins two _________ together?
A:        Computers
B:        Switches
C:        Networks
D:        Gateway

Right Answer: C

Que.2. What is the other types of OLAP apart from ROLAP?
A:        HOLAP
B:        MOLAP
C:        DOLAP
D:        Both a and b above

Right Answer: B

Que.3. ____________ assigns a unique number to each IP network adapter called the MAC address.
A:        Media Access Control
B:        Metro Access Control
C:        Metropolitan Access Control
D:        Both b and c above

Right Answer: A

Que.4. What is the full form of CAN?
A:        Campus Area Network
B:        Cluster Area Network
C:        Control Area network
D:        both a and b

Right Answer: D

Que.5. Dynamic addressing doesn't allow many devices to share limited address space on a network
A:        True
B:        False

Right Answer: B

Que.6. ARP works on Ethernet networks.
A:        False
B:        True

Right Answer: B

Que.7. __________ is a standard suite of protocols used for packet switching across computer networks.
A:        x.22
B:        x.23
C:        x.25
D:        x.26

Right Answer: C

Que.8. NAT stands for
A:        network address transformer
B:        network address translator
C:        network address translation
D:        Both b and c above

Right Answer: C

Que.9. Piconets in blue tooth a minimum of two and a maximum of ____________ Bluetooth peer devices.
A:        five
B:        eight
C:        nine
D:        four

Right Answer: B

Que.10. Which of the following below is/are capability of ICMP protocol?
A:        Report package count
B:        Report network congestion
C:        Both b and d
D:        Report availability of remote hosts

Right Answer: C

Que.11. What is the full form of URL?
A:        Uniform routing locator
B:        Uniform Resource locator
C:        Universal Resource locator
D:        Uniform router locator

Right Answer: B

Que.12. The process of assigning IP address for specific times to the various hosts by DHCP is called as?
A:        Lend
B:        sublease
C:        let
D:        Lease

Right Answer: D

Que.13. In 10base2, 10base5, what does 2 and 5 stand for?
A:        Speed in mbps
B:        Number of segments
C:        Length of segment
D:        Size of segment

Right Answer: B

Que.14. Which of the following below are secure VPN protocols?
A:        UDP
B:        TCP
C:        SSTP
D:        Both b and c

Right Answer: D

Que.15. Which of the following below is a loop back IP address?
A:        127.0.0.0
B:        127.0.1.1
C:        127.0.1.0
D:        127.0.0.1

Right Answer: D

Que.16. 10Base5, 10Base2, 10BaseT are types of?
A:        Internet
B:        LAN
C:        Ethernet
D:        Cables

Right Answer: C

Que.17. When computers in a network listen and receive the signal, it is termed as active toplogy
A:        True
B:        False

Right Answer: A

Que.18. Which of the following is true for secure shell tunneling?
A:        To set up an SSH tunnel, one configures an SSH client to forward a specified local port
B:        SSH tunnels provide a means to not bypass firewalls
C:        All SSH clients support dynamic port forwarding
D:        Both a and b

Right Answer: A

Que.19. Message Oriented Middleware allows general purpose messages to be exchanged in a Client/Server system using message queues.
A:        True
B:        False, it works based on stacks

Right Answer: A

Que.20. What is the difference between a switch and a hub?
A:        Switches operate at physical layer while hubs operate at data link layer
B:        Switches operate at data link layer while hubs operate at transport layer
C:        Switches operate at data link layer while hubs operate at physical layer
D:        Switches operate at transport layer while hubs operate at physical layer

Right Answer: C

SQL Server MCQ Test – 2


Que.1. Which feature converts row data to column for better analytical view?
A:    Views
B:    Join
C:    Pivot
D:    Trigger

Right Answer: C

Que.2. Which of the following statements is/are not true for SQL profiler?
A:    enables you to monitor events
B:    check if rows are being inserted properly
C:    check the performance of a stored procedure
D:    ALL

Right Answer: C

Que.3. Which global variables can be used to determine if a transaction is still open?
A:    @@NESTLEVEL
B:    @@FETCH_STATUS
C:    @@TRANCOUNT
D:    @@CONNECTIONS

Right Answer: C

Que.4. Which statement is used to define a cursor?
A:    OPEN
B:    FETCH
C:    DECLARE CURSOR
D:    @@FETCH_STATUS

Right Answer: C

Que.5. What is the default "SORT" order for a SQL?
A:    Ascending
B:    Descending

Right Answer: A

Que.6. Capabilities of RAISERROR
A:    It can be logged in the error log
B:    It can print a message to the application
C:    It can assign an error number, state and severity
D:    a,b and c

Right Answer: D

Que.7. How inserting data through stored procedure do reduces network traffic and increase database performance?
A:    Stored procedure can accept parameter
B:    Permission check is not required
C:    The execution plan is stored in the cache after it was executed the first time.

Right Answer: C

Que.8. Stored procedures are safe from SQL injection attacks
A:    True
B:    False

Right Answer: A

Que.9. Which of the following connection type supports application role permissions and password encryption?
A:    OLE DB
B:    DBLib
C:    ODBC
D:    OLE DB and ODBC

Right Answer: D

Que.10. Cursor that reflects the changes made to the database table even after the result set is returned
A:    Static
B:    Dynamic
C:    FORWARD_ONLY
D:    Keyset

Right Answer: B

Que.11. Which of the following is/are false for RAW mode of FOR XML?
A:    XMLSCHEMA option does not returns an in-line XSD schema.
B:    BINARY BASE32 returns the binary data in base32-encoded format.
C:    Each row in the query result is transformed into an XML element
D:    Both a and b above

Right Answer: D

Que.12. Which statement is correct from partitioned view?
A:    We cannot create an indexed view on a partitioned view
B:    We can create an indexed view on a partitioned view as long as the index is clustered
C:    We can create an indexed view on a partitioned view

Right Answer: C

Que.13. ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails
A:    Isolation
B:    Atomicity
C:    Consistency
D:    Durability

Right Answer: D

Que.14. Which utilities can we used to export data from sql server to a text file?
A:    DTS export wizard
B:    BCP
C:    ISQL
D:    a and b

Right Answer: D

Que.15. You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?
A:    TINYINT
B:    SMALLINT
C:    INT
D:    DECIMAL(1)

Right Answer: B

Que.16. Difference between UNION and UNION ALL.
A:    Both are similar
B:    UNION ALL is no longer supported in sql server 2000 onward
C:    UNION returns only unique records from both tables. UNION ALL returns all records from both tables

Right Answer: C

Que.17. Problems occurs if we don't implement proper locking strategy
A:    Dirty reads
B:    Phantom reads
C:    Lost updates
D:    Unrepeatable reads

Right Answer: D

Que.18. Which of the following statement is used to make sql server resize the database file to its smallest possible size?
A:    DBCC SHRINKFILE
B:    DBCC SHRINKDB
C:    DBCC SQLPERF SHRINKDB

Right Answer: A

Que.19. Which of the following fixed database roles can add or remove user IDs?
A:    db_accessadmin
B:    db_securityadmin
C:    db_setupadmin
D:    db_sysadmin

Right Answer: A

Que.20. By default sql server has ___________ isolation level
A:    READ COMMITTED
B:    READ UNCOMMITTED
C:    SERIALIZABLE
D:    REPEATABLE READ

Right Answer: A