Professional Knowledge Quiz

Q.1 NULL is

(A) the same as 0 for integer
(B) the same as blank for character
(C) the same as 0 for integer and blank for character
(D) not a value


Q.2 Which of the following is record based logical model?
(A) Network Model
(B) Object oriented model
(C) E-R Model
(D) None of these

Q.3 A data dictionary is a special file that contains:
(A) The name of all fields in all files.
(B) The width of all fields in all files.
(C) The data type of all fields in all files.
(D) All of the above.

Q.4 A file manipulation command that extracts some of the records from a file is called
(A) SELECT
(B) PROJECT
(C) JOIN
(D) PRODUCT

Q.5 The physical location of a record is determined by a mathematical formula that transforms  a file key into a record location is :
(A) B-Tree File
(B) Hashed File
(C) Indexed File
(D) Sequential file.

Q.6 Using Relational Algebra the query that finds customers, who have a balance of over 1000 is
(A) PCustomer_name(s balance >1000(Deposit))
(B) s Customer_name(Pbalance >1000(Deposit))
(C) PCustomer_name(s balance >1000(Borrow))
(D) s Customer_name(Pbalance >1000(Borrow))

Q.7 A primary key is combined with a foreign key creates
(A) Parent-Child relation ship between the tables that connect them.
(B) Many to many relationship between the tables that connect them.
(C) Network model between the tables that connect them.
(D) None of the above.

Q.8 In E-R Diagram derived attribute are represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle

Q.9 Cross Product is a:
(A) U nary Operator
(B) Ternary Operator
(C) Binary Operator
(D) Not an operator

Q.10 An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true?
(A) A is a candidate key
(B) A is not a candidate key
(C) A is a primary Key
(D) Both (A) and (C)

Q.11 Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:
(A) mn
(B) m+n
(C) (m+n)/2
(D) 2(m+n)

Q.12 The natural join is equal to :
(A) Cartesian Product
(B) Combination of Union and Cartesian product
(C) Combination of selection and Cartesian product
(D) Combination of projection and Cartesian product

Q.13 Which one of the following is not true for a view:
(A) View is derived from other tables.
(B) View is a virtual table.
(C) A view definition is permanently stored as part of the database.
(D) View never contains derived columns.

Q.14 A primary key if combined with a foreign key creates
(A) Parent-Child relationship between the tables that connect them.
(B) Many to many relationship between the tables that connect them.
(C) Network model between the tables that connect them.
(D) None of the above.

Q.15 In E-R Diagram relationship type is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Diamond


ANSWERS:
Ans 1: D
Ans 2: A
Ans 3: D
Ans 4: A
Ans 5: B
Ans 6: A
Ans 7: A
Ans 8: B
Ans 9: C
Ans 10: B
Ans 11: A
Ans 12: D
Ans 13: C
Ans 14: A
Ans 15: D

00:20 - By Unknown 0

Professional Knowledge Quiz

Ques. 1 Database management systems are used to

A. eliminate data redundancy
B. establish relationships among records in different files
C. manage file access
D. none of above


Ques. 2 Ascending order of data hierarchy is
A. bit->byte->record->field->file->database
B. bit->byte->field->record->file->database
C. byte->bit->field->record->file->database
D. byte->bit->field->file->record->database

Ques. 3 Which among following is not a router function
A. Packet Switching
B. Packet Filtering
C. Internetwork communication
D. Forwarding broadcasts by default

Ques. 4 Framing is done on which layer
A. Datalink Layer
B. Physical Layer
C. Transport Layer
D. Application Layer

Ques. 5 Segments are made on which layer
A. Session Layer
B. Transport Layer
C. Application Layer
D. Network Layer

Ques. 6 Which layer deals with Flow control?
A. Session Layer
B. Network Layer
C. Transport Layer
D. Application Layer

Ques. 7 Which layer deals with TCP and UDP?
A. Transport Layer
B. Physical Layer
C. Network Layer
D. None of above

Ques. 8 Which of the following performs modulation and demodulation?
A. Modem
B. Fiber optic
C. satellite
D. coaxial cable

Ques. 9 X.25 standard specifies
A. technique for start-stop data
B. technique for dial access
C. DTE/DCE interface
D. data bit rate

Ques. 10 IPV6 is in which format?
A. Hexadecimal format
B. Octal format
C. Alphanumeric format
D. Numeric format




ANSWERS:
1. A
2. B
3. D
4. A
5. B
6. C
7. A
8. A
9. C
10. A

00:40 - By Unknown 0

SBI IT OFFICER - Professional Knowledge Quiz

Dear Readers,

In view of the upcoming SBI IT Officer Examination, we have decided to provide you all a daily quiz on Professional Knowledge. Hope the post provides to be a fruitful for you all and hope you succeed in the upcoming exams!!!

Ques. 1 It is possible to define a schema completely using 

(A) VDL and DDL. 

(B) DDL and DML. 

(C) SDL and DDL.

(D) VDL and DML

Ques. 2 Which of the following is a valid SQL type? 

(A) CHARACTER 

(B) NUMERIC 

(C) FLOAT 

(D) All of the above 

Ques. 3 The RDBMS terminology for a row is 

(A) tuple. 

(B) relation. 

(C) attribute. 

(D) degree. 

Ques. 4 Which of the following operations need the participating relations to be union compatible? 

(A) UNION 

(B) INTERSECTION 

(C) DIFFERENCE

(D) All of the above

Ques. 5 The full form of DDL is 

(A) Dynamic Data Language 

(B) Detailed Data Language 

(C) Data Definition Language 

(D) Data Derivation Language

ANS C

Ques. 6 Which of the following is an advantage of view? 

(A) Data security 

(B) Derived columns 

(C) Hiding of complex queries 

(D) All of the above 

Ques. 7 A set of possible data values is called 

(A) attribute 

(B) degree 

(C) tuple

(D) domain. 

Ques. 8 Which of the operations constitute a basic set of operations for manipulating relational 

data? 

(A) Predicate calculus 

(B) Relational calculus 

(C) Relational algebra 

(D) None of the above 

Ques. 9 Which of the following is another name for weak entity? 

(A) Child 

(B) Owner 

(C) Dominant 

(D) All of the above 

Ques. 10 Which of the following database object does not physically exist? 

(A) base table 

(B) index 

(C) view 

(D) none of the above 

ANSWERS:

Ans 1 : B

Ans 2 : D 

Ans 3 : A 

Ans 4 : D

Ans 5 : D

Ans 6 : D

Ans 7 : D

Ans 8 : C

Ans 9 : A

Ans 10: C

05:14 - By Unknown 0

Professional Knowledge Quiz

1. Which of the following services use TCP?
a. DHCP
b. SMTP
c. HTTP
d. TFTP
e. FTP


A. a and b
B. b, c and e
C. a, b and d
D. a, c and d

2. What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?

A. Application
B. Host-to-Host
C. Internet
D. Network Access

3. Which of the following describe the DHCP Discover message?

a. It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast.
b. It uses UDP as the Transport layer protocol.
c. It uses TCP as the Transport layer protocol.
d. It does not use a layer 2 destination address.

A. a only
B. a and b
C. c and d
D. d only


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?

A. SMTP
B. SNMP
C. DHCP
D. ARP

5. Which of the following is private IP address?

A.12.0.0.1
B. 168.172.19.39
C. 172.15.14.36
D. 192.168.24.43

6. Which of the following allows a router to respond to an ARP request that is intended for a remote host?

A. Gateway DP
B. Reverse ARP (RARP)
C. Proxy ARP
D. Inverse ARP (IARP)

7. The DoD model (also called the TCP/IP stack) has four layers. Which layer of the DoD model is equivalent to the Network layer of the OSI model?

A. Application
B. Host-to-Host
C. Internet
D. Network Access

8. Which of the following services use UDP?

a. DHCP
b. SMTP
c. SNMP
d. FTP
e. HTTP
f. TFTP
A. a, c and 6
B. b and d
C. a, b and d
D. All of the above

9. Which class of IP address provides a maximum of only 254 host addresses per network ID?

A. Class A
B. Class B
C. Class C
D. Class D

10. If you use either Telnet or FTP, which is the highest layer you are using to transmit data?

A. Application
B. Presentation
C. Session
D. Transport



ANSWERS:
1. B
2. B
3. B
4. C
5. D
6. C
7. C
8. A
9. C
10. A

05:05 - By Unknown 0

Professional Knowledge Quiz

1. How long is an IPv6 address?

A. 32 bits
B. 128 bytes
C. 64 bits
D. 128 bits


2. What flavor of Network Address Translation can be used to have one IP address allow many users to connect to the global Internet?
A. NAT
B. Static
C. Dynamic
D. PAT

3. What are the two main types of access control lists (ACLs)?
I.  Standard
II. IEEE
III.Extended
IV. Specialized
A. I and III
B. II and IV
C. III and IV
D. I and II

4. What command is used to create a backup configuration?
A. copy running backup
B. copy running-config startup-config
C. config mem
D. wr mem

5. You have 10 users plugged into a hub running 10Mbps half-duplex. There is a server connected to the switch running 10Mbps half-duplex as well. How much bandwidth does each host have to the server?
A. 100 kbps
B. 1 Mbps
C. 2 Mbps
D. 10 Mbps

6. Which WLAN IEEE specification allows up to 54Mbps at 2.4GHz?
A. A
B. B
C. G
D. N

7. Which of the following is the valid host range for the subnet on which the IP address 192.168.168.188 255.255.255.192 resides?
A. 192.168.168.129-190
B. 192.168.168.129-191
C. 92.168.168.128-190
D. 192.168.168.128-192

8. To back up an IOS, what command will you use?
A. backup IOS disk
B. copy ios tftp
C. copy tftp flash
D. copy flash tftp

9. What protocol does PPP use to identify the Network layer protocol?
A. NCP
B. ISDN
C. HDLC
D. LCP

10. Which of the following commands will allow you to set your Telnet password on a Cisco router?
A line telnet 0 4
B. line aux 0 4
C. line vty 0 4
D. line con 0

11. Which protocol does DHCP use at the Transport layer?
A. IP
B. TCP
C. UDP
D. ARP

12. Which command is used to determine if an IP access list is enabled on a particular interface?
A. show access-lists
B. show interface
C. show ip interface
D. show interface access-lists

13. Where is a hub specified in the OSI model?
A. Session layer
B. Physical layer
C. Data Link layer
D. Application layer

14. What does the passive command provide to dynamic routing protocols?
A. Stops an interface from sending or receiving periodic dynamic updates.
B. Stops an interface from sending periodic dynamic updates but not from receiving updates.
C. Stops the router from receiving any dynamic updates.
D. Stops the router from sending any dynamic updates.

15. Which protocol is used to send a destination network unknown message back to originating hosts?
A. TCP
B. ARP
C. ICMP
D. BootP

ANSWERS:

1. D

2. D

3. A

4. B

5. D

6. C

7. A

8. D

9. A

10. C

11. C

12. C

13. B

14. B

15. C

05:00 - By Unknown 0