{"id":230548,"date":"2025-10-13T23:00:06","date_gmt":"2025-10-13T17:30:06","guid":{"rendered":"https:\/\/www.oliveboard.in\/blog\/?p=230548"},"modified":"2025-10-13T23:00:10","modified_gmt":"2025-10-13T17:30:10","slug":"database-and-sql-for-ssc-cgl","status":"publish","type":"post","link":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/","title":{"rendered":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_77 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of content<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#What_is_a_Database\" >What is a Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Types_of_Databases\" >Types of Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Important_Database_Terminologies\" >Important Database Terminologies<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#What_is_SQL\" >What is SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Common_SQL_Commands\" >Common SQL Commands<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Basic_SQL_Queries_for_Practice\" >Basic SQL Queries for Practice<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Advantages_of_Using_Databases\" >Advantages of Using Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#Key_Takeaways\" >Key Takeaways<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#FAQs\" >FAQs<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Database and SQL are among the most important topics in the Computer Awareness section of SSC CGL Tier 2. Questions from this topic test your understanding of how data is stored, organized, and managed in computer systems. Having basic knowledge of databases and SQL commands helps you answer these questions quickly and accurately.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-a-database\"><span class=\"ez-toc-section\" id=\"What_is_a_Database\"><\/span><strong>What is a Database?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A <strong>database<\/strong> is an organized collection of data that can be easily accessed, managed, and updated. It stores information in a structured format, usually in tables made up of rows and columns. Databases are used in almost every sector from banking systems to government offices to store and retrieve information efficiently.<\/p>\n\n\n\n<div class=\"wp-block-buttons alignwide is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button aligncenter\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/ssc-cgl-previous-year-papers\/?ref=contmk-db\" target=\"_blank\" rel=\"noreferrer noopener\">Download SSC CGL Tier 2 Previous Year papers for Free<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-types-of-databases\"><span class=\"ez-toc-section\" id=\"Types_of_Databases\"><\/span><strong>Types of Databases<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Databases can be categorized based on their structure and use. Understanding the types of databases helps you know how different systems store and manage data.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong><strong>Type of Database<\/strong><\/strong><\/td><td><strong><strong>Description<\/strong><\/strong><\/td><\/tr><tr><td><strong>Relational Database (RDBMS)<\/strong><\/td><td>Stores data in tables related by keys (e.g., MySQL, Oracle, SQL Server).<\/td><\/tr><tr><td><strong>Hierarchical Database<\/strong><\/td><td>Data is stored in a tree-like structure (e.g., IBM IMS).<\/td><\/tr><tr><td><strong>Network Database<\/strong><\/td><td>Data is represented using records and links (e.g., Integrated Data Store).<\/td><\/tr><tr><td><strong>Object-Oriented Database<\/strong><\/td><td>Stores data as objects, similar to programming languages (e.g., ObjectDB).<\/td><\/tr><tr><td><strong>Distributed Database<\/strong><\/td><td>Data is stored across multiple systems but acts as a single database.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/ssc-cgl-free-pyp-kit\/?ref=contmk-blogs\" target=\"_blank\" rel=\"noreferrer noopener\">Download Complete SSC CGL Tier 2 PYP Kit E-book for free<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-important-database-terminologies\"><span class=\"ez-toc-section\" id=\"Important_Database_Terminologies\"><\/span><strong>Important Database Terminologies<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before learning SQL, it\u2019s important to understand some key database terms that form the foundation of this topic.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong><strong>Term<\/strong><\/strong><\/td><td><strong><strong>Meaning<\/strong><\/strong><\/td><\/tr><tr><td><strong>Table<\/strong><\/td><td>Collection of rows and columns where data is stored.<\/td><\/tr><tr><td><strong>Row (Record)<\/strong><\/td><td>A single entry or data item in a table.<\/td><\/tr><tr><td><strong>Column (Field)<\/strong><\/td><td>A specific attribute or data type in the table.<\/td><\/tr><tr><td><strong>Primary Key<\/strong><\/td><td>Unique identifier for each record in a table.<\/td><\/tr><tr><td><strong>Foreign Key<\/strong><\/td><td>Links two tables together using a common field.<\/td><\/tr><tr><td><strong>Schema<\/strong><\/td><td>The structure that defines how data is organized in a database.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button aligncenter\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/ssc-typing-test\/?ref=contmk-db\" target=\"_blank\" rel=\"noreferrer noopener\">Attempt SSC CGL Typing Test for free<\/a><\/div>\n<\/div>\n\n\n\n<p>Also check out: <a href=\"https:\/\/www.oliveboard.in\/blog\/ssc-cgl-typing-test-error\/\"><strong>SSC CGL Typing Test Errors<\/strong><\/a> to minimize your errors in Data Entry Speed Test.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-sql\"><span class=\"ez-toc-section\" id=\"What_is_SQL\"><\/span><strong>What is SQL?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>SQL (Structured Query Language)<\/strong> is used to communicate with and manage databases. It helps in performing actions such as inserting, updating, deleting, and retrieving data from tables. SQL is easy to learn and is used in most database management systems like MySQL, Oracle, and PostgreSQL.<\/p>\n\n\n\n<p>Check out <a href=\"https:\/\/www.oliveboard.in\/ssc-cgl-notification\/?ref=contmk-blogs\" target=\"_blank\" rel=\"noreferrer noopener\">SSC CGL Exam<\/a> Notification<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-common-sql-commands\"><span class=\"ez-toc-section\" id=\"Common_SQL_Commands\"><\/span><strong>Common SQL Commands<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SQL commands are divided into categories based on their function. The table below lists some of the most commonly used SQL commands for SSC exams.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong><strong>Command Type<\/strong><\/strong><\/td><td><strong><strong>Examples<\/strong><\/strong><\/td><td><strong><strong>Purpose<\/strong><\/strong><\/td><\/tr><tr><td><strong>DDL (Data Definition Language)<\/strong><\/td><td><code>CREATE<\/code>, <code>ALTER<\/code>, <code>DROP<\/code><\/td><td>Used to define and modify the structure of database objects.<\/td><\/tr><tr><td><strong>DML (Data Manipulation Language)<\/strong><\/td><td><code>INSERT<\/code>, <code>UPDATE<\/code>, <code>DELETE<\/code><\/td><td>Used to modify data within the database.<\/td><\/tr><tr><td><strong>DQL (Data Query Language)<\/strong><\/td><td><code>SELECT<\/code><\/td><td>Used to retrieve data from the database.<\/td><\/tr><tr><td><strong>DCL (Data Control Language)<\/strong><\/td><td><code>GRANT<\/code>, <code>REVOKE<\/code><\/td><td>Used to control access permissions.<\/td><\/tr><tr><td><strong>TCL (Transaction Control Language)<\/strong><\/td><td><code>COMMIT<\/code>, <code>ROLLBACK<\/code><\/td><td>Used to manage transactions in a database.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/blog\/ssc-cgl-computer-awareness\/?ref=conmk-blog\" target=\"_blank\" rel=\"noreferrer noopener\">Read full blog on computer awareness for sSC CGL Tier 2 <\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-basic-sql-queries-for-practice\"><span class=\"ez-toc-section\" id=\"Basic_SQL_Queries_for_Practice\"><\/span><strong>Basic SQL Queries for Practice<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here are a few simple SQL queries that help in understanding how SQL commands work. You can expect conceptual questions like these in SSC exams.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong><strong>Purpose<\/strong><\/strong><\/td><td><strong><strong>SQL Query Example<\/strong><\/strong><\/td><\/tr><tr><td>To create a table<\/td><td><code>CREATE TABLE Students (ID INT, Name VARCHAR(50), Age INT);<\/code><\/td><\/tr><tr><td>To insert data<\/td><td><code>INSERT INTO Students VALUES (1, 'Rahul', 21);<\/code><\/td><\/tr><tr><td>To fetch all data<\/td><td><code>SELECT * FROM Students;<\/code><\/td><\/tr><tr><td>To update data<\/td><td><code>UPDATE Students SET Age = 22 WHERE ID = 1;<\/code><\/td><\/tr><tr><td>To delete data<\/td><td><code>DELETE FROM Students WHERE ID = 1;<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-advantages-of-using-databases\"><span class=\"ez-toc-section\" id=\"Advantages_of_Using_Databases\"><\/span><strong>Advantages of Using Databases<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Databases make data handling more systematic and efficient. Below are some key advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Easy data storage and retrieval<\/li>\n\n\n\n<li>Reduces data duplication and inconsistency<\/li>\n\n\n\n<li>Supports multiple users simultaneously<\/li>\n\n\n\n<li>Provides data security and backup<\/li>\n\n\n\n<li>Enables data sharing and better decision-making<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-key-takeaways\"><span class=\"ez-toc-section\" id=\"Key_Takeaways\"><\/span><strong>Key Takeaways<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Below are the key takeaways:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A database stores data in an organized manner.<\/li>\n\n\n\n<li>SQL is used to manage and manipulate data in databases.<\/li>\n\n\n\n<li>Understanding basic SQL commands like <code>SELECT<\/code>, <code>INSERT<\/code>, <code>UPDATE<\/code>, and <code>DELETE<\/code> is important for SSC CGL Tier 2.<\/li>\n\n\n\n<li>Relational databases are the most commonly used type.<\/li>\n\n\n\n<li>Regular practice of SQL-based questions improves accuracy in the Computer Awareness section.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button aligncenter\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/ssc-cgl\/?ref=contmk-db\" target=\"_blank\" rel=\"noreferrer noopener\">Explore all SSC CGL Courses Here<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-faqs\"><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1760365987825\"><strong class=\"schema-faq-question\"><strong>Q1. What type of database questions are asked in SSC CGL Tier 2 Computer Awareness?<\/strong><\/strong> <p class=\"schema-faq-answer\">Questions are mostly conceptual, focusing on topics like database structure, SQL commands, keys, and types of databases.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1760365994229\"><strong class=\"schema-faq-question\"><strong>Q2. What is a database in simple terms?<\/strong><\/strong> <p class=\"schema-faq-answer\">A database is an organized collection of data stored in tables, which can be easily accessed, updated, and managed.<br\/><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1760365999362\"><strong class=\"schema-faq-question\"><strong>Q3. What is SQL and why is it important for SSC CGL Tier 2?<\/strong><\/strong> <p class=\"schema-faq-answer\">SQL (Structured Query Language) is used to manage and retrieve data from databases. Understanding SQL helps in solving Computer Awareness questions quickly.<br\/><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1760366004796\"><strong class=\"schema-faq-question\">Q4.<strong> What are the main types of SQL commands?<\/strong><\/strong> <p class=\"schema-faq-answer\">The main types are DDL (Data Definition Language), DML (Data Manipulation Language), DQL (Data Query Language), DCL (Data Control Language), and TCL (Transaction Control Language).<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1760366009784\"><strong class=\"schema-faq-question\"><strong>Q5. What is the difference between a primary key and a foreign key?<\/strong><\/strong> <p class=\"schema-faq-answer\">A primary key uniquely identifies each record in a table, while a foreign key links one table to another using a shared field.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Database and SQL are among the most important topics in the Computer Awareness section of SSC CGL Tier 2. Questions<\/p>\n","protected":false},"author":65,"featured_media":230554,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5217,10231,63],"tags":[],"class_list":["post-230548","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssc-prep","category-ssc-railways","category-ssc-exams","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.6 (Yoast SEO v26.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database &amp; SQL Basics for SSC CGL Tier 2 Preparation - Oliveboard<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation\" \/>\n<meta property=\"og:description\" content=\"Database and SQL are among the most important topics in the Computer Awareness section of SSC CGL Tier 2. Questions from this topic test your\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\" \/>\n<meta property=\"og:site_name\" content=\"Oliveboard\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Oliveboard\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-13T17:30:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-13T17:30:10+00:00\" \/>\n<meta name=\"author\" content=\"Mahima Khurana\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Oliveboard\" \/>\n<meta name=\"twitter:site\" content=\"@Oliveboard\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mahima Khurana\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"NewsArticle\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\"},\"author\":{\"name\":\"Mahima Khurana\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/2f25f4d24adbf225bc11e6a0a4bcad8b\"},\"headline\":\"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation\",\"datePublished\":\"2025-10-13T17:30:06+00:00\",\"dateModified\":\"2025-10-13T17:30:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\"},\"wordCount\":821,\"publisher\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp\",\"articleSection\":[\"SSC\",\"SSC &amp; Railways\",\"SSC CGL\"],\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\",\"name\":\"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation - Oliveboard\",\"isPartOf\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp\",\"datePublished\":\"2025-10-13T17:30:06+00:00\",\"dateModified\":\"2025-10-13T17:30:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825\"},{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229\"},{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362\"},{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796\"},{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp\",\"contentUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp\",\"width\":730,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/category\/articles\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#website\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/\",\"name\":\"Oliveboard\",\"description\":\"Free Govt. Exam Alerts &amp; Resources\",\"publisher\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.oliveboard.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\",\"name\":\"Oliveboard\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png\",\"contentUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png\",\"width\":150,\"height\":40,\"caption\":\"Oliveboard\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Oliveboard\",\"https:\/\/x.com\/Oliveboard\",\"https:\/\/www.instagram.com\/oliveboard.in\/\",\"https:\/\/www.youtube.com\/channel\/UCRvrHAyNdOMI_JBkE2pjZtw?sub_confirmation=1\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/2f25f4d24adbf225bc11e6a0a4bcad8b\",\"name\":\"Mahima Khurana\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/922450c81513b569654b520958cbf86230a614fd2f7f05d6b46674fe4bce8c99?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/922450c81513b569654b520958cbf86230a614fd2f7f05d6b46674fe4bce8c99?s=96&d=mm&r=g\",\"caption\":\"Mahima Khurana\"},\"description\":\"I\u2019m Mahima Khurana, a writer with a strong passion for creating meaningful, learner-focused content especially in the field of competitive exam preparation. From authoring books and developing thousands of practice questions to crafting articles and study material, I specialize in transforming complex exam-related topics into clear, engaging, and accessible content. I have first hand experience of 5+ months in SSC Exams. Writing, for me, is not just a skill but a way to support and guide aspirants through their preparation journey one well-written explanation at a time.\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825\",\"position\":1,\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825\",\"name\":\"Q1. What type of database questions are asked in SSC CGL Tier 2 Computer Awareness?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Questions are mostly conceptual, focusing on topics like database structure, SQL commands, keys, and types of databases.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229\",\"position\":2,\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229\",\"name\":\"Q2. What is a database in simple terms?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A database is an organized collection of data stored in tables, which can be easily accessed, updated, and managed.<br\/>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362\",\"position\":3,\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362\",\"name\":\"Q3. What is SQL and why is it important for SSC CGL Tier 2?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"SQL (Structured Query Language) is used to manage and retrieve data from databases. Understanding SQL helps in solving Computer Awareness questions quickly.<br\/>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796\",\"position\":4,\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796\",\"name\":\"Q4. What are the main types of SQL commands?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"The main types are DDL (Data Definition Language), DML (Data Manipulation Language), DQL (Data Query Language), DCL (Data Control Language), and TCL (Transaction Control Language).\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784\",\"position\":5,\"url\":\"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784\",\"name\":\"Q5. What is the difference between a primary key and a foreign key?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A primary key uniquely identifies each record in a table, while a foreign key links one table to another using a shared field.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation - Oliveboard","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/","og_locale":"en_US","og_type":"article","og_title":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation","og_description":"Database and SQL are among the most important topics in the Computer Awareness section of SSC CGL Tier 2. Questions from this topic test your","og_url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/","og_site_name":"Oliveboard","article_publisher":"https:\/\/www.facebook.com\/Oliveboard","article_published_time":"2025-10-13T17:30:06+00:00","article_modified_time":"2025-10-13T17:30:10+00:00","author":"Mahima Khurana","twitter_card":"summary_large_image","twitter_creator":"@Oliveboard","twitter_site":"@Oliveboard","twitter_misc":{"Written by":"Mahima Khurana","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#article","isPartOf":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/"},"author":{"name":"Mahima Khurana","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/2f25f4d24adbf225bc11e6a0a4bcad8b"},"headline":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation","datePublished":"2025-10-13T17:30:06+00:00","dateModified":"2025-10-13T17:30:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/"},"wordCount":821,"publisher":{"@id":"https:\/\/www.oliveboard.in\/blog\/#organization"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp","articleSection":["SSC","SSC &amp; Railways","SSC CGL"],"inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/","url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/","name":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation - Oliveboard","isPartOf":{"@id":"https:\/\/www.oliveboard.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp","datePublished":"2025-10-13T17:30:06+00:00","dateModified":"2025-10-13T17:30:10+00:00","breadcrumb":{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825"},{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229"},{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362"},{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796"},{"@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#primaryimage","url":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp","contentUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2025\/10\/SQL-Database.webp","width":730,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oliveboard.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.oliveboard.in\/blog\/category\/articles\/"},{"@type":"ListItem","position":3,"name":"Database &amp; SQL Basics for SSC CGL Tier 2 Preparation"}]},{"@type":"WebSite","@id":"https:\/\/www.oliveboard.in\/blog\/#website","url":"https:\/\/www.oliveboard.in\/blog\/","name":"Oliveboard","description":"Free Govt. Exam Alerts &amp; Resources","publisher":{"@id":"https:\/\/www.oliveboard.in\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oliveboard.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.oliveboard.in\/blog\/#organization","name":"Oliveboard","url":"https:\/\/www.oliveboard.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png","contentUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png","width":150,"height":40,"caption":"Oliveboard"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Oliveboard","https:\/\/x.com\/Oliveboard","https:\/\/www.instagram.com\/oliveboard.in\/","https:\/\/www.youtube.com\/channel\/UCRvrHAyNdOMI_JBkE2pjZtw?sub_confirmation=1"]},{"@type":"Person","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/2f25f4d24adbf225bc11e6a0a4bcad8b","name":"Mahima Khurana","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/922450c81513b569654b520958cbf86230a614fd2f7f05d6b46674fe4bce8c99?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/922450c81513b569654b520958cbf86230a614fd2f7f05d6b46674fe4bce8c99?s=96&d=mm&r=g","caption":"Mahima Khurana"},"description":"I\u2019m Mahima Khurana, a writer with a strong passion for creating meaningful, learner-focused content especially in the field of competitive exam preparation. From authoring books and developing thousands of practice questions to crafting articles and study material, I specialize in transforming complex exam-related topics into clear, engaging, and accessible content. I have first hand experience of 5+ months in SSC Exams. Writing, for me, is not just a skill but a way to support and guide aspirants through their preparation journey one well-written explanation at a time."},{"@type":"Question","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825","position":1,"url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365987825","name":"Q1. What type of database questions are asked in SSC CGL Tier 2 Computer Awareness?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Questions are mostly conceptual, focusing on topics like database structure, SQL commands, keys, and types of databases.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229","position":2,"url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365994229","name":"Q2. What is a database in simple terms?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"A database is an organized collection of data stored in tables, which can be easily accessed, updated, and managed.<br\/>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362","position":3,"url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760365999362","name":"Q3. What is SQL and why is it important for SSC CGL Tier 2?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"SQL (Structured Query Language) is used to manage and retrieve data from databases. Understanding SQL helps in solving Computer Awareness questions quickly.<br\/>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796","position":4,"url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366004796","name":"Q4. What are the main types of SQL commands?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"The main types are DDL (Data Definition Language), DML (Data Manipulation Language), DQL (Data Query Language), DCL (Data Control Language), and TCL (Transaction Control Language).","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784","position":5,"url":"https:\/\/www.oliveboard.in\/blog\/database-and-sql-for-ssc-cgl\/#faq-question-1760366009784","name":"Q5. What is the difference between a primary key and a foreign key?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"A primary key uniquely identifies each record in a table, while a foreign key links one table to another using a shared field.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/230548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/comments?post=230548"}],"version-history":[{"count":1,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/230548\/revisions"}],"predecessor-version":[{"id":230557,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/230548\/revisions\/230557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/media\/230554"}],"wp:attachment":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/media?parent=230548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/categories?post=230548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/tags?post=230548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}