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.
第1题:
A、1NF
B、2NF
C、3NF
D、BCNF
第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题:
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age >40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()
A.SORT BY age ASC, last_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name
第5题:
第6题:
下面的XML片断中结构完整的是()。
第7题:
Each machine in the internet is assigned a unique network address,called(),that is used to identify the machine for communication purposes
第8题:
下列字段名中,合法的有()
第9题:
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You 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? ()
第10题:
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;
第11题:
SORT BY age ASC, last_name
SORT BY age DESC, last_name
ORDER BY age DESC, last_name
ORDER BY age ASC, last_name
第12题:
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;
第13题:
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:CUST_ID NUMBER(4) NOT NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_ADDRESS VARCHAR2(150)CUST_PHONE VARCHAR2(20)Which SELECT statement accomplishes this task?()
A. SELECT* FROM customers;
B. SELECT name, address FROM customers;
C. SELECT id, name, address, phone FROM customers;
D. SELECT cust_name, cust_address FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第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题:
配置channel必须的参数 ()
A. name,listen address and listen port
B. name,multicastaddress,listen address and listen port
C. name, protocol, listen address, listen port
第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.
Atitle+first name
Btitle+title
Ctitle alone
Dfirst name+last name+title
第18题:
您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务()
第19题:
下面的文件正确吗?为什么?用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>
第20题:
Which three statements inserts a row into the table?()
第21题:
title+first name
title+title
title alone
first name+last name+title
第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题:
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',);