UPDATE pets…
SELECT….FROM pets
INSERT INTO pets…
ALTER TABLE pets…
第1题：
PETS法
第2题：
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
第3题：
Leading a dog’s life in America isn’t such a bad thing. Many grocery stores sell pet foods to owners eager to please their pets. In Houston, Texas, dogs can have their dinner delivered to their homes, just like pizza. Well-to-do canines can attend doggy daycare centers while their owners work. Pets can even accompany their owners on vacation. Fancy hotels are beginning to accommodate both man and beast. Furry guests in hotels can enjoy gourmet meals served on fine china and sleep in soft beds.
Beneath the furry luxuries, there lies a basic American belief: Pets have a right to be treated well. At least 75 animal welfare organizations exist in America. These provide care and adoption services for homeless and abused animals. Vets can give animals an incredible level of medical care for an incredible price. To pay for the high-tech health care, people can buy health insurance for their pets. And when it’s time to say good -bye, owners can bury their pets in a respectable pet cemetery.
The average American enjoys having pets around, and for good reason. Researchers have discovered that interacting with animals lowers a person’s blood pressure. Dogs can offer protection from burglars and unwelcome visitors. Cats can help rid the home of unwanted pests. Little creatures of all shapes and sizes can provide companionship and love. In many cases, having a pet prepares a young couple for the responsibilities of parenthood. Pets even encourage social relationships: They give their owners an appearance of friendliness, and they provide a good topic of conversation.
Pets are as basic to American culture as hot dogs or apple pies. To Americans, pets are not just property, but a part of the family. After all, pets are people, too.
(1)The word “please” in paragraph 1 line 2 means ().
A、to make somebody glad
B、to make somebody unhappy
C、to invite somebody
D、to treat somebody badly
(2)The topic sentence in paragraph 2 is ().
A、At least 75 animal welfare organizations exist in America
B、Vets can give animals an incredible level of medical care for an incredible price
C、To pay for the high-tech health care, people can buy health insurance for their pets
D、Beneath the furry luxuries, there lies a basic American belief: Pets have a right to be treated well
(3)“When it’s time to say good-bye” in paragraph 2 line 5 means ().
A、when the pet says “good-bye” to the host
B、when the host says “good-bye” to the pet
C、when the pet dies
D、when the pet has to leave
(4)Paragraph 3 mainly tells us ().
A、every American enjoys having pets
B、having pets can do people something good
C、dogs and cats are people’s good friends
D、pets do not encourage social relationships
(5)The author writes the last paragraph to show ().
A、pets are the same as hot dogs and apple pies
B、pets are people
C、pets are just property
D、pets are important
第4题：
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）
第5题：
One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）
第6题：
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）
第7题：
You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
第8题：
清使用VC6或使用【答题】菜单打开考生文件夹projl下的工程projl，此工程中包含了类Pets(“宠物”) 和主函数main的定义。程序中位于每个“//ERROR****found ****”之后的一行语句有错误，请加以改 正。改正后程序的输出结果应为： Name：sonny Type：dog Name：John Type：dog Name：Danny Typc：cat Name：John Type：dog 注意：只修改每个“//ERROR ****found ****”下的那一行，不要改动程序中的其他内容。 include<iostream> using namespace sm； enum Pets_type{d09，cat，bird，fish}； class Pets{ private： char *name； Pets_type type； public： Pets(const char *name=”sonny”，Pets_type type=dog)； Pets&operator=(const Pets&s)； ～Pets； void showeonst；}； Pets：：Pets(eonst char$naIne，Pets_type type) //构造函数 { This ->name=new char[strlen(name)+1]； strcpy(this一>name，name)； //ERROR *********found********* type=type； }{ Pets：：～Pets//析构函数，释放name所指向的字符串 { //ERROR *********found********* name=’/0‘； } Pets&Pets：：0perator=(const Pets&s){ if(&s==this)//确保不要向自身赋值 return *this； delete[]name； name=new char[strlen(S．name)+1]；//ERROR *********found********* strcpy(this一>nmne，name)； type=S．type： return *this；} void Pets：：showconst cout<<“Name：”<<name<<”Type：”： Pets mypetl，mypet2(’’John”，dog)；
第9题：
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
第10题：
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）