A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error：  SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal；  SELECT ename FROM emp W

题目

A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error：  SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal；  SELECT ename FROM emp WHERE deptno=10 ORDER BY sal  ERROR at line 1：  ORA-01157： cannot identify/lock data file  201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’  What is a possible reason？（）

  • A、 The tempfile belonging to the default temporary tablespace is missing.
  • B、 The database is opened in restricted mode， so queries are not allowed
  • C、 The default temporary tablespace required to execute the query is offline.
  • D、 The default temporary tablespace required to execute the query is dropped.
  • E、 The default temporary tablespace required to execute the query is read-only.
相似考题

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

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

3.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".

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

更多“A user executes ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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.

    正确答案:A,D

  • 第5题：

    多选题
    Which two statements are true regarding the execution of the correlated subqueries？（）
    A

    The nested query executes after the outer query returns the row.

    B

    The nested query executes first and then the outer query executes.

    C

    The outer query executes only once for the result returned by the inner query.

    D

    Each row returned by the outer query is evaluated for the results returned by the inner query.


    正确答案： A,D
    解析： 暂无解析

  • 第6题：

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


    正确答案： B
    解析： 暂无解析

  • 第7题：

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

    Multicast

    B

    DHCP

    C

    APIPA

    D

    Broadcast


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： E,D
    解析： 暂无解析

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


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

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


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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 file

    B

    because of data from database buffer cache

    C

    because of data from a temporary tablespace

    D

    because of undo data from the undo tablespace


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

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


    正确答案： B
    解析： 暂无解析

  • 第17题：

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


    正确答案： C
    解析： 暂无解析

  • 第18题：

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


    正确答案： D
    解析： 暂无解析

  • 第19题：

    多选题
    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?（）
    A

     Modify the Value property of the progress bar in DoCalculations.

    B

     Modify the Value property of the progress bar in the ProgressChanged event handler of the background worker.

    C

     Modify the Value property of the progress bar in the RunWorkerCompleted event handler of the background worker.

    D

     Call the ReportProgress method of the background worker in DoCalculations.

    E

     Call the ReportProgress method of the background worker in the DoWork event handler of the background worker.


    正确答案： A,C
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

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


    正确答案： D
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容