Each question in this quiz is timed.
Click the button below to start the quiz.
The basic component of a file in a file system is a?
Universe of Discourse
UoD stands for?
Universe of Discourse
A relational database consists of a collection of
A ________ in a table represents a relationship among a set of values.
The term _______ is used to refer to a row.
The term attribute refers to a ___________ of a table.
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Can you use the UPDATE and SELECT clauses in one SQL statement?
You can if you use nested SQL statement
You can use UPDATE and SELECT clause together, even if you don’t have nested SQL
Can we temporarily disable a login name?
Permanent setting of specific server characteristics is done by trace tags
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?
Both a and b
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:
referential integrity constraints.
None of the above is correct
Which of the following gives a logical structure of the database graphically ?
The entity relationship set is represented in E-R diagram as
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 ?
Both 1 and 2 individually
Either 1 or 2
In OSI network architecture, the dialogue control and token management are responsibility of
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
Which of the following services use TCP?
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?
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.
3 and 4
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?
Which of the following is private IP address?
The _______ is the physical path over which a message travels.
All the above
The information to be communicated in a data communications system is the _______.
Frequency of failure and network recovery time after a failure are measures of the _______ of a network.
Which of this is not a class of IP address?
The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.
110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits
Which process can affect of be affected by other processes executing in the system?
An un-interruptible unit is known as
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 ?
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
To extend the connectivity of the processor bus we use ______ .
Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).
Selection of a model is based on
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?
Which of the following is not a pair tag?
myarr is equivalent of?
&(myarr + 5)
*(myarr + 5)
(*myarr + 5)
None of the above
The process of building new classes from existing one is called ______.