Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
- A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
- B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
- C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
- D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
- E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
相关考题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
After adding a new Ethernet card to a system and rebooting， the system administrator notices the card was not configured. How can the system administrator determine if there were errors during the configuration process for the card？（）A、Examine the bootlog with the command： alog -o -f /var/adm/ras/bootlogB、Display the device attributes and errors with the command： lsdev -C -l ent0C、Examine the AIX errlog for configuration method errors with the command： errpt -a -C ent0D、Examine the ODM for configuration errors with the command： odmget -q "method_errors" ent0
A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）A、db2advis -d proddb -i workload.sql -P B、db2advis -d proddb -i workload.sql -partitioning C、db2advis -d proddb -i workload.sql -m P D、db2advis -d proddb -i workload.sql -m ALL
Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）A、In Event Viewer， examine the Application log.B、In Windows Update， examine the update history.C、At the command prompt， run Wusa.exe and specify the /kb parameter.D、At the command prompt， run Verifier.exe and specify the /query parameter.
You work as a network administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed. The ABC.com network has a domain controller named ABC_DC01.Which of the following tools would you use to manually remove Active Director from ABC_DC01？（）A、You should consider using the dism.exe command-line tool.B、You should consider using the dsadd.exe command-line tool.C、You should consider using the pcpromo.exe command-line tool.D、You should consider using the ntdsutil.exe command-line tool.E、You should consider using the netsh.exe command-line tool.F、You should consider using the rexec.exe command-line tool.
单选题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.
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）AIt cancels all pending disk drops within the disk groupBIt restores disks that are being dropped as the result of a DROP DISKGROUP operationCIt mounts disks in the disk group for which the drop-disk operation has already been completedDIt restores all the dropped disks in the disk group for which the drop-disk operation has already been completedEIt adds previously dropped disks back into the disk group
单选题You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. The computer that hosts the ASP.NET Web application contains a local instance of Microsoft SQL Server 2005. The instance uses Windows Authentication. You plan to configure the membership providers and the role management providers. | English | Chinese | Japan | Korean | - 101 - Test Information Co.， Ltd. All rights reserved. You need to install the database elements for both the providers on the local computer. What should you do？（）ARun the sqlcmd.exe -S localhost E command from the command line.BRun the aspnet_regiis.exe -s localhost command from the command line.CRun the sqlmetal.exe /server：localhost command from the command line.DRun the aspnet_regsql.exe -E -S localhost -A mr command from the command line.
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）AThe shrink operation touches every block in the BOOKING tableBThe high-water mark (HWM) for the BOOKING table is shifted from its original positionCThe progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableDThe data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
单选题Examine the following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id= ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）A It is loaded with the FIXED status.B It is loaded with the ACCEPTED status.C It is not loaded with the ENABLED status.D It is not loaded with the ACCEPTED status.
单选题You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. The computer that hosts the ASP.NET Web application contains a local instance of Microsoft SQL Server 2005. The instance uses Windows Authentication. You plan to configure the membership providers and the role management providers. You need to install the database elements for both the providers on the local computer. What should you do？（）ARun the sqlcmd.exe -S localhost E command from the command line. BRun the aspnet_regiis.exe -s localhost command from the command line. CRun the sqlmetal.exe /server:localhost command from the command line. DRun the aspnet_regsql.exe -E -S localhost -A mr command from the command line.
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）AThe table is moved to the SYSAUX tablespace.BThe table is moved to the SYSTEM tablespace.CThe table is removed from the database permanently.DThe table is renamed and remains in the TBSFD tablespace.
单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A The shrink operation touches every block in the BOOKING tableB The high-water mark （HWM） for the BOOKING table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题You work as a network administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed. The ABC.com network has a domain controller named ABC_DC01.Which of the following tools would you use to manually remove Active Director from ABC_DC01？（）AYou should consider using the dism.exe command-line tool.BYou should consider using the dsadd.exe command-line tool.CYou should consider using the pcpromo.exe command-line tool.DYou should consider using the ntdsutil.exe command-line tool.EYou should consider using the netsh.exe command-line tool.FYou should consider using the rexec.exe command-line tool.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below， which utility should you choose to use？（）Abcp.exe Bdta.exe Cdtexec.exe Dsqlmaint.exe
单选题You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）AIn Event Viewer， examine the Application log.BIn Windows Update， examine the update history.CAt the command prompt， run Wusa.exe and specify the /kb parameter.DAt the command prompt， run Verifier.exe and specify the /query parameter.
单选题You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 R2 on a new ABC.com server，you are instructed to add a graphical user interface （GUI） to the server. You want to achieve this goal from the command prompt. Which of the following actions should you take？（）AYou should consider making use of the dism.exe command.BYou should consider making use of the dsquery.exe command.CYou should consider making use of the dsadd.exe command.DYou should consider making use of the dsrm.exe command.
单选题You are the newly appointed system administrator at Certkiller.com. You make use of Microsoft.NET Framework v3.5 to create a Microsoft ASP.NET application. You are responsible for a local instance of Microsoft SQL Server 2005 named CERTKILLER-SR02. CERTKILLER-SR02 hosts the ASP.NET Web application. CERTKILLER-SR02 makes useof Windows Authentication. You are in the process of planning the configuration of the membership providers as well as the role management providers. It is important that you install thedatabase elements for both the providers on CERTKILLER-SR02 from the command line. What should you do？（）AYour best option would be to run the aspnet_regsql.exe -E -S localhost -A mr command.BYour best option would be to run the sqlcmd.exe -S localhost E command.CYour best option would be to run the sqlmetal.exe /server：localhost command.DYour best option would be to run the aspnet_regiis.exe -s localhost command.