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