Which  statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database 

题目

Which  statements are true about checkpointing（）

  • A、The checkpoint frequency decreases with the smaller redo log file size.
  • B、It ensures that all committed data is written to the data files during normal shutdown.
  • C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
  • D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
相似考题

1.12 Which of the following statements are correct?(1) Contingent assets are included as assets in financial statements if it is probable that they will arise.(2) Contingent liabilities must be provided for in financial statements if it is probable that they will arise.(3) Details of all adjusting events after the balance sheet date must be given in notes to the financial statements.(4) Material non-adjusting events are disclosed by note in the financial statements.A 1 and 2B 2 and 4C 3 and 4D 1 and 3

2.Which of the following statements is NOT a way of consolidating vocabulary A.Defining. B.Matching. C.Gapfilling. D.Labeling.

3.Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

4.Which of the following objects contains control structures that are considered the bound form of SQL statements?()A.UDTB.TriggerC.PackageD.Access plan

更多“Which  statements”相关问题

  • 第1题：

    Which statement is true regarding the INTERSECT operator?（）

    • A、It ignores NULL values 
    • B、Reversing the order of the intersected tables alters the result 
    • C、The names of columns in all SELECT statements must be identical 
    • D、The number of columns and data types must be identical for all SELECT statements in the query 

    正确答案:D

  • 第2题：

    Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）

    • A、A list of SQL statements and recommendations for tuning
    • B、A list of SQL statements that have been tuned by the Advisor, with before and after metrics
    • C、Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
    • D、All of the above

    正确答案:A

  • 第3题：

    Which two statements are true about standard database auditing（）

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第4题：

    多选题
    If p and q are primes greater than 2, which of the following statements must be true? (Indicate all such statements.)
    A

    p + q is even

    B

    pq is odd

    C

    p2-q2 is even


    正确答案： A,B
    解析：
    由于所有大于2的质数都是奇数，因此p和q均是奇数，两奇数相加为偶数，所以A项正确；两奇数的乘积还是奇数，所以B项正确；两奇数的平方还各自是奇数，而两奇数的平方之差是偶数，因此C项也正确；所以选择A、B、C三项。

  • 第5题：

    多选题
    Which of the following statements are true? (Indicate all such statements.)
    A

    τ(5) =τ(7)

    B

    τ(5) τ(7) =τ(35)

    C

    τ(5) + τ(7) =τ(12)


    正确答案： A,B
    解析：
    5和7均只有两个正除数，因此根据题干信息，A项正确；35有四个正除数，所以B项也是正确的；12有6个正除数，因此C项错误；选择A、B两项。

  • 第6题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP...


    正确答案： D,F
    解析： 暂无解析

  • 第7题：

    单选题
    Which of the following statements is NOT a way of consolidating vocabulary?
    A

    Defining.

    B

    Matching.

    C

    Gap-filling.

    D

    Labeling.


    正确答案： D
    解析：

  • 第8题：

    单选题
    For the following statements， which one is the strongest symmetrical encryption algorithm？（）
    A

    AES

    B

    3DES

    C

    DES

    D

    Diffie-Hellman


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    Which three statements about subqueries are true? （）
    A

    Asinglerowsubquerycanretrieveonlyonecolumnandonerow.

    B

    Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.

    C

    Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.

    D

    Amultiplerowsubquerycanbecomparedusingthe；>；；operator.

    E

    AsinglerowsubquerycanusetheINoperator.

    F

    Amultiplerowsubquerycanusethe；=；operator.


    正确答案： D,A
    解析： 暂无解析

  • 第10题：

    单选题
    Which statement is true regarding the INTERSECT operator?（）
    A

    It ignores NULL values 

    B

    Reversing the order of the intersected tables alters the result 

    C

    The names of columns in all SELECT statements must be identical 

    D

    The number of columns and data types must be identical for all SELECT statements in the query 


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    Which three statements are valid SDM configuration wizards？ （）

    • A、NAT
    • B、VPN
    • C、STP
    • D、Security Audit

    正确答案:A,B,D

  • 第13题：

    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

    • A、 SQL statements that are part of the AWR baseline only
    • B、 SQL statements based on the AWR top SQL identification
    • C、 SQL statements that are part of the available SQL Tuning Set （STS） only
    • D、 SQL statements that are available in the cursor cache and executed by a user other than SYS

    正确答案:B

  • 第14题：

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

    • A、ADDM
    • B、AWR
    • C、Cursor Cache
    • D、SQL Tuning Sets
    • E、Flash Recovery Area

    正确答案:E

  • 第15题：

    多选题
    Concerning the figure below, if a =b, which of the following statements must be true? (Indicate all such statements.)
    A

    c=d

    B

    l and k are parallel

    C

    m and l are perpendicular


    正确答案： C,B
    解析：
    根据题目中的已知信息无法推断出各直线的关系，因此B、C均不正确；而由图示可知，c和d分别是a和b的补角，由于a=b，所以c=d，A项正确。

  • 第16题：

    单选题
    Which statement is true when you run the SQL Tuning Advisor with limited scope？（）
    A

    Access path analysis is not performed for the SQL statements.

    B

    SQL structure analysis is not performed for the SQL statements.

    C

    SQL Profile recommendations are not generated for the SQL statements.

    D

    The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.


    正确答案： B
    解析： 暂无解析

  • 第17题：

    多选题
    Which two statements are reserved words in Java？（）
    A

    Run

    B

    Import

    C

    Default

    D

    Implement


    正确答案： B,D
    解析： 暂无解析

  • 第18题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP


    正确答案： E,C
    解析： 暂无解析

  • 第19题：

    单选题
    Which of the following statements is correct concerning the “flash point ” of a liquid?（）
    A

    It is lower than the ignition temperature

    B

    It is the temperature at which a substance will spontaneously ignite

    C

    It is the temperature at which a substance, when ignited, will continue to bum

    D

    It is the temperature at which the released vapors will fall within the explosive range


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
    A

     SQL statements that are part of the AWR baseline only

    B

     SQL statements based on the AWR top SQL identification

    C

     SQL statements that are part of the available SQL Tuning Set （STS） only

    D

     SQL statements that are available in the cursor cache and executed by a user other than SYS


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
    A

    ADDM

    B

    AWR

    C

    Cursor Cache

    D

    SQL Tuning Sets

    E

    Flash Recovery Area


    正确答案： A
    解析： 暂无解析

相关内容