761594
Descripción
Test por monishalakshman, actualizado hace más de 1 año
|
Creado por monishalakshman
hace más de 10 años
|
|
Pregunta 1
Pregunta
The basic component of a file in a file system is a?
Respuesta
-
data item
-
Universe of Discourse
-
software
-
database system
Pregunta 2
Pregunta
UoD stands for?
Respuesta
-
data item
-
Universe of Discourse
-
software
-
database system
Pregunta 3
Pregunta
A relational database consists of a collection of
Respuesta
-
Tables
-
Fields
-
Records
-
Keys
Pregunta 4
Pregunta
A ________ in a table represents a relationship among a set of values.
Respuesta
-
Column
-
Key
-
Row
-
Entry
Pregunta 5
Pregunta
The term _______ is used to refer to a row.
Respuesta
-
Attribute
-
Tuple
-
Field
-
Instance
Pregunta 6
Pregunta
The term attribute refers to a ___________ of a table.
Respuesta
-
Record
-
Column
-
Tuple
-
Key
Pregunta 7
Pregunta
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Respuesta
-
Domain
-
Relation
-
Set
-
Schema
Pregunta 8
Pregunta
Can you use the UPDATE and SELECT clauses in one SQL statement?
Respuesta
-
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
Pregunta 9
Pregunta
Can we temporarily disable a login name?
Respuesta
-
Yes
-
No
Pregunta 10
Pregunta
Permanent setting of specific server characteristics is done by trace tags
Respuesta
-
False
-
True
Pregunta 11
Pregunta
Which of the following statements is/are false for Extended events in sql server 2008?
Respuesta
-
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
Pregunta 12
Pregunta
When SQL server is installed, which of the following database are created by default?
Respuesta
-
Master
-
Model
-
Both a and b
-
Root
Pregunta 13
Pregunta
Which of the following statements is/are true for SQL server?
Respuesta
-
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.
Pregunta 14
Pregunta
What is the difference between the WHERE and HAVING SQL clauses?
Respuesta
-
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
Pregunta 15
Pregunta
What is the syntax for creation new login on the SQL server?
Respuesta
-
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
Pregunta 16
Pregunta
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:
Respuesta
-
A → B
-
A → C.
-
A → (B,C)
-
(B,C) → A.
Pregunta 17
Pregunta
The different classes of relations created by the technique for preventing modification anomalies are called:
Respuesta
-
normal forms.
-
referential integrity constraints.
-
functional dependencies.
-
None of the above is correct
Pregunta 18
Pregunta
Which of the following gives a logical structure of the database graphically ?
Respuesta
-
Entity-relationship diagram
-
Entity diagram
-
Database diagram
-
Architectural representation
Pregunta 19
Pregunta
The entity relationship set is represented in E-R diagram as
Respuesta
-
Double diamonds
-
Undivided rectangles
-
Dashed lines
-
Diamond
Pregunta 20
Pregunta
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 ?
Respuesta
-
Only 1
-
Only 2
-
Both 1 and 2 individually
-
Either 1 or 2
Pregunta 21
Pregunta
In OSI network architecture, the dialogue control and token management are responsibility of
Respuesta
-
session layer
-
network layer
-
transport layer
-
data link layer
-
none of above
Pregunta 22
Pregunta
In OSI network architecture, the routing is performed by
Respuesta
-
network layer
-
data link layer
-
transport layer
-
session layer
-
none of above
Pregunta 23
Pregunta
OSI stands for
Respuesta
-
open system interconnection
-
operating system interface
-
optical service implementation
-
none of the mentioned
Pregunta 24
Pregunta
The OSI model has ___ layers
Respuesta
-
4
-
5
-
6
-
7
Pregunta 25
Pregunta
Which of the following services use TCP?
DHCP
SMTP
HTTP
TFTP
FTP
Respuesta
-
1 and 2
-
2, 3 and 5
-
1, 2 and 4
-
1, 3 and 4
Pregunta 26
Pregunta
What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?
Respuesta
-
Application
-
Host-to-Host
-
Internet
-
Network Access
Pregunta 27
Pregunta
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.
Respuesta
-
1 only
-
1 and 2
-
3 and 4
-
4 only
Pregunta 28
Pregunta
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?
Respuesta
-
SMTP
-
SNMP
-
DHCP
-
ARP
Pregunta 29
Pregunta
Which of the following is private IP address?
Respuesta
-
12.0.0.1
-
168.172.19.39
-
172.15.14.36
-
192.168.24.43
Pregunta 30
Pregunta
The _______ is the physical path over which a message travels.
Respuesta
-
Protocol
-
Medium
-
Signal
-
All the above
Pregunta 31
Pregunta
The information to be communicated in a data communications system is the _______.
Respuesta
-
Medium
-
Protocol
-
Message
-
Transmission
Pregunta 32
Pregunta
Frequency of failure and network recovery time after a failure are measures of the _______ of a network.
Respuesta
-
Performance
-
Reliability
-
Security
-
Feasibility
Pregunta 33
Pregunta
Which of this is not a class of IP address?
Respuesta
-
ClassE
-
ClassC
-
ClassD
-
ClassF
Pregunta 34
Pregunta
The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.
Respuesta
-
last four,first
-
first four,first
-
first four,last
-
last four,last
Pregunta 35
Pregunta
110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits
Respuesta
-
Class A
-
Class B
-
Class C
-
Class D
Pregunta 36
Pregunta
Which process can affect of be affected by other processes executing in the system?
Respuesta
-
cooperating process
-
child process
-
parent process
-
init process
Pregunta 37
Pregunta
An un-interruptible unit is known as
Respuesta
-
single
-
atomic
-
static
-
None of these
Pregunta 38
Pregunta
The wait-for graph is a deadlock detection algorithm that is applicable when :
Respuesta
-
all resources have a single instance
-
all resources have multiple instances
-
both a and b
Pregunta 39
Pregunta
In internal fragmentation, memory is internal to a partition and :
Respuesta
-
is being used
-
is not being used
-
is always used
-
None of these
Pregunta 40
Pregunta
Which of the following page replacement algorithms suffers from Belady’s Anomaly ?
Respuesta
-
Optimal replacement
-
LRU
-
FIFO
-
Both optimal replacement and FIFO
Pregunta 41
Pregunta
The main virtue for using single Bus structure is ,
Respuesta
-
Fast data transfers
-
Cost effective connectivity and speed
-
Cost effective connectivity and ease of attaching peripheral devices
-
None of these
Pregunta 42
Pregunta
______ are used to over come the difference in data transfer speeds of various devices .
Respuesta
-
Speed enhancing circuitory
-
Bridge circuits
-
Multiple Buses
-
Buffer registers
Pregunta 43
Pregunta
To extend the connectivity of the processor bus we use ______ .
Respuesta
-
PCI bus
-
SCSI bus
-
Controllers
-
Multiple bus
Pregunta 44
Pregunta
Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).
Respuesta
-
100-200
-
200-400
-
400-1000
-
above 1000
Pregunta 45
Pregunta
Selection of a model is based on
Respuesta
-
Requirements
-
Development team
-
Users
-
Project type and associated risk
-
All of the mentioned
Pregunta 46
Pregunta
Which of the following tags are related to Table in HTML ?
Respuesta
-
<table> <head> <body>
-
<table> <row> <column>
-
<table> <tr> <td>
-
<table> <header> <footer>
Pregunta 47
Pregunta
Which of the following is an attribute of <Table> tag?
Respuesta
-
src
-
cellpadding
-
Link
-
Bold
Pregunta 48
Pregunta
Which of the following is not a pair tag?
Respuesta
-
<p>
-
<u>
-
<i>
-
<img>
Pregunta 49
Pregunta
myarr[5] is equivalent of?
Respuesta
-
&(myarr + 5)
-
*(myarr + 5)
-
(*myarr + 5)
-
None of the above
Pregunta 50
Pregunta
The process of building new classes from existing one is called ______.
Respuesta
-
Polymorphism.
-
Structure
-
Inheritance
-
Cascading
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.