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