Database Organization & Design MCQs
Database Organization & Design MCQs
Try to answer these 100+ Database Organization & Design MCQs and check your understanding of the Database Organization & Design subject.
Scroll down and let's begin!
1: ____ attributes can have many values.
A. Simple
B. Single-valued
C. Multivalued
D. Composite
2: ____ are important because they help to ensure data integrity
A. Constraints
B. Attributes
C. Entities
D. Relationships
3: The estimated percentage of unsolicited email of all email is approximately ____ percent.
A. 80
B. 60
C. 70
D. 50
4: The crow's foot symbol with two vertical parallel lines indicates _____ cardinality.
A. (0,N)
B. (1,N)
C. (1,1)
D. (0,1)
5: In _________________________ no row may contain two or more multivalued facts about an entity.
A. 5NF
B. 3NF
C. 4NF
D. 2NF
6: Fields in the query design grid include all of the following except ________.
A. Enforce Referential Integrity is checked
B. Pound signs (#)
C. Fields that are listed as Primary Keys
D. Housing market
7: ____ case tools provide support for the coding and implementation phases.
A. Horizontal
B. Front-end
C. Back-end
D. Vertical.
8: ____ data can have only a true or false (yes or no) values.
A. Logical
B. Character
C. Date
D. Numeric
9: ____ data exist in the format in which they were collected.
A. Unstructured
B. Attribute
C. Enterprise
D. Object-oriented
10: ____ describes how instances of one entity relate to instances of another entity.
A. Scalability
B. Compatibility
C. Cardinality
D. Functionality
11: ____ is the formal term for combining two or more columns to form a primary key.
A. Inconsistent data
B. RELATIONSHIPS
C. Concatenation
D. Update anomalies
12: ____ keys work with primary keys to properly implement relationships in the relational model.
A. Foreign
B. Composite
C. Natural
D. Surrogate
13: ____ means that an entity has a minimum cardinality of one.
A. The entity is required in the relationship.
B. The entity is not required in the relationship.
C. The entity should not be in the relationship as an attribute.
D. The entity must be listed with all ones in the data fields
14: ____ reduces the size of a database and makes the data easier to work with.
A. Normalization
B. Centerlization
C. Both
D. None of these
15: ____ view provides the most options for defining fields.
A. Field Create
B. Field Define
C. Table Create
D. Table Design
16: _____ provide a unified, single point of entry for information distribution.
A. Decision support systems
B. Portals
C. Data warehouses
D. Dashboards
17: ________ is a tool even non-programmers can use to access information from a database.
A. Repository.
B. Structured query language
C. Unstructured and unpredictable use of data
D. Enterprise data modeling
18: 1nf, 2nf, and 3nf are ____.
A. Normalization stages
B. Relational databases
C. Relatoinal models
19: A ____ is a storage structure designed to hold a collection of data.
A. Column
B. Row
C. Table
D. Database
20: A ____ key is defined as a key that is used strictly for data retrieval purposes.
A. Lookup
B. Foreign
C. Candidate
D. Secondary
21: A _____ relationship exists when three entities are associated.
A. Unary
B. Weak
C. Binary
D. Ternary
22: A data administrator is also known as a(n) _____.
A. Data security officer
B. Systems administrator
C. Information resource manager
D. Information engineering officer
23: A data warehouse ____ data from several databases to provide useful information.
A. Merges
B. File
C. Field
D. Record
24: A database _____________is organized into rows and columns.
A. Grid
B. Matrix
C. Table
D. Spreadsheet
25: A database _____.
A. Is a collection of integrated and related files
B. Is a collection of integrated and related bit
C. Is a collection of integrated and related flat files
D. Is a collection of integrated and related choice
26: A database holds related file data in ____ .
A. True
B. Text File
C. Fields
D. Tables
27: A file (table) is a collection of related ________.
A. Fields
B. Records
C. Characters
D. Metadata
28: A natural key is also called a(n) ____ key.
A. Surrogate
B. Intelligent
C. Secondary
D. Defining
29: A(n) ____ lock will prevent any ddl operations from being performed on the locked table.
A. UPDATE
B. Exclusive
C. ROLLBACK
D. False
30: Another name for a database server-side extension program is _____.
A. A database application server
B. A web server
C. Web-to-database middleware
D. A web application middleware
31: Changing the database design to improve the performance is called ____.
A. Tuning the design
B. Primary and foreign
C. Concurrent update
D. Data archive
32: In a relational database, a row can be referred to as a(n) ____.
A. Tables
B. Tuple
C. First
33: In data modeling, a(n) ________ is something that the users want to store data about.
A. Entity
B. Store only the metadata about each video in the database
C. Columns
D. ACID
34: In database systems, a _____ defines the data that a table can hold.
A. File
B. Row
C. Key
D. Record
E. Field
35: In database systems, a table is also known as a _____.
A. Table
B. Column
C. Field
D. Record
E. Key
36: In databases information is organized in ________
A. System
B. System requirements
C. Vertical market
D. Tables, records, fields
37: In some database programs, a data file is referred to as a(n) ______.
A. Table
B. Unit
C. Record
D. Sheet
38: The ________ states that no primary key attribute may be null.
A. Referential integrity constraint
B. Entity integrity rule
C. Partial specialization rule
D. Range domain rule
39: To concatenate character strings, you use the _____________ operator in a string expression.
A. FROM
B. +
C. *
D. Asterisk
E. DESC
40: To make changes to existing data in a table, you would use the ____ command.
A. DELETE
B. SELECT
C. UPDATE
D. CHANGE
41: The syntax for the union query is ____.
A. Query + query
B. UNION (query, query)
C. UNION: query query
D. Query UNION query
42: The sql aggregate function that gives the arithmetic mean for a specific column is _____.
A. COUNT.
B. AVG.
C. MAX.
D. SUM. AVG
43: To change rows for which a specific condition is true, use the ____ command
A. WHERE
B. Query
C. LCASE
D. UCASE
44: Surrogate primary keys are especially helpful when there is no _____ key.
A. Natural
B. Natural identifier
C. Redundant
D. Unique
45: The sdlc phase in which the detailed conceptual data model is created is the ________ phase.
A. Planning
B. Design
C. Analysis
D. Implementation
46: To delete rows from the database, use the ____ command.
A. ROLLBACK
B. COMMIT
C. DELETE
D. None of these
47: The special operator used to check whether a subquery returns any rows is ____.
A. BETWEEN
B. EXISTS
C. LIKE
D. IN
48: The special operator used to check whether an attribute value is within a range of values is _____.
A. BETWEEN
B. NULL
C. LIKE
D. IN
49: The extended entity relationship model (eerm) is sometimes referred to as the _____.
A. Enclosed entity relationship model
B. Enhanced entity relationship model
C. Entity clustering relationship
D. Extended entity relationship
50: The implicit beginning of a transaction is ____.
A. When the database is started
B. When a table is accessed for the firsttime
C. When the first SQL statement is encountered
D. When the COMMIT command is issued
List of Database Organization ...
Available in:
Database Organization & Design MCQs
Вопросы по организации и дизайну базы данных на русском языке
Preguntas sobre organización y diseño de bases de datos en español
日本語でのデータベースの組織と設計に関する質問
Domande di organizzazione e progettazione di database in lingua italiana
Questions d'organisation et de conception de bases de données en langues françaises
Questões de organização e design de banco de dados em idiomas portugueses
Fragen zur Datenbankorganisation und -gestaltung in deutschen Sprachen
中文数据库组织与设计问题
أسئلة تنظيم وتصميم قواعد البيانات باللغات العربية
Soal Organisasi & Perancangan Basis Data dalam bahasa Indonesia
Türkçe dillerinde Veritabanı Düzenleme ve Tasarım soruları
