database mcqs
16) How to make changes permanent after manipulating a table? A) Rollback B) Update C) Delete D) Commit
;Answer: D
D) Constraint:
Allows the database designer to enforce business rules about the data stored in the database's tables and the relationships between tables.
10) A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly
Answer: A
12) ________ is a set of commands used to update a database. A) DML B) DDL C) DCL D) DPL
Answer: A
6) In the figure below, the primary key for "Order Line" is which type of key? A) Composite B) Foreign C) Standard D) Grouped
Answer: A
7) The entity integrity rule states that: A) No primary key attribute can be null. B) Referential integrity must be maintained across all entities. C) Each entity must have a primary key. D) A primary key must have only one attribute.
Answer: A
Short answers: 23) What is schema?
Answer: A schema is a logical grouping of tables, indexes, triggers, and other data objects under one qualifying name.
1) Data is represented in the form of: A) Data trees B) Tables C) Data notes D) Dependent
Answer: B
13) DDL is typically used during which phase of the development process? A) Implementation B) Physical design C) Analysis D) Evaluation
Answer: B
14) Any create command may be reversed by using a(n) ________ command. A) Undo B) Drop C) Delete D) Unpack
Answer: B
15) The SQL command ________ adds one or more new columns to a table. A) Create table B) Alter table C) Create view D) Create relationship
Answer: B
20) An ---------------- is a collection of similar entities. A) Entity B) Entity set C) Attribute D) Attribute set
Answer: B
4) A primary key that consists of more than one attribute is called a: A) Foreign key B) Composite key C) Multivalued key D) Cardinal key
Answer: B
5) In the SQL language, the ________ statement is used to make table definitions. A) Create session B) Create table C) Create index D) Select
Answer: B
9) In the figure below, what type of relationship do the relations depict? A) Strong entity weak entity B) One-to-many C) Ternary D) Many-to-many
Answer: B
11) ________ is a set of commands used to control a database, including security. A) DML B) DDL C) DCL D) TCL
Answer: C
17) INSERT INTO is an example of ________ code. A) DDL B) DCL C) DML D) DNL
Answer: C
2) An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) Column B) Foreign field C) Primary key D) Duplicate key
Answer: C
3) An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) Link attribute B) Link key C) Foreign key D) None of the above
Answer: C
18) A ________ defines or constrains some aspect of the business. A) Business constraint B) Business structure C) Business control D) Business rule
Answer: D
19) The Database Management System is responsible for: A) Data organization B) Data integrity C) Data security D) All of the above
Answer: D
8) A rule that states that each foreign key value must match a primary key value in the other relation is called the: A) Key match rule B) Entity key group rule C) Foreignprimary match rule D) Referential integrity constraint
Answer: D
D) CRUD:
Create, Retrieve, Update and Delete
C) DCL:
Data Control Language
Abbreviations: 21) These abbreviations stand for: A) DDL:
Data Definition Language
B) DML:
Data Manipulation Language
22) These abbreviations stand for: A) DQL:
Data Query Language
B) DBMS:
Database Management System
B) Composite key:
If the primary key consists of more than one column is called a composite key.
C) Foreign key:
It is an attribute(column) in one table whose value must match the value of a primary or an alternate key in a different table.
C) RDBMS:
Relational Database Management System
24) Explain the following concepts: A) Primary key:
The primary key is an attribute(column) or a set of attributes(columns) whose values uniquely identify a row.
D) TCL:
Transaction Control Language