Hamster
Search
Open menu
熟悉傳統數據庫概念及 SQL
1. 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.
Dynamic Query Language (DQL)
C.
Structured Query Language (SQL)
D.
JAVA
2. Which of the following may be a valid SQL statement?
A.
get students where name='paul' and age>20;
B.
choose name, id from students if name='paul' && age>20;
C.
select * from students where name='paul' and age>20;
D.
select students if name='paul' && age>20;
3. Which of the following is suitable to use index?
A.
Many duplicate rows
B.
Table with many modifications but few actual queries
C.
Columns often be used in ORDER BY clause
D.
Table with few rows
4. 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));
5. Which of the following is not a many-to-many relationship?
A.
Customer and Restaurant
B.
Student and Teacher
C.
Patient and Doctor
D.
Husband and wife
6. 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.
Venn Diagram
D.
Splay Tree
7. Typically where is a database is stored?
A.
On a Hard disk.
B.
On a CDROM.
C.
In the CPU.
D.
In memory.
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)values (Select order_id,name,price from orders);
D.
Insert into sales(item_id,name,price)select order_id,name,price from orders;
9. Create an index when? (choose two)
A.
A column contains a wide range of values
B.
A column contains a large number of null values
C.
Most queries are expected to retrieve more than 2% to 4% of the rows in the table.
D.
The table is updated frequently
10. In most databases, data are organized and stored in:
A.
plain text
B.
directory
C.
table
D.
view