You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A、All the extents will be of the same size.B、Bitmap will be used to record free and allocated extents.C、Free extents will be managed by the data dictionary tables.D、The tablespace will be system managed and the users cannot specify the extent size.
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）
- A、All the extents will be of the same size.
- B、Bitmap will be used to record free and allocated extents.
- C、Free extents will be managed by the data dictionary tables.
- D、The tablespace will be system managed and the users cannot specify the extent size.
相关考题：
(c) Explain the extent to which you should plan to place reliance on analytical procedures as audit evidence.(6 marks)
What quantities of the specified item can you regularly deliver ()short notice?A、atB、onC、inD、for
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.
What is the maximum size that can be specified when creating an XML column in a DB2 table?() A.No size is specifiedB.The buffer pool sizeC.The page size for the table spaceD.The extent size for the table space
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.
What must be specified to create an extent pool（）A、blocksize， rank group， and nameB、storage type， rank group， and nameC、storage type， capacity， and rank groupD、capacity， name， and storage type
You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
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.
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.
You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）A、DEFAULT STORAGE B、EXTENT MANAGEMENT C、AUTOEXTEND D、DATAFILE
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 managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group？（）A、 The au_size disk group attribute determines the size of allocation units in the disk group. B、 The allocation unit size may vary but the extent size is fixed.C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.D、 Extent management is completely automated.
What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A、No size is specifiedB、The buffer pool sizeC、The page size for the table spaceD、The extent size for the table space
问答题Practice 7 You should spend about 40 minutes on this task. Write about the following topic: Universities should accept equal numbers of male and female students in every subject. To what extent do you agree or disagree? You should write at least 250 words.
问答题Practice 3 You should spend about 40 minutes on this task. Write about the following topic: Students at schools and universities learn far more from lessons with teachers than from other sources (such as the Internet and television). To what extent do you agree or disagree? You should write at least 250 words.
多选题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.
单选题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
单选题You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）AAll the extents will be of the same size.BBitmap will be used to record free and allocated extents.CFree extents will be managed by the data dictionary tables.DThe tablespace will be system managed and the users cannot specify the extent size.
单选题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？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.
单选题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
问答题Practice 6 You should spend about 40 minutes on this task. Write about the following topic: News media is more influential nowadays. Some people think it is a negative development. To what extent do you agree or disagree? You should write at least 250 words.
问答题Practice 5 You should spend about 40 minutes on this task. Write about the following topic: If a product is of good quality and meets people's needs, people will buy it, Therefore, advertising is unnecessary and is no more than a type of entertainment, To what extent do you agree or disagree? You should write at least 250 words.
单选题I would be much（）if you could take the matter up with Owners or Agents on the damage sustained and also request them to send their representative to us to ascertain the extent of the damage.AobligedBengagedCgainedDcontaminated
单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）AROWSBSKIPCLOADDBINDSIZE