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, user3B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D、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;
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;
相关考题：
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.
Other than academic success, what has been your greatest achievement up to date? What do you see as your personal strength, why?
Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?() A.DBA_USERSB.DBA_OBJECTSC.DBA_TS_QUOTASD.DBA_TAB_PRIVS
Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?() A.DBA_TABLESPACESB.DBA_TABLESC.DBA_SEGMENTSD.DBA_FREE_SPACE
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.entiretyB.integrityC.unityD.reliability
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 TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
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_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
Which view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
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
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.
You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
What should you look at first to compute the number of undo blocks written per second to disk？ （）A、V$UNDOSTATB、V$TRANSACTIONC、V$ROLLSTATD、DBA_UNDO_EXTENTSE、DBA_ROLLBACK_SEGS
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_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
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_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
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
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_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
单选题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_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT
单选题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？（）Acontrol fileBpassword fileClistener controller fileDcontrol file and password file
单选题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 TableB Both the Flashback Transaction Query and the Flashback Version QueryC Only the Flashback DropD Only the Flashback Version
单选题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_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
单选题You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE
单选题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？（）AAssign the DEFAULT profile to the usersBSet the RESOURCE_LIMIT parameter to TRUE in the parameter fileCCreate a new profile with CPU restrictions and assign it to the usersDSpecify the users as members of the DEFAULT_CONSUMER_GROUPERevoke the DBA role and grant CONNECT and RESOURCE role to the users
单选题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（）AAn Automatic Workload Repository snapshot has been taken recently.BThe non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.CThe threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.DThe threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
单选题As A DBA， which of the following methods can you use to make a backup of your table？（）ARecover Manager （RMAN） utilityBImport utilityCExport utilityDO/S backup command
单选题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_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE
单选题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？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
单选题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? （）ACREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3BCREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3CCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3DCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;ECREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
单选题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_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY