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

Which of the following best defines a database?
a. A collection of programs
b. A structured collection of data
c. A type of operating system
d. A statistical model
Answer: b. A structured collection of dataplacementpreparation
What is the primary function of a Database Management System (DBMS)?
a. Data mining
b. Data visualization
c. Data storage and retrieval
d. Data cleaning
Answer: c. Data storage and retrievalplacementpreparation
In relational databases, what does each row in a table represent?
a. Attribute
b. Tuple
c. Field
d. Method
Answer: b. Tupletestbook
Which SQL statement is used to retrieve data from a database?
a. UPDATE
b. SELECT
c. DELETE
d. INSERT
Answer: b. SELECTccbp
What is a primary key used for in a relational database?
a. Encrypting data
b. Uniquely identifying a record
c. Enhancing performance
d. Storing passwords
Answer: b. Uniquely identifying a recordccbp
In normalization, which normal form eliminates transitive dependencies?
a. First Normal Form
b. Second Normal Form
c. Third Normal Form
d. Fifth Normal Form
Answer: c. Third Normal Formccbp
Which model uses a tree-like structure for organizing data?
a. Relational Model
b. Network Model
c. Hierarchical Model
d. Object-oriented Model
Answer: c. Hierarchical Modelccbp
Which command is used to remove an entire table from the database?
a. DELETE
b. DROP
c. REMOVE
d. TRUNCATE
Answer: b. DROPccbp
What is normalization in databases mainly designed to avoid?
a. Data inconsistencies
b. Query errors
c. Performance bottlenecks
d. Redundancy
Answer: d. Redundancyccbp
What does ACID stand for in database transactions?
a. Atomicity, Consistency, Integrity, Durability
b. Atomicity, Consistency, Isolation, Durability
c. Access, Control, Integrity, Durability
d. Access, Consistency, Integrity, Durability
Answer: b. Atomicity, Consistency, Isolation, Durabilityccbp
Which SQL constraint ensures uniqueness of all values in a column?
a. FOREIGN KEY
b. CHECK
c. UNIQUE
d. PRIMARY KEY
Answer: c. UNIQUEsanfoundry
Which of the following is not a type of SQL join?
a. Inner join
b. Left join
c. Cross join
d. Around join
Answer: d. Around joinccbp
Which clause in SQL is used to filter records returned by a SELECT statement?
a. WHERE
b. GROUP BY
c. HAVING
d. ORDER BY
Answer: a. WHEREplacementpreparation
What is a foreign key used for?
a. Encrypting columns
b. Defining valid values
c. Linking two tables
d. Speeding up queries
Answer: c. Linking two tablesccbp
Which of the following is a non-relational database?
a. MySQL
b. PostgreSQL
c. MongoDB
d. Oracle
Answer: c. MongoDBsanfoundry
In the context of databases, what is a schema?
a. A backup file
b. The structure that defines database organization
c. An index structure
d. A data warehouse
Answer: b. The structure that defines database organizationsanfoundry
What does the SQL command GRANT do?
a. Removes a table
b. Gives user permissions
c. Updates table data
d. Deletes user data
Answer: b. Gives user permissionssiteforinfotech
Which of the following is an advantage of NoSQL databases?
a. Fixed schema only
b. High scalability
c. No indexing
d. Only supports small datasets
Answer: b. High scalabilitysanfoundry
When is a database said to be in First Normal Form (1NF)?
a. When all attributes are atomic
b. When partial dependencies are removed
c. When transitive dependencies are removed
d. When all keys are unique
Answer: a. When all attributes are atomicccbp
Which of the following best describes a data warehouse?
a. A system for storing transactional data only
b. An analytical database optimized for reporting
c. A spreadsheet tool
d. A non-relational key-value store
Answer: b. An analytical database optimized for reportingsanfoundry
The command used to modify existing data in a table is:
a. UPDATE
b. SELECT
c. INSERT
d. DROP
Answer: a. UPDATEinterviewbit
A database index is primarily used to:
a. Compress data
b. Reduce storage costs
c. Speed up query retrieval
d. Ensure ACID properties
Answer: c. Speed up query retrievalsanfoundry
What type of relationship is represented by a foreign key?
a. One-to-one
b. Many-to-many
c. One-to-many
d. All of the above
Answer: d. All of the aboveccbp
Which of these is an example of a distributed database?
a. SQLite
b. CouchDB
c. Access
d. Excel
Answer: b. CouchDBsanfoundry
Which SQL clause combines results from two or more SELECT statements?
a. GROUP BY
b. UNION
c. INTERSECT
d. ORDER BY
Answer: b. UNIONplacementpreparation
Which language is commonly used to define and manipulate data in a database?
a. DML
b. HTML
c. CSS
d. XML
Answer: a. DMLsanfoundry
The process of recovering a database after failure is called:
a. Roll-up
b. Restoration
c. Recovery
d. Consolidation
Answer: c. Recoverysanfoundry
In a DBMS, the logical configuration is represented by:
a. Catalogs
b. Schemas
c. Fields
d. Indices
Answer: b. Schemassanfoundry
The maximum number of entities that can participate in a relationship refers to:
a. Cardinality
b. Modality
c. Multiplicity
d. Affinity
Answer: a. Cardinalitysanfoundry
Which type of SQL statement is used to add new records to a table?
a. SELECT
b. DELETE
c. INSERT
d. ALTER
Answer: c. INSERTinterviewbit
What is denormalization?
a. Making database schema less flexible
b. Introducing redundant data for faster lookups
c. Splitting tables into smaller ones
d. Enforcing indexes
Answer: b. Introducing redundant data for faster lookupsccbp
Which of the following best describes data integrity?
a. Ensuring rapid query response
b. Guaranteeing consistency and accuracy of data
c. Enabling external access
d. Data compression
Answer: b. Guaranteeing consistency and accuracy of datasanfoundry
A field uniquely identifying a record in a table is called:
a. Foreign Key
b. Candidate Key
c. Primary Key
d. Sub Key
Answer: c. Primary Keyscribd
Which view in a DBMS is concerned with individual user perspective?
a. Internal view
b. External view
c. Conceptual view
d. Global view
Answer: b. External viewtestbook
What is a data mart?
a. A DBMS admin tool
b. A subset of a data warehouse
c. A form of normalization
d. A type of NoSQL database
Answer: b. A subset of a data warehousesanfoundry
What does SQL stand for?
a. Simple Query Language
b. Secure Query Language
c. Structured Query Language
d. Symbolic Query Language
Answer: c. Structured Query Languageplacementpreparation
Which of the following ensures only valid data is stored in a field?
a. Index
b. Constraint
c. View
d. Procedure
Answer: b. Constraintsanfoundry
Which NoSQL database type stores data as key-value pairs?
a. Document store
b. Relational store
c. Key-value store
d. Graph store
Answer: c. Key-value storeplacementpreparation
Which of the following is a common open-source relational database?
a. Cassandra
b. MongoDB
c. MySQL
d. Redis
Answer: c. MySQLsanfoundry
What does OLAP stand for?
a. Online Analytical Processing
b. Offline Allocation Processing
c. Online Access Processing
d. Operational Logic and Analytics Platform
Answer: a. Online Analytical Processingsanfoundry
Which of these is not a usual component of the three-level DBMS architecture?
a. Internal level
b. Conceptual level
c. Application level
d. External level
Answer: c. Application leveltestbook
Which command is used to revise the structure of an existing table?
a. UPDATE
b. ALTER
c. MODIFY
d. APPEND
Answer: b. ALTERplacementpreparation
Who is responsible for database schema definition and access control?
a. Normal user
b. Developer
c. Database Administrator (DBA)
d. Data analyst
Answer: c. Database Administrator (DBA)sanfoundry
What is a transaction in the context of databases?
a. A statistical analysis step
b. A sequence of one or more SQL operations performed as a unit
c. A single SELECT query
d. An export import process
Answer: b. A sequence of one or more SQL operations performed as a unitccbp
Which of these statements is true about Big Data databases?
a. They handle only structured data
b. They cannot scale horizontally
c. They can process large volumes, variety, and velocity of data
d. They never use SQL
Answer: c. They can process large volumes, variety, and velocity of datasanfoundry
Which field is used to link two tables together?
a. Primary Key
b. Foreign Key
c. Cardinality Field
d. Unique Index
Answer: b. Foreign Keyccbp
SQL injection exploits the absence of:
a. Primary key
b. Indexing
c. Input validation and parameterization
d. Data compression
Answer: c. Input validation and parameterizationplacementpreparation
Which of these is a major objective of a database system?
a. Data independence
b. Data visualization
c. Data redundancy
d. Data mining
Answer: a. Data independencescribd
A database backup is mainly necessary to:
a. Improve data redundancy
b. Enable faster queries
c. Ensure data recovery in case of failure
d. Test database schema
Answer: c. Ensure data recovery in case of failuresanfoundry
Which is a common interface for naive database users?
a. Command-line interface
b. Programming APIs
c. Form-based interface
d. Batch processing interface
Answer: c. Form-based interfacescribd

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info