Technical Part -2

Question 1

Question

The basic component of a file in a file system is a?

Answer

data item
Universe of Discourse
software
database system

Question 2

Question

UoD stands for?

Answer

data item
Universe of Discourse
software
database system

Question 3

Question

A relational database consists of a collection of

Answer

Tables
Fields
Records
Keys

Question 4

Question

A ________ in a table represents a relationship among a set of values.

Answer

Column
Key
Row
Entry

Question 5

Question

The term _______ is used to refer to a row.

Answer

Attribute
Tuple
Field
Instance

Question 6

Question

The term attribute refers to a ___________ of a table.

Answer

Record
Column
Tuple
Key

Question 7

Question

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Answer

Domain
Relation
Set
Schema

Question 8

Question

Can you use the UPDATE and SELECT clauses in one SQL statement?

Answer

You can if you use nested SQL statement
You can’t
You can use UPDATE and SELECT clause together, even if you don’t have nested SQL

Question 9

Question

Can we temporarily disable a login name?

Answer

Question 10

Question

Permanent setting of specific server characteristics is done by trace tags

Answer

False
True

Question 11

Question

Which of the following statements is/are false for Extended events in sql server 2008?

Answer

Enhanced event handling system in SQL Server
Both b and c below
Used for problem identification or problem trouble shooting
An architecture that is not very scalable, highly configurable

Question 12

Question

When SQL server is installed, which of the following database are created by default?

Answer

Master
Model
Both a and b
Root

Question 13

Question

Which of the following statements is/are true for SQL server?

Answer

SQL Server has Logical Architecture and Physical Architecture
Both a and c
SQL Server is compatible with the structured query language and has rich for XML
SQL Server is a DBMS, a complete database.

Question 14

Question

What is the difference between the WHERE and HAVING SQL clauses?

Answer

The WHERE and the HAVING clauses are identical The HAVING SQL clause condition(s) is applied to all rows in the result set before the
WHERE clause is applied (if parent). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.
HAVING clause is applied (if parent). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group

Question 15

Question

What is the syntax for creation new login on the SQL server?

Answer

USE LOGIN login_id WITH PASSWORD password
CREATE LOGIN login_id WITH USE password
CREATE LOGIN login_id USE password
CREATE LOGIN login_id WITH PASSWORD password

Question 16

Question

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

Answer

A → B
A → C.
A → (B,C)
(B,C) → A.

Question 17

Question

The different classes of relations created by the technique for preventing modification anomalies are called:

Answer

normal forms.
referential integrity constraints.
functional dependencies.
None of the above is correct

Question 18

Question

Which of the following gives a logical structure of the database graphically ?

Answer

Entity-relationship diagram
Entity diagram
Database diagram
Architectural representation

Question 19

Question

The entity relationship set is represented in E-R diagram as

Answer

Double diamonds
Undivided rectangles
Dashed lines
Diamond

Question 20

Question

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?

Answer

Only 1
Only 2
Both 1 and 2 individually
Either 1 or 2

Question 21

Question

In OSI network architecture, the dialogue control and token management are responsibility of

Answer

session layer
network layer
transport layer
data link layer
none of above

Question 22

Question

In OSI network architecture, the routing is performed by

Answer

network layer
data link layer
transport layer
session layer
none of above

Question 23

Question

OSI stands for

Answer

open system interconnection
operating system interface
optical service implementation
none of the mentioned

Question 24

Question

The OSI model has ___ layers

Answer

Question 25

Question

Which of the following services use TCP? DHCP SMTP HTTP TFTP FTP

Answer

1 and 2
2, 3 and 5
1, 2 and 4
1, 3 and 4

Question 26

Question

What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?

Answer

Application
Host-to-Host
Internet
Network Access

Question 27

Question

Which of the following describe the DHCP Discover message? It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast. It uses UDP as the Transport layer protocol. It uses TCP as the Transport layer protocol. It does not use a layer 2 destination address.

Answer

1 only
1 and 2
3 and 4
4 only

Question 28

Question

You want to implement a mechanism that automates the IP configuration, including IP address, subnet mask, default gateway, and DNS information. Which protocol will you use to accomplish this?

Answer

SMTP
SNMP
DHCP
ARP

Question 29

Question

Which of the following is private IP address?

Answer

12.0.0.1
168.172.19.39
172.15.14.36
192.168.24.43

Question 30

Question

The _______ is the physical path over which a message travels.

Answer

Protocol
Medium
Signal
All the above

Question 31

Question

The information to be communicated in a data communications system is the _______.

Answer

Medium
Protocol
Message
Transmission

Question 32

Question

Frequency of failure and network recovery time after a failure are measures of the _______ of a network.

Answer

Performance
Reliability
Security
Feasibility

Question 33

Question

Which of this is not a class of IP address?

Answer

ClassE
ClassC
ClassD
ClassF

Question 34

Question

The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.

Answer

last four,first
first four,first
first four,last
last four,last

Question 35

Question

110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits

Answer

Class A
Class B
Class C
Class D

Question 36

Question

Which process can affect of be affected by other processes executing in the system?

Answer

cooperating process
child process
parent process
init process

Question 37

Question

An un-interruptible unit is known as

Answer

single
atomic
static
None of these

Question 38

Question

The wait-for graph is a deadlock detection algorithm that is applicable when :

Answer

all resources have a single instance
all resources have multiple instances
both a and b

Question 39

Question

In internal fragmentation, memory is internal to a partition and :

Answer

is being used
is not being used
is always used
None of these

Question 40

Question

Which of the following page replacement algorithms suffers from Belady’s Anomaly ?

Answer

Optimal replacement
LRU
FIFO
Both optimal replacement and FIFO

Question 41

Question

The main virtue for using single Bus structure is ,

Answer

Fast data transfers
Cost effective connectivity and speed
Cost effective connectivity and ease of attaching peripheral devices
None of these

Question 42

Question

______ are used to over come the difference in data transfer speeds of various devices .

Answer

Speed enhancing circuitory
Bridge circuits
Multiple Buses
Buffer registers

Question 43

Question

To extend the connectivity of the processor bus we use ______ .

Answer

PCI bus
SCSI bus
Controllers
Multiple bus

Question 44

Question

Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).

Answer

100-200
200-400
400-1000
above 1000

Question 45

Question

Selection of a model is based on

Answer

Requirements
Development team
Users
Project type and associated risk
All of the mentioned

Question 46

Question

Which of the following tags are related to Table in HTML ?

Answer

<table> <head> <body>
<table> <row> <column>
<table> <tr> <td>
<table> <header> <footer>

Question 47

Question

Which of the following is an attribute of <Table> tag?

Answer

src
cellpadding
Link
Bold

Question 48

Question

Which of the following is not a pair tag?

Answer

<p>
<u>
<i>
<img>

Question 49

Question

myarr[5] is equivalent of?

Answer

&(myarr + 5)
*(myarr + 5)
(*myarr + 5)
None of the above

Question 50

Question

The process of building new classes from existing one is called ______.

Answer

Polymorphism.
Structure
Inheritance
Cascading

	Created by monishalakshman about 10 years ago

Next up

Technical Part -2

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Question 41

Question 42

Question 43

Question 44

Question 45

Question 46

Question 47

Question 48

Question 49

Question 50

Similar