Database MCQs
Database MCQs
Answer these Database MCQs and see how sharp is your knowledge of Database.
Scroll down and let's start!
1: The relational database model enables you to view data ____ rather than ____.
A. Relationally, hierarchically
B. Hierarchically, relationally
C. Physically, logically
D. Logically, physically
2: In a relational database, a row can be referred to as a(n) ____.
A. Third
B. Table
C. Tuple
D. First
3: The relationships between tables are handled through ____________________ columns.
A. PROJECT
B. JOIN
C. SELECT
D. Common
4: The sdlc phase in which the detailed conceptual data model is created is the ________ phase.
A. Planning
B. Design
C. Analysis
D. Implementation
5: A(n) ____ is an application programs or an individual users picture of the database.
A. View
B. System Catalog
C. Systematic Database
D. Data Dictionary
6: _____ refer to databases focused on addressing the concerns of a specific problem or business unit
A. Data mining
B. Data marts
C. Information
D. Dbms
7: To include all fields in a sql query, use the ____ symbol after the word select.
A. View
B. Set
C. Asterisk (*)
D. Outer
8: The crows feet notation on an erd is a type of _______ constraint.
A. cardinality
B. relationship
C. many-to-many
D. multiplicity
9: A programming language typically used for cgi scripts is ____.
A. PERL
B. SQL
C. Java
D. JavaScript
10: The term _________________________ refers to scattered locations storing the same basic data.
A. Application Program
B. Data independence
C. Data redundancy
D. Islands of information
11: The _____ component of a case tool produces the information system's input/output formats.
A. Screen painter and report generator
B. Front-end
C. Database security officer
D. Provide the data necessary for tactical decisions and planning
12: A(n) ____ is a query that is embedded (or nested) inside another query.
A. Operator.
B. Subquery.
C. Alias.
D. View.
13: A/an ___________________ report shows a summary but no details.
A. Aggregate
B. Surrogate
C. Custom
D. Standard
14: Some very specialized applications may require normalization beyond the _____.
A. 3NF
B. 1NF
C. 4NF
D. 2NFF
15: A(n) ____ is a piece of data required by an action in a macro.
A. Code
B. Argument
C. Message
D. Pointer
16: ____________________ is a process to help reduce the likelihood of data anomalies.
A. Granularity
B. Normalization
C. Data warehouse
D. Concept of keys
17: The default comparison condition for the subtype discriminator attribute is the _____ comparison.
A. Nonequality
B. Less than
C. Greater than
D. Equality
18: The _____ model uses the term connectivity to label the relationship types.
A. Network
B. Entity relationship
C. Object-orientedd
D. Relational.
List of Database MCQs Multiple...
Available in:
Database MCQs
База данных МCQs (множественного выбора)
Database MCQs (Preguntas de opción múltiple)
データベース MCQs（多肢選択問題）
Database MCQs (Domande a risposta multipla)
QCM de Base de données
Questões de Múltipla Escolha de Banco de Dados
Datenbank-MCQs (Multiple-Choice-Fragen)
数据库选择题
قاعدة بيانات متعددة الخيارات
Database Soal Pilihan Ganda
Veritabanı Çoktan Seçmeli Sorular
