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 regi

题目

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;
相似考题

1.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.

2.Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?()A.DBA_USERSB.DBA_OBJECTSC.DBA_TS_QUOTASD.DBA_TAB_PRIVS

3.Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?()A.DBA_TABLESPACESB.DBA_TABLESC.DBA_SEGMENTSD.DBA_FREE_SPACE

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

更多“You are the DBA for an academic ”相关问题

  • 第1题：

    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，学术诚信。
    　　

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

    • A、 INDEX_STATS
    • B、 DBA_INDEXES
    • C、 DBA_IND_COLUMNS
    • D、 V$OBJECT_USAGE

    正确答案:A

  • 第5题：

    You issued the following statement to monitor the usage of the index：        SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；   Which view will you query to ensure that the index is being monitored？（）  

    • A、 INDEX_STATS
    • B、 DBA_INDEXES
    • C、 DBA_IND_COLUMNS
    • D、 V$OBJECT_USAGE

    正确答案:D

  • 第6题：

    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

    • A、V$DATABASE 
    • B、DBA_TABLES 
    • C、SYSAUD$ 
    • D、EMP

    正确答案:B

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（）
    A

     INDEX_STATS

    B

     DBA_INDEXES

    C

     DBA_IND_COLUMNS

    D

     V$OBJECT_USAGE


    正确答案： B
    解析： 暂无解析

  • 第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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You issued the following statement to monitor the usage of the index：        SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；   Which view will you query to ensure that the index is being monitored？（）
    A

     INDEX_STATS

    B

     DBA_INDEXES

    C

     DBA_IND_COLUMNS

    D

     V$OBJECT_USAGE


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    What should you look at first to compute the number of undo blocks written per second to disk？ （）

    • A、V$UNDOSTAT
    • B、V$TRANSACTION
    • C、V$ROLLSTAT
    • D、DBA_UNDO_EXTENTS
    • E、DBA_ROLLBACK_SEGS

    正确答案:A

  • 第17题：

    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

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

    正确答案:C

  • 第18题：

    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

    • A、 DBA_PENDING_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第19题：

    单选题
    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
    A

    control file

    B

    password file

    C

    listener controller file

    D

    control file and password file


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）
    A

     DBA_SCHEDULER_JOB_RUN_DETAILS

    B

     DBA_SCHEDULER_RUNNING_JOBS

    C

     DBA_SCHEDULER_JOBS

    D

     DBA_SCHEDULER_JOB_LOG


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）
    A

    Assign the DEFAULT profile to the users

    B

    Set the RESOURCE_LIMIT parameter to TRUE in the parameter file

    C

    Create a new profile with CPU restrictions and assign it to the users

    D

    Specify the users as members of the DEFAULT_CONSUMER_GROUP

    E

    Revoke the DBA role and grant CONNECT and RESOURCE role to the users


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    As A DBA， which of the following methods can you use to make a backup of your table？（）
    A

    Recover Manager （RMAN） utility

    B

    Import utility

    C

    Export utility

    D

    O/S backup command


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
    A

     DBA_PENDING_TRANSACTIONS

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


    正确答案： D
    解析： 暂无解析

相关内容