单选题You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book.

题目
单选题
You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）
A

SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;

B

SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;

C

SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

D

SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

相似考题

1.2． —1 want to buy the book "Cold Mountain"． Do you know its _________?—Not really． Maybe three dollars．A． coverB． sizeC． colorD． price

2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

3.In which scenario would TOP N analysis be the best solution? ()A. You want to identify the most senior employee in the company.B. You want to find the manager supervising the largest number of employees.C. You want to identify the person who makes the highest salary for all employees.D. You want to rank the top three sales representatives who have sold the maximum number of products.

4.If you want to telephone him, you will have to _____ the number in this book.A.look upB.look throughC.look intoD.look at

更多“单选题You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. ”相关问题

  • 第1题：

    Receiving Visitors at the Airport

    Do you, sometimes, need to go to meet some visitors at the airport? What should you do when you meet them? What should you talk about? On their arrival, you should pay attention to the following points:

    Going up to meet the visitors

    Asking about their journey

    Helping with their luggage

    When going to the visitors and making introduction at the airport, you should remember that the person of less importance, regardless of gender, is introduced to the person of greater importance and the visitor is always more important than anyone in your organization. The introduction is usually followed by a brief and firm handshake.

    To break the ice, after introduction, you can ask about their journey, like: “Did you enjoy your journey?” , “How was your trip?” etc. If you want to be more friendly and helpful, you may offer to take the luggage.

    When you get to the hotel, accompany your visitors to the hotel front desk and help them with the check-in. After check-in, ask a bell boy to help carry the luggage.

    When your visitors have settled down, discuss the schedule with them to see if there might be any changes. If there are changes, don't forget to let the related persons know.

    1.When making introductions, the introduction is usually starting with a brief and firm handshake.

    2.In order to break the ice, you may ask visitors about their journey after the introduction.

    3.If you want to be more friendly and helpful, you'd better help carry the luggage.

    4.You should discuss the schedule with the visitors before they've settled down.

    5.It is not friendly to ask about the visitor's journey.


    参考答案：1.T 2.T 3.T 4.F 5.F

  • 第2题：

    In which three cases would you use the USING clause?()

    A.You want to create a nonequijoin.

    B.The tables to be joined have multiple NULL columns.

    C.The tables to be joined have columns of the same name and different data types.

    D.The tables to be joined have columns with the same name and compatible data types.

    E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


    参考答案：C, D, E

  • 第3题：

    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

    • A、The collection level for the AWR should be set to BASIC
    • B、The moving window size must be less than Undo Retention
    • C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
    • D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

    正确答案:D

  • 第4题：

    In which scenario would TOP N analysis be the best solution? （）

    • A、You want to identify the most senior employee in the company.
    • B、You want to find the manager supervising the largest number of employees.
    • C、You want to identify the person who makes the highest salary for all employees.
    • D、You want to rank the top three sales representatives who have sold the maximum number of products.

    正确答案:D

  • 第5题：

    In which case would you use a FULL OUTER JOIN?（）

    • A、Both tables have NULL values.
    • B、You want all unmatched data from one table.
    • C、You want all matched data from both tables.
    • D、You want all unmatched data from both tables.
    • E、One of the tables has more data than the other.
    • F、You want all matched and unmatched data from only one table.

    正确答案:D

  • 第6题：

    You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）

    • A、SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
    • B、SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
    • C、SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
    • D、SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

    正确答案:D

  • 第7题：

    单选题
    You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）
    A

    SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;

    B

    SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;

    C

    SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

    D

    SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    In which case would you use a FULL OUTER JOIN?（）
    A

    Both tables have NULL values.

    B

    You want all unmatched data from one table.

    C

    You want all matched data from both tables.

    D

    You want all unmatched data from both tables.

    E

    One of the tables has more data than the other.

    F

    You want all matched and unmatched data from only one table.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You are developing a product search page named Search.aspx for Web application that will be integrated into Certkiller .com's existing e-Commerce Web site. The Search.aspx page allows customers search for products that match specific criteria. Once a product is located, you want an image of the product to be displayed. You want to use an Image control to display the image. You want to configure the Image control to display a description of the image if the image cannot be displayed in the customer's Web browser. What should you do?（）
    A

     Set the ToolTip property of the Image control.

    B

     Set the ImageUrl property of the Image control.

    C

     Set the AlternateText property of the Image control.

    D

     Set the DescriptionUrl property of the Image control.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）
    A

    SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;

    B

    SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;

    C

    SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

    D

    SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
    A

    Use the DROP DATAFILE command.

    B

    Use the DROP TABLESPACE command.

    C

    Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

    D

    Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?（）
    A

    Page break before. 

    B

    Page break after. 

    C

    Page protect. 

    D

    Keep with anchoring object.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    You work as an application developer at Certkiller .com. You are currently in the process of creating a new application for Certkiller .com. You are required to read compressed data files that has been sent by Certkiller .com‘s sales offices.These data files are less than 4 GB in size, but was compressed without cyclic redundancy. You want to write a method that receives the compressed files and return the uncompressed data as a byte array.What should you do?（）

    A.

    B.

    C.

    D.


    参考答案：A

  • 第14题：

    Directions:You want to contribute to Project Hope by offering financial aid to a child in a remote area. Write a letter to the department concerned, asking them to help find a candidate. You should specify what kind of child you want to help and how you will carry out your plan.

    Write your letter with no less than 100 words. Write it on ANSWER SHEET 2. Do not sign your name at the end of the letter; use Li Ming instead. You do not need to write the address. (10 points)


    正确答案：

    　To Whom It May Concern,

    　　I am writing to ask you whether you could help me find a child in a remote area to whom I will offer my financial aid.

    　　The candidate should be a girl at age 10 to 12 who is deprived of the opportunity to continue her education because of poverty. Her previous score reports should prove her potential to be an outstanding student in the future.

    　　I would like to give the girl my financial support annually until she graduates from college. The money will cover her tuition fee and other expenses at school. Besides, I will correspond with her frequently so that she can seek advice whenever she needs.

    　　I am looking forward to your reply.

    　　Sincerely,

    　　Li Ming


  • 第15题：

    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

    • A、It would attempt to start the default listener
    • B、It would start the most recently created listener.
    • C、It would display an error with a message asking for the listener name to be specified.
    • D、It would show you a list of listeners and prompts for the listener name that you want to start.

    正确答案:A

  • 第16题：

    You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?（）

    • A、Page break before. 
    • B、Page break after. 
    • C、Page protect. 
    • D、Keep with anchoring object.

    正确答案:C

  • 第17题：

    You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）

    • A、SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
    • B、SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
    • C、SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
    • D、SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

    正确答案:D

  • 第18题：

    You are developing a product search page named Search.aspx for Web application that will be integrated into Certkiller .com's existing e-Commerce Web site. The Search.aspx page allows customers search for products that match specific criteria. Once a product is located, you want an image of the product to be displayed. You want to use an Image control to display the image. You want to configure the Image control to display a description of the image if the image cannot be displayed in the customer's Web browser. What should you do?（）

    • A、 Set the ToolTip property of the Image control.
    • B、 Set the ImageUrl property of the Image control.
    • C、 Set the AlternateText property of the Image control.
    • D、 Set the DescriptionUrl property of the Image control.

    正确答案:C

  • 第19题：

    单选题
    When you are firing a pyrotechnic distress signal，it should be aimed（）.
    A

    horizontally and directly abeam of your vessel

    B

    at the vessel whose attention you want to attract

    C

    into the wind

    D

    at greater than 60 degrees above the horizon


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    A

    If you want to return or exchange your purchase, you should do that as soon as possible.

    B

    Under any circumstances, you can exchange what you’ve bought.

    C

    Sometimes things on sale are not allowed to be exchanged.

    D

    While you are exchanging something, you should bring the receipt with you.


    正确答案： B
    解析：
    细节题。录音中提到“Sometimes things on sale are not allowed to be exchanged”，因此B项错误。故选B。
    【录音原文】
    W: Jack, I want to do some shopping this afternoon, but I know next to nothing about it in the States. Could you tell me something about it?
    M: Of course, Linda. First of all, you must be aware that there is not only a wide range of prices of goods in the States, but also a big difference in the quality of goods for sale. So my advice is: Don’t hurry. Visit various stores, examine the goods carefully and compare prices. In a word, explore and examine before you buy.
    W: But I’m afraid I can’t afford the-time,
    M: That’s true. So I’d suggest if you want to buy food, go to a nearby supermarket. There you will find all kinds of food, and prices are very reasonable.
    W: If I want to buy some odds and ends like household items?
    M: Then go and shop in some discount stores. These stores have nearly as great a variety of goods as department stores, but offer lower prices.
    W: When I read the newspaper, I often find ads for sales. Do you think the prices are really reduced?
    M: Well, in some cases, yes. Sales are an excellent opportunity to buy quality goods at reduced prices, but sometimes it’s just a deception. So be careful.
    W: Can I return or exchange my purchase if I find it defective?
    M: Yes, you can. But you should do that as soon as possible, say, within a week. And be sure to bring the receipt with you. Oh, there is an exception: Sometimes things on sale are not allowed to be exchanged. So you should be especially careful with those products.
    W: Thanks for all the useful information.
    Questions 1 to 3 are based on the conversation you have just heard.
    1. As the woman wants to do some shopping, what does the man suggest in the first place?
    2. According to the man, where is the best place to buy household items?
    3. Which of the following is NOT true?

  • 第22题：

    单选题
    You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）
    A

    Configure the Windows backup to backup the system partition.

    B

    Configure the Windows backup to backup the System State Data.

    C

    Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts.

    D

    Create a batch file to run rdisk.exe/s before the backup starts.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）
    A

    The collection level for the AWR should be set to BASIC

    B

    The moving window size must be less than Undo Retention

    C

    The moving window size should be greater than the Automatic Workload Repository (AWR) retention period

    D

    The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    Actually I bought my car quite a while before you bought yours, but yours seems ______ in condition than mine.
    A

    worse

    B

    worst

    C

    bad

    D

    badly


    正确答案： B
    解析：
    句意：实际上我的车买的比你的早，但似乎现在你的车况还不如我的呢。than是比较级的标志。

相关内容