COMPUTER NETWORKS LECTURE NOTES

MCA / BCA COMPUTER NETWORKS LECTURE NOTES (2019-20)

For JAVA PROGRAMMING LECTURE NOTES STUDENT MAY CLICK AT THIS LINK

https://drive.google.com/file/d/19Rb8D2c3Lw2DZjehRQIIGdCt8uFulIWL/view?usp=sharing

JAVA PROGRAMMING LECTURE NOTES

MCA / BCA JAVA PROGRAMMING LECTURE NOTES (2019-20)

For JAVA PROGRAMMING LECTURE NOTES STUDENT MAY CLICK AT THIS LINK

https://drive.google.com/open?id=1IZReQBhKMA6IPfgXBfTWDQ4-8nQNjFhq

DBMS Quiz 2019

DBMS Quiz 2019

a) A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
b) A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
c) The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
d) Course(course_id, sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
e) 1. In the __________ normal form, a composite attribute is converted to individual attributes.
a) First
b) Second
c) Third
d) Fourth
f) SQL can be used to:
a) Create database structures only
b) Query database data only
c) Modify database data only
d) All of the mentioned
g)  Using which language can a user request information from a database ?
a) Query
b) Relational
c) Structural
d) Compiler
h) The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
a) Select
b) Join
c) Union
d) Intersection
i) The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
a) Join
b) Projection
c) Select
d) Union
j) Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
k) To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table
l) Which of the following makes the transaction permanent in the database ?
a) View
b) Commit
c) Rollback
d) Flashback
m) In order to maintain the consistency during transactions database provides
a) Commit
b) Atomic
c) Flashback
d) Retain
n) A transaction completes its execution is said to be
a) Committed
b) Aborted
c) Rolled back
d) Failed
o) The default extension for an Oracle SQL*Plus file is:
a) .txt
b) .pls
c) .ora
d) .sql
p) What type of join is needed when you wish to include rows that do not have matching values?
a) Equi-join
b) Natural join
c) Outer join
d) All of the mentioned
q)  Which forms are based on the concept of functional dependency:
a) 1NF
b) 2NF
c) 3NF
d) 4NF
r) The entity set person is classified as student and employee. This process is called _________
a) Generalization
b) Specialization
c) Inheritance
d) Constraint generalization
s) Functional Dependencies are the types of constraints that are based on______
a) Key
b) Key revisited
c) Superset key
d) None of the mentioned
t) A deadlock exists in the system if and only if the wait-for graph contains a ___________
a) Cycle
b) Direction
c) Bi-direction
d) Rotation
U)Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema

V)Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema

W) To remove a relation from an SQL database, we use the ______ command.

a) Delete
b) Purge
c) Remove
d) Drop table

X) Updates that violate __________ are disallowed.

a) Integrity constraints
b) Transaction control
c) Authorization
d) DDL constraints

Y) The user defined data type can be created using

a) Create datatype
b) Create data
c) Create definetype
d) Create type

Z) In the __________ normal form, a composite attribute is converted to individual attributes.

a) First
b) Second
c) Third
d) Fourth

Java Quiz-I (2019-20) and Class Test papers

Java Quiz -I (2019-20)& Class Test Paper

1. For Java Programming Quiz Student can hit at given link

https://drive.google.com/file/d/1cRLyAW_BwQDqrdpc5Rta9zRTwZPnm6Tx/view?usp=sharing


https://drive.google.com/file/d/1cRLyAW_BwQDqrdpc5Rta9zRTwZPnm6Tx/view?usp=sharin

2. For SAD Class Test papers Student can hit at given link(please copy the following url and past it to your browser)

https://drive.google.com/file/d/1-Md4SOXV4TIzS2W2fq30jGT6XccB2TAD/view?usp=drivesdk


3. For IJP Class Test papers Student can hit at given link (please copy the following url and past it to your browser)

https://drive.google.com/file/d/1-MdpWQ9a-aA8n8TA3XCci-5QIDY_5417/view?usp=drivesdk

Student's Feedback Forms

Dear Students,

Please find the links for the Student's Feedback Forms

Feedback Form 1: 

https://docs.google.com/forms/d/e/1FAIpQLSezLTIJXDFuFSEQpEGH_hrtoZ1Jw-JW9-L4ijzBZbGlGYwLCw/viewform

Feedback Form 2:  

https://docs.google.com/forms/d/e/1FAIpQLSfJVOQfSLvu_dRGOj_WDKw9QvUrxJ2YMCGUwalhvzzwqq0S4Q/viewform

I have made you the editor of the form so that you could edit the form and permissions accordingly. In case of any further queries, feel free to contact me.

Regards

MCA / BCA JAVA PROGRAMMING LAB MANUAL 2019-20

 MCA/BCA JAVA PROGRAMMING LAB MANUAL 2019-20

Students may use this URL for java programming lab manual

https://drive.google.com/open?id=18GrQ5DEyOxDcYNuNuy2pl7eQ8D7yQERT

SPECIAL CARRY OVER THEORY EXAMINATION 2019

BCA-403        

B.C.A, - Semester-IV

SPECIAL CARRY OVER THEORY EXAMINATION 2019

DATA COMMUNICATION AND COMPUTER NETWORKS

                                 

Time:  03 Hours                                                                             Total Marks: 70

Note:     Attempt any five questions.

            

                                                                                                (14*5=70)

.

1.      What is computer networking? What are its main objectives of Computer Network?

2.      Discuss the OSI reference model? Discuss the functioning of each layer in detail.

3.      Explain Transmission media with the help of diagrams and their properties.     

4.      Explain, Slotted ALOHA and Pure ALOHA.                        

5.      What is framing? Explain the types of framing.

6.      Explain Domain Name System (DNS).

7.      Explain the LAN, MAN, and WAN.

8.      Difference Between Connectionless and Connection-Oriented Communication.

           9.      What are the advantages of encryption/decryption?

          10.  What is Error Control in Data Link Layer? Explain Stop and wait ARQ.

      Or

Short Notes :( Any Two)

(a) Routing.

(b) FTP and HTTP protocols.

(c) Transmission Mode.

(d) IP Addressing.