CCC Online Test

Menu mobile

Home
About
Question Bank
Study Material

Home
Course on Computer Concept (CCC)
SQL: QUERIES, CONSTRNNTS, TRIGGERS

Introduction to Computer
Introduction to Operating System
LibreOffice Writer
LibreOffice Calc
LibreOffice Impress
Introduction to Internet and WWW
Email Social Networking and eGovernance Services
Digital Financial Tools and Applications
Overview of Future Skills and Cyber Security
Introduction to Web Design
Editors
HTML
CSS
CSS Framework
Javscript and Angular Js
Photo Editor
Web Publishing and Browsing
Introduction to Programming
Algorithm and Flowcharts to solve problems
Introduction to Python
Operators Expressions and Python Statements
Sequence data types in python
Functions in Python
File Processing in Python
Modules in Python
NumPy Basics
Introduction to IoT
Things and Connections
Sensors, Actuators and Microcontrollers
Building IoT Applications
Security and Future of IoT Ecosystem
Soft skills-Personality Development
Introduction
Conditional Statements
Looping Statements
Jumping Statement
Arrays
Functions
Structure and Union
Pointers
File Processing
JAVA Object Oriented Programming
JAVA Introduction
JAVA Value and Types
JAVA Operators
JAVA Conditional Statements
JAVA Looping Statements
JAVA Methods
JAVA Class and Objects
JAVA Constructors
JAVA Library Classes
JAVA Arrays
JAVA Strings
JAVA Encapsulation
JAVA Inheritance
JAVA Polymorphism
HTML Introduction
HTML Text Formatting
HTML Images
HTML Links
HTML Lists
HTML Table
HTML Form
HTML Frameset
HTML Iframe
HTML Audio Video
Introduction
Syntax
Selectors
Properties in CSS
Animation in CSS
CSS Gradients
CSS Transforms
CSS Transitions
CSS Web Fonts
JS Introduction
JS Basic Syntax and Data Types
JS Control Flow and Loops
JS Functions
JS Arrays
Introduction
Decisions and loop
Function
Array and String
Forms Handling in PHP
File uploading in PHP
Session and Cookies in PHP
Database Connectivity with MySql
File Handling in PHP
BASIC OF ACCOUNTING
FUNDAMENTALS OF TALLY ERP 9
ACCOUNTING MASTERS IN TALLY ERP9
INVENTORY IN TALLY ERP 9
VOUCHERS ENTRIES IN TALLY ERP 9
ADVANCE ACCOUNTING IN TALLY ERP 9
ADVANCE INVENTORY IN TALLY ERP 9
VALUE ADDED TAX (VAT)
Operating system
MS Word
MS Excel
MS Powerpoint
MS Access
Computer Fundamental
Central Sales Tax (CST)
Point of Sale(PoS)
Report In Tally
Goods and Service Tax
Service Tax
Tax Deducted at Source
Data Structure Basics
Array
Linked List
Stack
Queue
Tree
Graph
Searching and Sorting
Creating an Application by Using WPF
JAVA File Handling
JAVA Recursion
JAVA Packages
JAVA Exception Handling
Multi Threading
JAVA Applet
JAVA Graphics
JAVA AWT and Event Handling
JAVA Swing
JAVA Remote Method Invocation RMI
JAVA JDBC
Storage Class
Child Development and Pedagogy
Hindi Language
English Language
Social Science
Mathematics and Science
Environmental Studies
Mathematics
Computer Science and IT
General Aptitude
October 2021
JQuery Introduction
Introduction to Multimedia
March 2021
April 2021
May 2021
June 2021
July 2021
August 2021
Books and Authors
Famous Personalities
Awards and Honors
Technology
February 2021
Invention
January 2021
Events
Science
India Geography
Sports
Database Fundamentals
MySQL Introduction
Object-Oriented Programming Concepts
Constructers and Destructors
Polymorphism
Inheritance
File Handling
Exception Handling
Class and Object
Paryayvachi Shabd
Tatsam and Tatbhav Shabd
Alanakar
Vilom Shabd
Anekarthi Shabd
Ling
Visheshan
Ekarth Shabd
Samash
Pratayay
Upsarg
Karak
Mukhya tath
Varn Mala
Vartani
Sandhi
Lokoktiyan
World Geography
Ancient Indian History
Medieval Indian History
Modern Indian History
Indian Economy
Indian Arts and Culture
September 2021
Muhavare
Shabd Vichar
Varn Vichar
Introduction to Mobile App Development
Getting Started with Mobile App Development
Building the User Interface
Adding Functionality to UI
Handling Data in Android
Working with Services and Broadcast Receivers
Enhancing the UI
Notifying the User
User Location-Based Service
Communication via Android App
Enhancing Apps with Graphics and Multimedia
Securing Android App
Testing and Deploying Android App
November 2021
December 2021
Uttar Pradesh GK
Madhya Pradesh GK
BIHAR GK
HARIYANA GK
Uttarakhand GK
CHHATTISGARH GK
JHARKHAND GK
Important Days and Dates
Gujrat Gk
Himachal Pradesh Gk
Karnataka Gk
Manipur GK
Goa GK
Assam GK
Maharastra GK
Kerala GK
Andhra Pradesh GK
January 2022
Udisha GK
Jammu and Kashmir GK
Panjab GK
Rajasthan GK
Sikkim GK
Tamil Nadu GK
Telangana GK
West Bengal GK
Andaman and Nicobar GK
Arunachal Pradesh GK
International GK
Defence GK
JQuery Effects
JQuery HTML
JQuery Traversing
JQuery Ajax
Computer Awareness
February 2022
Average Aptitude
Number system
Percentages
Simple Interest and Compound Interest
Profit and Loss
Mensuration
Time and Work
Time and Distance
Ratio
Elementary Statistics
Age Calculations
Sets
Trigonometry
Probability
Analogy
Series
Coding and Decoding
Puzzles
Direction and Distance
Blood Relation
Alphabet and Word
Venn Diagram
Missing Number
Non Verbal Reasoning
Classification
Verbal Reasoning
Square root
Calendar and Clock
Social Science Misc
Sangya
English Misc
CDP Misc
Managing databases
Working with tables
Constraints and Relationships
Querying data
Sorting data
Filtering data
Joining tables
Grouping data
Functions in Mysql
HTML Layout
HTML 5
March 2022
April 2022
May 2022
June 2022
August 2022
July 2022
Sandhi Vichchhed
rachanaye
Rash
Earth Systems and Resources
The Living World
Population
Land and Water Use
Energy Resources and Consumption
Pollution
Global Change
Climate Change
Resources and Development
Forest and Wildlife Resources
Water Resources
Agriculture
Minerals and Energy Resources
Manufacturing Industries
Lifelines of National Economy
The Rise of Nationalism in Europe
The Nationalist Movement in Indo- China
Nationalism in India
The Making of a Global World
The Age of Industrialisation
Work, Life and Leisure Cities in the Contemporary World
Print Culture and The Modern World
Novels, Society and the World Class
Power Sharing
Federalism
Democracy and Diversity
Gender, Religion and Caste
Popular Struggles and Movements
Political Parties
Outcomes of Democracy
Challenges to Democracy
Development
Sectors of the Indian Economy
Money and Credit
Globalisation and the Indian Economy
Consumer Rights
Indus Valley Key Civilization
Vedic Culture
Buddhism
Jainism
Maurya Dynasty
Gupta Dynasty
Harshvardhan
Rajput Period
Saltanat Kal
Mughal Empire
Maratha Empire
Real Number
LCM and HCF
Polynomial Equations
Geometry
September 2022
Units and Measurements
Measuring Devices and Scales
Motion Under Gravity
Physical Properties of Materials
Light
Thermodynamics
Wave Motion
Electric Current
Conductivity
Nuclear Physics
Constitution of India
Important Places in India
October 2022
November 2022
December 2022
Accounting Standards
Financial accounting
Management accounting
Auditing
Information systems
Tax accounting
Forensic accounting
The Solid State
Solutions
Electrochemistry
Chemical Kinetics
Surface Chemistry
General Principles and Processes of Isolation of Elements
The p Block Elements
The d & f Block Elements
Coordination Compounds
Haloalkanes and Haloarenes
Alcohols, Phenols, and Ethers
Aldehydes, Ketones, and Carboxylic Acids
Amines
Biomolecules
Polymers
Chemistry in Everyday Life
Electric Charges and Fields
Electrostatic Potential and Capacitance
Current Electricity
Moving Charges and Magnetism
Magnetism and Matter
Electromagnetic Induction
Alternating Current
Electromagnetic Waves
Ray Optics and Optical Instruments
Wave Optics
Database Connectivity in Python
Dual Nature of Radiation and Matter
Atoms
Nuclei
Semiconductor Materials
Communication System
Light-Reflection and Refraction
The Human Eye and The Colourful World
Electricity
Magnetic Effects Of Electric Current
Sources of Energy
Our Environment
Management of Natural Resources
January 2023
Reproduction in Organisms
Sexual Reproduction in Flowering Plants
Human Reproduction
CPU Scheduling
Synchornization
Deadlock
Memory Management
File System
Overview of Operating System
Computer Funcamental
Number system
Boolean Algebra Operations
Boolean Expression
Boolean Algebra Terminologies
Boolean Algebra Truth Table
Boolean Algebra Rules
Laws of Boolean Algebra
Boolean Algebra Theorems
K Map
How Do Organisms Reproduce
Heredity and Evolution
Our Environment
Management of Natural Resources
AngularJS Introduction
AngularJS Directives
AngularJS Expressions
AngularJS Model
AngularJS Modules
AngularJS Controller
February 2023
Mixed
Mix Questions
Relations and Functions
Complex Numbers
Quadratic Equations
Linear Inequalities
Permutations and Combinations
Binomial Theorem
Sequence and Series
Basic Computer Organisation
Types of software
Operating system (OS)
Boolean logic
Encoding schemes
Expansion of british power
Concept of Teaching
Characteristics of Teaching
Factors affecting Teaching
Methods of teaching
Impact of british rule on indian economy
Socio-religious movements of the 19th-20th centuries
Introduction to Tally Prime
Company Creation and Configuration
Inventory Management
Banking and Reconciliation
Billing and Invoicing
Receivable and Payables
Cost Management
Caste, Tribal, Peasant and labor movements
Freedom Movement l. Revolt of 1857
Moderate/Liberal Phase (1885–1905)
Garam Panthi / Extremist Phase (1905 AD-1917 AD)
Gandhi era (1917 AD-1947 AD)
Miscellaneous (Modern India)
Psychology Overview
March 2023
April 2023
Introduction to Cybersecurity
Cyber Threats and Attack Vectors
Network Security
May 2023
Conditional Statement
Looping Statement
Introduction to C++
Data Types Variables and Operataors
Pointer
Structure and Union
JS Objects
JS Events
JS DOM Manipulation
JS Browser Object Model
Miscellaneous
Introduction
ES6
Render HTML
JSX
Component
Class
Props
Events
Conditionals
Lists
Forms
Routers
Memo
CSS Styling
Sass Styling
Array
Anguler JS Integration with Other Libraries/Frameworks
Introduction to Node JS
Setup Dev Environment
Node JS Modules
Node Package Mananger
Creating Web server
Node JS File System
Debugging Node JS Application
Node JS Events
Express.JS
Serving Static Resources
Database connectivity
Template Engines
miscellaneous
Function in c++
Introduction to Django
Installation of Django
Understanding Django Projects and Apps
The Django Template System
Models and Databases
Views and URLs
Forms and Form Handling
Admin Interface
Authentication and Authorization
Static Files and Media Handling
Introduction to Tkinter
Designing Form
Event Handling in Tkinter
Database connectivity in Tkinter
June 2023
July 2023
August 2023
September 2023
October 2023
November 2023
December 2023
January 2024
February 2024
AngularJs Scopes
AngularJS Filters
AngularJS Services
AngularJS HTTP
AngularJS Tables
AngularJS Select
AngularJS SQL
AngularJS DOM
AngularJS Events
AngularJS Forms
AngularJS Validations
AngularJS API
AngularJS Includes
AngularJS Animations
AngularJS Rounting
AngularJS Application
JS Error Handling
JS Asynchronous JavaScript
JS ES6+ Features
JS Modules
JS Regular Expressions
JS Function Library
Vachan
Kriya
Kaal
vachya
Avayay
Chhand
vakya rachana
Social Issues
World Organizations
Entertainment
Medicine and Health
Space and Astronomy
Introduction to Photoshop 7
Working with Layers
Selection and Masking
Photo Editing
Text and Typography
Filters and Effects
Drawing and Painting
Working with Paths
Web Design with Photoshop 7
Exporting and Saving
Printing and Color Management
Introduction to CorelDRAW
Basic Tools and Functions
Working with Objects
Text and Typography
Color and Fills
Working with Layers
Image Editing
Advanced Drawing Techniques
Vectorizing Bitmaps
Page Layout and Printing
Web Graphics and Export
Symbols and Libraries
Advanced Effects
Interactive Tools
Introduction to PageMaker
User Interface
Document Setup
Text Handling
Graphics and Images
Page Elements
Typography
Color Management
Printing and Exporting
Crop Science
Livestock Farming
Soil Science
Agroecology
Agribusiness
Climate Change and Agriculture
Biotechnology in Agriculture
Water Management
Food Security
Digital Agriculture
Government Policies and Agriculture
Urban Agriculture
March 2024
Introduction to GUI Programming with Python
Widgets and Layout Management
Event Handling
Advanced Widgets and Customization
Data Handling and Integration
GUI Application Architecture
Networking and Communication
Deployment and Packaging
Project Development
Using $http service for AJAX calls
Endpoint Security
Identity and Access Management (IAM)
Data Protection
Security Operations and Incident Response
Cloud Security
Web Security
Mobile Security
Cybersecurity Compliance and Regulations
IoT Security
Blockchain Security
Cybersecurity Tools and Technologies
Ethical Hacking and Penetration Testing
Introduction to Go
Installing and Setting Up Go
Basic Syntax and Data Types
Control Structures
Functions and Methods
Pointers and Memory Management
Concurrency and Goroutines
Packages and Libraries
Error Handling
File Handling and I/O Operations
Web Development with Go
Database Access and ORM
JSON and XML Processing
Concurrency Patterns and Best Practices
April 2024
Introduction to Digital Marketing
Digital Marketing Strategy and Planning
Website and SEO
Content Marketing
Social Media Marketing
Email Marketing
Pay-Per-Click (PPC) Advertising
Affiliate Marketing and Influencer Marketing
Analytics and Data-Driven Marketing
Vouchers and Transactions
Taxation
Payroll Management
Master Data Management
Reports and Analysis
Backup and Restoration
May 2024
Introduction to Data Science
Python Basics
Data Manipulation with Pandas
Data Analysis and Visualization
Exploratory Data Analysis (EDA)
Statistical Analysis
Machine Learning with Python
Fundamental of Image Editing
June 2024
July 2024
Social Theory
Research Methods in Sociology
Social Institutions
Social Stratification and Inequality
Culture and Society
Social Change and Social Movements
Urban and Rural Sociology
Globalization and Society
Criminology and Deviance
Health, Medicine, and Society
August 2024
September 2024
October 2024
November 2024
December 2024
Import and Export in MYSQL
January 2025
OVERVIEW OF DATABASE SYSTEMS
INTRODUCTION TO DATABASE DESIGN
THE RELATIONAL MODEL
SQL: QUERIES, CONSTRNNTS, TRIGGERS
OVERVIEWOF STORAGE AND INDEXING
OVERVIEW'OF STORAGE AND INDEXING
STORING DATA: DISKS AND FILES
EXTERNAL SORTING
OVERVIEW OF TRANSACTION MANAGEMENT
CONCURRENCY CONTROL
INFORMATION SYSTEMS
COMPUTER HARDWARE – AN OVERVIEW
COMPUTER SOFTWARE – AN OVERVIEW
INTERNET AND OTHER TECHNOLOGIES
MANAGEMENT INFORMATION SYSTEMS – AN OVERVIEW
ENTERPRISE RESOURCE MANAGEMENT
E-GOVERNANCE IN INDIA
INFORMATION TECHNOLOGY LAW
SYSTEMS AUDIT – AN OVERVIEW
Metaphysics
Epistemology
Ethics (Moral Philosophy)
Aesthetics
Political Philosophy
INTRODUCTION TO COMMUNICATION
EFFECTIVE COMMUNICATION SKILLS
PROCESS OF COMMUNICATION
BARRIERS AND GATEWAYS IN COMMUNICATION
LETTERS IN BUSINESS
REPORTS WRITING IN BUSINESS
ORAL AND NON-VERBAL COMMUNICATION
PUBLIC SPEAKING AND PRESENTATION SKILLS
COMMUNICATION NEGOTIATIONS AND LEGAL ASPECTS
AGENCY CORRESPONDENCE IN BUSINESS
SENTENCE AND TEXT
THE VERB PHRASE
INFINITIVE, GERUND AND PARTICIPLES
THE NOUN PHRASE
ADJECTIVES, ADVERBS AND PREPOSITIONS
MAIN CLAUSES AND SUB CLAUSES
PROPOSITIONS
PATTERNS OF PROOF
INDUCTION
NUMBER THEORY
GRAPH THEORY
DIRECTED GRAPHS
RELATIONS AND PARTIAL ORDERS
STATE MACHINES
SUMS AND ASYMPTOTICS
RECURRENCES
CARDINALITY RULES
GENERATING FUNCTIONS
INFINITE SETS
EVENTS AND PROBABILITY SPACES
INDEPENDENCE
CONDITIONAL PROBABILITY
EXPECTATION
RANDOM VARIABLES AND DISTRIBUTIONS
DEVIATIONS
RANDOM WALKS
Macro
ERROR HANDLING
DYNAMIC MEMORY ALLOCATION
DATA STRUCTURE - RECURSION BASICS
STRUCTURE OF OPERATING SYSTEM
PROCESS MANAGEMENT
VIRTUAL MEMORY
SYSTEM PROTECTION
SYSTEM SECURITY
I/O SYSTEM
COMPUTER NETWORK FUNDAMENTALS
ARCHITECTURE AND DESIGN
BANDWIDTH AND THROUGHPUT
NETWORKING
THE DATA-LINK LAYER
802.11 LOCAL AREA WIRELESS NETWORKS
THE NETWORK LAYER (IP)
MORE ABOUT THE NETWORK LAYER
THE TRANSPORT LAYER (TCP & UDP)
THE DOMAIN NAME SERVICE (DNS)
PEER TO PEER NETWORKS
NETWORK SECURITY
INTRODUCTION AND ESSENTIAL CONCEPTS
FILE I/O
BUFFERED I/O
ADVANCED FILE I/O
PROCESS MANAGEMENT
ADVANCED PROCESS MANAGEMENT
FILE AND DIRECTORY MANAGEMENT
MEMORY MANAGEMENT
TIME
SYSTEM CONCEPTS AND INFORMATION SYSTEM ENVIRONMENT
PROJECT SELECTION AND MANAGEMENT
REQUIREMENTS DETERMINATION
PROCESS MODELING
DATA MODELING
MOVING INTO DESIGN
USER INTERFACE DESIGN
MOVING INTO IMPLEMENTATION
Data Manipulation and Cleaning
Recursion
Introduction to Web Development
Full-Stack Integration
Deployment
Advanced Topics
Capstone Project
MongoDB
Express.js
React.js
Node.js
Introduction to NoSQL databases.
MongoDB basics: Collections, Documents, Queries.
CRUD operations.
Indexing and Aggregation.
MongoDB Atlas (Cloud Database).
Setting up a Node.js and Express.js server.
Building RESTful APIs.
Middleware and Routing.
Error handling and validation.
Authentication with JWT (JSON Web Tokens).
February 2025
AJAX & PHP
March 2025
April 2025
May 2025

SQL: QUERIES, CONSTRNNTS, TRIGGERS

About

Login
Register
Install App
Whatsapp Channel
CCC Syllabus

Useful links

Join CCC Course
Programming Tutorials & Tricks
O Level Online Test
A Level Online Test
Current Affairs
Online Exam Quiz
Online Typing Test

Contact with Us

info@ccconlinetest.com