This 'DBMS quizzy fo shizzy' assesses knowledge in database management systems, focusing on dependencies, anomalies, and normal forms. It's designed to test understanding of key DBMS concepts, crucial for students and professionals in IT and computer science.
Inverse
Transitive
Derived
Partial
Relational
Rate this question:
Redundancy
Insertion
Deletion
Modification
None of the above
Rate this question:
Redundancy
Insertion
Deletion
Modification
None of the above
Rate this question:
1st
2nd
3rd
4th
None of the above
Rate this question:
1st
2nd
3rd
4th
None of the above
Rate this question:
1st
2nd
3rd
4th
None of the above
Rate this question:
A table must have at least one column
In most commercial DBMS products, the maximum number of rows in a table is unlimited or very large
A table must have a least one row
Rows in a table are considered to be unsorted
In many commercial DMBS products, the maximum number of columns in a table is limited to 255
Row
Tuple
Table
Attribute
Record
Rate this question:
Based on the value of the foreign key
Optimized by the database engine
Based on the value of the primary key
Changes as data is inserted and deleted
Left to right as defined when the table is created
Rate this question:
Either parent or child depending on the nature of the relationship
Parent
Special key
Child
Rate this question:
Nothing
N/A
Three spaces
High values
000 (three zeros)
Rate this question:
Qualitative
Composite
Value added
Non unique
Indexed
Rate this question:
Foreign keys
Cross table relationships
Indexes
Primary keys
File systems
Rate this question:
Either parent or child depending on the nature of the relationship
Special key
Parent
Child
Rate this question:
Value
Entity
Field
Columns
Attribute
Rate this question:
An employee may be working on several projects
A project may have more than one employee working on it
An employee may not be working on a project
An employee may be working on just one project
A project may have only one employee working on it
Rate this question:
Key based ERD
Context ERD
Full Attribute ERD
This is not one of the defined ERD diagrams
Foreign Key ERD
This central entity in an ERD
A property that uniquely describes an entity
Any property that is a Primary Key or a Foreign Key
The most common property of an entity
Any property that describes an entity
Rate this question:
Data selection and retrieval
Data definition
Data integrity
Access control
All of the above
Rate this question:
Rarely, since there are so many standards and levels of compliance
Usually, but will likely require significant changes
Never, since SQL is unique to IBM
Always, since SQL is standardized
Usually, with minor modifications required
Rate this question:
OO language ilke Java
Language designed for relational databases
Database engine
Programming language unique to Microsoft
3rd generation language like COBOL
Rate this question:
20
30
50
200
Rate this question:
The name can be used to assign the constraint to a second table without having to define the constraint in the second table
It makes understanding certain error messages easier
The same constraint name can be used more than once
The constraint can be selectively overridden when new rows are added to a table
It will eliminate the need to make any modification when porting SQL code from one product to another (e.g. Oracle to DB2)
Rate this question:
Each table can have only one primary key
Tables may have zero, one, or more foreign keys
When defining a parent/child relationship, the ON DELETE clause is specified in one child.
A table may have multiple candidate keys from which the primary key is chosen
A surrogate key is a number that is used by the data owners to identify particular rows (e.g. a student number)
Rate this question:
CHECK
FOREIGN KEY
NULL
UNIQUE
PRIMARY KEY
Rate this question:
SHOW
SELECT *
LIST *
DESCRIBE
Rate this question:
SELECT City as "City Name Is" FROM Offices;
SELECT 'City Name Is', City FROM Offices;
SELECT "City Name Is", City FROM Offices;
SELECT City as 'City Name Is' FROM Offices;
Rate this question:
Jan Dan Man
Fran Stan Dan
Ann Dan Man
Jan Daniel Man
Rate this question:
WHERE Quota BETWEEN 2000 AND 3000
WHERE Quota BETWEEN 1999 AND 3001
WHERE Quota IS BETWEEN 2000 AND 3000
WHERE Quota >= 2000 AND
Rate this question:
TODAY
CURRENTDATE
CURRENT_DATE
TODAY()
Rate this question:
LOWER(columnname)
UPPER(columnname)
Column data cannot be converted to upper case
TO_UPPER(columnname)
Rate this question:
Equi-Join
Full-Inner Join
Non-Equi Join
Cartesian Join
Rate this question:
Mgr and Manager
SalesRep and Mgr
Offices and RepOffice
SalesRep and Manager
Rate this question:
Return all the rows from both tables whether they have a match in the other or not
Return all rows where there is a match in both tables
Return all rows where there is a match in both tables, plus any rows in the right table on the FROM clause that do not have a match on the left table
Return all rows where there is a match in both tables, plus any rows in the left table on the FROM clause that do not have a match on the right table
Rate this question:
True
False
Rate this question:
Return all rows where there is a match in both tables, plus any rows in the left table on the FROM clause that do not have a match on the right table
Return all rows where there is a match in both tables, plus any rows in the right table on the FROM clause that do not have a match on the left table.
Return all rows where there is a match in both tables
Return all the rows from both tables whether they have a match in the other or not
Rate this question:
COUNT(ColumnName)
Count(%)
Count()
Count(*)
Rate this question:
True
False
Rate this question:
When using column functions, the WHERE clause cannot be used
A column function takes the values of two columns and adds them together to create a new value
A column function takes an entire row of data and summarizes it into a single data item
A column function takes an entire column of data and summarizes it into a single data item
Rate this question:
True
False
Rate this question:
HAVING is used to eliminate groups from the result set
If a column function is used on the HAVING clause, it will be calculated after the GROUP BY, creating additional processing.
HAVING clause normally consists of one or more of the column functions applied to each of the groups
HAVING is used to eliminate rows from the result set
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
A query where the sub-query portion is executed many times
The sub-query executes once for every row returned by the outer query
The DBMS executes the inner query first, then the outer query
The sub-query contains an outer reference (a column from the sub-query that is also in a table from the outer query)
A query where the sub-query portion is executed only once
Rate this question:
A query where the sub-query portion is executed many times
The sub-query executes once for every row returned by the outer query
The DBMS executes the inner query first, then the outer query
The sub-query contains an outer reference (a column from the sub-query that is also in a table from the outer query)
A query where the sub-query portion is executed only once
Rate this question:
DML (Data Manipulation Language)
DDL (Data Definition Language)
Transactions
All the above
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
Quiz Review Timeline (Updated): Aug 8, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.