Hamster
Search
Open menu
熟悉傳統數據庫概念及 SQL
1. Each record in the products table has a product ID, a product name and a price. How to calculate the numbers of products whose prices are greater than $100?
A.
select sum(*) from products where price > 100;
B.
select total(*) from products for price > 100;
C.
select count(*) from products wehre price > 100;
D.
select total(*) from products if price > 100;
2. Which of the following is the best description for a database?
A.
A database directly contains some columns.
B.
A database directly contains some rows.
C.
A database directly contains some tables.
D.
A database directly contains some records.
3. Which of the following is a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways, without having to reorganize the table?
A.
Relational Database
B.
Array
C.
Splay Tree
D.
Venn Diagram
4. Which of the following may be a valid SQL statement?
A.
select * from students where name='paul' and age>20;
B.
select students if name='paul' && age>20;
C.
choose name, id from students if name='paul' && age>20;
D.
get students where name='paul' and age>20;
5. Which of the following may be a valid SQL statement?
A.
select students if name='paul' && age>20;
B.
select * from students where name='paul' and age>20;
C.
choose name, id from students if name='paul' && age>20;
D.
get students where name='paul' and age>20;
6. How to create a table?
A.
create table { id integer; name varchar(20)}
B.
create table ( id integer primary key, name varchar(20));
C.
class table { id: integer; name: String; }
D.
create table ( id integer primary key; name varchar(20));
7. In most databases, data are organized and stored in:
A.
table
B.
view
C.
plain text
D.
directory
8. In creating a database, this is the process of organizing it into tables in such a way that the results of using the database are always unambiguous.
A.
normalization
B.
probability
C.
virtual organization
D.
data modeling
9. Each record in the products table has a product ID, a product name and a price. How to double the prices of all products?
A.
update products by price = 2*price;
B.
update price = 2*price from products;
C.
update products set price = 2*price;
D.
update products price = 2*price;
10. Typically where is a database is stored?
A.
In the CPU.
B.
In memory.
C.
On a CDROM.
D.
On a Hard disk.