网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）
A
&
B
ACCEPT
C
PROMPT
D
&&
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A B ACCEPTC PROMPTD ” 相关考题
考题
You need to read the entire contents of a file named Message.txt into a single string variable.Which code segment should you use?()
A.B.C.D.
考题
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? ()
A. B. ACCEPTC. PROMPTD.
考题
In which case would you use a FULL OUTER JOIN? ()
A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
考题
In which three cases would you use the USING clause?（）A、You want to create a nonequijoin.B、The tables to be joined have multiple NULL columns.C、The tables to be joined have columns of the same name and different data types.D、The tables to be joined have columns with the same name and compatible data types.E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
考题
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
考题
Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（） A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN
考题
You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）A、use enterprise managerB、use DBMS_SQL packageC、use DBMS_AWR packageD、use PRVT_WORKLOAD packageE、query the AWR snapshot repository objectsF、use DBMS_WORKLOAD_REPOSITORY package
考题
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A、FULLB、SCHEMASC、REMAP_SCHEMAD、REMAP_DATAFILESE、REMAP_TABLESPACE
考题
You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）A、NLSLANGB、NLSLENGTHSEMANTICSC、NLSTERRITORYD、NLSLANGUAGEE、NLSCHARACTERSETF、NLSDATELANGUAGEG、NLSNCHARCHARACTERSET
考题
In which scenario will you use the Flashback Version Query feature？（）A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace
考题
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）A、FULLB、SCHEMASC、TRANSFORMD、REMAP_SCHEMAE、REMAP_TABLESPACE
考题
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A、B、ACCEPTC、PROMPTD、
考题
Which protocols would you want to use for secure VPN ？（）A、EAPB、ChapC、Ms-ChapD、PPTPE、PAPF、SPAP
考题
单选题In which scenario will you use the Flashback Version Query feature？（）A
when you want to restore a table that has been dropped from the Recycle BinB
when you want to identify the transaction ID of the transaction that deleted some important records from a tableC
when you want to recover the schema of a dropped userD
when you want to restore a dropped tablespace
考题
单选题You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）A
When you want all unauthenticated traffic to be redirectedB
When you want all clear text traffic to be redirected.C
When you want all authenticated traffic to be redirected.D
When you want all encrypted traffic to be redirected.
考题
单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A
FULLB
SCHEMASC
REMAP_SCHEMAD
REMAP_DATAFILESE
REMAP_TABLESPACE
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
单选题Which protocols would you want to use for secure VPN ？（）A
EAPB
ChapC
Ms-ChapD
PPTPE
PAPF
SPAP
考题
单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task（）A
FULLB
SCHEMASC
TRANSFORMD
REMAP_SCHEMAE
REMAP_TABLESPACE
考题
单选题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
考题
多选题In which three cases would you use the USING clause?（）AYou want to create a nonequijoin.BThe tables to be joined have multiple NULL columns.CThe tables to be joined have columns of the same name and different data types.DThe tables to be joined have columns with the same name and compatible data types.EYou want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
考题
单选题You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）A
ownerB
touserC
includeD
schemasE
fromuserF
transformG
remap_schemaH
remap_datafileI
reuse_datafilesJ
remap_tablespace
考题
单选题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 want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）A
NLSLANGB
NLSLENGTHSEMANTICSC
NLSTERRITORYD
NLSLANGUAGEE
NLSCHARACTERSETF
NLSDATELANGUAGEG
NLSNCHARCHARACTERSET
考题
单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）A
FULLB
SCHEMASC
TRANSFORMD
REMAP_SCHEMAE
REMAP_TABLESPACE
热门标签
最新试卷
