网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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” 相关考题
考题 Input data from keyboard are stored in(71) for processing.A.modemB.busC.memoryD.printer

考题 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.

考题 ● Input data from keyboard are stored in (72) for processing.(72)A.modemB.busC.memoryD.printer

考题 Which two statements about the SQL Management Base (SMB) are true?() A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

考题 Whenever new information is entered, it must be stored somewhere in the computer's(70). RAM only(71)the data temporarily. That is, all information stored in the RAM will disappear if you switch the computer off.A.processorB.keyboardC.printerD.memory

考题 All data are stored in stacked semiconductor dynamic RAM memory boards; the information recorded,the()rate,and the order in which the data are stored differ.A.receiving B.stacking C.sampling D.erasing

考题 George got information about Richard from ______.A. a dictionary collector in Australia B. the latter’s rivals DylansC. a rare first edition of a dictionary D. the wrapping paper of a book

考题 A major difference between archiving and backing up data is that data backups:()A、contain data removed from the server.B、contain data that still resides on the server.C、are stored with the servers.D、are stored securely.

考题 A customer is planning to migrate a financial application to a 12-way p5-570 system with 96GB of memory.  The application data is stored on an ESS Model 800 attached to a p670 server with AIX 5.2.  They will have a short outage window to perform the data migration.  What is the quickest way to move all the data stored on the attached ESS from the p670 to the new p5-570?()A、Use rsync to synchronize the data across servers.B、Use exportvg and importvg to move the data to the target system.C、Use NFS to copy the data from the source system to the target system.D、Backup the data from the source system and restore to the target system.

考题 The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache

考题 Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()A、V$DATAFILEB、V$DATAFILE_HEADERC、DBA_DATA_FILESD、V$DBFILEE、V$DATAFILE_ERRORS

考题 You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache

考题 What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?() A、The filename format. B、Information stored inside a data dictionary table. C、Information stored in the ALERT.LOG file for the corresponding instance. D、Information stored inside the corresponding initialization parameter file for the instance.

考题 You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?()A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

考题 多选题Some data storage and transfer media have fixed-length physical records.  When the data records are short, more then one can be stored in a single, physical record to use the storage space efficiently. Consider this data:   1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas   Which two statements can you use to load the data into the EMP table?()AABBCCDD

考题 多选题Which two statements about the SQL Management Base (SMB) are true?()AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.

考题 单选题You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?()A Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. B Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C Choose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. E Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

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

考题 单选题ou need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created?()A  It is a list of remote database links stored in the XML file that are available to the users of the database.B  It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.C  It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.D  It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

考题 多选题Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.

考题 单选题Stephen Smith feels thatA the security of information on the network used to be a worry.B all the data should be stored on the same system.C the company’s computer-based information is well-protected.

考题 单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?()A The filename format. B Information stored inside a data dictionary table. C Information stored in the ALERT.LOG file for the corresponding instance. D Information stored inside the corresponding initialization parameter file for the instance.

考题 单选题The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.A large poolB shared poolC data buffer cacheD redo log bufferE data dictionary cache

考题 单选题A major difference between archiving and backing up data is that data backups:()A contain data removed from the server.B contain data that still resides on the server.C are stored with the servers.D are stored securely.

考题 单选题Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()A V$DATAFILEB V$DATAFILE_HEADERC DBA_DATA_FILESD V$DBFILEE V$DATAFILE_ERRORS

考题 单选题What does the Metadata Application Programming Interface (API) allow you to do?()A Repair damaged data dictionary entries.B Delete data dictionary information about database objects you no longer need.C Extract data definition commands from the data dictionary in a variety of formats.D Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator

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