单选题Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）A SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM

题目
单选题
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）
A

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

B

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

C

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

D

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

E

SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

相似考题

1.Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()A. ORDER BY SALARY > 5000B. GROUP BY SALARY > 5000C. HAVING SALARY > 5000D. WHERE SALARY > 5000

2.From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。A. UpdatingB. ViewingC. DeletingD. InsertingE. Truncating

3.The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()A. The SQL statement displays the desired results.B. The column in the WHERE clause should be changed to display the desired results.C. The operator in the WHERE clause should be changed to display the desired results.D. The WHERE clause should be changed to use an outer join to display the desired results.

4.Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()A. The SELECT statement is syntactically accurate.B. The SELECT statement does not work because there is no HAVING clause.C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Which SELECT statement should you use to extract the year fr”相关问题

  • 第1题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

    A.The SELECT statement is syntactically accurate.

    B.The SELECT statement does not work because there is no HAVING clause.

    C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    参考答案：A

  • 第2题：

    Which two are true about aggregate functions?（）

    • A、You can use aggregate functions in any clause of a SELECT statement.
    • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
    • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
    • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
    • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
    • F、You cannot group the rows of a table by more than one column while using aggregate functions.

    正确答案:A,E

  • 第3题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第4题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

    • A、You should use local Service account
    • B、You should use network Service account
    • C、You should use domain account
    • D、You should use local System account

    正确答案:C

  • 第5题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （） 

    • A、You should use the Database Engine Tuning Advisor tool 
    • B、You should use the Windows System Monitor tool 
    • C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 
    • D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

    正确答案:D

  • 第6题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第7题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

    • A、You should use row compression 
    • B、You should use page compression 
    • C、You should use backup compression 
    • D、You should use windows NTFS file system compression

    正确答案:B

  • 第8题：

    单选题
    You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?（）
    A

    You should use /63.

    B

    You should use /64.

    C

    You should use /61.

    D

    You should use /62.


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

  • 第9题：

    单选题
    Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）
    A

    SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

    B

    SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

    C

    SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

    D

    SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

    E

    SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;


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

  • 第10题：

    单选题
    Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
    A

    ORDER BY SALARY > 5000

    B

    GROUP BY SALARY > 5000

    C

    HAVING SALARY > 5000

    D

    WHERE SALARY > 5000


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

  • 第11题：

    问答题
    The extract below comes from an article which appeared in a magazine called Society Today. You read the extract and have strong feelings about its contents, and decide to write an article, in which you respond to the points made and express your own views.　　You should write the article in no fewer than 120 words. Now write your letter on the answer sheet.

    正确答案：
    The Influence of Popular CultureIt seems that image and appearance are attracting more and more attention in the modern world which is full of material desires. Some believe that it is the rise of popular culture including the media, sport and the fashion industry to blame. It is definitely true that this has somewhat brought about some shallow and egoistic people. However, we absolutely should not attribute this to the popular culture itself.
    Popular culture, opposite to exquisite culture, is easy to appreciate and comprehend and is oriented to the common people. Being popular does not mean emphasizing the appearance. The reason why they mislead some people is that they have developed a false concept in their mind. They believe anything popular must be presentational and only related to outer appearance.
    Whether the influence of popular culture is positive or negative depends on how people perceive and treat them. Properly used, they can instruct and entertain the public; on the contrary, they can also produce a generation of skin-deep people.
    解析： 暂无解析

  • 第12题：

    单选题
    The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）
    A

    The SQL statement displays the desired results.

    B

    The column in the WHERE clause should be changed to display the desired results.

    C

    The operator in the WHERE clause should be changed to display the desired results.

    D

    The WHERE clause should be changed to use an outer join to display the desired results.


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

  • 第13题：

    You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）

    • A、SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
    • B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
    • C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
    • D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
    • E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

    正确答案:C

  • 第14题：

    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

    • A、Updating
    • B、Viewing
    • C、Deleting
    • D、Inserting
    • E、Truncating

    正确答案:B,D

  • 第15题：

    Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）

    • A、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
    • B、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
    • C、SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
    • D、SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
    • E、SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

    正确答案:A

  • 第16题：

    You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

    • A、DBCC DBREINDEX
    • B、SELECT * FROM sys.dm_db_index_physical_stats
    • C、DBCC INDEXDEFRAG
    • D、SELECT * FROM sys.indexes

    正确答案:B

  • 第17题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

    • A、You should use database snapshots 
    • B、You should use database backup and restore 
    • C、You should use database backup and restore along with compression 
    • D、You should use schema-bound views in a read-only database. The database resides on the same instance.

    正确答案:A

  • 第18题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

    • A、You should use SQLServer:Buffer Manager
    • B、You should use SQLServer:Memory Manager 
    • C、You should use SQLServer:Databases 
    • D、You should use SQLServer:Access Methods

    正确答案:D

  • 第19题：

    You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?（）

    • A、You should use /63.
    • B、You should use /64.
    • C、You should use /61.
    • D、You should use /62.

    正确答案:B

  • 第20题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （）
    A

    You should use SQLServer:Buffer Manager

    B

    You should use SQLServer:Memory Manager 

    C

    You should use SQLServer:Databases 

    D

    You should use SQLServer:Access Methods


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

  • 第21题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


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

  • 第22题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （）
    A

    You should use local Service account

    B

    You should use network Service account

    C

    You should use domain account

    D

    You should use local System account


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

  • 第23题：

    单选题
    The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）
    A

    The SQL statement displays the desired results.

    B

    The column in the WHERE clause should be changed to display the desired results.

    C

    The operator in the WHERE clause should be changed to display the desired results.

    D

    The WHERE clause should be changed to use an outer join to display the desired results.


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

  • 第24题：

    多选题
    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
    A

    Updating

    B

    Viewing

    C

    Deleting

    D

    Inserting

    E

    Truncating


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

相关内容