网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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” 相关考题
考题
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
考题
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
考题
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.
考题
Did you get the financial records _______ shape for your audit next month?
A into ;B in ;C from
考题
It can be inferred from the last paragraph that outside directors______.A．may stay for the attractive offers from the firmB．have often had records of wrongdoings in the firmC．are accustomed to stress-free work in the firmD．will decline incentives from the firm
考题
The text suggests that early settlers in New EnglandA．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.
考题
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
考题
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 loadB、conventional path load
考题
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.
考题
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
考题
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 modeC、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.
考题
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.
考题
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 intervalB、Configure mailbox （MB） resource records in the external DNS domain. Configure each record so that it has the same default Time to Live （TTL） intervalC、Configure mail exchanger （MX） resource records in the external DNS domain. Configure each record to have the same preference and a different mail exchangerD、Configure mail exchanger （MX） resource records in the external DNS domain. Configure each record to have the same preference and the same mail exchanger
考题
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.
考题
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.
考题
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.
考题
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.
考题
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 intervalC、From the aging properties of the zone， modify the no-refresh interval and the refresh intervalD、From the start of authority （SOA） record of the zone， modify the refresh interval and the expire interval
考题
单选题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
考题
单选题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
考题
单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）A
After two days，a backup will be marked obsoleteB
After two days，a backup will be deleted from the mediaC
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.
考题
单选题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
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE 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.
考题
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）A
After two days, a backup will be marked obsoleteB
After two days, a backup will be deleted from the mediaC
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.
考题
单选题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 modeC
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.
考题
单选题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.
考题
单选题Ellsworth Huntington’s conclusion was based on _____.A
variations of his own mental abilities from season to seasonB
the result of research done by him and other scientists among peoples in different climatesC
detailed records of temperature changes in different placesD
detailed records of different ways of thinking among peoples in different climates
考题
单选题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 loadB
conventional path load
热门标签
最新试卷
