Database Management System - Data Management & Databases
Practice questions to test your knowledge and improve your understanding.
The definition for ____ also defines a candidate key.
Which of the following in true regarding Null Value?
Constraints on the minimum number of entities in a relationship are called ________ cardinalities.
Relational tables need to be ______________ to help avoid duplicate data.
To insert a new field in a table, the ____ keyword should be used with the alter table command.
The basic form of an sql retrieval command is ____.
The dbms provides applications for processing operations such as ________.
Oracle 11g is an example of the _____.
In a database, a collection of related records is referred to as a table or a ____.
School-age children would most admire _____.
To make a specific database active, you must execute the ____ database statement.
Changing cardinalities ________.
Report generators are used to
The maintenance and evolution phase of the database life cycle (dblc) involves _____.
The oracle equivalent to an ms access autonumber is a(n) _____.
If a primary key combines two or more fields, then it is called a _____.
A(n) ____________________ is a specific request issued to the dbms for data manipulation.
To close the resultset, use ____.
A group of similar rows or records is known as ________.
Complete categories are represented by ____ line(s) below the category symbol.
The way patient records are created, filed, and maintained is called a(n) ____.
A collection of related records in a database is referred to as a _____.
The one table in a one-to-many relationship is the ____________________ table.
The sql command ________ defines a logical table from one or more tables or views.
Normalization is normally done to ___ normal form.
Each attribute of an entity becomes a(n) ________ of a table.
Granularity refers to ____.
The dbms _____ the data and sends the result set back to the client.
Which of the following is not a level of data abstraction?
To include all fields in a sql query, use the ____ symbol after the word select.
From the performance point of view, _____ databases eliminate disk access bottlenecks.
A(n) _____ is bidirectional.
You would use query by example, if _____.
In database systems, a _____ refers to a list of data.
The types of constraints supported in sql are ____.
The comparison operator, < >, is used to insert a condition that means ____.
A database administrator (dba) is responsible for _____.
Some databases use ______, which is a visual approach to developing queries and requests.
__________ are the most commonly used database clients.
A _____ attribute can be further subdivided to yield additional attributes.
The syntax for the union query is ____.
A(n) ____ join will select only the rows with common values in the common attribute(s).
Most family therapists who work with couples concentrate on ______.
Snapshot of the dta in the database at a given instant of time is called
The _____ statement combines rows from two queries and excludes duplicates.
The Primary key must be
The ____ data type is used to store integers
Another name for a composite entity is a(n) _____ entity.
The characteristics of an entity are called ____.
"union-compatible" means that the ____.