Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache

题目

Records from the data dictionary information are stored in which of the following database memory areas?（）

  • A、Library cache 
  • B、Row cache 
  • C、Session UGA 
  • D、Buffer cache
相似考题

1.The amount of the outstanding checks is included on the bank reconciliation as a(n) ( )A. deduction from the balance per depositor's recordsB. addition to the balance per bank statementC. deduction from the balance per bank statementD. addition to the balance per depositor's records

2.You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

3.Did you get the financial records _______ shape for your audit next month?A into ;B in ;C from

4.The text suggests that early settlers in New England__________.[A] were mostly engaged in political activities[B] were motivated by an illusory prospect[C] came from different backgrounds.[D] left few formal records for later reference

更多“Records from theQ”相关问题

  • 第1题：

    It can be inferred from the last paragraph that outside directors______.

    A．may stay for the attractive offers from the firm

    B．have often had records of wrongdoings in the firm

    C．are accustomed to stress-free work in the firm

    D．will decline incentives from the firm


    正确答案：A
    解析：推理题。题干定位在最后一段，没有明确的定位。因此需要分析段落结构，找到作者所暗示的内容。最后一段首先提到独立董事会在公司坏消息出现前离开以避免影响自己的声誉。然后提到了需要奖励来留住他们，否则Simmons女士的例子会重现。

  • 第2题：

    Academic records from other institutions often become part of a university's official file and can neither be returned to a student nor duplicated.

    A:borrowed
    B:purchased
    C:copied
    D:rewritten

    答案：C
    解析：
    本句意思：来自其他学院的学业成绩常常成为大学官方文件的一部分，既不会返还给学 生也不可以复制。duplicate复制，复写。copy复制，抄写；borrow借人；purchase购买；rewnte重 写，改写。

  • 第3题：

    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

    • A、 Issue the grant command from the SYS user （or equivalent） of the target database.
    • B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
    • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
    • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
    • E、 Issue the grant command from RMAN when connected to the target database.

    正确答案:D

  • 第4题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第5题：

    You need to configure the DNS resource records for incoming e-mail messages from the Internet. What should you do？（）

    • A、Configure mailbox （MB） resource records in the external DNS domain. Configure each record so that it has the same refresh interval
    • B、Configure mailbox （MB） resource records in the external DNS domain. Configure each record so that it has the same default Time to Live （TTL） interval
    • C、Configure mail exchanger （MX） resource records in the external DNS domain. Configure each record to have the same preference and a different mail exchanger
    • D、Configure mail exchanger （MX） resource records in the external DNS domain. Configure each record to have the same preference and the same mail exchanger

    正确答案:C

  • 第6题：

    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 （SP2）. You have a DNS server named Server1 that hosts a primary zone for the domain. You have a DNS server named Server 2 that hosts a secondary zone for the domain.  You discover that the resource records on Server2 are different from the resource records on Server1. You need to ensure that the resource records are the same on Server1 and Server2.  What should you do？（）

    • A、On Server2， select Reload in the DNS zone.
    • B、On Server2， select Reload from Master in the DNS zone.
    • C、On Server1， select Update Server Data File in the DNS zone.
    • D、On Server1， deselect the Fail on load if bad zone data option.

    正确答案:B

  • 第7题：

    Your network contains a domain controller that is configured as a DNS server. The server hosts an  Active Directory-integrated zone for the domain.   You need to reduce how long it takes until stale records are deleted from the zone.  What should you do（）

    • A、From the configuration directory partition of the forest， modify the tombstone lifetime.
    • B、From the configuration directory partition of the forest， modify the garbage collection interval.
    • C、From the aging properties of the zone， modify the no-refresh interval and the refresh interval.
    • D、From the start of authority （SOA） record of the zone， modify the refresh interval and the expire interval.

    正确答案:C

  • 第8题：

    单选题
    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 Bin

    B

     when you want to identify the transaction ID of the transaction that deleted some important records from a table

    C

     when you want to recover the schema of a dropped user

    D

    when you want to restore a dropped tablespace


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

  • 第9题：

    单选题
    You issue the following RMAN command to set a retention policy on a database：   RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of issuing this command？（）
    A

     After two days，a backup will be marked obsolete

    B

     After two days，a backup will be deleted from the media

    C

     If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.

    D

     If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.


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

  • 第10题：

    单选题
    You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）
    A

     After two days， the backup will be marked obsolete.

    B

     After two days， the backup will be deleted from the media.

    C

     If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.

    D

     If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.


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

  • 第11题：

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


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

  • 第12题：

    单选题
    Ellsworth Huntington’s conclusion was based on _____.
    A

    variations of his own mental abilities from season to season

    B

    the result of research done by him and other scientists among peoples in different climates

    C

    detailed records of temperature changes in different places

    D

    detailed records of different ways of thinking among peoples in different climates


    正确答案： B
    解析：
    细节题。“Ellsworth Huntington concluded from other men’s work and his own among peoples in different climates”，从该句可以得知亨廷顿的结论是建立在他人和自己的研究基础之上的。

  • 第13题：

    The text suggests that early settlers in New England

    A．were mostly engaged in political activities.

    B．were motivated by an illusory prospect.

    C．came from different intellectual backgrounds.

    D．left few formal records for later reference.


    正确答案：C

  • 第14题：

    SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）

    • A、direct-path load
    • B、conventional path load

    正确答案:A

  • 第15题：

    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 Bin
    • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
    • C、 when you want to recover the schema of a dropped user
    • D、when you want to restore a dropped tablespace

    正确答案:B

  • 第16题：

    You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）

    • A、Ensure that the source database is Microsoft SQL Server.
    • B、Ensure that the destination database is Microsoft SQL Server.
    • C、Ensure that the column names in the source table match the column names in the destination table.
    • D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.

    正确答案:B

  • 第17题：

    You have a DNS server that runs Windows Server 2003 Service Pack 2 (SP2).The server contains two zones named nwtraders.com and contoso.com. Nwtraders.com is configured as an Active Directory-integrated zone. Contoso.com is configured as a standard primary zone. You discover that stale resource records are not being removed from contoso.com. Stale resource records are being removed from nwtraders.com.You need to ensure that stale resource records are automatically removed from contoso.com.  What should you do?（）

    • A、Enable aging and scavenging on the contoso.com zone. 
    • B、Convert contoso.com to an Active Directory-integrated zone. 
    • C、From the start of authority (SOA) record for contoso.com, change the refresh interval. 
    • D、From the start of authority (SOA) record for contoso.com, change the TTL For This Record value.

    正确答案:A

  • 第18题：

    You have a DNS server named Server1 that hosts a primary zone for the domain. You have a DNS server named Server 2 that hosts a secondary zone for the domain.You discover that the resource records on Server2 are different from the resource records on Server1. You need to ensure that the resource records are the same on Server1 and Server2. What should you do?（）

    • A、On Server2, select Reload in the DNS zone. 
    • B、On Server2, select Reload from Master in the DNS zone. 
    • C、On Server1, select Update Server Data File in the DNS zone. 
    • D、On Server1, deselect the Fail on load if bad zone data option. 

    正确答案:B

  • 第19题：

    Your network contains a domain controller that is configured as a DNS server. The server hosts an Active Directory-integrated zone for the domain. You need to reduce how long it takes until stale records are deleted from the zone. What should you do？（）

    • A、From the configuration directory partition of the forest， modify the tombstone lifetime.
    • B、From the configuration directory partition of the forest， modify the garbage collection interval
    • C、From the aging properties of the zone， modify the no-refresh interval and the refresh interval
    • D、From the start of authority （SOA） record of the zone， modify the refresh interval and the expire interval

    正确答案:C

  • 第20题：

    单选题
    Records from the data dictionary information are stored in which of the following database memory areas?（）
    A

    Library cache 

    B

    Row cache 

    C

    Session UGA 

    D

    Buffer cache


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

  • 第21题：

    单选题
    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

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


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

  • 第22题：

    单选题
    You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）
    A

    After two days, a backup will be marked obsolete

    B

    After two days, a backup will be deleted from the media

    C

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

    D

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.


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

  • 第23题：

    单选题
    You have a DNS server that runs Windows Server 2003 Service Pack 2 (SP2). The server contains two zones named nwtraders.com and contoso.com. Nwtraders.com is configured as an Active Directory-integrated zone. Contoso.com is configured as a standard primary zone. You discover that stale resource records are not being removed from contoso.com. Stale resource records are being removed from nwtraders.com. You need to ensure that stale resource records are automatically removed from contoso.com.  What should you do?（）
    A

    Enable aging and scavenging on the contoso.com zone.

    B

    Convert contoso.com to an Active Directory-integrated zone.

    C

    From the start of authority （SOA） record for contoso.com， change the refresh interval.

    D

    From the start of authority （SOA） record for contoso.com， change the TTL For This Record value.


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

  • 第24题：

    单选题
    SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）
    A

    direct-path load

    B

    conventional path load


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

相关内容