User A executes the following command to update the TRANS table） SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）A、The transaction for user A is rolled back.B、The ALTER TABLE command modifies the column successfully.C、The ALTER TABLE command fails due to the resource being busy.D、The ALTER TABLE command waits until user A ends the transaction.

考题 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.

查看答案

考题 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 creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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 creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD. The globalization environment that exists at the time of the job creation prevails at the job runs

查看答案

考题 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 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.MulticastB.DHCPC.APIPAD.Broadcast

查看答案

考题 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.

查看答案

考题 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、20B、25C、50D、55

查看答案

考题 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'

查看答案

考题 You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）A、 The batch operation started by the user， SCOTT， terminates with an error.B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

查看答案

考题单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A It contains only the plan for the SQL statement executed by the user.B It contains the SQL text executed by the user and the bind variables used with it.C It contains the plan and statistics associated with the SQL statement executed by the user.D It contains the plan for the SQL statement executed by the user and the bind variables used with it.

查看答案

考题多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.

查看答案

考题单选题Given: What is the result？（）A Compilation fails.B An exception is thrown at runtime.C The code executes and prints "running".D The code executes and prints "runningrunning".E The code executes and prints "runningrunningrunning".

查看答案

考题单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

查看答案

考题单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）A It contains only the plan for the SQL statement executed by the user.B It contains the SQL text executed by the user and the bind variables used with it.C It contains the plan and statistics associated with the SQL statement executed by the user.D It contains the plan for the SQL statement executed by the user and the bind variables used with it

查看答案

考题单选题A user reports that their laptop does not have network connectivity, but was working fine last week. The technician executes IPCONFIG to see what the IP address is but it comes up with a 169.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 MulticastB DHCPC APIPAD Broadcast

查看答案

考题多选题You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application uses the background worker process (BWP). When the user clicks a button, the background worker executes a method named DoCalculations asynchronously. You need to implement a progress bar on the user interface (UI) that informs the user of the progress of DoCalculations. Which two actions should you perform?（）AModify the Value property of the progress bar in DoCalculations.BModify the Value property of the progress bar in the ProgressChanged event handler of the background worker.CModify the Value property of the progress bar in the RunWorkerCompleted event handler of the background worker.DCall the ReportProgress method of the background worker in DoCalculations.ECall the ReportProgress method of the background worker in the DoWork event handler of the background worker.

查看答案

考题多选题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）AThe batch operation started by the user， SCOTT， terminates with an error.BThe batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

查看答案

考题单选题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'

查看答案

考题单选题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.

查看答案

考题单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）A ServiceGreatUser should be added to the appropriate fixed database roles. B You should assign the appropriate object-level permissions to ServiceGreatUser C You should assign the appropriate server-level permissions to ServiceGreatLogin D You should assign the appropriate database-level permissions to ServiceGreatUser

查看答案

考题单选题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.

查看答案

考题单选题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 modeC 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.

查看答案

考题单选题Given: What is the result?（）A Compilation fails.B An exception is thrown at runtime.C The code executes normally and prints "sleep".D The code executes normally, but nothing is printed.

查看答案

考题单选题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（）A The command fails because SCOTT still has privileges.B The command succeeds and privileges are revoked from JIM.C The command fails because HR cannot revoke the privileges from JIM.D The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

查看答案

考题单选题The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）A because of redo data from redo log fileB because of data from database buffer cacheC because of data from a temporary tablespaceD because of undo data from the undo tablespace

查看答案

考题单选题User A executes the following command to update the TRANS table） SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）A The transaction for user A is rolled back.B The ALTER TABLE command modifies the column successfully.C The ALTER TABLE command fails due to the resource being busy.D The ALTER TABLE command waits until user A ends the transaction.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：