网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ 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 allowedC、 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.” 相关考题
考题
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.
热门标签
最新试卷