Quiz
Technical Part -2
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (50)
1The basic component of a file in a file system is a?
- Adata item
- BUniverse of Discourse
- C software
- D database system
2UoD stands for?
- Adata item
- B Universe of Discourse
- Csoftware
- D database system
3A relational database consists of a collection of
- ATables
- BFields
- CRecords
- DKeys
4A ________ in a table represents a relationship among a set of values.
- AColumn
- BKey
- CRow
- DEntry
5
The term _______ is used to refer to a row.- AAttribute
- BTuple
- CField
- DInstance
6The term attribute refers to a ___________ of a table.
- ARecord
- BColumn
- CTuple
- DKey
7For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
- ADomain
- BRelation
- CSet
- DSchema
8Can you use the UPDATE and SELECT clauses in one SQL statement?
- AYou can if you use nested SQL statement
- B You can’t
- CYou can use UPDATE and SELECT clause together, even if you don’t have nested SQL
9Can we temporarily disable a login name?
- AYes
- BNo
10Permanent setting of specific server characteristics is done by trace tags
- AFalse
- BTrue
11Which of the following statements is/are false for Extended events in sql server 2008?
- AEnhanced event handling system in SQL Server
- B Both b and c below
- CUsed for problem identification or problem trouble shooting
- DAn architecture that is not very scalable, highly configurable
12 When SQL server is installed, which of the following database are created by default?
- AMaster
- BModel
- CBoth a and b
- DRoot
13Which of the following statements is/are true for SQL server?
- A SQL Server has Logical Architecture and Physical Architecture
- BBoth a and c
- CSQL Server is compatible with the structured query language and has rich for XML
- DSQL Server is a DBMS, a complete database.
14What is the difference between the WHERE and HAVING SQL clauses?
- AThe WHERE and the HAVING clauses are identical
The HAVING SQL clause condition(s) is applied to all rows in the result set before the - BWHERE 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.
- CHAVING 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
- AThe WHERE and the HAVING clauses are identical
15What is the syntax for creation new login on the SQL server?
- AUSE LOGIN login_id WITH PASSWORD password
- B CREATE LOGIN login_id WITH USE password
- CCREATE LOGIN login_id USE password
- D CREATE LOGIN login_id WITH PASSWORD password
16Every 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:
- AA → B
- BA → C.
- CA → (B,C)
- D(B,C) → A.
17The different classes of relations created by the technique for preventing modification anomalies are called:
- Anormal forms.
- Breferential integrity constraints.
- Cfunctional dependencies.
- DNone of the above is correct
18Which of the following gives a logical structure of the database graphically ?
- AEntity-relationship diagram
- BEntity diagram
- CDatabase diagram
- DArchitectural representation
19The entity relationship set is represented in E-R diagram as
- ADouble diamonds
- BUndivided rectangles
- CDashed lines
- DDiamond
20Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?
- AOnly 1
- BOnly 2
- CBoth 1 and 2 individually
- DEither 1 or 2
21In OSI network architecture, the dialogue control and token management are responsibility of
- Asession layer
- Bnetwork layer
- Ctransport layer
- Ddata link layer
- Enone of above
22In OSI network architecture, the routing is performed by
- Anetwork layer
- Bdata link layer
- Ctransport layer
- Dsession layer
- Enone of above
23OSI stands for
- Aopen system interconnection
- Boperating system interface
- C optical service implementation
- D none of the mentioned
24 The OSI model has ___ layers
- A4
- B5
- C6
- D7
25Which of the following services use TCP?
DHCP
SMTP
HTTP
TFTP
FTP- A1 and 2
- B 2, 3 and 5
- C1, 2 and 4
- D1, 3 and 4
26What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?
- AApplication
- BHost-to-Host
- CInternet
- DNetwork Access
27Which 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.- A1 only
- B1 and 2
- C3 and 4
- D4 only
28You 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?
- ASMTP
- BSNMP
- CDHCP
- DARP
29Which of the following is private IP address?
- A12.0.0.1
- B168.172.19.39
- C172.15.14.36
- D192.168.24.43
30The _______ is the physical path over which a message travels.
- AProtocol
- BMedium
- CSignal
- DAll the above
31The information to be communicated in a data communications system is the _______.
- AMedium
- BProtocol
- CMessage
- DTransmission
32Frequency of failure and network recovery time after a failure are measures of the _______ of a network.
- APerformance
- BReliability
- CSecurity
- DFeasibility
33Which of this is not a class of IP address?
- AClassE
- BClassC
- CClassD
- DClassF
34The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.
- Alast four,first
- Bfirst four,first
- Cfirst four,last
- Dlast four,last
35110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits
- AClass A
- BClass B
- C Class C
- DClass D
36 Which process can affect of be affected by other processes executing in the system?
- Acooperating process
- Bchild process
- Cparent process
- Dinit process
37An un-interruptible unit is known as
- Asingle
- Batomic
- Cstatic
- DNone of these
38 The wait-for graph is a deadlock detection algorithm that is applicable when :
- Aall resources have a single instance
- Ball resources have multiple instances
- Cboth a and b
39 In internal fragmentation, memory is internal to a partition and :
- Ais being used
- B is not being used
- C is always used
- DNone of these
40Which of the following page replacement algorithms suffers from Belady’s Anomaly ?
- AOptimal replacement
- BLRU
- CFIFO
- DBoth optimal replacement and FIFO
41 The main virtue for using single Bus structure is ,
- AFast data transfers
- BCost effective connectivity and speed
- CCost effective connectivity and ease of attaching peripheral devices
- DNone of these
42______ are used to over come the difference in data transfer speeds of various devices .
- ASpeed enhancing circuitory
- BBridge circuits
- CMultiple Buses
- DBuffer registers
43To extend the connectivity of the processor bus we use ______ .
- APCI bus
- BSCSI bus
- CControllers
- DMultiple bus
44Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).
- A 100-200
- B 200-400
- C400-1000
- Dabove 1000
45Selection of a model is based on
- ARequirements
- B Development team
- CUsers
- DProject type and associated risk
- EAll of the mentioned
46Which of the following tags are related to Table in HTML ?
- A<table> <head> <body>
- B<table> <row> <column>
- C<table> <tr> <td>
- D<table> <header> <footer>
47Which of the following is an attribute of <Table> tag?
- Asrc
- Bcellpadding
- CLink
- DBold
48Which of the following is not a pair tag?
- A<p>
- B<u>
- C<i>
- D<img>
49myarr[5] is equivalent of?
- A&(myarr + 5)
- B*(myarr + 5)
- C(*myarr + 5)
- DNone of the above
50The process of building new classes from existing one is called ______.
- APolymorphism.
- BStructure
- CInheritance
- DCascading
Information
- Description
- All related technical topics : 50 questions 100 Marks
- Author
- monishalakshman
- Language
- English
- Views
- 140
- Rating
- No ratings yet Rate this quiz