[单选]
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20)
SAL NUMBER
MGR_ID NUMBER
DEPARTMENT_ID NUMBER
You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:
EMPLOYEE_ID: Next value from the sequence
EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables
SAL: 2000
MGR_ID: No value
DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50.
Which INSERT statement meets the above requirements?（）

A . INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
B . INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did IN (20,50));
C . INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
D . INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
E . INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did)

You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB（） choosing the extent allocation type to uniform。 choosing the Segment Space Management option to manual。 setting autoextension on for the data file mentioned for the tablespace。 setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value。测量电池单体电压时数据必须精确到（）小数点后二位。小数点后四位。小数点后一位。小数点后三位。因火灾一个易熔塞溶化时，会发生哪种情况（）只关闭全部井的井口安全阀（SSV）。关闭部分井的井口安全阀（SSV）和井底安全阀（SSSV）。只关闭部分井底安全阀。 An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（） Gtid_mode must be set to AUTO during point in time recoveries。 Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs。 The server keeps track of which GTIDs have already been executed and skips those。 Enforce_gtid_consistency is set to ON。 In which scenario will you use the Flashback Transaction Query feature？（） when you want to restore an important table that is dropped from the Recycle Bin。 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction。 when you want to restore a dropped user’s schema。 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period。

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20)
SAL NUMBER
MGR_ID NUMBER
DEPARTMENT_ID NUMBER
You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:
EMPLOYEE_ID: Next value from the sequence
EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables
SAL: 2000
MGR_ID: No value
DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50.
Which INSERT statement meets the above requirements?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: