网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?()
A
functions
B
package
C
procedure
D
database trigger
E
anonymous PL/SQL block
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?()A functionsB packageC procedureD database triggerE anonymous PL/SQL block” 相关考题
考题
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler()A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from = http://www.amaderforum.comD、Recovery Manager (RMAN) script
考题
You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?()A、 .SQL B、 .PLL C、 .PLDD、 .PRT
考题
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()A、The source PL/SQL code will be stored in native machine code.B、The source PL/SQL code will be stored in interpreted byte code.C、The compiled PL/SQL code will be stored in native machine code.D、The compiled PL/SQL code will be stored in interpreted byte code.
考题
The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()A、Programme units. B、PL/SQL libraries. C、Database object. D、Built in packages.
考题
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem? ()A、functionB、packageC、procedureD、database triggerE、anonymous PL/SQL block
考题
You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? ()A、Menu B、Plus C、MacroD、PL/SQL
考题
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?()A、 functionsB、 packageC、 procedureD、 database triggerE、 anonymous PL/SQL block
考题
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this()A、the XML scriptB、the PL/SQL scriptC、the DBMS_SCHEDULER packageD、Enterprise Manager to schedule the backup
考题
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()A、An object type is a user-defined composite data type. B、The attributes of an object type can be those of other object types. C、A PL/SQL table of records is an example of a nested object type. D、An object type must be declared as a type before the actual object itself can be declared.
考题
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()A、SQL scriptB、PL/SQL scriptC、Operating System (OS) scriptD、Enterprise Manager (EM) scriptE、Recovery Manager (RMAN) script
考题
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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? () A、You should use local Service accountB、You should use network Service accountC、You should use domain accountD、You should use local System account
考题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?()A、one that uses an internal SQL Server Web service endpointB、one that runs a SQL Server Integration Services (SSIS) packageC、one that uses Service BrokerD、one that runs a user-defined function
考题
单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem? ()A
functionB
packageC
procedureD
database triggerE
anonymous PL/SQL block
考题
单选题In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()A
The source PL/SQL code will be stored in native machine code.B
The source PL/SQL code will be stored in interpreted byte code.C
The compiled PL/SQL code will be stored in native machine code.D
The compiled PL/SQL code will be stored in interpreted byte code.
考题
单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()A
The source PL/SQL code will be stored in native machine code.B
The source PL/SQL code will be stored in interpreted byte code.C
The compiled PL/SQL code will be stored in native machine code.D
The compiled PL/SQL code will be stored in interpreted byte code.
考题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()A
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题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 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
考题
单选题The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()A
Programme units. B
PL/SQL libraries. C
Database object. D
Built in packages.
考题
单选题What type of stopper would you use on a nylon mooring line? ()A
ChainB
NylonC
ManilaD
Wire
考题
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this()A
the XML scriptB
the PL/SQL scriptC
the DBMS_SCHEDULER packageD
Enterprise Manager to schedule the backup
考题
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?()A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_SPACE_ADMIN
考题
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()A
The XML scriptB
The PL/SQL scriptC
The DBMS_SCHEDULER packageD
Enterprise Manager to schedule the backup
考题
单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?()A
functionsB
packageC
procedureD
database triggerE
anonymous PL/SQL block
考题
单选题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 have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?()A
.SQL B
.PLL C
.PLDD
.PRT
考题
单选题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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? ()A
You should use local Service accountB
You should use network Service accountC
You should use domain accountD
You should use local System account
考题
多选题You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()AAn object type is a user-defined composite data type.BThe attributes of an object type can be those of other object types.CA PL/SQL table of records is an example of a nested object type.DAn object type must be declared as a type before the actual object itself can be declared.
热门标签
最新试卷