Introduction to Database MCQ (FREE Multiple Choice Questions)

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

51: When a primary key combines two or more fields, it is called a ____ key.

A. Constructed

B. Composite

C. Collective

D. Parallel

52: When a project executes, its __________ is automatically displayed.

A. Main sub

B. Startup form

C. Event procedure

D. Form load event

53: When a script file contains more than one command, each command must end with a(n) ____.

A. Question mark.

B. Colon.

C. Period.

D. Semicolon

54: When an entity has a relationship to itself, we have a(n) ________.

A. 0 or 1

B. Create a new ID-dependent entity with a 1:N relationship

C. Recursive relationship

D. Association table will have additional columns

55: When choosing field names, it is best to choose names that ____.

A. Include both numbers and letters in the name

B. Use only uppercase characters

C. Describe the content or purpose of the field

D. Use only lowercase letters and no spaces

56: When creating a query using the query design command, first you must ____________.

A. Select the table(s) you want to get criteria from

B. File compression

C. Connect the data in tables

D. Select the text

57: When designing a database, you should ____.

A. Consider more important issues such as performance before normalizing,

B. Create table structures then normalize the database,

C. Make sure entities are in normal form before table structures are created,

D. Only normalize the database when performance problems occur

58: When designing a new database, the first question users should ask themselves is ________.

A. Commone field

B. .accdb

C. True

D. What questions should this database be able to answer

59: When designing tables a ____ structure is preferred

A. Simple

B. Complex

C. Detailed

D. Complete

60: With a(n) ____ language, the user provides an example of the data requested.

A. SQL

B. IDE

C. QBE

D. Interpolated

61: 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.

62: The system catalog is also called the ____.

A. Data dictionary.

B. Transaction database.

C. System database.

D. Master data table

63: The term ____ database comes from the fact that two or more tables are linked by a common field.

A. Database

B. Entry bar

C. Relational

D. Purpose, meaningful title

64: To change a table name, we ________.

A. Use the SQL-92 RENAME TABLE command

B. Use the SQL-92 ALTER TABLENAME command

C. Use the SQL-92 MODIFY TABLENAME command

D. Create a new table, move the data and drop the old table

65: The ____ clause is used to specify the interval between two sequential values.

A. CREATE INDEX...ON

B. DROP SEQUENCE

C. INCREMENT BY

D. CREATE SEQUENCE

66: The _____ data model is said to be a semantic data model.

A. Relational

B. Network

C. Object-oriented

D. Entity relationship

67: The process of retrieving only certain rows based upon a specified condition is known as ____.

A. True

B. USING

C. DML operations cannot be performed on a non key-preserved table.

D. Selection

68: Use data when __________.

A. Using generally accepted information

B. Providing background information

C. Giving context for an argument

D. Needing hard facts Please select the best answer from the choices provided

69: _____ is the result of revealing the meaning of raw facts.

A. Data integrity

B. Unstructured

C. Application

D. Information

70: A ____ column is a column that is not part of the primary key.

A. Period

B. Entity

C. Nonkey

D. Order

71: A ____ defines the name and data type of program variables.

A. Nonprocedural

B. Data operation

C. Data declaration

D. Static, dynamic

E. Unresolved references

72: A ____ is a program that lets computer users create and access a collection of organized data.

A. Data warehouse

B. Database management system

C. Database

D. Management system

73: A ____ key is defined as a key that is used strictly for data retrieval purposes.

A. Lookup

B. Foreign

C. Candidate

D. Secondary

74: A _____ controls database operations, including storing, retrieving, updating, and deleting data.

A. Manipulation

B. Manufacturing

C. Schema

D. Dynamic

75: A _____ is a simple database program whose records have no relationship to one another.

A. Select one:

B. Flat file

C. Schema

D. Relational system

E. User view

76: A _____ specifies the fields and identifies the primary key in a particular file.

A. Output design

B. Market basket design

C. Table design

D. Diagram design

77: A ________ describes the data and relationships that will be stored in a database.

A. Data aggregator.

B. Query model.

C. Data model

78: A ________ is a temporary table used in the from clause of an sql query.

A. Correlated subquery.

B. Derived table.

C. View table.

D. None of these

79: A ________ of a base class expects to be overridden in a derived class.

A. Constructor function

B. Destructor function

C. Static function

D. Virtual function

80: A __________ is the column of data in a database that is used as the basis for arranging data.

A. Primary key

B. Sort key

C. Datatype

D. Keyvalue

81: A characteristic of decision support data is ____.

A. High query activity

B. High update volumes

C. Highly normalized

D. Low aggregation level

82: A characteristic of operational data is ____.

A. Summarized data

B. Hundreds of gigabytes

C. High normalization

D. Historic data

83: A data dictionary typically includes any of the following except ____.

A. Data redundancy

B. Data integrity

C. Flexible use of data

D. Information sharing

84: A data integrity problem will occur only if ________.

A. There are multiple administrators

B. Data are duplicated

C. The database is very large

D. There are complex relationship

A. Fields

B. Files

C. Tables

A. Flat file

B. Choice

C. Files

D. Bit

87: A database is used instead of a spreadsheet when ________.

A. Lists of data involve a single theme

B. Structures of data lists are simple

C. Lists involve data with multiple themes

D. Users do not want to store all data in one place

88: A dbms lets you assign users to ____.

A. Groups

B. Classes

C. Attributes

D. Clusters

89: A desktop database is a ____ database

A. Single-user

B. Workgroup

C. Multiuser

D. Distributed

A. Key Field

B. Qualities

C. Metadata

D. Fields

E. Records

91: A relation is in ____ if it does not contain any repeating groups.

A. First normal form

B. Second normal form

C. Third normal form

D. Boyce-Codd normal form

A. Query

B. Primary

C. Database

D. Landscape

93: Another term for a database row is a(n) ________.

A. Foreign key

B. Attribute

C. Primary key

D. Record

94: As part of a dbms, a(n) _________ documents information about a database.

A. Integrated

B. A key field

C. Data dictionary

D. Big Data

95: Browser-based applications ________.

A. Eliminate the need to check for data consistency

B. Need to be pre-installed on the users' computers

C. Run within a corporate network that is protected from the Internet

D. Are more vulnerable to security threats than are traditional applications

96: Changing the order of fields in a database table is an example of changing a table’s ____.

A. Purpose

B. Structure

C. Data

D. Value

97: Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

A. Minimum

B. Maximum

C. Both of these