Top 25 Final Viva Question Instructor Ask From You In CS Project

[Ali Raza Tawary]

Top 25 Final Viva Question Instructor Ask From You In CS Project

Introduce Your Self and Your Project In 3 to 5 Lines ?
What is life Line ?
What arrow Shows ?
What are the Boxes Above the Life Line ?
What are The Actors ?
What Box on life line represents ?
What is Loop On Life Line ? Error Message etc ?
What is DDL ? commands Also ?
What is DML ? commands Also ?
What is DCL ? Commands Also ?
What is Primary Key . ?
What is Foreign Key ?
What Difference Between Unique and Primary Key .
Primary Key Could Be Null ?
Unique Key Could be Null ?
What is Normalization ?
What is De normalization ?
What is First Normal form ?
What is Second Third Normal Form?
What is Class Diagram ?
What is Relation between Classes ?
What is Aggregation composition Inheritance abstraction Encapsulation Polymorphic ?
What is Diamonds For ?
Which ones are functions in diagram ?
Which one attributes in diagram?

Answers Given Below Scroll The Topic.Thanks

[Ali Raza Tawary]

1) Introduce Your Self and Your Project In 3 to 5 Lines ?
Answer:
In The Name of Allah The Most Gracious and Merciful . My Name is Ali Raza My Student Id is Mc.......... and My Project Name is (Your Project Name) . My Project is About
( Now Introduce Project in 2 , 3 Lines )

[Ali Raza Tawary]

2 What is life Line ?
3 What arrow Shows ?
4What are the Boxes Above the Life Line ?
5What are The Actors ?
6What Box on life line represents ?
7 What is Loop On Life Line ? Error Message etc ?

Answers Are Given Below .
A sequence diagram describes an interaction among a set of objects participated in a collaboration (or scenario), arranged in a chronological order; it shows the objects participating in the interaction by their "lifelines" and the messages that they send to each other.


What is a Sequence Diagram in UML?
UML Sequence diagrams are interaction diagrams that detail how operations are carried out. As sequence diagrams can be used to capture the interaction between objects in the context of a collaboration, one of the primary uses of sequence diagrams is in the transition from requirements expressed as use cases to the next and more formal level of refinement. Use cases are often refined into one or more sequence diagrams.

Sequence diagrams are time focus and they show the order of the interaction visually by using the vertical axis of the diagram to represent time what messages are sent and when.

Sequence Diagrams captures interaction in different level of granularity:

high-level interactions between user of the system and the system, between the system and other systems, or between subsystems (sometimes known as system sequence diagrams)
the interaction that takes place in a collaboration that either realizes a use case or an operation (instance diagrams or generic diagrams)
Represent objects interact in (Model, View / Controller) MVC pattern of software framework
Lifeline
A lifeline represents an individual participant in the Interaction.


What is Actor
An Actor a type of role played by an entity that interacts with the subject (e.g., by exchanging signals and data). An actor can also be an external to the subject (i.e., in the sense that an instance of an actor is not a part of the instance of its corresponding subject). They typically represent roles played by human users, external hardware, or other subjects.



Note That:

An actor does not necessarily represent a specific physical entity but merely a particular role of some entity
A person may play the role of several different actors and, conversely, a given actor may be played by multiple different person.

What is Activation
An activation is represented by a thin rectangle on a lifeline) represents the period during which an element is performing an operation. The top and the bottom of the of the rectangle are aligned with the initiation and the completion time respectively



What is Call Message
A call message defines a particular communication between lifelines of an interaction, which represents an invocation of operation of target lifeline.



What is Return Message
A return message defines a particular communication between lifelines of an interaction, which represents the pass of information back to the caller of a corresponded former message.



What is Self Message
A self message defines a particular communication between lifelines of an interaction, which represents the invocation of message of the same lifeline.



What is Recursive Message
A recursive message defines a particular communication between lifelines of an interaction, which represents the invocation of message of the same lifeline. It's target points to an activation on top of the activation where the message was invoked from.


What is Destroy Message
A destroy message defines a particular communication between lifelines of an interaction, which represents the request of destroying the lifecycle of target lifeline.



What is Duration Message
A duration message defines a particular communication between lifelines of an interaction, which shows the distance between two time instants for a message invocation.

Note 2 or 3 Question Panel Must Ask you From Above Questions So Prepare These Question Very Well

[Ali Raza Tawary]

Panel Ask you Which one is your Favorite Subject You Tell Them Like DBMS and They Ask you Following Questions From you.


What is DDL ? commands Also ?
Data Definition Language (DDL)
Definition - What does Data Definition Language (DDL) mean?
A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc. This term is also known as data description language in some contexts, as it describes the fields and records in a database table.
Commonly used DDL in SQL querying are:
CREATE: This command builds a new table and has a predefined syntax. The CREATE statement syntax is CREATE TABLE [table name] ([column definitions]) [table parameters]. CREATE TABLE Employee (Employee Id INTEGER PRIMARY KEY, First name CHAR (50) NULL, Last name CHAR (75) NOT NULL).
ALTER: An alter command modifies an existing database table. This command can add up additional column, drop existing columns and even change the data type of columns involved in a database table. An alter command syntax is ALTER object type object name parameters. ALTER TABLE Employee ADD DOB Date.
DROP: A drop command deletes a table, index or view. Drop statement syntax is DROP object type object name. DROP TABLE Employee.

What is DML ? commands Also ?

DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements.


What is DCL ? Commands Also ?
A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization). In particular, it is a component of Structured Query Language (SQL). Examples of DCL commands include: GRANT to allow specified users to perform specified tasks.


What is Primary Key . ?

A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. A primary key's main features are: It must contain a unique value for each row of data. It cannot contain null values.


What is Foreign Key ?
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

What Difference Between Unique and Primary Key .

Behavior: Primary Key is used to identify a row (record) in a table, whereas Unique-key is to prevent duplicate values in a column (with the exception of a null entry). 2. Indexing: By default SQL-engine creates Clustered Index on primary-key if not exists and Non-Clustered Index on Unique-key.

Primary Key Could Be Null ?

SQL PRIMARY KEY Constraint. The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only one primary key, which may consist of single or multiple fields.


Unique Key Could be Null ?

One row in the database is allowed to have null for the value of the unique key constraint. Although a table should have a PK, it need not have any additional unique keys. However, tables can have more than one unique key if that meets your needs. Like PKs, unique keys can span multiple columns.

What is Normalization ?

Database normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. It was first proposed by Edgar F. Codd as an integral part of his relational model.

What is De normalization ?

Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data

What is First Normal form ?

First normal form is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.

What is Second Third Normal Form?

Second normal form is a normal form used in database normalization. 2NF was originally defined by E.F. Codd in 1971. To qualify for second normal form a relation must: be in first normal form not have any non-prime attribute that is dependent on any proper subset of any candidate key of the relation.

A relation is in third normal form if it is in 2NF and no non key attribute is transitively dependent on the primary key. ... The table in this example is in 1NF and in 2NF.

[Ali Raza Tawary]

What is Class Diagram ?

In software engineering, a class diagram in the Unified Modeling Language is a type of static structure diagram that describes the structure of a system by showing the system's classes, their attributes, operations, and the relationships among objects.

What is Relation between Classes ?

Classes can be related in two ways:
An aggregation relation, named Has-a:
class C2 is related by Has-a with class C1 when C2 has a field whose type is that of class C1. This relation can be generalized as: C2 has at least one field whose type is that of class C1.
An inheritance relation, named Is-a:
class C2 is a subclass of class C1 when C2 extends the behavior of C1. One big advantage of object-oriented programming is the ability to extend the behavior of an existing class while reusing the code written for the original class. When a class is extended, the new class inherits all the fields (data and methods) of the class being extended.
Aggregation
Class C1 aggregates class C2 when at least one of its instance variables has type C2. One gives the arity of the aggregation relation when it is known.
Let us define a figure as a set of points. Therefore we declare class picture (see figure 15.2), in which one of the fields is an array of points. Then the class picture aggregates point, using the generalized relation Has-a.

Inheritance Relation
This is the main relation in object-oriented programming. When class c2 inherits from class c1, it inherits all fields from the parent class. It can also define new fields, or redefine inherited methods to specialize them. Since the parent class has not been modified, the applications using it do not need to be adapted to the changes introduced in the new class.
Inheritance is the process through which the properties (state and behaviour) of parent is reflected in the child. In OOP, inheritance is beneficial because it allows for code reusability and polymorphism.

Encapsulation is a mechanism of wrapping the properties together as a single unit. In OOP, think of a class as an encapsulated unit of states(variables) and behaviours(methods/functions). Encapsulation allows Data-Hiding and Data Abstraction. Through abstraction, the user/programmer using the encapsulated class doesn't need to know the values of variables or the implementation of the methods. They just need to know which method to call to do which task.

Polymorphism is the ability of an object to take on many forms. In OOP, polymorphism is achieved through inheritance. Suppose you require an animal to pull a cart but there is no specific mentioning of which animal to use. The animal can be either an ox, horse, donkey or camel (which are all animals i.e., inherit the properties of what we would consider an animal in general). Therefore the animal object in this context is polymorphic.