网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）
- A、 It remains valid.
- B、 It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
- C、 It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
- D、 It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
参考答案
更多 “ A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）A、 It remains valid.B、 It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C、 It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D、 It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.” 相关考题
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL－related problems?()
A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data
考题
A PL／SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL／SQL procedure after the online table redefinition?()
A. It remains valid.B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
考题
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
考题
在PL/SQL中定义一个可以存放雇员表（EMP）的员工名称（ENAME）的PL/SQL表类型，应该（）A、type array arr_type[emp.ename%type] index by binary_integer;B、type table arr_type[emp.ename%type] index by binary_integer;C、type arr_type is table of emp.ename%type index by binary_integer;D、type arr_type is pl_sql table of emp.ename%type index by binary_integer;
考题
You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do？（）A、Implement a stored procedure that writes data about schema changes to a log table.B、Implement DDL AFTER triggers that write user and schema information to a log table.C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D、Implement a DML AFTER trigger that writes data about schema changes to a log table.
考题
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A、Oracle Data Pump.B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D、Online Table Redefinition.E、Edition-Based Table Redefinition.
考题
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would yousuggest to the PL/SQL developers to achieve this（）A、Create the procedure with definer’s right.B、Create the procedure with invoker’s right.C、Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D、Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（） A、 ADR diagnostic filesB、 all the optimizer statisticsC、 initialization parameter settingsD、 PL/SQL functions，procedures，and packagesE、 the table and index definitions and actual data
考题
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？ （）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
Which two PL/SQL8 features are supported in Oracle Forms?（）A、methods B、object tables C、object columns D、collection types E、object as stored procedure parameters
考题
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）A、Perform point-in-time recovery to 2： 00 p.m.B、Use Flashback Table feature to revert the changes.C、Restore the entire database from the recent backup and open it.D、Issue the rollback statement with system change number （SCN）.
考题
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
考题
Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）A、Grand privileges on the interim table.B、Invoke the dbms_redefinition.can_redef_table procedure.C、Invoke the dbms_redefinition.sync_interim_table procedure.D、Create any triggers， indexes， or constraints on the interim table.E、Create an empty interim table with all the desired characteristics.
考题
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
考题
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.
考题
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue 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 checked.E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
考题
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
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. There is a database named DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 11 ... 12 GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. What action should you do perform?（） A、Between lines 01 and 02, you should insert the WITH EXECUTE AS apos;dboapos; clause. B、Between lines 01 and 02, you should insert the EXECUTE AS USER = apos;dboapos; statement. C、You should give the user the ALTER permission on the Service schema D、You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.
考题
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 the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（） 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 = apos;dboapos; option immediately before the call to the sp_executesql stored procedure.
考题
多选题Which three table transformations can be done using online redefinition of tables？（）AABBCCDDEE
考题
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A
Oracle Data Pump.B
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D
Online Table Redefinition.E
Edition-Based Table Redefinition.
考题
单选题A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）A
It remains valid.B
It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C
It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D
It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
考题
单选题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？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）A
It remains valid.B
It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C
It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D
It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
考题
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A
The materialized view should have a complete refresh performed after the online table redefinition is completed.B
The materialized view should have a fast refresh performed after the online table redefinition is completed.C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
考题
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A
The dependent materialized view should have a complete refresh performed after the online table redefinition process.B
Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C
Referential integrity constraints must be manually enabled after the online table redefinition process.D
The materialized log should be dropped before the online table redefinition process.
热门标签
最新试卷