更多"Which declaration preve"的相关试题:
[单项选择] Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
[单项选择] A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?()
A. INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
B. INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
C. INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
D. INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)
[多项选择]Creat Recovery media创建抢救介质,可以创建哪些介质()
A. 创建CD挽救介质
B. 创建USB硬盘抢救介质
C. 创建产品恢复光盘
D. 创建产品恢复USB硬盘
[单项选择]用户可以通过Creat Recovery media创建出几套恢复光盘()
A. 1
B. 2
C. 3
D. 无数次
[单项选择]每个系统的Creat Recovery media可以创建几套挽救介质()
A. 1
B. 2
C. 3
D. 多次
[单项选择]每个系统的Creat Recovery media可以创建几套Product Recovery恢复光盘()
A. 4
B. 2
C. 1
D. 3
[单项选择]Which declaration prevents creating a subclass of an outer class?()
A. Static class FooBar{}
B. Private class FooBar{}
C. Abstract public class FooBar{}
D. Final public class FooBar{}
E. Final abstract class FooBar{}
[单项选择] The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoyminterval(1,’month’)) (partition p0 values less than (to_date(’01-01-2005’,’dd-mm-yyyy’)), partition p1 values less than (to_date(’01-01-2006’,’dd-mm-yyyy’))); The following data has been inserted into the INV_HISTORY table : INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command: SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)), FOR(TO_DATE(’15-apr-2006’)) INTO PARTITION sys_py; What would be the outcome of this command?()
A. It executes successfully,and the transition point is set to ’1-apr-2006’.
B. It executes successfully,and the transition point is set to ’15-apr-2006’.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values stored in the table.
[单项选择]
设有关系模式:student(sno, sname, age, dept),现利用命令:
CREATE VIEW stu AS SELECT *FROM student WHERE dept="cs"WITH CHECK OPTION
创建了一个视图。则以下SQl命令中能正确执行的是()。
A. UPDATE stu SET dept="maths"
B. UPDATE stu SET dept="maths"WHERE age>=20
C. INSERT INTO stu VALUES ("2004001", "John", 30, "cs")
D. INSERT INTO stu VALUES ("2004001", "John", 50, "maths")
[单项选择] A new LPAR has been created that needs SAN attached disk for a database. After AIX has been installed, the fibre cables are attached to the adapters. How should the administrator configure the disks?()
A. Run ’mkdev’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
B. Run ’mkpath’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
C. Run ’chpath’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
D. Run ’cfgmgr’ to force the FC adapter to log into the SAN, have the SAN LUNs zoned to the server, run ’cfgmgr’ to discover and configure the disks.
[单项选择]A service profile is created using vHBAs. What will happen if the profile is applied to a server with amezzanine card without storage capability?()
A. The blade association will fail
B. The storage adapter will not be visible to the OS
C. A virtual storage adapter will be created
D. A WWNN/WWPN will be auto-selected from the default pool
[判断题]下载变桨程序时,creat bootproject并不是必须的步骤,仅是为了以防万一。
[单项选择]下列的SQL语句中,属于数据控制语句的是______。 1.CREAT 2.SELECT 3.UPDATE 4.GRANT 5.DROP 6.DELETE 7.ALTER 8.INSERT 9.REVOKE
A. 1,5,6,7
B. 4,9
C. 2,3.6,8
D. 1,5,7