网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）
A
The set of statements contains an error and does not work.
B
It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
C
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
D
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
E
It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
F
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）A The set of statements contains an error and does not work.B It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.” 相关考题
考题
What is the outcome of this block of code?()
A. It creates a task and workload, and executes the task.B. It creates a task and workload but does not execute the task.C. It produces an error because a template has not been created.D. It produces an error because the SQL Tuning Set has not been created.
考题
You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
考题
Examine these statements:CREATE ROLE registrarGRANT UPDATE ON dtudent_grades TO registrar;GRANT registrar to user1, user2, user3;What does this set of SQL statements do? ()
A. The set of statements contains an error and does not work.B. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()
A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
Evaluate the set of SQL statements:What is true about the set?()
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.B. The ROLLBACK statement frees the storage space occupies by the DEPT table.C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
考题
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available SQL Tuning Set (STS) only D、SQL statements that are available in the cursor cache and executed by a user other than SYS
考题
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;
考题
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）A、The DESCRIBE DEPT statement displays the structure of the DEPT table.B、The ROLLBACK statement frees the storage space occupied by the DEPT table.C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
考题
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
考题
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the available SQL Tuning Set （STS） onlyD、 SQL statements that are available in the cursor cache and executed by a user other than SYS
考题
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A、 DBMS_WORKLOAD_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR
考题
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?（）A、The set of statements contains an error and does not work.B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
Your company has an Exchange Server 2010 organization. A user named User1 is configured as a Delegate for a user named User2. You need to ensure that User1 can add User2 in the From field when sending email messages. Messages that contain User2 in the From field must display User2 as the message sender when recipients receive the messages. What should you do（）？ A、Remove User1 as a delegate， and then grant User1 Send As permissions to User2¯s mailboxB、Remove User1 as a delegate， and then grant User1 Send on Behalf permissions to User2¯s mailboxC、Create a Sharing policy， and then grant User1 Modify permissions to User2¯s mailboxD、Create a Sharing policy， and then grant User1 Full Mailbox permissions to User2¯s mailbox
考题
单选题You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A
DBMS_WORKLOAD_REPOSITORYB
DBMS_RESOURCE_MANAGERC
DBMS_SQLTUNED
DBMS_ADVISOR
考题
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）A
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
考题
单选题A system administrator needs to specify a set of FQDN to IP address mappings for a legacyserver； the administrator does not want the legacy server to be referenced by other servers. Which of the following should the administrator use to set this？（）A
DHCP serverB
DNS serverC
Host fileD
Route statements
考题
单选题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;
考题
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A
The commands execute successfully.B
Command 6 produces an error because of circular role grant.C
Command 5 produces an error because a role cannot be granted to another role.D
Command 3 produces an error because the MGRROLE role already contains system privileges.E
The table created by HR remains and HR still has the CREATE TABLE system privilege.F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A
SQL statements that are part of the AWR baseline only B
SQL statements based on the AWR top SQL identificationC
SQL statements that are part of the available SQL Tuning Set (STS) only D
SQL statements that are available in the cursor cache and executed by a user other than SYS
考题
单选题Your company has an Exchange Server 2010 organization. A user named User1 is configured as a Delegate for a user named User2. You need to ensure that User1 can add User2 in the From field when sending email messages. Messages that contain User2 in the From field must display User2 as the message sender when recipients receive the messages. What should you do（）？A
Remove User1 as a delegate， and then grant User1 Send As permissions to User2¯s mailboxB
Remove User1 as a delegate， and then grant User1 Send on Behalf permissions to User2¯s mailboxC
Create a Sharing policy， and then grant User1 Modify permissions to User2¯s mailboxD
Create a Sharing policy， and then grant User1 Full Mailbox permissions to User2¯s mailbox
考题
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A
SQL statements that are part of the AWR baseline onlyB
SQL statements based on the AWR top SQL identificationC
SQL statements that are part of the available SQL Tuning Set （STS） onlyD
SQL statements that are available in the cursor cache and executed by a user other than SYS
考题
多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）A
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
考题
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A
The tablespace TBS1 is full.B
The user is not the owner of the SYSTEM tablespace.C
The user does not have quota on the TBS1 tablespace.D
The user does not have sufficient system privileges to create table in the TBS1 tablespace.E
The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
单选题Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）A
The database manager will rollback the transaction in both applications.B
The database manager will rollback the transaction in one of the two applications.C
Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D
Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
热门标签
最新试卷