Previous QuizPrev Quiz
Relational Databases
Next QuizNext Quiz

Big Java Binder Early Objects

Computing

Quiz 23 :
Relational Databases

Quiz 23 :
Relational Databases

Showing 1 - 20 of 75
Next Quiz
arrow
Insert the statement that would remove the following table from the database. CREATE TABLE Course ( Course_ID VARCHAR(11), Credits VARCHAR(4), Room_No INT(4) ) ____________________
Free
Multiple Choice
Answer:

Answer:

D

arrow
A _____________ is a column (or set of columns) whose value uniquely specifies a table record.
Free
Multiple Choice
Answer:

Answer:

B

arrow
A ____________ is a reference to a primary key in a linked table.
Free
Multiple Choice
Answer:

Answer:

A

arrow
Complete the following statement, which inserts rows into the following Course table. ____________________ VALUES ('CS221', 'Data Structures', '4', 'J. Jones') Course table img
Multiple Choice
Answer:
arrow
In the table below, the ____ correspond(s) to the attributes of a customer in the database. Customer table img
Multiple Choice
Answer:
arrow
In database terminology, a column (or combination of columns) that uniquely identifies a row in a table is called a(n) ____.
Multiple Choice
Answer:
arrow
Which of the following table attributes could be a unique identifier for a person?
Multiple Choice
Answer:
arrow
Which of the following statements is correct?
Multiple Choice
Answer:
arrow
Based on the customer table below, which of the attributes do you think represents the primary key? Customer table img
Multiple Choice
Answer:
arrow
Which of the following would be a good primary key for a Course table designed to hold course information for a university?
Multiple Choice
Answer:
arrow
In SQL, the _____________ command is used to issue queries.
Multiple Choice
Answer:
arrow
In SQL, the _____________ command is used to issue queries that do not modify the database.
Multiple Choice
Answer:
arrow
The outcome of a SQL query is a ____________________.
Multiple Choice
Answer:
arrow
A ____________ is a set of rows and columns that provides a "window" through which you can see some of the database data.
Multiple Choice
Answer:
arrow
Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________. Customer table img
Multiple Choice
Answer:
arrow
Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________. Customer table img
Multiple Choice
Answer:
arrow
Based on the table below, the query that finds the names and zip codes of all customers is _____________________. Customer table img
Multiple Choice
Answer:
arrow
Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________ Customer table img
Multiple Choice
Answer:
arrow
In SQL, ____ is used to test for equality.
Multiple Choice
Answer:
arrow
Based on the table below, which of the following statements will return the number of customers in Michigan (MI)? Customer table img
Multiple Choice
Answer:
Showing 1 - 20 of 75
Next Quiz