搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files

B、dropping a user in your database

C、enabling or disabling redo log archiving

D、dropping a tablespace in your database

E、re-creating the control files， after you lost all the control files in your database

查看正确答案
更多“You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）”相关的问题
第1题
[单选题] 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 DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at th

A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.   B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.   C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header   D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.  

点击查看答案
第2题
[单选题] Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

A、Schedule the report's execution in the queue manager.   B、Schedule the reports execution using the R30RQM command line with scheduled parameter.   C、Create a trigger in the application to execute the report every six hours.   D、You cannot schedule a reports execution.  

点击查看答案
第3题
[单选题] You are designing a security group strategy to meet the business and technical requirements. What should you do?（）

A、Create one global group named G_Executives. Make all executives user accounts members of that group.  B、Create two global groups named G_Executives and one universal group named U_Executives. Make the two global members of U_Executives. Make the executive user accounts members of the appropriate global group.  C、Create three global groups named G_NY_Executives and G_Chi_Executives and G_Executives. Make G_NY_Executives and G_Chi_Executives members of G_Executives. Make the executive user accounts members of the appropriate global group.    D、Create one domain local group named DL_Executives. Make all executive user accounts members of that group.  

点击查看答案
第4题
[单选题] You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；  B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；  C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；  D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；  

点击查看答案
第5题
[多选题] You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

A、 Every SQL statement in the STS is considered only once for execution.  B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.  C、 The execution plan and execution statistics are computed for each SQL statement in the STS.   D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.  

点击查看答案
第6题
[单选题] Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

A、 The queries that are currently executing will abort and an error message will be returned to the user.  B、 The queries that are currently executing will execute normally but future queries will not executed.  C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.  D、 The currently executing and future queries will execute normally， but will be slower  

点击查看答案
第7题
[多选题] Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?（）

A、 DBCC CHECKTABLE   B、 ALTER INDEX REORGANIZE   C、 UPDATE STATISTICS   D、 CREATE STATISTICS   E、 DBCC SHOW_STATISTICS   F、 DBCC UPDATEUSAGE  

点击查看答案
第8题
[单选题]  The IT department is creating a human resources application that will require several new tables. You need to develop a standard alone executable that will defines these tables and their relationships. Which developer/2000 component could you use to create the executable?（）

A、Procedure builder.   B、Query builder.   C、Schema builder.   D、Form builder.   E、Project builder.   F、Transactional builder.  

点击查看答案
第9题
[单选题] You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）

A、 executing the SET PASSWORD command and then the SAVE_CONFIG command  B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command  C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command  D、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command  

点击查看答案
第10题
[多选题] Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

A、 when you change the name of a datafile  B、 when you drop a table from the database  C、 when you take an export of the database  D、 when you back up the database using OS utilities  E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement  F、 when you issue a BACKUP command from inside the RMAN run block  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服