Exam (elaborations)

BCIS 4660 - Midterm Exam || with Accurate Answers 100%.

0 purchase

Module
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...

[Show more]

Preview 3 out of 21 pages

View example

Uploaded on August 16, 2024
Number of pages 21
Written in 2024/2025
Type Exam (elaborations)
Contains Questions & answers

1 the product of two tables is also called the

Institution BCIS 4660
Module BCIS 4660

FullyFocus

Member since 2 year 550 documents sold

£11.05

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

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 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 £11.05. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69052 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling

Exam (elaborations)

BCIS 4660 - Midterm Exam || with Accurate Answers 100%.

Document information

Subjects

Written for

Seller

Reviews received

Content preview