Which of the following is not one of the five SQL built-in functions?
A -
MODE
B -
SUM
C -
COUNT
D -
MAX
2-
Which of the following commands are correct for adding a foreign key.
A -
Add foreign key did to table employees;
B -
Insert did into table employees;
C -
Alter table employees add foreign key (did) references department(did);
D -
Create foreign key (did) references department;
3-
Which of the following features of SQL Server 2000 allows users to enter a query such as the
following: Which stores in the Northeast region have had sales of greater than $20,000?
A -
Natural Language Querying
B -
English Query
C -
Transact-SQL
D -
Analysis Services
4-
SQL stands for:
A -
Standard Query Language.
B -
Structural Question Language.
C -
Structured Query Language.
D -
Structured Question Language.
5-
Given the relations above such that each student is assigned to one advisor, which of the following is
true?
A -
SID is both a primary key and a foreign key.
B -
AdvisorName is a determinant.
C -
AdvisorID is a foreign key.
D -
Phone is a candidate key.
6-
Which of the following commands will return the list of product names sorted in ascending (tăng dần)
alphabetic order?
A -
SELECT ProductName FROM products ORDER BY ProductName DESC
B -
SELECT ProductName FROM products ORDER BY ProductName ASC
C -
SELECT ProductName FROM products SORTED BY ProductName ASC
D -
SELECT ProductName FROM products SORTED BY ProductName DESC
7-
Which of the following will return a list of every product ID currently listed in the
order_details table where each product ID is listed only once?
A -
SELECT DISTINCT ProductID FROM order_details
B -
SELECT ProductID FROM order_details ONLY ONCE
C -
SELECT ProductID FROM order_details
D -
SELECT UNIQUE ProductID FROM order_details
8-
Which of the following statement is true?
A -
EXISTS and NOT EXISTS are actually just another form of correlated subqueries.
B -
If a table meets the minimum definition of a relation, it has an effective or appropriate structure.
C -
A constraint, based on a business, that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.
D -
Multi-user databases are less complicated than single-user databases because the work is distributed to many people.
9-
Two tables are connected by a field. In one table the field is the primary key. What is the name of the
joined field in the other table?
A -
Foreign key
B -
Remote key
C -
Secondary key
D -
Election key
10-
The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of:
