IS-340 Practice Exam Questions And Complete Answers.
2 views 0 purchase
Course
ISBN
Institution
ISBN
Primary Key - correct answer is used to uniquely identify each row in a table
Foreign Key - correct answer Used to reference or join data in different tables. In most cases the foreign key references a pr...
Primary Key - correct answer is used to uniquely identify each row in a table
Foreign Key - correct answer Used to reference or join data in different tables.
In most cases the foreign key references a primary key in another table.
Normalization Process - correct answer (1NF) repeating groups identified and a
primary key is used. (2NF) Any partial dependencies are removed. (3NF) Transitive dependencies
removed
What type of relationship cannot be stored in a database - correct answer A
many to many relationship because there would be no way to restructure or rejoin the data correctly.
What represents a row in a table - correct answer a record
What represents a column in a table - correct answer field
When part of the data in a table depends on a field in the table that isn't the table's primary key, it's
known as: - correct answer transitive dependency
Which of the following is used to join data contained in two or more tables - correct answer
Common field
Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table
- correct answer SELECT firstname, lastname FROM customers;
Which of the following SELECT statements returns all fields in the ORDERS table? - correct answer
SELECT * FROM orders;
, when must a comma be used on the SELECT clause of a query - correct answer
When listing more than one field ma,e and the fields aren't concatenated
Which customers live in New Jersey? List each customer's name first name last name and state - correct
answer select lastname, firstname, state
from customers
where state='NJ'
/
Which orders shipped after April 1, 2009? List each order number and the date it shipped. - correct
answer select order#, shipdate
from orders
where shipdate>'01-APR-05'
/
Which books are not in the fitness category? list each book title and category. - correct answer
select title, category
from books
where category<>'fitness'
/
which orders where placed on or before April, 1 2005 list each order number and order date write the
query in 2 separate ways - correct answer Way 1:
select order#, orderdate
from orders
where orderdate <='01-APR-05'
/
Write a statement that selects last names from new jersey and Georgia and puts them in descending
order. - correct answer select lastname, state
from customers
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 RealGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
