Sunday, July 28, 2013

LINUX MCQ Test – 3


Que.1. In _____________ state of a process, the process will be terminated and the information will still be available in the process table.

A:        Interruptible
B:        Uninterruptible
C:        Zombie
D:        Running

Right Answer: C

Que.2. What is the use of a pipe?

A:        Several functions can be combined in a single statement.
B:        UNIX is an open source and free software
C:        Stream input to output.
D:        Both a and c

Right Answer: D

Que.3. What is the major difference between UNIX and LINUX?

A:        Linux is an open source and free software
B:        UNIX is an open source and free software
C:        UNIX uses Linux like OS
D:        Both a and c

Right Answer: A

Que.4. By default, the shell uses the _______________ library

A:        read
B:        data
C:        readline
D:        processline

Right Answer: C

Que.5. What is the Non interactive mode of nslookup used for?

A:        Fetch information about the specified host or domain
B:        Interact by querying information
C:        none of the able
D:        Both a and b

Right Answer: A

Que.6. Which system call is used to bias the existing property of process?

A:        proc()
B:        bias()
C:        Exec()
D:        Nice()

Right Answer: B

Que.7. Which Linux command will successfully mounts a USB drive?

A:        mount /dev/uda1 /mnt/usb
B:        mount /dev/sda1 /mnt/usb
C:        mount -t usbfs /dev/usb001 /mnt/usb
D:        mount /dev/hde1 /mnt/usb

Right Answer: B

Que.8. ___________ is a common tool for determining services and ports running on a remote Linux.

A:        arp
B:        nmap
C:        netstat
D:        None of the above

Right Answer: B

Que.9. Nettop is used to find network usage

A:        True
B:        False

Right Answer: B

Que.10. LD_LIBRARY_PATH is a type of

A:        system call
B:        command
C:        Environmental variable
D:        both b and c

Right Answer: C

Que.11. When a computer system is reported problems with inodes and blocks, which of the following is the problem and its solution to rectify it?

A:        The file system has become corrupt and needs to be repaired.
B:        The boot sector is corrupt and needs to be repaired.
C:        The drive is configured using an improper file system and needs to be reformatted.
D:        The partition table has become corrupt and needs to be replaced.

Right Answer: A

Que.12. When trying to compare two files using cmp, if the files differ; what is the output?

A:        tells the first byte where they differ
B:        tells the line number where they differ
C:        tells the first byte and line number where they differ
D:        it displays the files

Right Answer: C

Que.13. Ping will only report damaged packets.

A:        True
B:        False

Right Answer: B

Que.14. There is no difference between who and whoami command?

A:        True
B:        False

Right Answer: B

Que.15. Which of the following are valid functions of Red Hat Package Manager?

A:        Used to verify software packages.
B:        search engine to search for software's
C:        search engine to search for commands
D:        both a and b

Right Answer: D

Que.16. Which command is most useful when you want not only to send some data down a pipe, but also to save a copy?

A:        pipe
B:        awk
C:        split
D:        tee

Right Answer: D

Que.17. Cal is used to display calendar. If no arguments are supplied, what is displayed?

A:        The current month is displayed
B:        Nothing is displayed
C:        Shows an error
D:        None of the above

Right Answer: A

Que.18. Which configuration does cardmgr read at Linux system startup?

A:        PCMCIA cards
B:        PCI cards
C:        USB cards
D:        SCSI cards

Right Answer: A

Que.19. Which of the following allows to secure remote command line access?

A:        telnet
B:        SSL
C:        SSH(Secure Shell)
D:        Rlogin

Right Answer: C

Que.20. Which of the following command is used to test a network connection?

A:        ping
B:        pingall
C:        echo
D:        both a and b

Right Answer: A

SQL Server MCQ Test – 3


Que.1. In which database state, the database is in single-user mode and may be repaired or restored.

A:        OFFLINE
B:        SUSPECT
C:        EMERGENCY
D:        All choices are correct.

Right Answer: C

Que.2. _____________ can be used to connect to as many databases on as many servers

A:        Microsoft Management Console
B:        Enterprise Manager
C:        SQL Manager
D:        Both a and c above

Right Answer: B

Que.3. CREATE DATABASE has how many mandatory parameters?

A:        1
B:        2
C:        3
D:        None

Right Answer: A

Que.4. How many Primary key constraints can be included in a table definition?

A:        One
B:        Two

Right Answer: A

Que.5. Default is a type of constraint although it does not really enforce anything

A:        Yes
B:        No

Right Answer: A

Que.6. What is the difference between adhoc queries from stored procedures?

A:        Adhoc queries are placed embedded in the business logic code
B:        Stored procedures are placed embedded in the business logic code
C:        There is no difference as both are fired on the databases
D:        None of the above

Right Answer: A

Que.7. Which statement is used to delete all rows in a table without having the action logged?

A:        Drop table statement
B:        Delete table statement
C:        Truncate table statement

Right Answer: C

Que.8. Which of the following databases are created on installing SQL server?

A:        master
B:        msdb
C:        pub
D:        Both a and b above

Right Answer: D

Que.9. The SQL Query Analyzer is the main interface for running SQL queries against your database

A:        True
B:        False

Right Answer: A

Que.10. Tools for importing and exporting data in sql server

A:        bcp command utility
B:        BULK inserts statement
C:        DTS
D:        All choices are correct.

Right Answer: D

Que.11. Choose the incorrect option about the sql server index

A:        Two types of indexes - clustered indexes and non-clustered indexes
B:        Both types use B-TREE for searching data
C:        Only one clustered index on a table
D:        More than one clustered index on a table

Right Answer: D

Que.12. Can a clustered index also be a unique index?

A:        Yes
B:        No

Right Answer: A

Que.13. Is a composite index key always part of a covering index?

A:        Yes
B:        No

Right Answer: B

Que.14. Which type of integrity preserves the defined relationship between tables when records are entered or deleted?

A:        Entity integrity
B:        Domain integrity
C:        Referential integrity
D:        User-defined integrity

Right Answer: C

Que.15. Which of the following is not correct for DELETE and TRUNCATE?

A:        DELETE table can be rolled back
B:        TRUNCATE table cannot have triggers
C:        TRUNCATE table can have criteria
D:        DELETE table can have criteria

Right Answer: C

Que.16. By default "FILLFACTOR" value is

A:        Zero
B:        One
C:        Two
D:        Five

Right Answer: A

Que.17. Which of the following DBCC command is used to see when was the last time the index rebuild?

A:        DBCC SHOW_STATISTICS
B:        DBCC SHOWCONFIG
C:        DBCC DBREINDEX

Right Answer: A

Que.18. Which operation, when performed on a database can throw an error
"The database could not be exclusively locked to perform the operation"

A:        DELETE database
B:        DROP database
C:        Rename database
D:        DISABLE database

Right Answer: C

Que.19. A candidate key cannot be regarded as a possible primary key

A:        True
B:        False

Right Answer: B

Que.20. The ______________ database is a system database which is used as a template whenever a new database is created.

A:        pubs
B:        tempdb
C:        model
D:        master

Right Answer: C