Database Management System (DBMS) SQL Practical Record
Hands-on practical manual with SQL queries, relational schemas, ER diagrams, triggers, and stored procedures for BCA students.
Database Management System · CACS202 · Semester 3
Unit 1•Unit 1 of 2
Unit 1: Database Management System (DBMS) Laboratory Manual & SQL Queries
Course Code: CACS202 | Tribhuvan University BCA 3rd Semester
Data Structures and Algorithms Complete Course (freeCodeCamp)
Open lesson pageLesson videos
Related notes
- Artificial Intelligence — Complete Course Notes (BCA 7th Sem)Notes
- Data Structures and Algorithms — Complete Course Notes (BCA 3rd Sem)Notes
- C Programming — Complete Course Notes (BCA 1st Sem)Notes
- Unit 1: Introduction to Programming Concepts and C Language NotesNotes
- Unit 2: Operators and Expressions NotesNotes
- Unit 3: Input and Output Operations NotesNotes
Related video lessons
Practice questions
- Which of the following is an invalid variable name in C? (a) _salary (b) 1st_rank (c) total_sum (d) age2objective · 1 marks
- What is the return type of the `malloc()` function in C? (a) `int*` (b) `char*` (c) `void*` (d) `float*`objective · 1 marks
- Explain the difference between call by value and call by reference in C with suitable code snippets.short · 5 marks
- What is recursion? Write a recursive function in C to calculate the factorial of a positive integer.short · 5 marks
- Explain dynamic memory allocation in C. Differentiate between `malloc()` and `calloc()`. Write a C program to dynamically allocate memory for N integers, sort them in ascending order, and free the memory.long · 10 marks
- What is the worst-case time complexity of Quick Sort algorithm? (a) O(n) (b) O(n log n) (c) O(n^2) (d) O(log n)objective · 1 marks