Copy and Edit

Technical Part -2

Description

All related technical topics : 50 questions 100 Marks
monishalakshman
Quiz by monishalakshman, updated more than 1 year ago
monishalakshman
Created by monishalakshman over 10 years ago
112
0
0

Resource summary

Question 1

Question
The basic component of a file in a file system is a?
Answer
  • data item
  • Universe of Discourse
  • software
  • database system

Question 2

Question
UoD stands for?
Answer
  • data item
  • Universe of Discourse
  • software
  • database system

Question 3

Question
A relational database consists of a collection of
Answer
  • Tables
  • Fields
  • Records
  • Keys

Question 4

Question
A ________ in a table represents a relationship among a set of values.
Answer
  • Column
  • Key
  • Row
  • Entry

Question 5

Question
The term _______ is used to refer to a row.
Answer
  • Attribute
  • Tuple
  • Field
  • Instance

Question 6

Question
The term attribute refers to a ___________ of a table.
Answer
  • Record
  • Column
  • Tuple
  • Key

Question 7

Question
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Answer
  • Domain
  • Relation
  • Set
  • Schema

Question 8

Question
Can you use the UPDATE and SELECT clauses in one SQL statement?
Answer
  • 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

Question 9

Question
Can we temporarily disable a login name?
Answer
  • Yes
  • No

Question 10

Question
Permanent setting of specific server characteristics is done by trace tags
Answer
  • False
  • True

Question 11

Question
Which of the following statements is/are false for Extended events in sql server 2008?
Answer
  • 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

Question 12

Question
When SQL server is installed, which of the following database are created by default?
Answer
  • Master
  • Model
  • Both a and b
  • Root

Question 13

Question
Which of the following statements is/are true for SQL server?
Answer
  • 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.

Question 14

Question
What is the difference between the WHERE and HAVING SQL clauses?
Answer
  • 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

Question 15

Question
What is the syntax for creation new login on the SQL server?
Answer
  • 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

Question 16

Question
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:
Answer
  • A → B
  • A → C.
  • A → (B,C)
  • (B,C) → A.

Question 17

Question
The different classes of relations created by the technique for preventing modification anomalies are called:
Answer
  • normal forms.
  • referential integrity constraints.
  • functional dependencies.
  • None of the above is correct

Question 18

Question
Which of the following gives a logical structure of the database graphically ?
Answer
  • Entity-relationship diagram
  • Entity diagram
  • Database diagram
  • Architectural representation

Question 19

Question
The entity relationship set is represented in E-R diagram as
Answer
  • Double diamonds
  • Undivided rectangles
  • Dashed lines
  • Diamond

Question 20

Question
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 ?
Answer
  • Only 1
  • Only 2
  • Both 1 and 2 individually
  • Either 1 or 2

Question 21

Question
In OSI network architecture, the dialogue control and token management are responsibility of
Answer
  • session layer
  • network layer
  • transport layer
  • data link layer
  • none of above

Question 22

Question
In OSI network architecture, the routing is performed by
Answer
  • network layer
  • data link layer
  • transport layer
  • session layer
  • none of above

Question 23

Question
OSI stands for
Answer
  • open system interconnection
  • operating system interface
  • optical service implementation
  • none of the mentioned

Question 24

Question
The OSI model has ___ layers
Answer
  • 4
  • 5
  • 6
  • 7

Question 25

Question
Which of the following services use TCP? DHCP SMTP HTTP TFTP FTP
Answer
  • 1 and 2
  • 2, 3 and 5
  • 1, 2 and 4
  • 1, 3 and 4

Question 26

Question
What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?
Answer
  • Application
  • Host-to-Host
  • Internet
  • Network Access

Question 27

Question
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.
Answer
  • 1 only
  • 1 and 2
  • 3 and 4
  • 4 only

Question 28

Question
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?
Answer
  • SMTP
  • SNMP
  • DHCP
  • ARP

Question 29

Question
Which of the following is private IP address?
Answer
  • 12.0.0.1
  • 168.172.19.39
  • 172.15.14.36
  • 192.168.24.43

Question 30

Question
The _______ is the physical path over which a message travels.
Answer
  • Protocol
  • Medium
  • Signal
  • All the above

Question 31

Question
The information to be communicated in a data communications system is the _______.
Answer
  • Medium
  • Protocol
  • Message
  • Transmission

Question 32

Question
Frequency of failure and network recovery time after a failure are measures of the _______ of a network.
Answer
  • Performance
  • Reliability
  • Security
  • Feasibility

Question 33

Question
Which of this is not a class of IP address?
Answer
  • ClassE
  • ClassC
  • ClassD
  • ClassF

Question 34

Question
The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.
Answer
  • last four,first
  • first four,first
  • first four,last
  • last four,last

Question 35

Question
110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits
Answer
  • Class A
  • Class B
  • Class C
  • Class D

Question 36

Question
Which process can affect of be affected by other processes executing in the system?
Answer
  • cooperating process
  • child process
  • parent process
  • init process

Question 37

Question
An un-interruptible unit is known as
Answer
  • single
  • atomic
  • static
  • None of these

Question 38

Question
The wait-for graph is a deadlock detection algorithm that is applicable when :
Answer
  • all resources have a single instance
  • all resources have multiple instances
  • both a and b

Question 39

Question
In internal fragmentation, memory is internal to a partition and :
Answer
  • is being used
  • is not being used
  • is always used
  • None of these

Question 40

Question
Which of the following page replacement algorithms suffers from Belady’s Anomaly ?
Answer
  • Optimal replacement
  • LRU
  • FIFO
  • Both optimal replacement and FIFO

Question 41

Question
The main virtue for using single Bus structure is ,
Answer
  • Fast data transfers
  • Cost effective connectivity and speed
  • Cost effective connectivity and ease of attaching peripheral devices
  • None of these

Question 42

Question
______ are used to over come the difference in data transfer speeds of various devices .
Answer
  • Speed enhancing circuitory
  • Bridge circuits
  • Multiple Buses
  • Buffer registers

Question 43

Question
To extend the connectivity of the processor bus we use ______ .
Answer
  • PCI bus
  • SCSI bus
  • Controllers
  • Multiple bus

Question 44

Question
Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).
Answer
  • 100-200
  • 200-400
  • 400-1000
  • above 1000

Question 45

Question
Selection of a model is based on
Answer
  • Requirements
  • Development team
  • Users
  • Project type and associated risk
  • All of the mentioned

Question 46

Question
Which of the following tags are related to Table in HTML ?
Answer
  • <table> <head> <body>
  • <table> <row> <column>
  • <table> <tr> <td>
  • <table> <header> <footer>

Question 47

Question
Which of the following is an attribute of <Table> tag?
Answer
  • src
  • cellpadding
  • Link
  • Bold

Question 48

Question
Which of the following is not a pair tag?
Answer
  • <p>
  • <u>
  • <i>
  • <img>

Question 49

Question
myarr[5] is equivalent of?
Answer
  • &(myarr + 5)
  • *(myarr + 5)
  • (*myarr + 5)
  • None of the above

Question 50

Question
The process of building new classes from existing one is called ______.
Answer
  • Polymorphism.
  • Structure
  • Inheritance
  • Cascading
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

ExamTime's Getting Started Guide
PatrickNoonan
A-level Sociology Quiz
Chuck Amobi
A-Level Chemistry: Atomic Structure
cian.buckley+1
MODE, MEDIAN, MEAN, AND RANGE
Elliot O'Leary
Cell Organelles and Functions
Melinda Colby
GCSE AQA Biology 2 DNA & Cell Division
Lilac Potato
AS Biology Unit 1
lilli.atkin
Acids and Bases
Sarah Egan
New GCSE Maths
Sarah Egan
Britain and World War 2
Sarah Egan
Rossetti Links
Mrs Peacock
Browse Library