MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

What is the full form of RDBMS?
a. Random Database Management System
b. Relational Database Management System
c. Real-time Database Management System
d. Recursive Database Management System
Answer: b) Relational Database Management Systemsanfoundry
Which key uniquely identifies a record in a table?
a. Foreign Key
b. Candidate Key
c. Primary Key
d. Alternate Key
Answer: c) Primary Keyinterviewbit
Which SQL statement is used to retrieve data from a database?
a. INSERT
b. DELETE
c. SELECT
d. UPDATE
Answer: c) SELECTccbp
What does ACID stand for in RDBMS properties?
a. Atomicity, Consistency, Isolation, Durability
b. Availability, Consistency, Integrity, Durability
c. Atomicity, Communication, Isolation, Durability
d. Accuracy, Consistency, Integrity, Data
Answer: a) Atomicity, Consistency, Isolation, Durabilityinterviewbit
Which join preserves all rows from the left table?
a. Inner Join
b. Right Join
c. Left Join
d. Full Join
Answer: c) Left Joinstudydocs
What operation is used to combine the results of two queries and removes duplicates?
a. INTERSECT
b. UNION
c. JOIN
d. DIFFERENCE
Answer: b) UNIONinterviewbit
Which of the following is a correct statement about a foreign key?
a. It uniquely identifies a row in its own table
b. It is a key from another table used to maintain referential integrity
c. It is always primary key
d. It is never null
Answer: b) It is a key from another table used to maintain referential integrityinterviewbit
What is the lowest level of database abstraction that describes how data is stored?
a. Physical Level
b. Logical Level
c. View Level
d. Conceptual Level
Answer: a) Physical Levelinterviewbit
Which SQL function is used to count the number of rows in a query result?
a. COUNT()
b. SUM()
c. AVG()
d. MAX()
Answer: a) COUNT()interviewbit
Which normal form eliminates all partial dependencies?
a. 1NF
b. 2NF
c. 3NF
d. BCNF
Answer: b) 2NFsanfoundry
What is a tuple in RDBMS?
a. A column in a table
b. A single record (row) in a table
c. A set of tables
d. None of the above
Answer: b) A single record (row) in a tablescribd
What does the term “schema” in RDBMS refer to?
a. The physical storage of data
b. The logical design of the database including tables and relationships
c. The data in the database
d. The query results
Answer: b) The logical design of the database including tables and relationshipssanfoundry
Which SQL clause is used to filter records?
a. WHERE
b. ORDER BY
c. GROUP BY
d. HAVING
Answer: a) WHEREinterviewbit
What is a candidate key?
a. A key that can uniquely identify records in a table
b. A key that references another table
c. A key that is always null
d. A key that stores multiple values
Answer: a) A key that can uniquely identify records in a tableinterviewbit
What is the main purpose of normalization?
a. Reduce data redundancy and improve data integrity
b. Increase data processing speed
c. Store data in a single table
d. Encrypt database tables
Answer: a) Reduce data redundancy and improve data integritysanfoundry
Which operation is used to remove duplicate rows from query results?
a. JOIN
b. DISTINCT
c. GROUP BY
d. UNION
Answer: b) DISTINCTinterviewbit
What does an ER model describe?
a. Data storage structure
b. Logical structure and relationships of entities
c. Physical database layout
d. SQL queries
Answer: b) Logical structure and relationships of entitiessanfoundry
Which type of join returns only matching rows from both tables?
a. Inner Join
b. Left Join
c. Right Join
d. Full Outer Join
Answer: a) Inner Joininterviewbit
Which of the following is NOT a property of a transaction?
a. Atomicity
b. Isolation
c. Serialization
d. Durability
Answer: c) Serializationinterviewbit
What does SQL stand for?
a. Simple Query Language
b. Structured Query Language
c. Sequential Query Language
d. Storage Query Language
Answer: b) Structured Query Languagesanfoundry
Which key ensures that the value is unique and not null?
a. Primary Key
b. Foreign Key
c. Unique Key
d. Composite Key
Answer: c) Unique Keyinterviewbit
What is the term for a set of attributes that uniquely identify a tuple?
a. Super Key
b. Foreign Key
c. Primary Key
d. Candidate Key
Answer: a) Super Keyinterviewbit
Which aggregate function returns the largest value from a selected column?
a. SUM()
b. AVG()
c. MAX()
d. COUNT()
Answer: c) MAX()interviewbit
What type of data model is used in an RDBMS?
a. Hierarchical
b. Network
c. Relational
d. Object-oriented
Answer: c) Relationalsanfoundry
Which command is used to remove a table and all its data from the database?
a. DELETE
b. DROP
c. REMOVE
d. ERASE
Answer: b) DROPsanfoundry
What does a composite key consist of?
a. One attribute
b. Multiple attributes that together uniquely identify a record
c. Foreign key only
d. Candidate key only
Answer: b) Multiple attributes that together uniquely identify a recordsanfoundry
Which of the following is a DDL command?
a. SELECT
b. INSERT
c. CREATE
d. UPDATE
Answer: c) CREATEstudyglance
Which SQL clause is used to sort the result-set?
a. ORDER BY
b. GROUP BY
c. HAVING
d. WHERE
Answer: a) ORDER BYinterviewbit
Which property of transactions ensures that all operations are completed or none at all?
a. Consistency
b. Isolation
c. Atomicity
d. Durability
Answer: c) Atomicityinterviewbit
Which is not a valid SQL join type?
a. Inner Join
b. Outer Join
c. Side Join
d. Cross Join
Answer: c) Side Joininterviewbit
Which SQL keyword is used to change data in a table?
a. UPDATE
b. MODIFY
c. CHANGE
d. ALTER
Answer: a) UPDATEsanfoundry
Which clause is used with GROUP BY to filter groups?
a. WHERE
b. ORDER BY
c. HAVING
d. FILTER
Answer: c) HAVINGinterviewbit
What is a view in RDBMS?
a. A physical copy of the table
b. A virtual table based on the result of a query
c. A backup of a table
d. A type of index
Answer: b) A virtual table based on the result of a querysanfoundry
What does the term “tuple” refer to in RDBMS?
a. Column
b. Table
c. Row
d. Key
Answer: c) Rowscribd
Which of the following constraints ensures data accuracy and integrity?
a. CHECK
b. DEFAULT
c. UNIQUE
d. PRIMARY KEY
Answer: a) CHECKsanfoundry
What is the main purpose of an index in a database?
a. Store large data
b. Speed up data retrieval
c. Delete redundant data
d. Encrypt data
Answer: b) Speed up data retrievalsanfoundry
Which SQL statement is used to add records to a table?
a. ADD
b. INSERT INTO
c. UPDATE INTO
d. ADD RECORD
Answer: b) INSERT INTOsanfoundry
What does referential integrity ensure?
a. Foreign key values must exist in the referenced primary key
b. Primary key values must be unique
c. Data is encrypted
d. No redundant data exists
Answer: a) Foreign key values must exist in the referenced primary keyinterviewbit
Which keyword is used in SQL to remove duplicate rows from the result set?
a. UNIQUE
b. DISTINCT
c. DIFFERENT
d. SEPARATE
Answer: b) DISTINCTinterviewbit
What does normalization primarily try to avoid?
a. Data redundancy and inconsistency
b. Data speed issues
c. Lack of encryption
d. Slow query processing
Answer: a) Data redundancy and inconsistencysanfoundry
What is the full form of DML?
a. Data Manipulation Language
b. Data Management Language
c. Data Modified Language
d. Data Model Language
Answer: a) Data Manipulation Languagestudyglance
In a relation, columns are called:
a. Records
b. Tuples
c. Attributes
d. Fields
Answer: c) Attributessanfoundry
What does the primary key constraint do?
a. It allows null values
b. It uniquely identifies each record and does not allow nulls
c. It references a primary key of another table
d. It allows duplicate values
Answer: b) It uniquely identifies each record and does not allow nullsinterviewbit
Which of the following is true about the candidate key?
a. It uniquely identifies tuples and can be any key eligible to be primary
b. It allows duplicates
c. It always contains nulls
d. It references foreign keys
Answer: a) It uniquely identifies tuples and can be any key eligible to be primaryinterviewbit
In SQL, how do you retrieve unique values from a column?
a. SELECT UNIQUE
b. SELECT DISTINCT
c. SELECT DIFFERENT
d. SELECT ONLY
Answer: b) SELECT DISTINCTinterviewbit
What is a super key?
a. A set of attributes that can uniquely identify a tuple in a relation
b. A key that is used for encryption
c. A key only used in network databases
d. None of the above
Answer: a) A set of attributes that can uniquely identify a tuple in a relationinterviewbit
Which of the following is not a benefit of RDBMS?
a. Data integrity
b. Data redundancy
c. Data security
d. Ease of access
Answer: b) Data redundancysanfoundry
A natural join in SQL is a join that:
a. Joins tables based on all columns with the same name and data type
b. Joins tables on primary key only
c. Joins tables without condition
d. Joins tables on foreign key only
Answer: a) Joins tables based on all columns with the same name and data typesanfoundry
Which is the process of transforming a table into multiple tables to remove redundancy?
a. Denormalization
b. Normalization
c. Aggregation
d. Decomposition
Answer: b) Normalizationsanfoundry
What is an example of an aggregate function in SQL?
a. SELECT
b. COUNT
c. WHERE
d. JOIN
Answer: b) COUNTinterviewbit

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info