Introduction to Database MCQs
Introduction to Database MCQs
These Introduction to Database multiple-choice questions and their answers will help you strengthen your grip on the subject of Introduction to Database. You can prepare for an upcoming exam or job interview with these Introduction to Database MCQs.
So scroll down and start answering.
1: The privilege ____ can be granted to change the table structure.
A. ALTER
B. UPDATE
C. False
D. Select
2: The product of two tables is also called the ____ product.
A. Cartesian
B. Aggregate
C. Cathode
D. Exponential
3: The response of the dbms to a query is the ____.
A. Ad hoc query
B. Ad hoc response
C. Query result set
D. Integrated view of the data
4: The privilege ____ can be granted to change data.
A. Select
B. Delete
C. Parent
D. UPDATE
5: The organization of data within folders in a manual file system is determined by _______.
A. Its date of creation
B. Its expected use
C. The title
D. The data processing specialist
6: The pl/sql block starts with the _____ section.
A. Section
B. OPEN
C. DECLARE
D. BEGIN
7: The rate of data that is transmitted from your computer to the internet is ____.
A. Downstream speed
B. Uploaded
C. Upstream speed
D. Network class
8: The relational database model enables you to view data ____ rather than ____.
A. Relationally, hierarchically
B. Hierarchically, relationally
C. Physically, logically
D. Logically, physically
9: The ____ constraint prevents the user from adding a null value in the specified column.
A. INCREMENT BY
B. NOT NULL
C. NEXTVAL
D. COUNT
10: The data _______ or schema contains a description of the structure of data in the database.
A. Distributed
B. Dictionary
C. Attribute
D. Relational
11: The data mining technique that relies on association rule learning is often called _____.
A. Strategy-orientated analysis
B. Market basket analysis
C. Simulated analysis
D. Virtual storage analysis
12: The erd represents the ____ database as viewed by the end user.
A. Condensed
B. Physical
C. Logical
D. Conceptual
13: The process of extracting information from a data warehouse or data mart is called ____.
A. Data mining
B. Business intelligence
C. Data warehouse
D. Database
14: The output of data mining in a business setting is sometimes called ____.
A. QBE, query by example
B. Business intelligence
C. The names of the data items
D. Tables and fields
15: The primary disadvantage of contiguous storage is that ____.
A. It is hard to implement and manage
B. It is difficult to find information in files
C. File can't be expanded unless there is empty space available immediately following it
D. It is an inefficient use of space
16: The primary purpose of a database is ______.
A. To make it easy to create graphs
B. To keep track of lists of data with multiple themes
C. To store a list of data involving a single topic or theme
D. To apply formulas to data representing mathematical relationships
E. Avoid having to learn about spreadsheets
17: The ____ is the most widely used database model today.
A. Relational database management system (RDBMS)
B. Data dictionary
C. Report
D. Record
18: The command to delete a view is ____.
A. DROP INDEX
B. DROP VIEW
C. SYSTABLES
D. SYSCOLUMNS
19: The data accessed by data mining and other analysis techniques is often stored in a data ____.
A. Example *
B. JavaScript *
C. Related *
D. Warehouse
20: The database structure in a dbms is stored as a ____.
A. Collection of files
B. Many to many
C. Object-oriented
D. Anomalies
21: The equijoin takes its name from the comparison operator ____ used in the condition.
A. =
B. 1:1
C. 1:M
D. Logically, physically
22: The field that uniquely identifies a row in a relational database table is called a ________.
A. Foreign key
B. Primary key
C. Column
D. Data definition language
E. Null value
23: The following are all processing operations of a dbms except _________.
A. Data is duplicated
B. Metadata
C. A single theme
D. Autocorrect data
24: The conceptual model can handle _____ relationships and multivalued attributes.
A. (1,1)
B. M:N
C. False
D. Rectangle
25: The connection between two tables in a database is called a _________.
A. Spreadsheet
B. Attribute
C. A data model
D. Relationship
26: The object-oriented data model was developed in the _____.
A. File system data model
B. 1980s
C. 1970s
D. Entity relationship
27: The person responsible for the control of the centralized and shared database is the database ____.
A. Analyst
B. Administrator
C. Programmer
D. User
28: The sdlc phase in which the detailed conceptual data model is created is the ________ phase.
A. Implementation
B. Constraint
C. Analysis
D. User view
29: To restrict the rows returned from an sql query, you should use the _____ clause:
A. SELECT
B. WHERE
C. GROUP BY
D. CONDITION
E. All of the above
30: To upload a file, display the ____ bar, and then click the upload button or the add files button.
A. Apps
B. 2 GB.
C. Right-click
D. A browser
31: Use the ____ command to save the current object with a new name.
A. Datasheet
B. View
C. Save Object As
D. Save as
32: When linking two tables in a relational database, a user will use a ________ to create the link.
A. Common field
B. Tag
C. Hyperlink
D. Bookmark
33: When renaming columns, you include the new column names in ____ following the name of the view.
A. Parent
B. Parentheses
C. DROP INDEX
D. False
34: When we consider entities as tables, each column is a(n) ________.
A. Attribute.
B. Record.
C. Form.
D. Bot.
E. Query
35: When you specify a foreign key, the table referenced by the foreign key is the ____.
A. parent
B. Super
C. Sibling
D. Child
36: While triggers run automatically, ________ do not and have to be called.
A. Trapdoors
B. Routines
C. Selects
D. Updates
37: You can think of a database as a _____________________.
A. Folder of different objects
B. List of data
C. Spreadsheet file
D. Set of document tabs
E. Long word-processing document
38: You use the ____ clause to list data in a specific order.
A. ORDER BY
B. ORDER
C. SET ORDER
D. LIST BY
39: The _____ model is the end users’ view of the data environment.
A. Object-oriented
B. External
C. Entity relationship
D. Segment
40: The multi-step process used when creating a new system is referred to as ____.
A. The Systems Development Life Cycle
B. Data mining
C. E-R Modeling
D. SQL
41: The database is loaded during the ____ phase of the sdlc.
A. Analysis
B. Detailed systems design
C. Implementation
42: The principle of accuracy in logic is __________.
A. RETRIEVE
B. UPDATE
C. READ
D. SELECT
43: To avoid data ____, a database stores data in one place.
A. Integrity
B. Primary key
C. Redundancy
D. Data mining
44: To generate unique numbers in sequence, you use the ________________ attribute.
A. AUTO_INCREMENT
B. Foreign keys
C. ALTER TABLE
D. Foreign key
45: To guarantee that the member variables of a class are initialized, you use ____.
A. Accessors
B. Mutators
C. Constructors
D. Destructor
46: To insert a new field in a table, the ____ keyword should be used with the alter table command.
A. ADD
B. Primary
C. True
D. False
47: To make a specific database active, you must execute the ____ database statement.
A. CHANGE
B. USE
C. SWITCH
D. SELECT
48: To order the records in the answer to a query in a particular way, you ____ the records.
A. True
B. Join
C. Sort
D. Print
49: To represent relationships, ________ are added to tables.
A. Locking keys.
B. Value keys.
C. Entity keys.
D. Normalized keys.
E. Foreign keys
50: Validation rules can indicate a ____.
A. Clicking the New record, CTRL + Plus Sign, Click new button
B. Filter records, Changing the appearance of data sheet, adding new records, Changing the data
C. Required
D. Required field, Default Value, Range of Values
List of Introduction to Databa...
Available in:
Introduction to Database MCQs
Вопросы с выбором ответов по основам баз данных (MCQ)
Preguntas de opción múltiple sobre Introducción a Bases de Datos (MCQ)
データベース入門の選択肢式問題 (MCQ)
Domande a risposta multipla sull'Introduzione ai Database (MCQ)
Questions à choix multiples sur l'Introduction aux Bases de Données (MCQ)
Perguntas de Múltipla Escolha sobre Introdução a Banco de Dados (MCQ)
Multiple-Choice-Fragen zur Einführung in Datenbanken (MCQ)
数据库导论多项选择题 (MCQ)
أسئلة اختيارية متعددة حول مقدمة قواعد البيانات (MCQ)
Pertanyaan Pilihan Ganda Pengantar Database (MCQ)
Veritabanı Girişi MCQ Soruları
