MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 251 Mcqs, each offering curated multiple-choice questions to sharpen your Neural Networks knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In Three-Schema Architecture, the schema which gives details about data types, constraints and entities is classified as |
| A. | internal schema |
| B. | external schema |
| C. | logical schema |
| D. | conceptual schema |
| Answer» E. | |
| 2. |
The association between two or more entities in a database system is classified as |
| A. | dynamic association |
| B. | relationship |
| C. | network model |
| D. | record models |
| Answer» C. network model | |
| 3. |
In a database of company, if the employees are classified as entity then the name of employees is called |
| A. | logical entity detail |
| B. | abstract detail |
| C. | attribute |
| D. | entity detail |
| Answer» D. entity detail | |
| 4. |
The objects in database description is called |
| A. | concept construct |
| B. | entity construct |
| C. | schema construct |
| D. | attribution construct |
| Answer» D. attribution construct | |
| 5. |
The process of converting the requests into results between three-schema architecture internal, external and conceptual levels is called |
| A. | mapping |
| B. | pitching |
| C. | transforming |
| D. | dependence |
| Answer» B. pitching | |
| 6. |
The local concurrency control, storage of data on disk pages and the buffering of disk pages are considered as tasks of |
| A. | client level |
| B. | server level |
| C. | open programming level |
| D. | database connectivity level |
| Answer» C. open programming level | |
| 7. |
The levels in which the three schema architecture can be defined includes |
| A. | internal schema |
| B. | conceptual schema |
| C. | external schema |
| D. | all of above |
| Answer» E. | |
| 8. |
The architecture of database in which the characteristics such as program insulations, multiple user support and the use of catalogs are achieved is classified as |
| A. | multiple-schema architecture |
| B. | single-schema architecture |
| C. | two-schema architecture |
| D. | three-schema architecture |
| Answer» E. | |
| 9. |
In two-tier client - server architecture, the functions of transaction server and query server are controlled by |
| A. | server side |
| B. | host side |
| C. | modulation side |
| D. | client side |
| Answer» B. host side | |
| 10. |
The type of relational database which incorporate the concepts of object database is classified as |
| A. | functional object system |
| B. | behavioral relational system |
| C. | extended relational system |
| D. | extended objects system |
| Answer» D. extended objects system | |
| 11. |
In DBMS, the description of database in the form of schema is also called |
| A. | extension of schema |
| B. | intension of schema |
| C. | mathematical operators of schema |
| D. | logical operators of schema |
| Answer» C. mathematical operators of schema | |
| 12. |
In database schema, the database snapshot is also called |
| A. | current set of entity |
| B. | current set of instances |
| C. | current set of entity |
| D. | current set of objects |
| Answer» C. current set of entity | |
| 13. |
The data model, access path and number of users of database management system are the criteria for |
| A. | logical phase basis of DBMS |
| B. | classification basis of DBMS |
| C. | data cycle basis of DBMS |
| D. | transaction phase basis of DBMS |
| Answer» C. data cycle basis of DBMS | |
| 14. |
The middle computer system which is accessed to access database server is classified as |
| A. | host server |
| B. | application server |
| C. | database server |
| D. | client server |
| Answer» C. database server | |
| 15. |
The type of data manipulation language which is used to describe the complex operations in more precise way is classified as |
| A. | internal mapping language |
| B. | non procedural language |
| C. | procedural language |
| D. | external mapping language |
| Answer» C. procedural language | |
| 16. |
For a three-schema architecture, there is strict partition between external, internal and conceptual level and the language used in this structure is |
| A. | view definition language |
| B. | logic map language |
| C. | concept mapping language |
| D. | storage mapping language |
| Answer» B. logic map language | |
| 17. |
DSL stands for ________ |
| A. | Data Storage Line |
| B. | Digital Subscriber Line |
| C. | Data Service Language |
| D. | Data Secure Language |
| Answer» C. Data Service Language | |
| 18. |
The Transmission Control Protocol divides a stream of data into smaller units that are called |
| A. | Frames |
| B. | Datagrams |
| C. | Segments |
| D. | Information |
| Answer» D. Information | |
| 19. |
TCP/IP does not define any specific protocol at the |
| A. | Network Layer |
| B. | Physical and Data Link Layers |
| C. | Transport layer |
| D. | Internet layer |
| Answer» C. Transport layer | |
| 20. |
The physical addresses change from |
| A. | point to point |
| B. | Hop to hop |
| C. | sender to receiver |
| D. | frame to frame |
| Answer» C. sender to receiver | |
| 21. |
The layer that is responsible for the process to process delivery of the entire message is |
| A. | Transport |
| B. | Session |
| C. | Application |
| D. | Presentation |
| Answer» B. Session | |
| 22. |
SONET stands for ________ |
| A. | Secure Offline Network |
| B. | Synchronous Optical Network |
| C. | Service Offline Network |
| D. | Secure Optical Netwrok |
| Answer» C. Service Offline Network | |
| 23. |
SMTP stands for ________ |
| A. | Service Message Transmission Permission |
| B. | Secure Message Transfer Protocol |
| C. | Simple Mail Transfer Protocol |
| D. | Simple Message Transfer Protocol |
| Answer» D. Simple Message Transfer Protocol | |
| 24. |
A logical address in the Internet is currently a |
| A. | 8 bit address |
| B. | 16 bit address |
| C. | 32 bit address |
| D. | 64 bit address |
| Answer» D. 64 bit address | |
| 25. |
When a message receive at the receiver end, data link layer removes the data meant for it, then passes the rest to |
| A. | Transport |
| B. | Network |
| C. | Physical |
| D. | Session |
| Answer» C. Physical | |
| 26. |
A 16-bit port address represents |
| A. | One single number |
| B. | four chunks of numbers |
| C. | two numbers |
| D. | both b and c |
| Answer» B. four chunks of numbers | |
| 27. |
Which user support layers allow interoperability among unrelated software system |
| A. | 1,2 |
| B. | 2,3 4 |
| C. | 1,3,6 |
| D. | 5,6,7 |
| Answer» E. | |
| 28. |
Logical Addresses are |
| A. | 16bit long |
| B. | 32bit long |
| C. | 64bit long |
| D. | 128bit long |
| Answer» C. 64bit long | |
| 29. |
The physical layer is responsible for movements of individual |
| A. | Bits |
| B. | frames |
| C. | Bytes |
| D. | Packet |
| Answer» B. frames | |
| 30. |
The second layer of the OSI model is |
| A. | Physical |
| B. | Data link |
| C. | Transport |
| D. | Session |
| Answer» C. Transport | |
| 31. |
ISO developed a standard model of computer data communication system which is known as |
| A. | OSI |
| B. | ANSI |
| C. | DEC |
| D. | SNA |
| Answer» B. ANSI | |
| 32. |
Layer of OSI model responsible for synchronization |
| A. | Physical Layer |
| B. | Data Link Layer |
| C. | Session Layer |
| D. | Presentation layer |
| Answer» D. Presentation layer | |
| 33. |
HTTP stands for ________ |
| A. | Hash Text Transfer Protocol |
| B. | Hyper Text Transfer Protocol |
| C. | Hash Transfer Text Protocol |
| D. | none of the mentioned |
| Answer» C. Hash Transfer Text Protocol | |
| 34. |
Route determination can be identified by |
| A. | Transport layer |
| B. | Application layer |
| C. | Network layer |
| D. | Presentation layer |
| Answer» D. Presentation layer | |
| 35. |
In terms of the size of the network the correct order (ascending) is – |
| A. | PAN, MAN, LAN, WAN |
| B. | LAN, MAN, WAN, PAN |
| C. | PAN, LAN, MAN, WAN |
| D. | LAN, PAN, MAN, WAN |
| Answer» D. LAN, PAN, MAN, WAN | |
| 36. |
A signal in which 1 bit lasts 0.001 s, the Bit rate would be |
| A. | 1kbps |
| B. | 500bps |
| C. | 5obps |
| D. | 1700bps |
| Answer» B. 500bps | |
| 37. |
The layer that is in between of session and application layer is |
| A. | Network |
| B. | Transport |
| C. | Presentation |
| D. | Data link |
| Answer» D. Data link | |
| 38. |
Which of the following are session layer check points? |
| A. | allow just a portion of a file to be resent |
| B. | detect and recover errors |
| C. | control the addition of headers |
| D. | are involved in dialog control |
| Answer» B. detect and recover errors | |
| 39. |
Unreliable and connectionless protocol is |
| A. | TCP |
| B. | ARP |
| C. | IP |
| D. | RARP |
| Answer» D. RARP | |
| 40. |
Layer of computer OSI model which provides services that directly supports user application is |
| A. | application |
| B. | presentation |
| C. | transport |
| D. | physical |
| Answer» B. presentation | |
| 41. |
The network layer provides the services for |
| A. | application layer |
| B. | Physical layer |
| C. | Session layer |
| D. | Transport layer |
| Answer» E. | |
| 42. |
Layer that is responsible for transferring Frames is |
| A. | Application layer |
| B. | Presentation layer |
| C. | Data link layer |
| D. | Session layer |
| Answer» D. Session layer | |
| 43. |
Frame boundaries are recognized and created by .................... |
| A. | Application layer |
| B. | Data Link layer |
| C. | Session layer |
| D. | Network layer |
| Answer» D. Network layer | |
| 44. |
A signal with 200 mill watts power passes through 10 devices, each with an average noise of2 microwatts, calculate SNR |
| A. | 5000 |
| B. | 10000 |
| C. | 150 |
| D. | 200 |
| Answer» C. 150 | |
| 45. |
In the OSI model, what is the main function of the transport layer? |
| A. | node-to-node delivery |
| B. | process-to-process message delivery |
| C. | synchronization |
| D. | updating and maintenance of routing tables |
| Answer» C. synchronization | |
| 46. |
The ____ created a model called the Open Systems Interconnection, which allows diverse systems to communicate. |
| A. | OSI |
| B. | ISO |
| C. | IEEE |
| D. | none of the above |
| Answer» C. IEEE | |
| 47. |
In the OSI model, encryption and decryption are functions of the ________ layer. |
| A. | transport |
| B. | session |
| C. | presentation |
| D. | application |
| Answer» D. application | |
| 48. |
__________ provides full transport layer services to applications. |
| A. | TCP |
| B. | UDP |
| C. | ARP |
| D. | none of the above |
| Answer» B. UDP | |
| 49. |
The session, presentation, and application layers are the ____ support layers. |
| A. | user |
| B. | network |
| C. | both (a) and (b) |
| D. | neither (a) nor (b) |
| Answer» B. network | |
| 50. |
The _______ layer links the network support layers and the user support layers. |
| A. | transport |
| B. | network |
| C. | data link |
| D. | session |
| Answer» B. network | |