当前位置:1Z0-007题库

问题:

[单选]

The EMP table has these columns:
ENAME VARCHAR2(35)
SALARY NUMBER(8,2)
HIRE_DATE DATE
Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? ()

A . SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B . SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C . SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D . SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5

In which file created by a mksysb would an administrator find filesystem and logical volume information?()  /fs.data。 /image.data。 /bosinst.data。 /install.data。 影响无形资产评估价值的因素()。 效益因素。 机会成本。 技术成熟因素。 市场供需状况。 A customer wants to deploy a new CRM application on an 8-way Intel-based server.  They plan to upgrade to a 16-way server six months later, because the CRM application will support a larger number of processors.  After the upgrade, they will need more I/O slots to support the SAN storage and LAN bandwidth requirements.  They are considering either the IBM x445 or the HPQ DL740/DL760G2.  Which TWO of the following choices are the key competitive advantages of the IBM x445?() x445 supports PCI-X adapters。 x445 can scale up to 16 processors。 x445 supports redundant power supplies。 x445 can expand I/O by adding the RXE-100。 x445 comes standard with systems management software。 You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database() 4 and 6。 2,3,4,and 6。 1,2,4,5,and 6。 1,2,3,4,5,and 6。 现代西方心理学流派中,最重视游戏问题的一个派别是() 经典学派。 认知发展学派。 社会文化历史学派。 精神分析学派。

The EMP table has these columns:
ENAME VARCHAR2(35)
SALARY NUMBER(8,2)
HIRE_DATE DATE
Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? ()

参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服