违法和不良信息举报 联系客服
免费注册 登录

You are the DBA for an academic

题目

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

  • A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
  • B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
  • C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
  • D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
  • E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?()

A.DBA_USERS

B.DBA_OBJECTS

C.DBA_TS_QUOTAS

D.DBA_TAB_PRIVS


参考答案：B

第2题：

Even if you don’t actually carry out all the actions you say you will take, honest students will appreciate knowing that you care enough about academic ______ to take precautions.

A.entirety
B.integrity
C.unity
D.reliability

答案：B
解析：
A选项意为“完全，整体”；B选项意为“诚信，正直”；C选项意为“联合，统一”；D选项意为“可靠，可信赖”。题目意为“即使你不执行你所说的所有行动，诚实的学生也会知道你对学术_____足够重视，采取预防措施。”因此选B，学术诚信。
　　

第3题：

Which describes the default behavior when you create a table? ()

A. The table is accessible to all users.

B. Tables are created in the public schema.

C. Tables are created in your schema.

D. Tables are created in the DBA schema.

E. You must specify the schema when the table is created.


参考答案：C

第4题：

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

  • A、V$SESSION 
  • B、V$SYSSTAT 
  • C、DBA_SEGMENTS 
  • D、V$SORT_USAGE

正确答案:D

第5题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

  • A、 V$FLASHBACK_DATABASE_LOG
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$DATABASE
  • D、 V$UNDOSTAT

正确答案:A

第6题：

Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?()

A.DBA_TABLESPACES

B.DBA_TABLES

C.DBA_SEGMENTS

D.DBA_FREE_SPACE


参考答案：C

第7题：

You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）

  • A、 Only the Flashback Table
  • B、 Both the Flashback Transaction Query and the Flashback Version Query
  • C、 Only the Flashback Drop
  • D、 Only the Flashback Version

正确答案:B

第8题：

Other than academic success, what has been your greatest achievement up to date? What do you see as your personal strength, why?


正确答案：

 

 

第9题：

Which view will you use to view information regarding the jobs that are currently running in a database？（）

  • A、DBA_SCHEDULER_RUNNING_JOBS
  • B、DBA_SCHEDULER_JOB_RUN_DETAILS
  • C、DBA_SCHEDULER_JOBS
  • D、DBA_SCHEDULER_JOB_LOG

正确答案:A

第10题：

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）

  • A、An Automatic Workload Repository snapshot has been taken recently.
  • B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
  • C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
  • D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

正确答案:C

更多相关问题
相关内容