Scribd
Upload
2 views3 pages

Computer Applications Lab Curriculum

The document outlines the curriculum for the Computer Application Honors program at Ranchi University, focusing on practical examinations for Turing Machines, Visual Basic .NET, and Database Management Systems. It details the structure of practical exams, including question groups, marks distribution, and assignment requirements. Additionally, it specifies SQL commands and database operations to be covered in the course.

Uploaded by

Md Istekhar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views3 pages

Computer Applications Lab Curriculum

The document outlines the curriculum for the Computer Application Honors program at Ranchi University, focusing on practical examinations for Turing Machines, Visual Basic .NET, and Database Management Systems. It details the structure of practical exams, including question groups, marks distribution, and assignment requirements. Additionally, it specifies SQL commands and database operations to be covered in the course.

Uploaded by

Md Istekhar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

COMPUTER APPLICATION HONS.

CBCS CURRICULUM RANCHI UNIVERSITY

C8: TURING MACHINE

DFA

NFA

PDA

COMPUTER PRACTICAL- C 9 LAB 60 Lectures

Marks : Pr (ESE: 3Hrs)=50 Pass Marks: Pr (ESE) = 20

Instruction to Question Setter for

Practical Examination (ESE)

There will be two group of questions in Practical Examination of 3Hrs.. Group A having questions from
CORE PAPER 9 (CC9) will contain four questions, out of which any two are to be answered Group B
having questions from CORE PAPER 10 (CC10) will contain four questions, out of which any two is to be
answered.

Lab: Student have to Answer the given questions on Answer booklet and execute the answered
programs/steps in computer with standard output.

Assignment: The Assignment should be hand written in A4 size paper. First three pages (i.e. front page
+ acknowledgment

+ index) & Bibliography may be printout.


COMPUTER APPLICATION HONS. CBCS CURRICULUM RANCHI UNIVERSITY

Marks Distribution:

LAB(Experiment + Answer script) = 30 marks

Assignment =10 marks

Viva-voce =10 marks

VISUAL BASIC. NET

 Console Based Programming

 Window Based Programming

 Application Development using Database connectivity

COMPUTER PRACTICAL-C 10 LAB 60 Lectures DATABASE MANAGEMENT SYSTEMS

SQL * plus and SQL Commands:

1. Use of SQL *Plus Buffer Commands, Environment variables and Data Types.

2. Use of select, from, where,

3.

4. order by, having, group by.

5. Use of IN, NOT IN, IS NULL, IS NOT NULL, LIKE, % or _, ALL, ANY, SOME, EXISTS, BETWEEN.

6. Use of AND, OR, NOT, UNION, UNION ALL, INTERSECT, MINUS in SQL.

7. Using DDL and DML with database objects like Table, View, Sequence, Synonym and Index.

8. Use of COMMIT, ROLLBACK, SAVEPOINT.

9. GRANT & REVOKE privileges on database objects.

10. Use of sub-query, correlated sub-query, self-join, equi-join,

11. Displaying data from multiple tables.


COMPUTER APPLICATION HONS. CBCS CURRICULUM RANCHI UNIVERSITY

12. Producing Readable output using SQL * plus.

You might also like