Atitle+first name
Btitle+title
Ctitle alone
Dfirst name+last name+title
第1题:
A、1NF
B、2NF
C、3NF
D、4NF
第2题:
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? ()
A. CREATE INDEX NAME _IDX (first_name, last_name);
B. CREATE INDEX NAME _IDX (first_name, AND last_name)
C. CREATE INDEX NAME_IDX ON (First_name, last_name);
D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
第3题:
Each machine in the internet is assigned a unique network address,called(),that is used to identify the machine for communication purposes
A.MAC address
B.IP address
C.host address
D.domain name address
第4题:
配置channel必须的参数 ()
A. name,listen address and listen port
B. name,multicastaddress,listen address and listen port
C. name, protocol, listen address, listen port
第5题:
下面的XML片断中结构完整的是()。
第6题:
您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务()
第7题:
下面的文件正确吗?为什么?用IE和本章中的解析器验证你的结论。 mes.dtd <!ELEMENT message ANY> <!ELEMENT persion (name,age?,lxfs)> <!ELEMENT lxfs (#PCDATA,tel|email)*> <!ELEMENT name (first,last)> <!ATTLIST name sex (male|female) "male"> <!ELEMENT first %pc; > <!ELEMENT last %pc;> <!ELEMENT age %pc;> <!ELEMENT tel %pc;> <!ELEMENT email %pc;> <!ENTITY % pc “(#PCDATA)”> <!ELEMENT emergency EMPTY> <!ATTLIST emergency fire CDATA #FIXED "119" police CDATA #FIXED "110" hospital CDATA #FIXED "120" > mes.xml <?xml version="1.0" encoding="gb2312"?> <!DOCTYPE SYSTEM "mes.dtd"> <message> <persion> <name sex="男"> <first>li</first> <last>xiao</last> </name> <age>25</age> <lxfs> <tel>123456</tel> </lxfs> </persion> <persion> <name> <first>wang</first> <last>xiao</last> </name> <lxfs></lxfs> </persion> <emergency fire="120" police="110" /> </message>
第8题:
SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第9题:
INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
第10题:
SORT BY age ASC, last_name
SORT BY age DESC, last_name
ORDER BY age DESC, last_name
ORDER BY age ASC, last_name
第11题:
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
INSERT INTO employees VALUES ('1000','JOHN','NULL');
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
第12题:
CREATE INDEX NAME _IDX (first_name, last_name);
CREATE INDEX NAME _IDX (first_name, AND last_name)
CREATE INDEX NAME_IDX ON (First_name, last_name);
CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
CREATE INDEX NAME_IDX ON employees (First_name, last_name);
CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
第13题:
A、1NF
B、2NF
C、3NF
D、BCNF
第14题:
In(66)the strength of the carder signal is varied to represent binary 1 or 0.(67)is a system that can map a name to an address and conversely an address to an name.(68)is a three-way handshaking authentication protocol that it's packets are encapsulated in the point-to-point protocol.(69)is an approach that enables an ATM Switch to behave like a LAN switch.(70)is an guided media which is made of glass or plastic and transmits signals in the form. of light.
A.ASK
B.PSK
C.FSK
D.FDM
第15题:
Each machine in the ineternet is assigned a unique network address, called__(71)__,that is used to identify the machine for communication purposes.
A.MAC address
B.IP address
C.host address
D.domain name address
第16题:
第17题:
The way in which people address each other depends on their age, sex, social group and personal relationship. The English system of address forms frequently used includes first name, last name, title+last name, (), and kin term.
第18题:
Each machine in the internet is assigned a unique network address,called(),that is used to identify the machine for communication purposes
第19题:
title+first name
title+title
title alone
first name+last name+title
第20题:
INSERT INTO employees VALUES (NULL, 'John', 'smith');
INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');
INSERT INTO employees VALUES ('1000, 'John', 'smith');
INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
第21题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第22题:
SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第23题:
SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;