网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）
A
The tablespace TBS1 is full.
B
The user is not the owner of the SYSTEM tablespace.
C
The user does not have quota on the TBS1 tablespace.
D
The user does not have sufficient system privileges to create table in the TBS1 tablespace.
E
The user does not have sufficient privileges to create table on the default permanent tablespace.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A The tablespace TBS1 is full.B The user is not the owner of the SYSTEM tablespace.C The user does not have quota on the TBS1 tablespace.D The user does not have sufficient system privileges to create table in the TBS1 tablespace.E The user does not have sufficient privileges to create table on the default permanent tablespace.” 相关考题
考题
You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'You need to be able to access the folder. What must you do?A．Allow write permission on WebReports.B．Allow directory browsing permissions on WebReports.C．In the IIS console, enable anonymous access to WebReports.D．In the IIS console, set the execute permissions option to script. and executables on WebReports.
考题
The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）A. ARCHIVELOG mode must be enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately
考题
You would like to configure a fractional T1 interface on a channelized T3 controller with the following properties:Which set of configuration commands accomplishes this goal?()
A.AB.BC.CD.D
考题
You would like to configure a channelized OC3 interface with the following properties:Which set of configuration commands accomplishes this goal?()
A.AB.BC.CD.D
考题
You would like to configure an Ethernet interface with the following characteristics:Which set of configuration commands accurately completes this task?()
A.AB.BC.CD.D
考题
You are working as an administrator at TestKing, and you need to set the bandwidth of your routers serial port to 56K. Which of the following commands would you use?()
A. Bandwidth 56000B. Bandwidth 56000000C. Bandwidth 56D. Bandwidth 56kbps
考题
You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application. The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do？（）A、Create a custom action and set the NoImpersonate property to trueB、Create a custom action and set the NoImpersonate property to falseC、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvokerD、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator
考题
You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
考题
You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application.The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do？（）A、Create a custom action and set the NoImpersonate property to trueB、Create a custom action and set the NoImpersonate property to falseC、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvoker.D、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator.
考题
You are working as an administrator at TestKing, and you need to set the bandwidth of your routers serial port to 56K. Which of the following commands would you use?（）A、Bandwidth 56000B、Bandwidth 56000000C、Bandwidth 56D、Bandwidth 56kbps
考题
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）A、Create the CREATE_TEST procedure with definer’s rights.B、Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.C、Create the CREATE_TEST procedure with invoker’s rights.D、Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
考题
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？ （）A、 The statement will not execute successfully.B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.
考题
In a Server Core Installation of Windows Server 2012 R2，which of the following commands should you use to create a 3-TB volume on a 3-TB MBR hard disk？（）A、diskpart create volumeB、diskpart convert gptC、diskpart extend sizeD、diskpart formatE、diskpart gpt attributes
考题
ertkiller .com has purchased laptop computers that will be used to connect to a wireless network. You create a laptop organizational unit and create a Group Policy Object （GPO） and configure user profiles by utilizing the names of approved wireless networks. You link the GPO to the laptop organizational unit. The new laptop users complain to you that they cannot connect to a wireless network. What should you do to enforce the group policy wireless settings to the laptop computers（）A、Execute gpupdate/target：computer command at the command prompt on laptop computersB、Execute Add a network command and leave the SSID （service set identifier） blankC、Execute gpupdate/boot command at the command prompt on laptops computersD、Connect each laptop computer to a wired network and log off the laptop computer and then login again.E、None of the above
考题
单选题To generate recommendations to improve the performance of a set of SQL queries in an application， you execute the following blocks of code： BEGIN dbms_advisor.create_task（dbms_advisor.sqlaccess_advisor，’TASK1’）； END； / BEGIN dbms_advisor.set_task_parameter（’TASK1’，’ANALYSIS_SCOPE’，’ALL’）； dbms_advisor.set_task_parameter（’TASK1’，’MODE’，’COMPREHENSIVE’）； END； / BEGIN dbms_advisor.execute_task（’TASK1’）； dbms_output.put_line（dbms_advisor.get_task_script（’TASK1’））； END； / The blocks of code execute successfully；however，you do not get the required outcome. What could be the reason？（）A
A template needs to be associated with the task.B
A workload needs to be associated with the task.C
The partial or complete workload scope needs to be associated with the task.D
The type of structures （indexes， materialized views， or partitions） to be recommended need to be specified for the task.
考题
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）A
Start the server with the – innodb_recover_options option set to FORCEB
Start the server with the – innodb_force_recovery option set to a non-zero valueC
Start the server as usual, and then execute the REPAIR TABLE commandD
Start the server as usual, and then execute the CHECK TABLE command
考题
单选题In a Server Core Installation of Windows Server 2012 R2，which of the following commands should you use to create a 3-TB volume on a 3-TB MBR hard disk？（）A
diskpart create volumeB
diskpart convert gptC
diskpart extend sizeD
diskpart formatE
diskpart gpt attributes
考题
单选题You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A
The statistics are stored in the pending statistics table in the data dictionary.B
The statistics are treated as the current statistics by the optimizer for all sessions.C
The statistics are treated as the current statistics by the optimizer for the current sessions only.D
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
单选题Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）A
Only 1B
Only 2C
Only 3D
3 and 1E
1 and 2
考题
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
考题
单选题You would like to configure a fractional T1 interface on a channelized T3 controller with the following properties: Which set of configuration commands accomplishes this goal?（）A
AB
BC
CD
D
考题
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）A
Create the CREATE_TEST procedure with definer’s rights.B
Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.C
Create the CREATE_TEST procedure with invoker’s rights.D
Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
考题
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B
STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D
STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
单选题You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A
Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B
Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C
Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D
Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
热门标签
最新试卷
