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

文章作者 100test 发表时间 2009:04:09 22:29:23
来源 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



相关文章


ORACLE认证相关问题与解答2Oracle认证考试
ORACLE认证相关问题与解答1Oracle认证考试
国外某公司的OracleDBA试题Oracle认证考试
OracleDBA面试题及参考答案Oracle认证考试
tk007v5.0中几道有争议的题Oracle认证考试
Oracle题库:032的27与127题Oracle认证考试
Oracle试题:032的144题Oracle认证考试
OracleDBA数据库结构试题选一Oracle认证考试
2008年Oracle认证考试详细介绍Oracle认证考试
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛