20151216 OCP 047 100-120meta character syntaxes and the

102.evaluate the dollowing command;

CREATE TABLE employees

( employee_id number(2) PRIMARY KEY,

last_name varchar2(25) not null,

department_id number(2),

job_id varchar2(8),

salary number(10,2));

you issue the dollowing command to create a view that dispays the IDs and last names of 

the sales staff in the organization

CREATE OR REPLACE VIEW sales_staff_vu AS SEKLECT employy_id,last_name,job_id

from employees where job like 'SA_%' with check option

which statements are true regarding the above view?

b.it allows you to delete the details of the existing sales from the employy table

删除一个视图上面的的记录会连带将对应表的记录删除

d.it allows you to insert the IDs,last names and job ids of the sales staff from the view if it is used in multitable insert statements

数据来自于视图而不是向视图内插如数据，这是允许的

104,the user SCOTT who is the owner ORDERS and ORDER_ITEMS tables issues the following GRANT command;

grant all

on orders,order_items to punlic;

what correction needs to be done to the above statement?

d.separate grant statements are required for ORDERS and ORDER_ITEM tables

对orders表和ORDER_ITEMS表的授权要使用单独的grant命令

106.which statement is true regarding the CUBE operator in the GROUP BY clause of as sql statement?

c.it produces 3 n possible superaggregate comninations,if the nclolumns and expressions are specified in the group by clauese

109.whch two statements are true regarding roles?

b.a role can be granted to public

public是oracle自带用户，指全部的用户

e.roles are named groups of related to remove privilages that can be granted to users or other roles

一组相关的权限被命名为角色，角色可以授予用户或是其他角色

112.view the exhibit and examine the details of the EMPLOYEES table

evalueate the following sql statements;

statement1

select employy_id,last_name,job_id ,manager_id from employees statrt with employy_id=101 connect by prior employy_id=manager_id nad manager_id!=108

statement2;

select employy_id,last_name,job_id,manager_id from employees where manager_id!=108

start with employyee_id=101

which two statemenrts are true regarding the above sql statements?

114.which statements are true?

a.the data dictionary is created and mainted by the database administartor

no,是被数据库服务器创建的而不是dba

b.the data dictionary views can consist of joins of fictionary base tables and user-defined tables.

不是由表组成，而是说数据字典总结了基础表的信息

c.the usernames of all the users including the database administrator are stored in the data dictioanry

数据字典存储用户名，对的、

d.the user_cons_columns view should be queried to find the names of the columns to which a constraint applies

对的，user_cons_columns view should be queried to find the names of the columns to which a constraint applies

此视图用来查询有约束应用于列的列名

e.both user_objects and cat views provide the same information

一看same就不对

f.views with the same name but different prefixes,succh  as DBAS,all and user,use the same ase tables from the data dictionary 

对的,dba和all表只比user表多了owner列，其他结构一直，内容随权限不同而不同，都是基于数据字典中同一张基础表之上

116.given below is the list of meta character syntaxes and their description in random oorder ;

meta character syntax

1.^ b.matches charactoer when is occurs at the begin ningof a list

2.【^....】 a.matches character when is occers at the beginning of a line

3.| d.matches one of the characters such as the OR operator

4./ c.treats the subsequent meta character as a literal

120.which two statements are true regarding constraints?

b.a column with the unique constraint can containt NULL

唯一键是可以为空的

d.a constraint can be disabled even if the constraint column containt data

废话啦，有数据当然也可以是索引失效