花费 92ms 找到589370条记录
1 1z0-071 Oracle Database 12c SQL13 ON DELETE CASCADE选项
2018年06月15 - the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option. Which DELETE statement would execute successfully?A. DELETE
2 1z0-071 Oracle Database 12c SQL 第22 ON DELETE CASCADE语句
2018年06月05 - 07-6月 -18 A、B选项 SQL> DROP TABLE A; DROP TABLE A * 第 1 行出现错误: ORA-02449: 表中的唯一/主键被外键引用 C选项 SQL> DELETE A WHERE A_ID=102; 已删除 1 行
3 1z0-071 Oracle Database 12c SQL 第17 ERD(ER模型)
2018年06月15 - entities. B. The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships. C. STUDENT_ID
4 1z0-071 Oracle Database 12c SQL 第6 constraints约束
2018年06月13 - of a primary key. Correct Answer: CD 对于 A 选项,foreign key 可以包含 null 对于 C 选项,constaint 在 delete,update 的时候也会应用。 对于 E 选项,not null 不能在表级别定义,只能在列级别定义。
5 1z0-071 Oracle Database 12c SQL 第9 WITH TIES关键字
2018年06月14 - /row-limiting-clause-for-top-n-queries.html http://www.oratea.com/2017/02/10/oracle12c%E6%96%B0%E7%89%B9%E6%80%A7-%E5%88%86%E9%A1%B5%E6%9F%A5%E8%AF%A2top-n-sql/
6 1z0-071 Oracle Database 12c SQL 第4 DML操作
2018年06月13 - 数据,mysql可以。 B. An UPDATE… SET… 语句可以基于表上的多个条件修改多行。 正确,Oracle支持多条件更新多行。 C. A DELETE FROM….. 语句只能基于表上的单个条件删除行。 错误,还可以以多条件删除行数据,如选项E。 D. An INSERT
7 1z0-071 Oracle Database 12c SQL 第16 in和or语句
2018年06月15 - Q15. Evaluate the following two queries: SQL> SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit IN (1000, 2000
8 1z0-071 Oracle Database 12c SQL 第8 正则表达式
2018年06月14 - members who reside in states starting with the letter A followed by exactly one character. Which SQL statement must you execute? A. SELECT * FROM
9 1z0-071 Oracle Database 12c SQL 第7 when语句
2018年06月13 - clause. If the condition is true, then the row would be evaluated by the subsequentWHEN clauses. C. They are evaluated by the first WHEN clause.
10 1z0-071 Oracle Database 12c SQL 第3 external table外部表
2018年06月13 - for an external table are stored outside the database.C. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.D.

 
© 2014-2019 ITdaan.com 粤ICP备14056181号