tk007v5.0中几道有争议的题Oracle认证考试

文章作者 100test 发表时间 2009:04:29 22:02:26
来源 100Test.Com百考试题网

47.which tow statements accurately describe a role?(choose two)
a. a role can be given to a maximum of 1000 users.
b. a user can have access to a maximum of 10 roles.
c. a role can have a maximum of 100 privileges contained in it.
d. privileges are given to a role by using the create role statement.
e. a role is a named group of privileges that can be granted to the user.
f. a user can have access to serveral roles,and sereral users can be assigned the same role.
answer: d,f

68.which tow are attributes of sql*plus(choose tow)
a.sql*plus commands cannot be abbreviated.
b.sql*plus commands are accesses from browser.
c.sql*plus commands are used to manipulate data in tables.
d.sql*plus manipulate table definitions in the database.
e.sql*plus is the oracle proprietary interface for executing sql statements.
answer:c,d

43.which two statements about subqueries are true? (choose two.)
a. a single row subquery can retrieve data from only one table.
b. a sql query statement cannot display data from table b that is referred to in its
subquery, unless table b is included in the main query’s from clause.
c. a sql query statement can display data from table b that is referred to in its
subquery, without including table b in its own from clause.
d. a single row subquery can retrieve data from more than one table.
e. a single row subquery cannot be used in a condition where the like operator is used
for comparison.
f. a multiple-row subquery cannot be used in a condition where the like operator is
used for comparison.
tk的答案是b,d

question no: 73
when should you create a role? (choose two)
a. to simplify the process of creating new users using the create user xxx
identified by yyy statement.
b. to grant a group of related privileges to a user.
c. when the number of people using the database is very high.
d. to simplify the process of granting and revoking privileges.
e. to simplify profile maintenance for a user who is constantly traveling.
answer: c, d

99.which three are true regarding the user of outer joins?(choose three)
a.you cannot use in operator in a condition that involves an outerjoin.
b.you use( ) on both sides of the where condition to perferm an outerjoin.
c.you use(*) on both sides of the where condition to perferm an outerjoin.
d.you use an outerjoin to see only the rows that do not meet the join condition.
e.in the where condotion,you user( ) following the name of the column in the table without matching rows,to perform an outerjoin.
f.you cannot link a condition that is involved in an outerjoin to another condition by using the or operator.
answer: d , e, f

question no: 74
which three statements about subqueries are true? (choose three)
a. a single row subquery can retrieve only one column and one row.
b. a single row subquery can retrieve only one row but many columns.
c. a multiple row subquery can retrieve multiple rows and multiple columns.
d. a multiple row subquery can be compared by using the “>.” operator.
e. a single row subquery can use the in operator.
f. a multiple row subquery can use the “=” operator.
answer: b, c, d