No privileges.
Only the SELECT privilege.
Only the CONNECT privilege.
All the privileges of a default user.
第1题:
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?()
A. The second user‘s session immediately produces the resource busy error.
B. The second user‘s command executes successfully.
C. The second user‘s session waits for a time period before producing the resource busy error.
D. A deadlock is created.
第2题:
Scott issues the SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13)};GRANT SELECTON DEPTT0 SUE;If Sue needs to select from Scott‘s DEPT table, which command should she use?()
A.SELECT*FROMDEPT;
B.SELECT*FROMSCOTT.DEPT;
C.SELECT*FROMDBASCOTTDEPT;
D.SELECT*FROMALL_USERSWHEREUSER_NAME=‘;SCOTT‘;ANDTABLENAME=‘;DEPT‘;;
第3题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
第4题:
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? ()
第5题:
SELECT*FROMDEPT;
SELECT*FROMSCOTT.DEPT;
SELECT*FROMDBASCOTTDEPT;
SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
第6题:
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.
第7题:
All the objects of scott are moved to the Recycle Bin.
Any objects in the Recycle Bin belonging to scott are purged.
All the objects owned by scott are permanently dropped from the database.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第8题:
The ALTER TABLE command modifies the column successfully.
The DDL operation gets higher priority and transaction for user a is rolled back.
The ALTER TABLE command waits indefinitely until user a ends the transaction.
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
第9题:
by using the DBMS_SESSION package
by granting the DBA role
by using the DBMS_RESOURCE_MANAGER package
by using the DBMS_RESOURCE_MANAGER_PRIVS package
第10题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第11题:
HR can grant the privilege to JIM but without GRANT OPTION.
HR can grant the privilege to JIM because HR is the owner of the view.
SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
第12题:
The transaction for user A is rolled back.
The ALTER TABLE command modifies the column successfully.
The ALTER TABLE command fails due to the resource being busy.
The ALTER TABLE command waits until user A ends the transaction.
第13题:
A. No privileges.
B. Only the SELECT privilege.
C. Only the CONNECT privilege.
D. All the privileges of a default user.
第14题:
The HR user creates a view with this command: SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp; Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?()
第15题:
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()
第16题:
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?()
第17题:
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user
第18题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第19题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第20题:
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
第21题:
The tablespace TBS1 is full.
The user is not the owner of the SYSTEM tablespace.
The user does not have quota on the TBS1 tablespace.
The user does not have sufficient system privileges to create table in the TBS1 tablespace.
The user does not have sufficient privileges to create table on the default permanent tablespace.
第22题:
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
One audit record is created for every session when any user successfully drops a table owned by SCOTT.
One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
第23题:
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.