NEW
Font size
WorksheetsUnit 26 - Develop Databases
Total questions: 20
Worksheet time: 39mins
Relational Databases save information as...
text files
Separate Documents
Structured tables without relations
Structured tables with relations
Many to many relation means..
One table record relates to another record in another table
One table record relates to many records in another table.
More than one table record relates to another table record
More than one table record relates to more than one record in another table
Some examples of relational databases include
Microsoft SQL Server
MySQL
Oracle
All of the above
A labeled element of a tuple, e.g. "Address" or "Date of birth" is called
Row
Tuple
Attribute
Record
A data report from the RDBMS in response to a query is called
Column
Result Set
Base Relation
Field
A constraint can restrict a given integer attribute to values between 1 and 10. This is called...
Primary Key Constraint
Foreign Key Constraint
Domain Constraint
Syntax Constraint
DDL stands for
Data Define Language
Define Data Language
Data Definition Language
Definition Data Language
DML includes
SELECT query
INSERT query
DELETE query
All of the above
A language consisting of diagrams that help developers to program (code) an application is known as
Structure Query Language
Unified Modeling Language
Hypertext Markup Language
eXtensible Markup Language
DBMS is...
a software used to create, update and delete user profiles in a computer system
a software used to only update a database in a computer system
a software that handles the storage, retrieval, and updating of data in a computer system.
a software used to alter the memory cache in a computer system
The names assigned to each piece of data and their data types are known as
Identifiers
Data definitions
Administration
Security
For instance there is an attribute “student-name”. Its type is varchar. It has a limit of maximum 20 characters. These all are...
Identifiers
Data Definitions
Administration
Security
What best describes a data dictionary?
A set of files that contains meta data for a database
A definition of relationships used in a database
A set of SQL statements to create a database
A glossary of terms used in database structures
Which one of the following best describes a relational database?
Each entity in an entity-relationship (ER) diagram converts to a table
Key values must be null before the entity relationship is defined
Primary keys must be joined in a one to many entity relationship
Entities are defined by a list of unique attributes
Which one of the following is a Database management environment?
MySQL
IDE
DTD
ODBC
Which one of the following segments of SQL code adds a new column for startdate to the courses table?
INSERT startdate INTO TABLE courses
ALTER TABLE courses ADD (startdate (DATE))
ALTER TABLE courses ADD (startdate DATE)
INSERT INTO TABLE courses (startdate)
A name of a database, table, or table column is known as...
Identifier
Data Definition
Administration
Security
Information on schema and all the other information regarding access, storage, built in programs or any other information about database elements or usage is known as
Identifier
Meta Data
Primary Key
Constraint
SQL is..
ANSI Standard
ISO Standard
W3C Standard
ANSI/ISO Standard
A query that removes structure and data of a table
Truncate
Drop
Delete
None of the above
