1. (TCO 1) Most DBMS are referred to as _____________database management systems
ID: 3541067 • Letter: 1
Question
1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4)
elemental
linked
hierarchical
relational
2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4)
information
processing
applications
programming
3. (TCO 2) A relationship is an association between_____________. (Points : 4)
objects.
entities.
databases.
fields.
4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table?
(Points : 4)
UNIQUE
PRIMARY KEY
FOREIGN KEY
NOT NULL
5. (TCO 3) A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. (Points : 4)
surrogate primary keys
time-variant data
design trap
fan trap
6. (TCO 3) All of the following are true about a prime attribute except_____________. (Points : 4)
it is a key attribute
it is at least part of a key
it is not a key attribute
it may be part of a composite key
7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in_____________. (Points : 4)
1NF.
2NF.
3NF.
4NF.
BCNF.
8. (TCO 4) When a constraint is created at the ______ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition. (Points : 4)
table
column
database
row
9. (TCO 4) Which of the following is not considered a database object? (Points : 4)
a table
a view
a constraint
a sequence
an index
10. (TCO 4) Which of the following SQL statements would you use to create a table named DEVRY? (Points : 4)
CREATE Devry
(
Student_id NUMBER (12),
Student_name VARCHAR2 (15),
Student_city VARCHAR2 (12)
);
CREATE TABLE Devry
(
Student_id NUMBER (12)
Student_name VARCHAR2 (15)
Student_city VARCHAR2 (12)
);
CREATE TABLE Devry
(
Student_id NUMBER (12),
Student_name VARCHAR2 (15),
Student_city VARCHAR2 (12)
);
CREATE TABLE Devry
Student_id NUMBER (12),
Student_name VARCHAR2 (15),
Student_city VARCHAR2 (12);
11. (TCO 5) The ____ constraint requires that a specific condition be met before a record can be added to a table. (Points : 4)
UNIQUE
REFERENCE
CONDITION
CHECK
12. (TCO 5) The ___________ model is both software and hardware dependent. (Points : 4)
conceptual
logical
condensed
physical
13. (TCO 6) The _________________________ statement can be used to enable or disable a constraint. (Points : 4)
alter table
modify table
create table
update table
14. (TCO 6) Which of the following keywords is used to remove a database table in Oracle? (Points : 4)
DROP TABLE
ALTER TABLE...DROP
DELETE TABLE
TRUNCATE TABLE
15. (TCO 6) Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column? (Points : 4)
ADD
MODIFY
CHANGE
RESET
16. (TCO 7) To create a query using a mathematical symbol to find a specific code (21344) from the product table you must write it as_____________. (Points : 4)
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE 21344;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE => 21344;
17. (TCO 7) Which of the following subqueries returns more than one row of results to the outer query? (Points : 4)
multiple-column subquery
single-row subquery
multiple-row subquery
correlated subquery
18. (TCO 7) To list a unique value, where the list will produce only a list of those values that are different from one another, you will write the command_____________. (Points : 4)
SELECT ONLY V-CODE
FROM PRODUCT;
SELECT UNIQUE V-CODE
FROM PRODUCT;
SELECT DIFFERENT V-CODE
FROM PRODUCT;
SELECT DISTINCT V-CODE
FROM PRODUCT;
19. (TCO 8) Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of categories contained in the table?
(Points : 4)
SELECT COUNT(DISTINCT category) FROM books;
SELECT DISTINCT COUNT(category) FROM books;
SELECT DISTINCT (COUNT(category)) FROM books;
SELECT DISTINCT COUNT(category) FROM books;
20. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?
(Points : 4)
SELECT order#, SUBSTR(shipzip, 1, 323)
FROM book_order;
SELECT order#, SUBSTR(shipzip, 1, 323)
FROM book_order
WHERE shipzip = 323;
SELECT order#
FROM book_order
WHERE shipzip = SUBSTR(shipzip, 1, 323);
SELECT order#
FROM book_order
WHERE SUBSTR(shipzip, 1, 3) = 323;
21. (TCO 8) Which of the following functions determines the number of characters in a character string? (Points : 4)
COUNT
NUMBER
LENGTH
DECODE
22. (TCO 9) The column to be updated by the UPDATE command is specified in the ______ clause. (Points : 4)
UPDATE
SET
WHERE
COL
23. (TCO 9) Using the promotion table shown below, which of the following SQL statements will insert a new row into the PROMOTION table?
sql> select * from promotion
gift minretail maxretail
bookmarker 0 12
book label 12.01 25
book cover 25.01 56
free shipping 56.01 999.99
(Points : 4)
INSERT INTO promotion (gift, minretail, maxretail)
VALUES (FREE BOOK, 75.01, 89.99);
INSERT INTO promotion (gift, minretail, maxretail)
VALUES ('FREE BOOK', 75.01, 89.99);
INSERT INTO promotion VALUES (FREE BOOK, 75.01, 89.99);
INSERT INTO promotion (gift, minretail)
VALUES (FREE BOOK, 75.01, 89.99);
24. (TCO 10) A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources. (Points : 4)
user
role
profile
manager
25. (TCO 10) Which of the following commands can be used to revoke system or object privileges previously granted to a user? (Points : 4)
UNGRANT
REMOVE
REVOKE
DROP
1. (TCO 2) Explain what physical independence means. (Points : 15)
2. (TCO 3) Explain in what two specific cases presented in the text composite primary keys are particularly useful. (Points : 15)
3. (TCO 7) Sally needs to find all employees who have a date-of-hire between 01-JAN-2003 and 01-JAN-2005. She writes and executes the following query:
SELECT emp_no, emp_lname, date_of_hire
FROM emp
WHERE date_of_hire BETWEEN '01-JAN-2005' and '01-JAN-2003';
When she looks at the returned result set it is empty. Why? (Points : 15)
4. (TCO 8) In a table named ORDER, there is a column named SHIPDATE that contains a date for each order that has been shipped. Write the query that would show the number of orders that have been shipped. List the column name as "Number of Orders Shipped" for this derived column. (Points : 15)
5. (TCO 6) Oracle will not allow the changing of a column's data type unless the column is empty, and even then it may still be prohibited. Discuss why? (Points : 15)
1. (TCO 7) Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order.
Explanation / Answer
1.relational
2.information
3.entities
4.FOREIGN KEY
5.surrogate primary keys
6.it is not a key attribute
7.2NF.
8column
9.a sequence
10.CREATE TABLE Devry
(
Student_id NUMBER (12),
Student_name VARCHAR2 (15),
Student_city VARCHAR2 (12)
);
11.CHECK
12)logical
13.alter table
14.DROP TABLE
15.MODIFY
16. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;
17.single-row subquery
18.SELECT DISTINCT V-CODE
FROM PRODUCT;
19.SELECT COUNT(DISTINCT category) FROM books;
20.SELECT order#
FROM book_order
WHERE shipzip = SUBSTR(shipzip, 1, 323);
21. LENGTH
22. SET
23. INSERT INTO promotion (gift, minretail, maxretail)
VALUES ('FREE BOOK', 75.01, 89.99);
24.role
25.REVOKE
1.physical independence means that logical scheme stays unchanged even though the storage space or type of some data is changed for reasons of optimization or reorganization. In this external schema does not change. In this internal schema changes may be required due to some physical schema were reorganized here. Physical data independence is present in most databases and file environment in which hardware storage of encoding, exact location of data on disk,merging of records, so on this are hidden from user.
2. That is not a good reason to use a composite key. The key is there for the machine not the user. The computer does not really care about the aesthetics of unbroken sequences.
The keys you have indicated in your tables are not good candidates if they are text. Text fields are relatively slow to join. If you used Integer codes for MaterialCode and MaterialColour in the RawMaterial table then it could be suitable.
More than two fields as a key starts to get messy. They must all appear everywhere the foreign key is required. I would definitely not use four.
3. WHERE need '=' after it.
4. SELECT COUNT(SHIPDATE) as Number of Orders Shipped FROM ORDER
WHERE SHIPDATE IS NOT NULL
5. As changing the datatype in a coloumn tends/causes to change the whole structure of the database and a int cannot determine/ mismatch the char/varchar field. thus there would be a hectic error. So inorder to reduce error it does not allow to change.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.