单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A GRANT SELECT ANY TRANSACTION TO ARRENB GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC GRANT SELECT_ANY_TRANSACTION TO ARREND GRANT FLASHBACK TO ARRENE GRANT SELECT ANY VIEW TO ARREN
单选题
A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）
A
GRANT SELECT ANY TRANSACTION TO ARREN
B
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
C
GRANT SELECT_ANY_TRANSACTION TO ARREN
D
GRANT FLASHBACK TO ARREN
E
GRANT SELECT ANY VIEW TO ARREN
参考解析
解析：
暂无解析
相关考题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? () A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment
SQL是 ______的缩写。A．Standard Query LanguageB．Structured Query LanguageC．Select Query LanguageD．以上都不是
SQL是那几个英文单词的缩写（）A、Standard Query LanguageB、Structured Query LanguageC、Select Query LanguageD、以上都不是
SQL是（）英文单词的缩写。A、Structured Query LanguageB、Standard Query LanguageC、Select Query LanguageD、以上都不是
A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）A、increase the size of redo log filesB、increase the size of the undo tablespaceC、increase the size of the Database Buffer CacheD、increase the size of the default temporary tablespaceE、enable the retention guarantee for the undo tablespace
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A、User processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
You have a computer named Computer1 that runs Windows 7. The computer is a member of an ActiveDirectory domain. The network contains a file server named Server1 that runs Windows Server 2008. Youlog on to the computer by using an account named User1. You need to ensure that when you connect toServer1, you authenticate by using an account named Admin1. What should you do on Computer1?（）A、From User Accounts， select Link online IDs.B、From Windows CardSpace， select Add a card.C、From Credential Manager， select Add a Windows credential.D、From Local Security Policy， modify the Access this computer from the network user right
Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). You create a new domain user account named User1 and assign the account a password of P@ssw0rd. On the new account, you enable the User must change password at next logon option. A week later, you discover that User1 is still using the password P@ssw0rd to log on to the domain. You need to ensure that User1 is forced to use a different password the next time she changes her password. What should you do first? （）A、In the Default Domain Policy, select Enforce password history.B、In the Default Domain Policy, select Passwords must meet complexity requirements.C、From the User’s account properties, select Account is sensitive and cannot be delegated.D、From the User’s account properties, select Store password using reversible encryption.
You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controllers run Windows Server 2003. The sales department recently hired 10 new employees. User accounts for these employees were created in Active Directory. The manager of the sales department sent you a list of a new users and asked you to add the user accounts to an existing global group named SalesDept. You need to add the users to the SalesDept global group. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Choose two.（）A、Use the dsadd user command to add the user accounts to the SalesDept global group.B、Use the dsadd group command to add the user accounts to the SalesDept global group.C、In Active Directory Users and Computers, select all 10 user accounts. Right-click the selected users, and then select the Properties menu command.D、In Active Directory Users and Computers, select all 10 user accounts. Right-click the selected users, and then select the Add to a Group menu command.
You create a Web server control named ContosoControls. You add a Web custom control named ContosoMailer to it. You then distribute the Web Control Library files to your team. You need to provide your team with the correct procedure for adding the Web Control Library to the items in the toolbox of Microsoft Visual Studio .NET. Which procedure should you provide to the team?（）A、Within the toolbox, click Choose Items and then browse to and select the ContosoControls user control.B、Within the toolbox, click Choose Items and then browse to and select the ContosoMailer user control.C、Right-click Web Project, click Add Reference, and then browse to and select the ContosoControls.dll file.D、Within the toolbox, click Choose Items and then browse to and select the ContosoControls.dll file.
You are the network administrator for The network consists of a single Active Directory domain named The functional level of the domain is Windows Server 2003. Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the password property to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort. First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords. What should you do next?（）A、Export the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.B、From the Results pane of the query, select all user accounts and modify their password properties simultaneously.C、Export the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.D、From the Results pane of the query, select each user account and modify the password property, one by one.
单选题You are the network administrator for your company. The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Terminal Server is installed on a member server named Server1, which is located in an organization unit (OU) named Servers. User of Server1 report unacceptable response times. To investigate, you start Task Manager on Server1. You discover that the average CPU usage is 80 percent. However, when you select the Processes tab, none of the processes show significant CPU usage. You need to identify the process that is responsible for the CPU usage. What should you do?（）AIn Task Manager, select the Show processes from all users option.BFrom a command prompt, run the query process command.COpen the Terminal Services Manager. Select Server1 from the list of servers, and then select the Processes tab.DEdit the Group policy object (GPO) for the Servers OU by adding your user account to the Profile a single process policy. Then use Task Manager to re-examine Server1.
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）A User processB Server processC System Monitor （SMON）D Process Monitor （PMON）E Checkpoint process （CKPT）
单选题Your network contains an Active Directory domain named contoso.com. The domain contains a server named Server1 that runs Windows Server 2012 R2 and has the Remote Access server role installed. A user named User1 must connect to the network remotely. The client computer of User1 requires Challenge Handshake Authentication Protocol （CHAP） for remote connections. CHAP is enabled on Server1. You need to ensure that User1 can connect to Server1 and authenticate to the domain. What should you do from Active Directory Users and Computers？（）AFrom the properties of Server1， select Trust this computer for delegation to any service （Kerberos only）.BFrom the properties of Server1， assign the Allowed to Authenticate permission to User1.CFrom the properties of User1， select Use Kerberos DES encryption types for this account.DFrom the properties of User1， select Store password using reversible encryption
单选题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 have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（ ）;You need to execute a method named Do Work（ ） that takes one second to run while the SQL query is executing. DoWork（ ） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）Awhile（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Bwhile（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Cwhile（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Dwhile（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
单选题You are the network administrator for your company. The network consists of a single Active Directorydomain. The functional level of the domain is Windows Server 2003.Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the passwordproperty to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort.First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords.What should you do next? （）AExport the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.BFrom the Results pane of the query, select all user accounts and modify their password properties simultaneously.CExport the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.DFrom the Results pane of the query, select each user account and modify the password property, one by one.
单选题You have an Organization 2010.Internal user named User1 sends a confidential message to another internal user named User2.User1 does not have any administrative privileges in theory. You need to ensure User1 can identify whether the message was successfully delivered？. What should you instruct User1 to do？（）AView the message headers in the sent item folderBOpen Microsoft Outlook and modify Read Receipt SettingsCOpen Microsoft Outlook and modify Delivery Receipt SettingsDOpen the ECP and select Organize E-Mail
单选题You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）AReplace the named query with an SQL view.BSet the transaction isolation level to serializable in the named query.CSet the source database to use snapshot isolation.DSet the transaction isolation level to repeatable read in the named query.
单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.