单选题User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）AUPDATE pets…BSELECT….FROM petsCINSERT INTO pets…DALTER TABLE pets…
单选题
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）
A
UPDATE pets…
B
SELECT….FROM pets
C
INSERT INTO pets…
D
ALTER TABLE pets…
参考解析
解析：
暂无解析
相关考题：
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?() A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
Which two are correct steps in taking a binary backup of MyISAM tables?() A.Always stop the server prior to the backupB.Stop the server or lock the tables prior to the backupC.Stop the server or lock the databases prior to the backupD.Make a copy of the .frm, .myd, and the .myi filesE.Make a copy of the binary log and tablespace files
When adding a new user and assigning a role, which user role has "read only" rights to theconfiguration and operational states? () A.userB.read_onlyC.target_operatorD.security_operator
When adding a new user and assigning a role, which user role has "read only" rights to theconfiguration and operational states? （）A、userB、read_onlyC、target_operatorD、security_operator
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A、 PUBLIC should be replaced with specific usernames.B、 ALL should be replaced with a list of specific privileges.C、 WITH GRANT OPTION should be added to the statement.D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
Which two are correct steps in taking a binary backup of MyISAM tables?（）A、Always stop the server prior to the backupB、Stop the server or lock the tables prior to the backupC、Stop the server or lock the databases prior to the backupD、Make a copy of the .frm, .myd, and the .myi filesE、Make a copy of the binary log and tablespace files
At which command prompt would you issue the set date command?（）A、[edit chassis]user@router#B、[edit]user@router#C、[edit system] user@router#D、user@router
Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A、Applications A and B will cause a deadlock situationB、Application B will read the previous version of the rowC、Application B will read the row and see uncommitted changes made by application AD、Application B will be placed in a lock-wait state until application A releases its lock
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A、Application B will read the row.B、Applications A and B will cause a deadlock situation.C、Application B will wait until application A releases the Update lock.D、Application A will be terminated so that application B can read the row.
In a TCP/IP network， which of the following protocols is involved when a user issues a ping command？（）A、TCPB、UDPC、ICMPD、SMTP
Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）A、The SKD user cannot log in to the database instance.B、The objects owned by the SKD user are not accessible to any user.C、The other users can access the objects owned by the SKD user， on which they have access.D、The password for the SKD user expires and the user is forced to change the password at the next log in
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）A、No privileges.B、Only the SELECT privilege.C、Only the CONNECT privilege.D、All the privileges of a default user.
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）A、UPDATE pets…B、SELECT….FROM petsC、INSERT INTO pets…D、ALTER TABLE pets…
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external tables.
单选题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A–skip-networking, to prohibit access from remote locationsB–reset-grant-tables, to start the server with only the mysql database accessibleC–read-only,to set all data to read-only except for super usersD–old-passwords, to start Mysql to use the old password format while running without the grant tables
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）Ano privilegesBonly the SELECT privilegeConly the CONNECT privilegeDall the privileges of a default user
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
单选题The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A PUBLIC should be replaced with specific usernames.B ALL should be replaced with a list of specific privileges.C WITH GRANT OPTION should be added to the statement.D Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
单选题You execute the following command to audit database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）AOne audit record is created for every successful DROP TABLE command executed in the session of SCOTT.BOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.COne audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.EOne audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in
单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）AAcquire locks on table queried BGenerate redo for statement CFetch data from disk into memory DWrite changes to disk
多选题Which two are correct steps in taking a binary backup of MyISAM tables?（）AAlways stop the server prior to the backupBStop the server or lock the tables prior to the backupCStop the server or lock the databases prior to the backupDMake a copy of the .frm, .myd, and the .myi filesEMake a copy of the binary log and tablespace files
单选题One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）Aexecute the command， ALTER SESSION KILL ..， to kill the blocking sessionBexecute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionCexecute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionDexecute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionEexecute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim； Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）AThe command fails because SCOTT still has privileges.BThe command succeeds and privileges are revoked from JIM.CThe command fails because HR cannot revoke the privileges from JIM.DThe command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）ANo privileges.BOnly the SELECT privilege.COnly the CONNECT privilege.DAll the privileges of a default user.
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in.