Hamster
Search
Open menu
熟悉傳統數據庫概念及 SQL
1. Typically where is a database is stored?
A.
In memory.
B.
In the CPU.
C.
On a CDROM.
D.
On a Hard disk.
2. Which of the following is suitable to use index?
A.
Columns often be used in ORDER BY clause
B.
Table with many modifications but few actual queries
C.
Table with few rows
D.
Many duplicate rows
3. Which of the following may be a valid SQL statement?
A.
select students if name='paul' && age>20;
B.
choose name, id from students if name='paul' && age>20;
C.
select * from students where name='paul' and age>20;
D.
get students where name='paul' and age>20;
4. In most databases, data are organized and stored in:
A.
view
B.
table
C.
directory
D.
plain text
5. 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 count(*) from products wehre price > 100;
B.
select total(*) from products if price > 100;
C.
select total(*) from products for price > 100;
D.
select sum(*) from products where price > 100;
6. Which of the following is a standard interactive and programming language for getting information from and updating a database?
A.
National Query Language (NQL)
B.
Structured Query Language (SQL)
C.
Dynamic Query Language (DQL)
D.
JAVA
7. 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.
Array
B.
Relational Database
C.
Venn Diagram
D.
Splay Tree
8. Which of the following SQL statements is the correct one to copy rows from another tables?
A.
Insert into sales(item_id,name,price)on select order_id,mane ,price from orders;
B.
Insert into sales(item_id,name,price)as select order_id,name,price from order;
C.
Insert into sales(item_id,name,price)select order_id,name,price from orders;
D.
Insert into sales(item_id,name,price)values (Select order_id,name,price from orders);
9. Each record in the products table has a product ID and a product name. How to list the products sorted by their names?
A.
select * from products order by name
B.
select from products sorted by name
C.
sort products by name
D.
select products by name
10. Which of the following is the best description for a database?
A.
A database directly contains some records.
B.
A database directly contains some tables.
C.
A database directly contains some columns.
D.
A database directly contains some rows.