BCIS 4660 - Midterm Exam || with Accurate Answers 100%.
1 view 0 purchase
Course
BCIS 4660
Institution
BCIS 4660
1. The product of two tables is also called the ___ product.
a. Cartilage
b. Cathode
c. Cartesian
d. Cardigan correct answers c. Cartesian
2. Which command will grant SELECT rights to user Franklin for Rep table?
a. GRANT SELECT ON Rep;
b. GRANT SELECT ON Rep TO FRANKLIN;
c. GRANT ON Re...
BCIS 4660 - Midterm Exam || with Accurate Answers 100%.
1. The product of two tables is also called the ___ product.
a. Cartilage
b. Cathode
c. Cartesian
d. Cardigan correct answers c. Cartesian
2. Which command will grant SELECT rights to user Franklin for Rep table?
a. GRANT SELECT ON Rep;
b. GRANT SELECT ON Rep TO FRANKLIN;
c. GRANT ON Rep TO FRANKLIN;
d. GRANT SELECT ON FRANKLIN; correct answers b. GRANT SELECT ON Rep TO
FRANKLIN;
3. To use the AND criterion, place the criteria on the ___ criteria row in the design grid.
a. tow above the
c. Same
b. rows above and below the
d. row below the correct answers c. Same
4. The way to write B functionally dependent on A is
a. A =>=>B
c. B=>=>A
b. B=>A
d. A=>B correct answers d. A=>B
5. What is the prevention of unauthorized access to the database?
a. Security
c. Indexing
b. View creation
d. Selection correct answers a. Security
6. A non-key column can be defined as being
a. a section of the primary key.
c. not a part of the primary key.
b. a part of the primary key.
d. a composite part of the primary key. correct answers c. not a part of the primary key.
7. Which operator should be used to connect a compound condition when both simple conditions
need to
be true in order for the compound condition to be true?
a. AND
c. NOR
b. OR
d. NOT correct answers a. AND
,8. Please refer to above figure. Which query will list the customer number and name of all
customer in
descending order by name?
a. SELECT CustomerNumber, CustomerName FROM Customer ORDER BY CustomerName
DESC;
b. SELECT CustomerNumber, CustomerName FROM Customer D OORDER BY
Customer Name D;
c. SLECT CustomerName FROM Customer ORDER BY CustomerName DESC;
d. SELECT CustomerNumber, CustomerName FROM Customer ORDER BY Customer DESC;
correct answers a. SELECT CustomerNumber, CustomerName FROM Customer ORDER BY
CustomerName
DESC;
9. Please refer to above figure. Which query would list the customer umber of every customer
located in a
city that contains the letters "Gro"?
a. SELECT CustomerNum FROM Customer WHERE City = %Gro%;
b. SELECT CustomerNum FROM Customer WHERE City LIKE 'Gro%';
c. SELECT CustomerNum FROM Customer WHERE City LIKE '@Gro_';
d. SELECT CustomerNum FROM Customer WHERE City LIKE %Gro%; correct answers d.
SELECT CustomerNum FROM Customer WHERE City LIKE %Gro%;
10. Which of the following statements is true when a view is created from a table?
a. Column names in the view must be the same as the table.
b. Column names in the view need not be the same as the table.
c. All columns from the table must exist in the view.
d. All rows from the table must exist in the view. correct answers b. Column names in the view
need not be the same as the table.
11. An advantage of a view is to
a. provided data independence.
b. allow different users to view the same data in different ways.
c. All columns from the table must exist in the view
d. all of the above are correct correct answers d. all of the above are correct
12. The keyword___ is used to create a table from a SELECT query.
a. UPDATE
c. DELETE
b. INTO
d. ADD correct answers b. INTO
13. In order to change a table's structure, which command should be used?
a. CHANGE TABLE
c. UPDATE TABLE
b. DROP TABLE
, d. ALTER TABLE correct answers d. ALTER TABLE
14. What happens when rows are grouped?
a. the totals appear with the rows
b. one line of output is produced for each group
c. no output is produced
d. the rows appear in order correct answers b. one line of output is produced for each group
15. The operation where every row in table A is combined with every rw in table B is the
a. union.
c. intersection
b. difference
d. product correct answers d. product
16. in order to create a foreign key RepNum in CUTOMER table, which statement will be used
to link it
to the REP table?
a. FOREIGN KEY (RepNum) REFERENCES Rep
b. FOREIGN KEY REFERENCES Rep
c. FOREIGN KEY (Rep) REFERENCES RepNum
d. FOREIGN KEY (RepNum) LINK TO Rep correct answers a. FOREIGN KEY (RepNum)
REFERENCES Rep
17. The "relationship" concept of ER diagrams is implemented in a relational database system by
using
a. All of the rows in an entity
b. the columns in common among entities.
c. all of the columns in an entity
d. the data in common among the entities. correct answers b. the columns in common among
entities.
18. Which function will give you a total number of rows returned by the query?
a. COUNT
c. MAX
b. SUM
d. TOTAL correct answers a. COUNT
19. An approach to writing queries using a visual or graphical method is called
a. SQL
c. QAC
b. QBE
d. ACCESS correct answers b. QBE
20. A table is in third normal form if it is in what other normal form and the only determinants
are
candidate keys?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
