网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）
A
DBMS_REPAIR
B
DBMS_SCHDULER
C
DBMS_STATS
D
DBMS_RESOURCE_MANAGER
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）A DBMS_REPAIRB DBMS_SCHDULERC DBMS_STATSD DBMS_RESOURCE_MANAGER” 相关考题
考题
You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.
考题
Which of the following answer choices are correct characteristics of named access list?()
A. You can delete individual statements in a named access listB. Named access lists require a numbered range from 1000 to 1099.C. Named access lists must be specified as standard or extended.D. You can use the ip access-list command to create named access lists.E. You cannot delete individual statements in a named access list.F. You can use the ip name-group command to apply named access lists.
考题
Which statement about access lists that are applied to an interface is true?()
A.you can apply multiple access lists with the same protocol or in different…B.you can config one access list,per direction,per layer 3 protocolC.you can placeasmanyaccess lists as you want on any interfaceD.you can apply ony one access list on any interface
考题
Which of the following answer choices are correct characteristics of named access list?（）A、You can delete individual statements in a named access listB、Named access lists require a numbered range from 1000 to 1099.C、Named access lists must be specified as standard or extended.D、You can use the ip access-list command to create named access lists.E、You cannot delete individual statements in a named access list.F、You can use the ip name-group command to apply named access lists.
考题
Which statement about access lists that are applied to an interface is true?（）A、you can apply multiple access lists with the same protocol or in different…B、you can config one access list,per direction,per layer 3 protocolC、you can placeasmanyaccess lists as you want on any interfaceD、you can apply ony one access list on any interface
考题
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
考题
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package
考题
Which statement about access lists that are applied to an interface is true？（）A、you can apply multiple access lists with the same protocol or in different…B、you can config one access list，per direction，per layer 3 protocolC、you can place as many access lists as you want on any interfaceD、you can apply ony one access list on any interface
考题
You want a class to have access to members of another class in the same package. Which is the most restrictive access modifier that will accomplish that will accomplish this objective？（） A、 PublicB、 PrivateC、 ProtectedD、 TransientE、 No access modifier is required.
考题
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）A、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN
考题
On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）A、 by using Oracle Enterprise ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
考题
You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D、 You cannot shrink the SCOTT.EMP table.
考题
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）A、It may advise the use of online table redefinition for tables in dictionary managed tablespace.B、It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C、It may advise the use of online table redefinition for tables in locally managed tablespacesD、It will detect and advise about chained rows.E、It may advise the use of segment shrink for free list managed tables.
考题
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）A、CLOBB、BLOBC、BFILED、LONG RAW
考题
You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）A、functionsB、packagesC、proceduresD、database triggersE、anonymous PL/SQL block
考题
You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（） A、 by using the DBMS_SESSION packageB、 by granting the DBA roleC、 by using the DBMS_RESOURCE_MANAGER packageD、 by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
单选题You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）A
functionsB
packagesC
proceduresD
database triggersE
anonymous PL/SQL block
考题
单选题In which scenario will you use the Flashback Transaction Query feature？（）A
when you want to restore an important table that is dropped from the Recycle BinB
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC
when you want to restore a dropped user’s schemaD
when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A
by using the ANALYZE utilityB
by using the DBVERIFY utilityC
by using the DB_BLOCK_CHECKING parameterD
by using the DBMS_REPAIR package
考题
单选题You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）A
by using the DBMS_SESSION packageB
by granting the DBA roleC
by using the DBMS_RESOURCE_MANAGER packageD
by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
多选题You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）ARESETLOGSBTO TIMESTAMPCTO BEFORE DROPDRENAME TOETO SCN
考题
多选题On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）Aby using Oracle Enterprise ManagerBby issuing the FLASHBACK TABLE statement at the RMAN promptCby issuing the FLASHBACK TABLE statement at the SQL promptDby issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
考题
单选题You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D
You cannot shrink the SCOTT.EMP table.
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
单选题You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）A
CLOBB
BLOBC
BFILED
LONG RAW
考题
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A
by using the Flashback Table featureB
by using the Flashback Database featureC
by performing incomplete recovery using RMAN utilityD
by performing incomplete recovery using user-managed recovery
考题
单选题You want a class to have access to members of another class in the same package. Which is the most restrictive access modifier that will accomplish that will accomplish this objective？（）A
PublicB
PrivateC
ProtectedD
TransientE
No access modifier is required.
热门标签
最新试卷