CS 2203 Unit 1 – 8 Self Quiz Review Questions

The main purpose of the information model is to inform software developers and provide protocol-specific constructs.
Select one:
True
False

Question 2
Which term describes each two-dimensional table or file in the relational model?
Select one:
a. Database
b. Relational Database
c. Data Warehouse
d. None of the Above

Question 3
If a relation has more than one candidate key the one chosen to represent the relation is called the:
Select one:
a. primary key
b. foreign key
c. alternate key
d. candidate key

Question 4
The first hierarchial DBMS was ____ and was released by IBM in 1968?
Select one:
a. IMS (Information Management System)
b. SQL
c. DB2
d. Oracle

Question 5
What is a field that uniquely describes each record?
Select one:
a. Composite Key
b. Foreign Key
c. Primary Key
d. None of the Above

Question 6
The number of attributes in a relation is known as:
Select one:
a. The relation degree
b. The relation cardinality
c. The relation domain
d. The relation schema

Question 7
Which of the following is NOT an information model?
Select one:
a. pureXML model
b. Relational Model
c. Hierarchial model
d. Network model

Question 8
The network model (CODASYL) was released in what year?
Select one:
a. 1979
b. 1969
c. 1964
d. 1980

Question 9
A formal description of all the database relations and all of the relationships existing between them is called a database schema.
Select one:
True
False

Question 10
A unique KEY field
Select one:
a. Is a special field that each database has to have.
b. Is a special field that identifies a particular record in a database
c. Is a special field that identifies a particular record in a data table
d. is a special field that has to be a unique number

Question 11
A foreign key is an attribute in one relation whose values match those of a primary key in another relation.
Select one:
True
False

Question 12
Which of the following is NOT a valid relationship for an entity relationship model?
Select one:
a. 1-to-1
b. m-to-1
c. 1-to-n
d. n-to-n

Question 13
A tuple is an ordered set of values that describe data characteristics at one moment in time. An informal term for tuple is:
Answer:

Question 14
A characteristic of data, a real-world data feature modeled in the database is called:
Select one:
a. attribute
b. cell
c. column
d. value

Question 15
The surrogate key provides a unique alternate for using a foreign key that is used to save space.
Select one:
True
False

Question 1
Which of the following statements BEST describes data integrity.
Select one:
a. ensures that data entered into the database is accurate, valid, and consistent.
b. Rules that ensure that no primary key is allowed to accept null values
c. Ensures consistency between the primary key and foreign key of relations
d. Ensure that primary keys are unique identifiers

Question 2
The AND logical operator is represented
Select one:
a. by the set of all things not contained within a set ( the compliment of the set)
b. by the overlap of two sets (the intersection)
c. by the union (overlap) of the universal set and a second set
d. by the contents of either of two sets (the union)

Question 3
Consider the following table:

SREF | INIT | SNAME | DOB | GENDER | RES | KIDS | HTOWN | 1 | TJ | OSMAN | 29-Sep-53 | M | No | 0 | MILLHOUSE GREEN | 2 | S | LANGLEY | 21-Aug-57 | F | No | 0 | HUDDERSFIELD | 3 | H | WILSON | 07-Jul-62 | M | Yes | 1 | HUDDERSFIELD | 4 | J | CARTER | 21-Mar-54 | F | Yes | 2 | BARNSLEY | 5 | A | JONES | 10-Nov-48 | F | Yes | 2 | SHEFFIELD | 6 | S | ISHEMO | 05-Dec-50 | M | No | 0 | LEEDS | 7 | K | ARNOTT | 01-Aug-60 | F | Yes | 2 | SHEFFIELD | 8 | B | ARNOTT | 23-May-62 | F | Yes | 1 | LEEDS | 9 | N | GREEN | 30-Sep-58 | M | Yes | 1 | SHEFFIELD |

the filter KIDS=1 OR RES=True will
Select one:
a. list all those who are resident and all those who have one child
b. list all those with 1 child
c. list all those who are resident
d. list only those who have one child as well as all those who are resident

Question 4
In strict relational terminology, an attribute is
Select one:
a. a table
b. a field
c. an entity
d. a record

Question 5
The entity integrity constraint says that if a relation R2 includes a foreign key FK matching the primary key PK of other relation R1, then every value of FK in R2 must either be equal to the value of PK in some tuple of R1 or be wholly null.
Select one:
True
False

Question 6
The primary key does not have to be unique in relations that have a one to many relationship.
Select one:
True
False

Question 7
A foreign key can accept a null value unless otherwise restricted by a null constraint.
Select one:
True
False

Question 8
Integrity constraints are rules that help ensure the quantity of the information.
Select one:
True
False

Question 9
A primary key must consist of one and only one field.
Select one:
True
False
Question 10
If a salesperson attempts to order merchandise for a customer not in the customer service database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.
Select one:
True
False

Question 11
>=1 is the same as >0 (for integers)
Select one:
True
False

Question 12
Consider the following table:

SREF | INIT | SNAME | DOB | GENDER | RES | KIDS | HTOWN | 1 | TJ | OSMAN | 29-Sep-53 | M | No | 0 | MILLHOUSE GREEN | 2 | S | LANGLEY | 21-Aug-57 | F | No | 0 | HUDDERSFIELD | 3 | H | WILSON | 07-Jul-62 | M | Yes | 1 | HUDDERSFIELD | 4 | J | CARTER | 21-Mar-54 | F | Yes | 2 | BARNSLEY | 5 | A | JONES | 10-Nov-48 | F | Yes | 2 | SHEFFIELD | 6 | S | ISHEMO | 05-Dec-50 | M | No | 0 | LEEDS | 7 | K | ARNOTT | 01-Aug-60 | F | Yes | 2 | SHEFFIELD | 8 | B | ARNOTT | 23-May-62 | F | Yes | 1 | LEEDS | 9 | N | GREEN | 30-Sep-58 | M | Yes | 1 | SHEFFIELD |

the filter KIDS >=1 OR KIDS=0 will
Select one:
a. List no-one
b. List everyone
c. List those who have 1 child
d. List those who have no children
Question 13
What do integrity constraint rules help you ensure?
Select one:
a. Quantity of the information
b. Quantity of the data
c. Quality of the information
d. All of the above

Question 14
There can be duplicate primary keys in the same file in a database.
Select one:
True
False

Question 1
A given relation is known to be in third normal form. Select the statement which can be inferred from this:
Select one:
a. All attributes contribute to the primary key
b. Each non-key attribute determines the primary key
c. Each non-key attribute is determined by the primary key
d. Every determinant is a candidate key
e. The relation is not in fourth normal form.

Question 2
A lack of normalisation can lead to which one of the following problems
Select one:
a. Lost Updates
b. Deletion of data
c. Insertion problems
Inserting data into an unnormalised system can result in the same data being entered in multiple tables. This gives rise to the possibility of data for the same object being entered "slightly differently" in more than one table. For instance, if a person's surname appeared in more than one table, and that person then changed his name, this change would have to be done in all tables where the name appeared. Ensuring this can be difficult, and so it is better to avoid such duplicated data by normalising the database design.
d. Deadlock conditions

Question 3
To transform a relation from second normal form to third normal form we must remove which one of the following?
Select one:
a. All partial-key dependencies
b. All inverse partial-key dependencies
c. All repeating groups
d. All transitive dependencies

Question 4
An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor. Competitor(cid, name, nationality) Event(eid, description, winner) Competes(cid, eid) Competitor | cid | name | nationality | 01 | Pat | British | 02 | Hilary | British | 03 | Sven | Swedish | 04 | Pierre | French | | Event | eid | description | winner | 01 | running | | 02 | jumping | | 03 | throwing | | | Competes | cid | eid | 01 | 01 | 02 | 01 | 03 | 02 | 04 | 02 | 04 | 03 | |
Select one:
a. A numeric attribute should be added to the Competes table
b. A numeric attribute should be added to the Event table
c. A numeric attribute should be added to the Competitor table
d. Three numeric attribute should be added to the Competitor table
e. Two numeric attributes should be added to the Competitor table

Question 5
The rule that prohibits transitive dependencies is
Select one:
a. first normal form
b. second normal form
c. third normal form
d. BCNF

Question 6
Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach
Select one:
a. second normal form
b. first normal form
c. third normal form
d. the standard of a flat file

Question 7
The rule that specifies that there should be no repeating fields and that fields should be atomic is
Select one:
a. first normal form
b. second normal form
c. third normal form
d. None of the above

Question 8
Consider the table (Relation) CARS REGNO
(Key Field) | MODEL | COLOUR | OID |

The key is REGNO (car registration number), OID is a foreign key that identifies the car's owner.

This table is in? select one:
a. first normal form
b. second normal form
c. third normal form
d. None of the above
Question 9
It is impossible to represent which of the following in a relational schema?
Select one:
a. any mandatory participation constraint in a many-to-one relationship
b. any mandatory participation constraint in a many-to-many relationship
c. a one-to-one relationship
d. a many-to-one relationship
e. a ternary relationship

Question 10
We know that table
Q has only one candidate key. Q is in 2NF.
Select one:
True
False

Question 11
Consider the table STUDREC SREF
(Key Field) | INIT | SNAME | DOB | GENDER | RES | KIDS | HTOWN | DISTANCE |

Which field (attribute) is transitively dependent on the key (SREF)
Select one:
a. RES (is the student residential)
b. KIDS (number of children)
c. DISTANCE (how far from The Northern College does the student live)
d. HTOWN (the student's home town)

Question 12
An atomic field is
Select one:
a. a single valued field
b. a key field
c. a numerical field
d. a key that contains only a single field

Question 13
Consider the table (Relation) CLASSES CLASSREF
(Key Field) | CLASS_TITLE | TUTOR_ID | ROOM_ID |

Why is the class title not suitable as a key field?
Select one:
a. The key field needs to be a unique number
b. The key field has to be an extra field to the actual data that we store about classes
c. It is likely that as time passes, we'll need to add more classes with different names to our CLASSES table.
d. It is possible to have more than one class with the same name (e.g. a database design class could run on Monday for one group and on Tuesday for another group)

Question 14
One of the tasks of a relational database management system (RDBMS) is to ensure that relational schemas are in at least 3NF.
Select one:
True
False

Question 15
Which of the following is generally a benefit of normalisation?
Select one:
a. Performance is improved
b. Insertion anomalies are avoided
c. Selection anomalies are avoided
d. Number of tables is reduced

Question 1
A given relation is known to be in third normal form. Select the statement which can be inferred from this:
Select one:
a. All attributes contribute to the primary key
b. Each non-key attribute determines the primary key
c. Each non-key attribute is determined by the primary key
d. Every determinant is a candidate key
e. The relation is not in fourth normal form.

Question 2
A lack of normalisation can lead to which one of the following problems
Select one:
a. Lost Updates
b. Deletion of data
c. Insertion problems
Inserting data into an unnormalised system can result in the same data being entered in multiple tables. This gives rise to the possibility of data for the same object being entered "slightly differently" in more than one table. For instance, if a person's surname appeared in more than one table, and that person then changed his name, this change would have to be done in all tables where the name appeared. Ensuring this can be difficult, and so it is better to avoid such duplicated data by normalising the database design.
d. Deadlock conditions

Question 3
To transform a relation from second normal form to third normal form we must remove which one of the following?
Select one:
a. All partial-key dependencies
b. All inverse partial-key dependencies
c. All repeating groups
d. All transitive dependencies

Question 4
Incorrect
An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor. Competitor(cid, name, nationality) Event(eid, description, winner) Competes(cid, eid) Competitor | cid | name | nationality | 01 | Pat | British | 02 | Hilary | British | 03 | Sven | Swedish | 04 | Pierre | French | | Event | eid | description | winner | 01 | running | | 02 | jumping | | 03 | throwing | | | Competes | cid | eid | 01 | 01 | 02 | 01 | 03 | 02 | 04 | 02 | 04 | 03 | |
Select one:
a. A numeric attribute should be added to the Competes table
b. A numeric attribute should be added to the Event table
c. A numeric attribute should be added to the Competitor table
d. Three numeric attribute should be added to the Competitor table
e. Two numeric attributes should be added to the Competitor table

Question 5
The rule that prohibits transitive dependencies is
Select one:
a. first normal form
b. second normal form
c. third normal form
d. BCNF

Question 6
Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach
Select one:
a. second normal form
b. first normal form
c. third normal form
d. the standard of a flat file

Question 7
The rule that specifies that there should be no repeating fields and that fields should be atomic is
Select one:
a. first normal form
b. second normal form
c. third normal form
d. None of the above

Question 8
Consider the table (Relation) CARS REGNO
(Key Field) | MODEL | COLOUR | OID |

The key is REGNO (car registration number), OID is a foreign key that identifies the car's owner.

This table is in
Select one:
a. first normal form
b. second normal form
c. third normal form
d. None of the above

Question 9
It is impossible to represent which of the following in a relational schema?
Select one:
a. any mandatory participation constraint in a many-to-one relationship
b. any mandatory participation constraint in a many-to-many relationship
c. a one-to-one relationship
d. a many-to-one relationship
e. a ternary relationship

Question 10
We know that table
Q has only one candidate key. Q is in 2NF.
Select one:
True
False
Question 11
Consider the table STUDREC SREF
(Key Field) | INIT | SNAME | DOB | GENDER | RES | KIDS | HTOWN | DISTANCE |

Which field (attribute) is transitively dependent on the key (SREF)
Select one:
a. RES (is the student residential)
b. KIDS (number of children)
c. DISTANCE (how far from The Northern College does the student live)
d. HTOWN (the student's home town)

Question 12
An atomic field is
Select one:
a. a single valued field
b. a key field
c. a numerical field
d. a key that contains only a single field

Question 13
Consider the table (Relation) CLASSES CLASSREF
(Key Field) | CLASS_TITLE | TUTOR_ID | ROOM_ID |

Why is the class title not suitable as a key field?
Select one:
a. The key field needs to be a unique number
b. The key field has to be an extra field to the actual data that we store about classes
c. It is likely that as time passes, we'll need to add more classes with different names to our CLASSES table.
d. It is possible to have more than one class with the same name (e.g. a database design class could run on Monday for one group and on Tuesday for another group)

Question 14
One of the tasks of a relational database management system (RDBMS) is to ensure that relational schemas are in at least 3NF.
Select one:
True
False

Question 15
Which of the following is generally a benefit of normalisation?
Select one:
a. Performance is improved
b. Insertion anomalies are avoided
c. Selection anomalies are avoided
d. Number of tables is reduced

Question 1
A Database Language Concerned with The Definition of the Whole Database Structure and Schema Is ________
Select one:
a. DCL
b. DML
c. DDL
d. All of the above

Question 2
Which of the following are valid CREATE statements in the world of DDL?
Select one:
a. CREATE SCHEMA
b. CREATE TABLE
c. CREATE DOMAIN
d. CREATE INDEX
e. All of the above

Question 3
To increase the number of nullable columns for a table,
Select one:
a. Use the alter table statement.
b. Ensure that all column values are NULL for all rows.
c. First increase the size of adjacent column datatypes, then add the column.
d. Add the column, populate the column, then add the NOT NULL constraint.

Question 4
The CREATE TABLE statement is used to…
Select one:
a. create a new database table.
b. change existing database table
c. create a new database.
d. None of the above

Question 5
Which SQL statement is used to update data in a database?
Select one:
a. update
b. save
c. modify
d. save as

Question 6
User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID,LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
Select one:
a. INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
b. INSERT INTO employee VALUES (59694,’HARRIS’, SALARY);
c. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);
d. INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’);

Question 7
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Select one:
a. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
b. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
c. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
d. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Question 8
Which three of the following are valid database datatypes in Oracle? (Choose three.)
Select one or more:
a. CHAR
b. VARCHAR
c. NUMBER
d. OBJECT

Question 9
The SQL ALTER statement can be used to:
Select one:
a. change the table structure.
b. change the table data.
c. add rows to the table.
d. delete rows from the table.
Question 10
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Select one:
a. INSERT INTO Persons (LastName) VALUES ('Olsen')
b. INSERT ('Olsen') INTO Persons (LastName)
c. INSERT INTO Persons ('Olsen') INTO LastName
d. None of the above
Question 1
The left outer join is one type of outer join. Another one is the.
Select one:
a. right
b. full
c. right outer
d. full outer
e. All of the above

Question 2
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Select one:
a. SELECT * FROM Persons SORT BY 'FirstName' DESC
b. SELECT * FROM Persons ORDER BY FirstName DESC
c. SELECT * FROM Persons ORDER FirstName DESC
d. SELECT * FROM Persons SORT 'FirstName' DESC

Question 3
Which SQL keyword is used to sort the result-set?
Select one:
a. SORT BY
b. ORDER
c. ORDER BY
d. SORT

Question 4
Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?
Select one:
a. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU
b. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER
c. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
d. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.

Question 5
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Select one:
a. Equi-join
b. Natural join
c. Outer Join
d. Cartesian Join

Question 6
Partially correct
Which of the following is one of the basic approaches for joining tables?
Select one:
a. Subqueries
b. Union Join
c. Natural join
d. All of the above
Question 7
A UNION query is which of the following?
Select one:
a. Combines the output from no more than two queries and must include the same number of columns.
b. Combines the output from no more than two queries and does not include the same number of columns.
c. Combines the output from multiple queries and must include the same number of columns.
d. Combines the output from multiple queries and does not include the same number of columns.

Question 8
What type of join is needed when you wish to return rows that do have matching values?
Select one:
a. Equi-join
b. Natural join
c. Outer Join
d. All of the above

Question 9
Consider the following database:
MOVIE(id,title,yr)
ACTOR(id,name)
CASTING(movieid,actorid)
Identify the SQL command which will return the titles of all 1959 Marilyn Monroe films. 1. The following SQL... SELECT title FROM movie,casting,actor WHERE movieid = movie.id<> AND name = 'Marilyn Monroe' ; 2. The following SQL... SELECT title FROM movie,actor WHERE name = 'Marilyn Monroe' AND yr = 1959 ; 3. The following SQL... SELECT title FROM movie,casting,actor WHERE movieid = movie.id AND actor.id = actorid AND name = 'Marilyn Monroe' AND yr = 1959 ; 4. The following SQL... SELECT title FROM movie,casting,actor WHERE movieid = movie.id AND actor.id = actorid AND movie.yr = casting.yr AND name = 'Marilyn Monroe' AND yr = 1959 ; 5. None of the above
Select one:
a. Choice 1
b. Choice 2
c. Choice 3
d. Choice 4
e. Choice 5

Question 10
An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor. Competitor(cid, name, nationality) Event(eid, description, winner) Competes(cid, eid) Competitor | cid | name | nationality | 01 | Pat | British | 02 | Hilary | British | 03 | Sven | Swedish | 04 | Pierre | French | | Event | eid | description | winner | 01 | running | | 02 | jumping | | 03 | throwing | | | Competes | cid | eid | 01 | 01 | 02 | 01 | 03 | 02 | 04 | 02 | 04 | 03 | |
Select the BEST answer from the following options based upon the provided data and data structures:
Select one:
a. There is a British competitor in every event.
b. Pierre does not compete in any event
c. Sven has been entered in two events
d. Pat is competing in the jumping event
e. Hilary has entered only the running event

Question 1
If we write a program in a programming language and switch to SQL when we require to use the database, then the SQL environment in use is known as _______ SQL.
Select one:
a. Real - time
b. Dynamic
c. PL -
d. Embedded

Question 2
Embedded SQL is which of the following?
Select one:
a. Hard-coded SQL statements in a program language such as Java.
b. The process of making an application capable of generating specific SQL code on the fly.
c. Hard-coded SQL statements in a procedure.
d. Hard-coded SQL statements in a trigger.
Question 3
In JDBC, what represents a single instance of a particular database session?
Select one:
a. a thread
b. an opened connection
c. a closed connection
d. a pipe
Question 4
A relational database query normally returns many rows of data. But an application program usually deals with one row at a time. Which of the following is used to bridge this gap allowing the program to deal with on row at a time.
Select one:
a. Cursor
b. Trigger
c. PL/SQL
d. Sub select join

Question 5
The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a relational database.
Select one:
True
False

Question 6
True or False: ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in java and JDBC code is automatically installable, secure, and portable on all platforms.
Select one:
True
False

Question 7
True/False: ODBC can be directly used with Java because it uses a C interface.
Select one:
True
False
Question 8
True/False: JDBC API is a natural Java Interface and is built on ODBC. JDBC retains some of the basic features of ODBC
Select one:
True
False