当前位置:1Z0-007题库

问题:

[单选]

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2 (60)
Which DELETE statement is valid?()

A . DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B . DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C . DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
D . DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey')

The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?() The Oracle database will perform block checking for the index blocks only。 The Oracle database will not perform block checking for any of the data blocks。 The Oracle database will perform block checking for the default permanent tablespace only。 The Oracle database will perform block checking for the data blocks in all user tablespaces。 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only。 以下哪项不属于信用信息查询内容中的提示信息内容?() 企业因违规行为受到警告、罚款和暂扣证照等行政处罚的。 企业被责令停产停业或在两年内因同一类违法行为受到行政处罚的。 企业未通过法定的专项或者周期性检查的。 企业违反行业自律公约受到通报批评警告的。 Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()    SQL Access Advisor recommendations are automatically implemented.。  Individual SQL Access Advisor recommendations can be scheduled for implementation.。  All SQL Access Advisor recommendations for a specific task must be implemented at the same time.。  SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.。  None of the above.。 可不进行施工招标的情形有()。 采购人依法能够自行建设的项目。 需要采用不可替代的专利技术的项目。 关系公众安全的项目。 使用外国政府贷款的项目。 需要向原中标人采购工程,否则将影响施工或者功能配套要求的项目。 A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?() The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql。 The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function。 For tables with UNIQUE keys, statement-based replication must be used maintain integrity。 The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite。 The applications have the SUPER privilege, which allows them to update row。

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2 (60)
Which DELETE statement is valid?()

参考答案:

  参考解析

本题暂无解析

在线 客服