NEW
Font size
WorksheetsLearn Database with ARJ
Total questions: 20
Worksheet time: 7mins
What is a database?
A database is a programming language used for data analysis.
A database is a type of software for creating websites.
A database is a physical location for storing files.
A database is an organized collection of data stored electronically.
Define data and information.
Data is raw facts; information is processed data that has meaning.
Data is a summary of findings; information is the collection of data.
Data is always organized; information is unstructured.
Data is only numerical; information is only textual.
What is a field in a database?
A field is a column in a database table that stores specific data attributes.
A field is a command used to query a database.
A field is a row in a database table.
A field is a type of database software.
What is a record in a database?
A record is a command used to query a database.
A record is a collection of related data items stored together in a database.
A record is a type of database software.
A record is a single data type in a database.
What are primary keys?
Primary keys can be duplicated across records.
Primary keys are unique identifiers for records in a database table.
Primary keys are used to store large text data.
Primary keys are optional fields in a database table.
What are foreign keys?
Foreign keys are used to create indexes on a single table.
Foreign keys are a type of primary key that can exist independently.
Foreign keys are constraints that link records in one table to records in another table, ensuring data integrity.
Foreign keys are constraints that only apply to the primary table.
What are the different types of databases?
Relational, NoSQL, In-memory, Time-series
Distributed, Hierarchical, Document
Cloud, XML, CSV
Flat-file, Graph, Object-oriented
What does SQL stand for?
Structured Query Language
Standard Query Language
Structured Query List
Simple Query Language
What is the purpose of sorting in a database?
To encrypt sensitive information in the database.
To delete unnecessary data from the database.
The purpose of sorting in a database is to organize data in a specific order for efficient retrieval and analysis.
To create backups of the database.
What is indexing in a database?
Indexing is a technique to optimize data retrieval in a database by creating a data structure that allows faster access to records.
Indexing refers to the process of backing up data in a database.
Indexing is a technique to encrypt data in a database.
Indexing is a method to delete records from a database.
Define entity in the context of databases.
An entity is a distinct object or concept in a database that has attributes and can be identified.
An entity refers to a database user.
An entity is a type of database query.
An entity is a method for data retrieval.
What is an attribute in a database?
An attribute is a database table.
An attribute is a type of database query.
An attribute is a method for data retrieval.
An attribute is a property or characteristic of an entity in a database.
What is the difference between a database and a spreadsheet?
A database is used for simple calculations, while a spreadsheet is for complex data management.
A database is only for storing text files, while a spreadsheet is for images.
A database can only handle small amounts of data, while a spreadsheet can manage large datasets.
A database is for managing large datasets and complex queries, while a spreadsheet is for individual data analysis and calculations.
What is normalization in databases?
A way to visualize database relationships
Normalization in databases is the process of organizing data to minimize redundancy and dependency.
A method to increase data redundancy
A technique for data encryption
What is a relational database?
A relational database is a type of spreadsheet software.
A relational database is a database that organizes data into tables that can be linked by relationships.
A relational database stores data in a single file without relationships.
A relational database is a collection of unrelated documents.
What is a NoSQL database?
A NoSQL database only stores data in tables.
A NoSQL database is a type of SQL database.
A NoSQL database is exclusively used for large-scale transactions.
A NoSQL database is a non-relational database that allows for flexible data storage and retrieval.
What is a database management system (DBMS)?
A database management system (DBMS) is software that manages databases.
A DBMS is a cloud service for hosting websites.
A DBMS is a programming language for creating applications.
A DBMS is a type of hardware for storing data.
What is a schema in a database?
A schema is a type of database management system.
A schema is a collection of data entries.
A schema is a blueprint that defines the structure of a database.
A schema is a programming language for databases.
What is a query in SQL?
A query in SQL is a type of database table.
A query in SQL is a request for data from a database.
A query in SQL is a programming language.
A query in SQL is a method for deleting data from a database.
What is the purpose of a database transaction?
The purpose of a database transaction is to ensure data integrity and consistency.
To improve database performance
To store data in a more complex format
To allow multiple users to access the database simultaneously
