User A executes 

题目

User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table:SQL> DELETE FROM trans WHERE tr_type=’SL’; Which statement is true regarding the DELETE command()

  • A、It fails to delete the records because the records are locked in SHARE mode.
  • B、It deletes the rows successfully because the table is locked in SHARE mode
  • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
  • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

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


参考答案:C

第2题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command? ()(Choose two.)

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D. The globalization environment that exists at the time of the job creation prevails at the job runs


参考答案:B, C

第3题:

You use Microsoft .NET Framework 4 to create a Windows Forms client application.You write the following code segment.The application contains a form of type Form1 that contains a FormSettings object named frmSettings1.You need to maintain the user‘s form size preference each time the user executes the application.Which code segment should you use? ()

A.

B.

C.

D.


参考答案:D

第4题:

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?()

  • A、20
  • B、25
  • C、50
  • D、55

正确答案:D

第5题:

A user reports that their laptop does not have network connectivity, but was working fine lastweek. The technician executes IPCONFIG to see what the IP address is but it comes up with a169.254.254.1 address. This address is not part of the company‘s subnet.Which of the following MOST likely identifies this address type?()

A.Multicast

B.DHCP

C.APIPA

D.Broadcast


参考答案:C

第6题:

Given:What can be a result?()

A.Compilation fails.

B.An exception is thrown at runtime.

C.The code executes and prints "StartedComplete".

D.The code executes and prints "StartedComplete0123".

E.The code executes and prints "Started0123Complete".


参考答案:E

第7题:

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?()

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B. It fails and reports an error because the CONTAINER=ALL clause is not used.

C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.

E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.


参考答案:A

第8题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案:B, C

第9题:

Given this fragment in a servlet: 23.if(req.isUserInRole("Admin")) { 24.// do stuff 25.} And the following fragment from the related Java EE deployment descriptor: 812. 813.Admin 814.Administrator 815. 900. 901.Admin 902.Administrator 903. What is the result?()

  • A、Line 24 can never be reached.
  • B、The deployment descriptor is NOT valid.
  • C、If line 24 executes, the user’s role will be Admin.
  • D、If line 24 executes, the user’s role will be Administrator.
  • E、If line 24 executes the user’s role will NOT be predictable.

正确答案:D

第10题:

A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()

  • A、It deletes all binary log files, except 'mysql-in.010'
  • B、It deletes all binary log files up to and including 'mysql-bin.010'
  • C、It deletes all binary log files before 'mysql-bin.010'
  • D、It deletes all binary log files after 'mysql-bin.010'

正确答案:C

更多相关问题