网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
A
table
B
transactional trigger
C
stored procedure
D
FROM clause query
参考答案
参考解析
解析：
暂无解析
更多 “单选题You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）A table B transactional trigger C stored procedure D FROM clause query” 相关考题
考题
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.
考题
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)A．Apply a bulk update lock to the table.B．Use separate client connections to load the files into the table simultaneously.C．Create a clustered index on the table.D．Specify the Full Recovery model for the database.E．Specify the Bulk-Logged Recovery model for the database.
考题
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）A、vector B、database view C、database table D、transactional trigger E、PL/SQL table of records F、multi-dimensional array
考题
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 need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger
考题
You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
考题
While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block？（） A、 RECOVER FILE=1201 BLOCK=1968B、 RECOVER CORRUPTION LISTC、 RECOVER DATAFILE 1201 BLOCK 1968D、 RECOVER BLOCK CORRUPTION LISTE、 None of the above
考题
You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）A、Built-in Packages B、Menus C、PL/SQL Libraries D、Object Libraries E、Form Module
考题
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）A、Create the relation manually and coordinate the blocks using triggers. B、Base the relation on a REF pointer using the Data Block Wizard. C、Base the relation on a foreign key using the Data Block Wizard. D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
考题
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number （SCN）.
考题
单选题The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）A
Choose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. D
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. E
Choose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. F
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
考题
多选题While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block？（）ARECOVER FILE=1201 BLOCK=1968BRECOVER CORRUPTION LISTCRECOVER DATAFILE 1201 BLOCK 1968DRECOVER BLOCK CORRUPTION LISTENone of the above
考题
单选题You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）A
Select the block that contains the data to appear in the pie chart. B
Select the table that contains the data to appear in the pie chart. C
Select the view that contains the data to appear in the pie chart. D
Nothing. The wizard will automatically create the pie chart based on the highlighted data.
考题
多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger
考题
单选题You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）A
Specify a view based on the archival data table and current data tables.B
Specify that the data must be queried by using a stored procedure.C
Specify that both the archival data table and the current data tables must have indexes created on the same columns.D
Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.
考题
多选题ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）AvectorBdatabase viewCdatabase tableDtransactional triggerEPL/SQL table of recordsFmulti-dimensional array
考题
单选题You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）A
Tab canvas. B
Pop up canvas. C
Spread table canvas. D
Vertical toolbar canvas.
考题
单选题You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）A
Built-in Packages B
Menus C
PL/SQL Libraries D
Object Libraries E
Form Module
考题
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A
You do not need to restore all the data files.B
You do not need to open the database with the RESETLOGS operationC
You do not need to perform a full backup after the RESETLOGS operation.D
You do not need to recover all the data files to the same system change number （SCN）.
考题
单选题You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A
by using the DBMS_REPAIR packageB
by using the DB_BLOCK_CHECKING parameterC
by using the DBVERIFY utilityD
will not be completely resolved until the hardware fault is corrected
考题
单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A
You must enable the block change tracking feature.B
You must have enable the flashback feature.C
You must use the OMF in your database.D
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
单选题You need to block messages from senders that do not comply sender policy framework （SPF）.What do you need to implement？（）A
Receive connectorB
Sender ID FilteringC
Sender FilteringD
Send connector
考题
单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）A
Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. C
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. D
Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. E
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
考题
单选题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 need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）A
Use the DESCRIBE command on the EMP_DEPT_VU view.B
Use the DEFINE VIEW command on the EMP_DEPT_VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
热门标签
最新试卷