SQL Interview Questions

SQL Interview Questions and Answers Interview Questions

SQL Interview Questions

SQL is very intersting topic or domain in job prospective, bus its interviews questions are also very tipicals, so we are here with SQL interview questions with answers. It help you to pass the Tech job interview and lead a good placement.

Basic SQL Interview Questions

1. What is SQL?

SQL stands for Structured Query Language. It is a domain-specific language used for managing and manipulating relational databases. SQL is widely used for tasks such as querying data, updating data, inserting data, and creating and modifying database structures.

2. Explain the difference between SQL and MySQL.

SQL is a standard language for managing relational databases, while MySQL is a relational database management system (RDBMS) that uses SQL as its query language. In other words, SQL is the language, and MySQL is one of the database management systems that implements this language.

3. What are the main types of SQL commands?

SQL commands are categorized into four main types:

  • Data Definition Language (DDL): Used to define and manage database structures (e.g., CREATE TABLE, ALTER TABLE).
  • Data Manipulation Language (DML): Used for manipulating data stored in the database (e.g., SELECT, INSERT, UPDATE, DELETE).
  • Data Control Language (DCL): Manages access to data (e.g., GRANT, REVOKE).
  • Transaction Control Language (TCL): Manages transactions in the database (e.g., COMMIT, ROLLBACK).

4. Explain the primary key in SQL.

A primary key is a column or a set of columns in a table that uniquely identifies each row in the table. It must contain unique values, and it cannot have NULL values. The primary key is used to establish relationships between tables and ensures data integrity.

5. What is the purpose of the WHERE clause in SQL?

The WHERE clause is used to filter records in a SQL query. It specifies a condition that must be met for a record to be included in the result set. For example, SELECT * FROM employees WHERE department = 'IT'; retrieves all employees who work in the IT department.

6. Explain the difference between DELETE and TRUNCATE commands.

  • DELETE: Removes rows from a table based on a condition. It is a DML command and can be rolled back.
  • TRUNCATE: Removes all rows from a table but retains the structure for future use. It is a DDL command and cannot be rolled back. It is faster than DELETE for large datasets.

7. What is a foreign key in SQL?

A foreign key is a column or a set of columns in a table that refers to the primary key of another table. It establishes a link between the two tables, enforcing referential integrity. The foreign key in one table is used to match the primary key in another table.

8. Explain the GROUP BY clause.

The GROUP BY clause is used in conjunction with aggregate functions to group rows based on one or more columns. It is often used with aggregate functions like COUNT, SUM, AVG, etc. For example, SELECT department, AVG(salary) FROM employees GROUP BY department; groups employees by department and calculates the average salary for each department.

9. What is normalization in the context of databases?

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down large tables into smaller, related tables and defining relationships between them. The goal is to eliminate data anomalies and ensure that data is stored efficiently.

10. Explain the difference between a view and a table in SQL.

  • A table is a physical storage structure that holds data, while a view is a virtual table derived from one or more tables or views.
  • Views do not store data themselves but provide a way to present data stored in tables in a specific way.
  • Views can also be used to restrict access to certain columns or rows of a table.

Aggregate function SQL Interview Questions

1. What is an aggregate function in SQL?

An aggregate function in SQL performs a calculation on a set of values and returns a single value. Common aggregate functions include COUNT, SUM, AVG, MIN, and MAX.

2. Explain the purpose of the COUNT() function in SQL.

The COUNT() function is used to count the number of rows in a result set or the number of occurrences of a specific column’s values. It can be used with the asterisk (*) to count all rows or with a specific column to count non-null values in that column.

3. How does the SUM() function work in SQL?

The SUM() function calculates the total sum of a numeric column. It adds up all the values in the specified column.

4. Explain the AVG() function in SQL.

The AVG() function calculates the average value of a numeric column. It adds up all the values in the specified column and divides the sum by the number of non-null values.

5. What is the purpose of the MIN() function in SQL?

The MIN() function is used to find the minimum (lowest) value in a numeric column or the minimum alphabetical value in a text column.

6. How does the MAX() function work in SQL?

The MAX() function is used to find the maximum (highest) value in a numeric column or the maximum alphabetical value in a text column.

7. Explain the difference between COUNT(*) and COUNT(column_name).

  • COUNT(*): Counts all rows in a table, including those with NULL values.
  • COUNT(column_name): Counts the number of non-null values in the specified column.

8. Can you use aggregate functions in the WHERE clause? Why or why not?

No, aggregate functions cannot be used directly in the WHERE clause. The WHERE clause filters rows before the aggregation occurs. Instead, use the HAVING clause to filter results after aggregation.

9. What is the purpose of the GROUP BY clause in conjunction with aggregate functions?

The GROUP BY clause is used to group rows that have the same values in specified columns into summary rows. When used with aggregate functions, it allows you to perform calculations on each group of rows separately.

10. Explain the HAVING clause in SQL.

The HAVING clause is used in conjunction with the GROUP BY clause and allows you to filter the results of a query based on aggregated values. It is used to specify a condition for groups of rows, similar to how the WHERE clause filters individual rows.


Normalization SQL Interview Questions

1. What is normalization in the context of databases?

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down large tables into smaller, related tables and defining relationships between them.

2. Explain the need for normalization in a relational database.

Normalization eliminates data redundancy, reduces the likelihood of data anomalies, and ensures that data is stored efficiently. It helps maintain data consistency and makes the database structure more adaptable to changes.

3. What are the primary goals of normalization?

The primary goals of normalization are to minimize data duplication, reduce update anomalies, prevent insertion anomalies, and maintain data integrity by organizing data into related tables.

4. Explain the difference between functional dependency and transitive dependency.

  • Functional Dependency: In a relation, attribute B is functionally dependent on attribute A if each value of A uniquely determines the value of B.
  • Transitive Dependency: If A determines B, and B determines C, then there is a transitive dependency where A indirectly determines C.

5. What is the First Normal Form (1NF)?

A table is in 1NF if it contains only atomic (indivisible) values, and there are no repeating groups or arrays of data. Each column must have a single, indivisible value.

6. Explain the Second Normal Form (2NF).

A table is in 2NF if it is in 1NF and all non-prime attributes (attributes not part of the primary key) are fully functionally dependent on the entire primary key.

7. What is the Third Normal Form (3NF)?

A table is in 3NF if it is in 2NF, and no transitive dependencies exist. In other words, all non-prime attributes are non-transitively dependent on the primary key.

8. Explain the Boyce-Codd Normal Form (BCNF).

BCNF is a higher normal form than 3NF. A table is in BCNF if, for every non-trivial functional dependency, the left-hand side is a superkey.

9. What is denormalization, and when might it be used?

Denormalization is the process of intentionally introducing redundancy into a database by combining tables that have been normalized. It might be used to improve query performance by reducing the number of joins, especially in read-heavy applications.

10. How does normalization affect database performance?

Normalization generally improves data integrity but can impact performance due to increased join operations. In some cases, denormalization may be used to enhance performance, but it involves trade-offs in terms of data redundancy.

These questions cover various aspects of normalization in databases, from basic concepts to higher normal forms and their implications on data integrity and performance.


Indexes and Performance SQL Interview Questions

1. What is an index in a database, and how does it improve performance?

An index is a data structure that improves the speed of data retrieval operations on a database table. It works like an index in a book, allowing the database engine to quickly locate specific rows in a table. Indexes are created on one or more columns and provide faster access to data, especially in WHERE clause conditions.

2. Explain the difference between a clustered and a non-clustered index

  • Clustered Index: Determines the physical order of data rows in a table. A table can have only one clustered index.
  • Non-Clustered Index: Does not affect the physical order of data rows. A table can have multiple non-clustered indexes.

3. When should you use an index, and when should you avoid it?

Use indexes for columns frequently used in WHERE clauses, JOIN conditions, and ORDER BY clauses. Avoid indexes on columns with low selectivity or in tables with frequent insert, update, or delete operations, as indexes can incur overhead during these operations.

4. How does an index impact SELECT, INSERT, UPDATE, and DELETE operations?

  • SELECT: Improves retrieval speed for indexed columns.
  • INSERT/UPDATE/DELETE: May slow down these operations because the index needs to be updated. However, proper indexing can still enhance overall performance.

5. Explain the concept of covering indexes.

A covering index includes all the columns needed to satisfy a query, so the query can be resolved using only the index without accessing the actual table. Covering indexes can significantly improve query performance by reducing the need to access the table data.

6. What is the purpose of a composite index?

A composite index involves more than one column. It can be used when queries involve multiple columns in the WHERE clause or when a combination of columns is frequently used in conditions.

7. How can you identify and resolve performance issues related to indexes

  • Use database profiling tools to identify slow queries.
  • Analyze query execution plans to check index usage.
  • Consider adding, modifying, or removing indexes based on query patterns.
  • Regularly update statistics for accurate query optimization.

8. What is the impact of indexing on disk space?

Indexing consumes additional disk space, and the impact depends on the size and structure of the index. Larger indexes require more disk space, and maintaining indexes during data modifications (inserts, updates, deletes) can also increase storage requirements.

9. Explain the term “Index Seek” and “Index Scan.”

  • Index Seek: A seek operation efficiently finds specific rows using an index, suitable for equality or inequality conditions.
  • Index Scan: A scan operation reads the entire index, which can be less efficient, especially for large datasets.

10. What is the role of the Query Optimizer in using indexes?

The Query Optimizer is responsible for determining the most efficient way to execute a query. It analyzes available indexes, query structure, and statistics to generate an execution plan that minimizes resource usage and maximizes performance.


Database transactions SQL Interview Questions

1. What is a database transaction?

A database transaction is a logical unit of work that consists of one or more SQL statements. It is executed as a single, indivisible operation, ensuring consistency and integrity of data.

2. Explain the ACID properties in the context of database transactions.

ACID stands for Atomicity, Consistency, Isolation, and Durability.

  • Atomicity: Ensures that a transaction is treated as a single, indivisible unit.
  • Consistency: Ensures that a transaction brings the database from one valid state to another.
  • Isolation: Ensures that the execution of one transaction is isolated from other transactions.
  • Durability: Guarantees that the changes made by a committed transaction are permanent.

3. What is the purpose of the BEGIN TRANSACTION, COMMIT, and ROLLBACK statements

  • BEGIN TRANSACTION: Marks the beginning of a transaction.
  • COMMIT: Marks the successful end of a transaction, applying changes to the database.
  • ROLLBACK: Undoes the changes made during the current transaction, reverting the database to its state before the transaction began.

4. Explain the concept of a Savepoint in SQL transactions.

A savepoint is a point within a transaction to which you can later roll back. It allows for partial rollback of a transaction without affecting the entire transaction.

5. What is a deadlock in the context of database transactions?

A deadlock occurs when two or more transactions are blocked, each waiting for the other to release a lock. This results in a situation where no transaction can proceed, and external intervention (like a timeout or manual intervention) is needed.

6. How does isolation level affect database transactions?

Isolation levels determine the degree to which one transaction is isolated from the effects of other concurrent transactions. Common isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

7. Explain optimistic and pessimistic concurrency control

  • Optimistic Concurrency Control: Assumes that conflicts between transactions are rare. It allows transactions to proceed without locking resources, and conflicts are detected and resolved at the time of commit.
  • Pessimistic Concurrency Control: Assumes conflicts are more likely. It involves locking resources during the transaction to prevent other transactions from accessing the same resources until the transaction is completed.

8. What is a transaction log, and how is it used in SQL transactions?

A transaction log records all changes made to the database during a transaction. It is used for recovery in case of a system failure, providing a record of committed and uncommitted changes.

9. Explain the concept of Read Committed isolation level.

In the Read Committed isolation level, a transaction sees only committed data and does not see uncommitted changes made by other transactions. It provides a higher level of isolation than Read Uncommitted.

10. How can you prevent or resolve a deadlock in SQL transactions?

Deadlocks can be prevented or resolved by adjusting the transaction isolation level, using timeouts, acquiring locks in a consistent order, or using deadlock detection mechanisms.


Database Concurrency SQL Interview Questions

1. What is database concurrency?

Database concurrency is the simultaneous execution of multiple transactions in a database system without interfering with each other. It ensures that transactions can run concurrently while maintaining the consistency and integrity of the database.

2. Explain the difference between optimistic and pessimistic concurrency control.

Pessimistic concurrency control locks data resources to prevent other transactions from accessing them until the lock is released. Optimistic concurrency control allows multiple transactions to proceed and checks for conflicts at the end, rolling back if necessary.

3. What are isolation levels in SQL, and how do they relate to concurrency?

Isolation levels define the degree to which one transaction must be isolated from the effects of other concurrent transactions. Common isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

4. How does a deadlock occur in a database, and how can it be prevented?

A deadlock occurs when two or more transactions are blocked, each waiting for the other to release a lock. Deadlocks can be prevented by careful ordering of lock acquisition, using timeouts, and implementing deadlock detection and resolution mechanisms.

5. Explain the concept of a transaction log and its role in database recovery.

A transaction log is a chronological record of changes made to a database. It plays a crucial role in database recovery by providing a means to restore the database to a consistent state after a failure. Transaction logs allow for the replay of committed transactions and the rollback of uncommitted ones.

6. What is a savepoint in SQL, and how does it aid in transaction management?

A savepoint is a point within a transaction to which you can roll back. It allows for partial rollback of a transaction, providing a level of flexibility in handling errors or exceptional conditions within the transaction.

7. Describe the ACID properties of transactions and their importance in database concurrency control.

ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties ensure that database transactions are reliable. In the context of concurrency control, isolation is particularly important to prevent interference between concurrent transactions.

8. How can optimistic concurrency control be implemented in a SQL database?

Optimistic concurrency control is often implemented by including a version number or timestamp in the data. Before committing a transaction, the system checks if the data being modified is still at the expected version. If not, it implies that another transaction has modified the data, and conflict resolution is required.

9. Explain the concept of a two-phase commit and its role in ensuring transaction consistency.

The two-phase commit is a protocol used to ensure that all participating databases in a distributed transaction either commit or roll back the transaction together. It involves a prepare phase and a commit phase, minimizing the chances of inconsistency in distributed transactions.

10. What is point-in-time recovery in a database, and how is it achieved?

Point-in-time recovery allows a database to be restored to a specific moment in time, typically just before a failure occurred. It is achieved by using transaction logs to replay committed transactions up to the desired point in time, ensuring data consistency and integrity.


Basic Structure Of Structured Query Language(SQL)

image-15

General Awareness Question Answers in Hindi

General Awareness in Hindi

  1. प्रधानमंत्री नरेंद्र मोदी का जन्म कहाँ हुआ था?
    • नरेंद्र मोदी का जन्म गुजरात राज्य के वडनगर ज़िले के वडनगर नामक स्थान पर हुआ था।
  2. भारत की सबसे ऊची चोटी कौन सी है?
    • कंचनजंघा, जो हिमालय की एक ऊची पर्वत श्रृंग है, भारत की सबसे ऊची चोटी है।
  3. भारत का सबसे बड़ा राज्य कौन सा है?
    • राजस्थान, जिसे “प्रजापति महाकौशल” भी कहा जाता है, भारत का सबसे बड़ा राज्य है।
  4. भारत की सबसे लंबी नदी कौन सी है?
    • गंगा नदी, जो भारत में 2525 किलोमीटर लंबी है, भारत की सबसे लंबी नदी है।
  5. “स्वच्छ भारत अभियान” किसने शुरू किया था?
    • प्रधानमंत्री नरेंद्र मोदी ने “स्वच्छ भारत अभियान” को 2 अक्टूबर 2014 को शुरू किया था।
  6. भारतीय रिजर्व बैंक की स्थापना कब हुई थी?
    • भारतीय रिजर्व बैंक की स्थापना 1 अप्रैल 1935 को हुई थी।
  7. भारतीय संविधान को किस तिथि को संग्रहित किया गया था?
    • भारतीय संविधान को 26 नवम्बर 1949 को संग्रहित किया गया था और 26 जनवरी 1950 को लागू हुआ।
  8. भारत में पहला रेलवे स्थापित किया गया था?
    • भारत में पहला रेलवे 16 अप्रैल 1853 को मुंबई से ठाणे के बीच चलाया गया था।
  1. भारतीय राष्ट्रीय ध्वज का रंग क्या है?
    • भारतीय राष्ट्रीय ध्वज का रंग तिरंगा है, जिसमें केसरिया, सफेद और हरा रंग होते हैं।
  2. भारत का पहला कंप्यूटर कहाँ स्थापित किया गया था?
    • भारत का पहला कंप्यूटर इंस्टिट्यूट ऑफ टेक्नोलॉजी (आईआईटी) कनप्यूटर सेंटर, कोलकाता में स्थापित किया गया था।
  3. भारतीय अंतरिक्ष अनुसंधान संगठन (ISRO) की स्थापना कब हुई थी?
    • भारतीय अंतरिक्ष अनुसंधान संगठन (ISRO) की स्थापना 15 अगस्त 1969 को हुई थी।
  4. भारतीय जनगणना कब होती है?
    • भारतीय जनगणना प्रति 10 वर्षों में एक बार होती है। आखिरी जनगणना 2021 में हुई थी।
  5. भारत का सबसे बड़ा जिला कौन सा है?
    • कछार जिला, जो राजस्थान राज्य में है, भारत का सबसे बड़ा जिला है।
  6. भारत की पहली महिला प्रधानमंत्री कौन थी?
    • भारतीय राजनीति में पहली महिला प्रधानमंत्री इंदिरा गांधी थी, जो 1966 में प्रधानमंत्री बनी थीं।
  7. भारत की पहली उपग्रह मिशन का नाम क्या था?
    • भारत की पहली उपग्रह मिशन का नाम “आर्यभट्ट” था, जो 1975 में भारतीय अंतरिक्ष अनुसंधान संगठन (ISRO) द्वारा लॉन्च किया गया था।
  1. भारतीय फिल्मों के लिए ‘नेशनल फिल्म अवॉर्ड्स’ कब स्थापित किए गए थे?
    • ‘नेशनल फिल्म अवॉर्ड्स’ की स्थापना 1954 में की गई थी।
  2. भारतीय संविधान की कितनी अनुसूचियां हैं?
    • भारतीय संविधान में 22 अनुसूचियां (Schedules) हैं।
  3. भारतीय रेलवे का सबसे लंबा समय तक चलने वाला ट्रेन कौन सी है?
    • भारतीय रेलवे का सबसे लंबा समय तक चलने वाला ट्रेन ‘हिमदर्शन एक्सप्रेस’ है, जो कन्याकुमारी से लेकर श्रीनगर तक जाती है।
  4. भारतीय जनगणना के अनुसार सबसे बड़ा राज्य कौन सा है (आबादी के हिसाब से)?
    • भारतीय जनगणना के अनुसार सबसे बड़ा राज्य उत्तर प्रदेश है, जिसकी जनसंख्या सबसे अधिक है।
  5. भारतीय बौद्ध धर्म के संस्थापक कौन थे?
    • भारतीय बौद्ध धर्म के संस्थापक भगवान बुद्ध थे।
  6. भारतीय जनता पार्टी (भा.ज.पा) का पहला प्रधानमंत्री कौन था?
    • भारतीय जनता पार्टी (भा.ज.पा) का पहला प्रधानमंत्री आतल बिहारी वाजपेयी थे।
  7. भारतीय संगीत महासभा का स्थापना कहां हुआ था?
    • भारतीय संगीत महासभा का स्थापना बनारस में 1914 में हुआ था।
  8. भारतीय फिल्म इंडस्ट्री को किस नाम से जाना जाता है?
    • भारतीय फिल्म इंडस्ट्री को “बॉलीवुड” के नाम से जाना जाता है।
  1. भारतीय गणतंत्र दिवस कब मनाया जाता है?
    • भारतीय गणतंत्र दिवस 26 जनवरी को मनाया जाता है। इस दिन, भारतीय संविधान की कमीशन की स्वीकृति मिली थी।
  2. भारतीय क्रिकेट टीम का नाम क्या है?
    • भारतीय क्रिकेट टीम का नाम “भारतीय राष्ट्रीय क्रिकेट टीम” है।
  3. भारतीय चंद्रयान मिशन का पहला संस्करण कब लॉन्च किया गया था?
    • भारतीय चंद्रयान मिशन का पहला संस्करण चंद्रयान-1, 22 अक्टूबर 2008 को लॉन्च किया गया था।
  4. भारतीय स्वतंत्रता संग्राम के महानायक ‘महात्मा गांधी’ का जन्म कहाँ हुआ था?
    • महात्मा गांधी का जन्म 2 अक्टूबर 1869 को पोरबंदर, गुजरात, भारत में हुआ था।
  5. भारतीय राजनीतिक पार्टी ‘भारतीय कांग्रेस’ की स्थापना कब हुई थी?
    • भारतीय कांग्रेस की स्थापना 28 दिसम्बर 1885 को बम्बई (अब मुंबई) में हुई थी।
  6. भारतीय नारी जब ओलंपिक में पहला स्वर्ण पदक जीती थी?
    • भारतीय नारी मीराबाई चानू ने 2000 के सिडनी ओलंपिक में वर्जिनिया रागादी की ओलंपिक वेटलिफ्टिंग चैम्पियनशिप में स्वर्ण पदक जीता था।
  7. भारत का सबसे पुराना विश्वविद्यालय कौन सा है?
    • भारत का सबसे पुराना विश्वविद्यालय नालंदा विश्वविद्यालय था, जो 5 वीं सदी से 12 वीं सदी तक विद्यार्थियों को शिक्षा प्रदान करता था। हालांकि, यह विश्वविद्यालय अब नहीं है।
  1. भारतीय चौथी लोकसभा के पहले प्रधानमंत्री कौन थे?
  • भारतीय चौथी लोकसभा के पहले प्रधानमंत्री जवाहरलाल नेहरु थे।
  1. भारतीय अर्थव्यवस्था का सबसे बड़ा क्षेत्र कौन-कौन सा है?
    • भारतीय अर्थव्यवस्था का सबसे बड़ा क्षेत्र कृषि है।
  2. भारतीय फिल्मों के लिए सबसे पुरस्कृत सम्मान क्या है?
    • भारतीय फिल्मों के लिए सबसे पुरस्कृत सम्मान “नेशनल फिल्म अवॉर्ड्स” है।
  3. भारतीय संविधान में कितने अनुच्छेद हैं?
    • भारतीय संविधान में कुल 470 अनुच्छेद हैं (अभ्यंतरवारिष्ठ के साथ)।
  4. भारतीय संविधान सभा का निर्माण कितने समय में हुआ था?
    • भारतीय संविधान का निर्माण 2 वर्ष 11 महीने और 18 दिनों में हुआ था।
  5. भारत में पहला विश्वविद्यालय कौन सा था?
    • भारत में पहला विश्वविद्यालय नालंदा विश्वविद्यालय था, जो 4 वीं से 13 वीं सदी तक अवस्थित था।
  6. भारतीय नारी जो एक अंतर्राष्ट्रीय विद्यार्थिनी और विचारक हैं, उनका नाम क्या है?
    • भारतीय नारी और अंतर्राष्ट्रीय विद्यार्थिनी, विचारक एवं जनरल सेक्रेटरी मेंडला जोगी नाथ कृष्ण हैं।
  7. भारतीय नर्मदा और गोदावरी नदियों को क्या कहा जाता है?
    • भारतीय नर्मदा और गोदावरी नदियों को “दक्षिणी गंगा” कहा जाता है।
  8. भारतीय रेलवे की पहली लोकोमोटिव का नाम क्या था?
    • भारतीय रेलवे की पहली लोकोमोटिव का नाम “फैरी नंबर-1” था, जो 1853 में चलाई गई थी।
  9. भारतीय राष्ट्रीय वन्यजन का संरक्षण कहाँ से किया जाता है?
    • भारतीय राष्ट्रीय वन्यजन का संरक्षण जिम्बाब्वे के ह्वांगे नेशनल पार्क से किया जाता है।
  1. भारतीय राजनीतिक नेता और भारतीय जनता पार्टी (भा.ज.पा) के संस्थापक श्री अटल बिहारी वाजपेयी ने कितनी बार प्रधानमंत्री के पद का कार्यभार संभाला था?
  • श्री अटल बिहारी वाजपेयी ने भारतीय जनता पार्टी (भा.ज.पा) के संस्थापक और पार्टी के अध्यक्ष के रूप में कार्य किया और उन्होंने प्रधानमंत्री के पद पर कार्यभार संभाला था।
  1. भारतीय राजनीति के प्रख्यात नेता और भारतीय नारी जो भारतीय राष्ट्रीय कांग्रेस की अध्यक्ष रही हैं, उनका नाम क्या है?
  • भारतीय राजनीति के प्रमुख नेता और भारतीय नारी सोनिया गांधी जी रही हैं। उन्होंने भारतीय राष्ट्रीय कांग्रेस की अध्यक्षता का कार्य भी किया है।
  1. भारतीय राष्ट्रीय फल का राजा कहलाता है, और यह कौनसा फल है?
  • भारतीय राष्ट्रीय फल आम (Mango) को “फल राजा” कहा जाता है।
  1. भारतीय खेल क्रिकेट का राष्ट्रीय खेल है, और इसका राष्ट्रीय टीम का नाम क्या है?
  • भारतीय खेल क्रिकेट को राष्ट्रीय खेल माना जाता है, और भारतीय क्रिकेट टीम को “भारतीय राष्ट्रीय क्रिकेट टीम” कहा जाता है।
  1. भारतीय संगीत के महान शास्त्रीय संगीतकार और सितार वादक कौन-कौन हैं?
  • भारतीय संगीत के महान शास्त्रीय संगीतकार और सितार वादक पंडित रविशंकर, पंडित रविशंकर जी, और उसके बेटे अनूष्का शंकर हैं।
  1. भारतीय फिल्मों में ‘बॉलीवुड’ के अलावा भी कुछ फिल्म उद्योग हैं। इन्हें क्या नाम दिया जाता है?
  • भारतीय फिल्मों में ‘बॉलीवुड’ के अलावा, भोजपुरी फिल्में (बोली: भोजपुरीया) और साउथ इंडियन फिल्में (बोली: साउथ इंडियन) भी हैं।
  1. भारतीय चिर लोक नृत्य क्षेत्र में एक प्रमुख नृत्य शैली है, जिसे “कथक” कहा जाता है।
  2. भारतीय संगीत में रागों का क्या महत्व है?
  • भारतीय संगीत में रागों का बहुत महत्व है, जो विभिन्न भावनाओं और भावों को व्यक्त करने में मदद करते हैं।
  1. भारतीय रेलवे का सबसे लंबा और सबसे लंबा दौड़ाने वाला स्टेशन कौन सा है?
  • भारतीय रेलवे का सबसे लंबा स्टेशन “गोरखपुर जंक्शन” है और सबसे लंबा दौड़ाने वाला स्टेशन “बीना” है।
  1. भारतीय जनसंख्या जनगणना के अनुसार सबसे बड़ा राज्य कौन सा है?
  • भारतीय जनसंख्या जनगणना के अनुसार सबसे बड़ा राज्य उत्तर प्रदेश है।
  1. भारतीय संविधान को कब अपनाया गया था?
  • भारतीय संविधान को 26 जनवरी 1950 को अपनाया गया था और इस दिन को गणतंत्र दिवस के रूप में मनाया जाता है।
  1. भारतीय नर्मदा और गोदावरी नदियाँ किस समुद्र में मिलती हैं?
  • भारतीय नर्मदा और गोदावरी नदियाँ बंगाल की खाड़ी में मिलती हैं।
  1. भारत की पहली महिला देशप्रेमी एवं आजादी सेनानी कौन थीं?
  • भारत की पहली महिला देशप्रेमी और आजादी सेनानी रानी लक्ष्मी बाई थीं।
  1. भारतीय रेलवे की पहली रेलगाड़ी किस स्थान से चली थी?
  • भारतीय रेलवे की पहली रेलगाड़ी 16 अप्रैल 1853 को मुंबई से ठाणे के बीच चली थी।
  1. भारतीय राजनीति की एक महत्वपूर्ण राजनीतिक पार्टी है जिसे ‘आम आदम पार्टी’ (AAP) कहा जाता है, इसका स्थापना किसने की थी?
  • आम आदम पार्टी (AAP) की स्थापना श्री अरविन्द केजरीवाल और उनके सहयोगियों द्वारा 2012 में की गई थी।
  1. भारतीय स्वतंत्रता सेनानी भगत सिंह को किस वर्ष फाँसी पर चढ़ाया गया था?
  • भगत सिंह को इंग्लैंड के लंदन जेल में फाँसी पर चढ़ाया गया था और उनकी मृत्यु 23 मार्च 1931 को हुई थी।
  1. भारतीय जनसंख्या में सबसे बड़ा धार्मिक समूह कौन-सा है?
  • भारतीय जनसंख्या में सबसे बड़ा धार्मिक समूह हिन्दू धर्मी हैं।
  1. भारतीय संगीत महासभा का मुख्यालय कहां स्थित है?
  • भारतीय संगीत महासभा का मुख्यालय दिल्ली में स्थित है।
  1. भारतीय बौद्ध धर्म के संस्थापक कौन थे?
  • भारतीय बौद्ध धर्म के संस्थापक भगवान बुद्ध थे।
  1. भारतीय नौसेना की मुख्य निगरानी संगठन का नाम क्या है?
  • भारतीय नौसेना की मुख्य निगरानी संगठन का नाम “इंडियन नेवी हेडक्वार्टर्स (इ.ने.एच.ख.)” है।
  1. भारतीय रेलवे का सबसे बड़ा और सबसे चौड़ा स्टेशन कौन-कौन से हैं?
  • भारतीय रेलवे का सबसे बड़ा स्टेशन “गोरखपुर जंक्शन” है और सबसे चौड़ा स्टेशन “नागपुर जंक्शन” है।
  1. भारतीय संविधान में नागरिकों को कितने मुख्य अधिकार मिलते हैं?
  • भारतीय संविधान में नागरिकों को 6 मुख्य अधिकार (फंडामेंटल राइट्स) मिलते हैं।
  1. भारतीय राष्ट्रीय चिन्ह को क्या कहा जाता है?
  • भारतीय राष्ट्रीय चिन्ह को “अशोक चक्र” कहा जाता है।
  1. भारत की सबसे ऊची पर्वत शिखर का नाम क्या है?
  • भारत की सबसे ऊची पर्वत शिखर का नाम “कांचनजंघा” है।
image-13

100 – General Awareness Question Answers

General Awareness Questions

  1. Question: What is the capital city of France?
    • Answer: Paris
  2. Question: Who is known as the “Father of the Nation” in India?
    • Answer: Mahatma Gandhi
  3. Question: Which planet is known as the “Red Planet”?
    • Answer: Mars
  4. Question: What is the currency of Japan?
    • Answer: Japanese Yen
  5. Question: Who wrote “Romeo and Juliet”?
    • Answer: William Shakespeare
  6. Question: In which year did Christopher Columbus reach the Americas?
    • Answer: 1492
  7. Question: What is the largest ocean on Earth?
    • Answer: Pacific Ocean
  8. Question: Who is the current Prime Minister of the United Kingdom?
    • Answer: Boris Johnson
  9. Question: Which gas makes up the majority of the Earth’s atmosphere?
    • Answer: Nitrogen
  10. Question: What is the currency of China?
  • Answer: Chinese Yuan
  1. Question: What is the largest mammal in the world?
    • Answer: Blue Whale
  2. Question: Which river is the longest in the world?
    • Answer: Nile River
  3. Question: Who is the author of the book “To Kill a Mockingbird”?
    • Answer: Harper Lee
  4. Question: What is the currency of Brazil?
    • Answer: Brazilian Real
  5. Question: In which year did India gain independence?
    • Answer: 1947
  6. Question: Which element has the chemical symbol “O”?
    • Answer: Oxygen
  7. Question: Who painted the Mona Lisa?
    • Answer: Leonardo da Vinci
  8. Question: What is the national flower of Japan?
    • Answer: Cherry Blossom
  9. Question: Which continent is known as the “Land Down Under”?
    • Answer: Australia
  10. Question: What is the main ingredient in guacamole?
    • Answer: Avocado
  1. Question: Which planet is known as the “Red Planet”?
    • Answer: Mars
  2. Question: Who is the current Prime Minister of the United Kingdom?
    • Answer: Boris Johnson
  3. Question: What is the capital city of Canada?
    • Answer: Ottawa
  4. Question: Which famous scientist formulated the laws of motion and universal gravitation?
    • Answer: Sir Isaac Newton
  5. Question: What is the official language of Brazil?
    • Answer: Portuguese
  6. Question: Which ocean is the largest on Earth?
    • Answer: Pacific Ocean
  7. Question: Who wrote the play “Romeo and Juliet”?
    • Answer: William Shakespeare
  8. Question: What is the currency of Japan?
    • Answer: Japanese Yen
  9. Question: In which year did the Titanic sink?
    • Answer: 1912
  10. Question: Which gas makes up the majority of the Earth’s atmosphere?
    • Answer: Nitrogen
  1. Question: What is the currency of Australia?
    • Answer: Australian Dollar
  2. Question: Who is known as the “Father of the Nation” in India?
    • Answer: Mahatma Gandhi
  3. Question: Which river is the longest in the world?
    • Answer: Nile River
  4. Question: What is the capital city of South Korea?
    • Answer: Seoul
  5. Question: Who is the author of the Harry Potter book series?
    • Answer: J.K. Rowling
  6. Question: Which country is known as the “Land of the Rising Sun”?
    • Answer: Japan
  7. Question: In which year did India gain independence from British rule?
    • Answer: 1947
  8. Question: What is the largest mammal in the world?
    • Answer: Blue Whale
  9. Question: Which continent is known as the “Dark Continent”?
    • Answer: Africa
  10. Question: Who is the current President of the United States?
    • Answer: Joe Biden
  1. Question: Which gas is most abundant in the Earth’s atmosphere?
    • Answer: Nitrogen
  2. Question: What is the largest planet in our solar system?
    • Answer: Jupiter
  3. Question: Who wrote the play “Romeo and Juliet”?
    • Answer: William Shakespeare
  4. Question: What is the currency of Japan?
    • Answer: Japanese Yen
  5. Question: Who was the first woman to win a Nobel Prize?
    • Answer: Marie Curie
  6. Question: Which mountain is the highest in the world?
    • Answer: Mount Everest
  7. Question: What is the main component of bones and teeth in the human body?
    • Answer: Calcium
  8. Question: Which ocean is the largest on Earth?
    • Answer: Pacific Ocean
  9. Question: What is the capital of Canada?
    • Answer: Ottawa
  10. Question: Who painted the Mona Lisa?
    • Answer: Leonardo da Vinci
  1. Question: In which year did the Titanic sink?
    • Answer: 1912
  2. Question: What is the largest mammal in the world?
    • Answer: Blue Whale
  3. Question: Who is known as the “Father of Computers”?
    • Answer: Charles Babbage
  4. Question: What is the currency of Australia?
    • Answer: Australian Dollar
  5. Question: Which gas do plants absorb from the atmosphere during photosynthesis?
    • Answer: Carbon Dioxide
  6. Question: Who wrote “To Kill a Mockingbird”?
    • Answer: Harper Lee
  7. Question: What is the capital of South Africa?
    • Answer: Pretoria (Administrative), Cape Town (Legislative), and Bloemfontein (Judicial)
  8. Question: In which year did India gain independence?
    • Answer: 1947
  9. Question: Who developed the theory of relativity?
    • Answer: Albert Einstein
  10. Question: Which planet is known as the “Red Planet”?
    • Answer: Mars
  1. Question: What is the largest ocean on Earth?
    • Answer: Pacific Ocean
  2. Question: Who was the first woman to win a Nobel Prize?
    • Answer: Marie Curie
  3. Question: Which river is the longest in the world?
    • Answer: Nile River
  4. Question: Who is the author of “1984”?
    • Answer: George Orwell
  5. Question: What is the capital of Canada?
    • Answer: Ottawa
  6. Question: Which gas makes up the majority of Earth’s atmosphere?
    • Answer: Nitrogen
  7. Question: Who painted the Mona Lisa?
    • Answer: Leonardo da Vinci
  8. Question: Which country is known as the Land of the Rising Sun?
    • Answer: Japan
  9. Question: What is the currency of Japan?
    • Answer: Japanese Yen
  10. Question: In which year did World War I begin?
    • Answer: 1914
  1. Question: Who wrote the play “Romeo and Juliet”?
    • Answer: William Shakespeare
  2. Question: Which planet is known as the Red Planet?
    • Answer: Mars
  3. Question: What is the currency of South Africa?
    • Answer: South African Rand
  4. Question: Who is known as the Father of the Indian Constitution?
    • Answer: B. R. Ambedkar
  5. Question: What is the currency of Brazil?
    • Answer: Brazilian Real
  6. Question: Which gas do plants absorb during photosynthesis?
    • Answer: Carbon Dioxide
  7. Question: Who is the current Secretary-General of the United Nations?
    • Answer: António Guterres
  8. Question: What is the capital of Australia?
    • Answer: Canberra
  9. Question: Who painted “The Starry Night”?
    • Answer: Vincent van Gogh
  10. Question: In which year did the Titanic sink?
    • Answer: 1912
  1. Question: What is the largest mammal on Earth?
    • Answer: Blue Whale
  2. Question: Who discovered penicillin?
    • Answer: Alexander Fleming
  3. Question: What is the capital of Japan?
    • Answer: Tokyo
  4. Question: Which country is known as the Land of the Rising Sun?
    • Answer: Japan
  5. Question: What is the main component of Earth’s atmosphere?
    • Answer: Nitrogen
  6. Question: Who was the first woman to win a Nobel Prize?
    • Answer: Marie Curie
  7. Question: What is the currency of China?
    • Answer: Chinese Yuan Renminbi
  8. Question: Who composed the “Moonlight Sonata”?
    • Answer: Ludwig van Beethoven
  9. Question: In which year did India gain independence?
    • Answer: 1947
  10. Question: What is the largest ocean on Earth?
    • Answer: Pacific Ocean
  1. Question: What is the currency of Brazil?
    • Answer: Brazilian Real
  2. Question: Who wrote “Romeo and Juliet”?
    • Answer: William Shakespeare
  3. Question: Which planet is known as the Red Planet?
    • Answer: Mars
  4. Question: What is the Great Barrier Reef?
    • Answer: The world’s largest coral reef system
  5. Question: Who was the first President of the United States?
    • Answer: George Washington
  6. Question: What is the smallest prime number?
    • Answer: 2
  7. Question: In which year did the Titanic sink?
    • Answer: 1912
  8. Question: What is the national flower of India?
    • Answer: Lotus
  9. Question: Which gas do plants absorb from the atmosphere?
    • Answer: Carbon dioxide
  10. Question: Who painted the Mona Lisa? –
  11. Answer: Leonardo da Vinci