网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）
- A、Extents would be managed by the freelists.
- B、The segment would be managed by bitmaps.
- C、The segment would be managed by the freelists.
- D、Free space would be managed by the data dictionary.
参考答案
更多 “You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A、Extents would be managed by the freelists.B、The segment would be managed by bitmaps.C、The segment would be managed by the freelists.D、Free space would be managed by the data dictionary.” 相关考题
考题
What quantities of the specified item can you regularly deliver ()short notice?A、atB、onC、inD、for
考题
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?（）A. Only one channel is allocated and the backup is created in the flash recovery areaB. Only one channel is allocated and the backup is created in the destination specified for channelC. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
考题
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.
考题
Which two of these are differences between traffic policing and traffic shaping？（）A、with traffic shaping，a router stores excess traffic in packet buffers until bandwidth is available againB、with policing you can tune the buffer usage for traffic exceeding the specified CIRC、with shaping you can tune the buffer usage for traffic exceeding the specified CIRD、shaping should only be applied for ingress traffic，policing only for egressE、policing uses a token bucket algorithm，shaping uses an SPD algorithm
考题
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? （）A、to execute a specified method of a Java class B、to reference a variable or invoke a method of a custom Java Object C、to pass variables between two different workflows D、to create an object for the purpose of executing methods on a remote computer E、to get a reference to the Contact and Session states F、to allow for arguments to be passed to a specified method
考题
Which three route filtering statements are true?（）A、After the router ospf 10 and passive - interface s0/0 commands have been issued , the s0/0 interface will not send any OSPF updates, but will receive routing updates on that interfaceB、When you use the passive - interface command with RIPv2, multicasts are sent out the specified interfaceC、After the router rip and passive -interface s0/0 commands have been issued, the s0/0 interface will not send any RIP updates, but will receive routing updates on that interfaceD、When you use the passive - interface command with EIGRP, hel lo messages are not sent out the specified interfaceE、After the router eigrp 10 and passive - interface s0/0 commands have been issued, the s0/0 interface will not send any EIGRP updates, but will receive routing updates on that interfaceF、When you use the passive - interface command with OSPF, hello messages are not sent out the specified interface
考题
Which three statements describe the functionality of the DO_KEY built-in?（）A、It accepts both a built-in and a key name as argument. B、If no key trigger is defined, the specified built-in executes. C、Its parameter must be specified in upper case, enclosed in single quotation marks. D、It performs the same task as if you pressed the function key associated with the specified argument. E、It executes the key trigger that corresponds to the built-in specified as its parameter.
考题
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
考题
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.
考题
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name. Which statement is true in this case（）A、The ORACLE_BASE parameter is not set.B、The installation is being performed by the root user.C、The operating system group that will be specified should have root user as its member.D、The installation is being performed without the "Create Starter Database" option selected.E、The operating system group that will be specified must have permission to write to the inventory directory
考题
You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed.You are running a training exercise for junior administrators. You are currently discussing what happens when you run the Remove-NetLbfoTeam Windows PowerShell cmdlet.Which of the following describes the results of running this cmdlet？（）A、It removes one or more network adapters from a specified NIC team.B、It removes a team interface from a NIC team.C、It removes a specified NIC team from the host.D、It removes a network adapter member from a switch team.
考题
多选题In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? （）Ato execute a specified method of a Java classBto reference a variable or invoke a method of a custom Java ObjectCto pass variables between two different workflowsDto create an object for the purpose of executing methods on a remote computerEto get a reference to the Contact and Session statesFto allow for arguments to be passed to a specified method
考题
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A
The archived redo logs are stored in an operating system-dependent location.B
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified timeE
to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
多选题Which three statements describe the functionality of the DO_KEY built-in?（）AIt accepts both a built-in and a key name as argument.BIf no key trigger is defined, the specified built-in executes.CIts parameter must be specified in upper case, enclosed in single quotation marks.DIt performs the same task as if you pressed the function key associated with the specified argument.EIt executes the key trigger that corresponds to the built-in specified as its parameter.
考题
单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A
The EVENT parameter was not setB
The SQL_TRACE parameter is set to FALSEC
The Enterprise Manager Grid Control is not usedD
The STATISTICS_LEVEL parameter is set to BASICE
The TIMED_STATISTICS parameter is set to FALSE
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified time
考题
单选题While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A
A primary key must have been created.B
A mapping table must have been created.C
An overflow tablespace must have been specified.D
The PCTTHRESHOLD option must have been specified.
考题
单选题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
考题
单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A
A primary key must have been created.B
A mapping table must have been created.C
An overflow tablespace must have been specified.D
The PCTTHRESHOLD option must have been specified.
考题
多选题Which two of these are differences between traffic policing and traffic shaping？（）Awith traffic shaping，a router stores excess traffic in packet buffers until bandwidth is available againBwith policing you can tune the buffer usage for traffic exceeding the specified CIRCwith shaping you can tune the buffer usage for traffic exceeding the specified CIRDshaping should only be applied for ingress traffic，policing only for egressEpolicing uses a token bucket algorithm，shaping uses an SPD algorithm
考题
单选题You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?（）A
The ORACLE_BASE base parameter is not set.B
The installation is being performed by the root user.C
The operating system group that is specified should have the root user as its member.D
The operating system group that is specified must have permission to write to the inventory directory
考题
单选题You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is true in this case（）A
The ORACLE_BASE parameter is not set.B
The installation is being performed by the root user.C
The operating system group that will be specified should have root user as its member.D
The installation is being performed without the Create Starter Database option selected.E
The operating system group that will be specified must have permission to write to the inventorydirectory.
考题
单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）A
Setting a metric thresholdB
Implementing Database Resource ManagerC
Enabling resumable timeout for user sessionsD
Decreasing the value of the IDLE_TIME resource limit in the default profile
考题
单选题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
考题
单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）A
ROWSB
SKIPC
LOADD
BINDSIZE
热门标签
最新试卷
