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