Which two statements cause changes to the data dictionary? A) DELETE FROM scott. emp; B) GRANT UPDATE ON scott. emp TO fin manager; C) AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY'; D) TRUNCATE ...

Which two statements are true about * TABLES views? A) You must have SELECT privileges on a table to view it in ALL TABLES. B) You must have SELECT privileges on a table to view it in DBA TABLES. C) ...

Which two statements are true about * TABLES views? A) You must have SELECT privileges on a table to view it in ALL TABLES. B) You must have SELECT privileges on a table to view it in DBA TABLES. C) ...

Examine this query which executes successfully: SELECT job, deptno FROM emp UNION ALL SELECT job, deptno FROM jobs_ history; What will be the result? A) It will return rows common to both SELECT state ...

Which three items does a direction of a relationship contain? A) an attribute B) a cardinality C) label D) an optionality E) a unique identifier F) an entity **** 本内容被作者隐藏 **** ...

Examine the description of the PRODCTS table which contains data: Name Null? Type ---------------------------------------------- PROD ID NOT NULL ...

Which two queries return the string Hello! we're ready? A) SELECT q'! Hello! We're ready! 'FROM DUAL; B) SELECT "Hello! We're ready "FROM |DUAL; C) SELECT q'[Hello! We're ready]'FROM DUAL; D) SELECT ' ...

Examine this description of the EMP table: Name Null? Type EMPNO NOT NULL NUMBER (4) ENAME VARCHAR2 (10) SAL ...