搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）

A、The modified data are not available on disk.

B、The modified data have been flushed out from memory.

C、The modified rows of the SupportCenter STAFF table have been locked.

D、Jack has not committed the changes after modifying the value.

E、Both users are accessing the database from two different machines.

查看正确答案
更多“Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）”相关的问题
第1题
[单选题] A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）

A、one server having at least two processors    B、two servers having one processor and one logical database partition    C、one server having four processors and two logical database partitions    D、two servers each having four processors and two logical database partitions  

点击查看答案
第2题
[单选题] How many database instances are used during a database-duplication process？（）

A、 One  B、 Two  C、 Three  D、 Four  E、 Five  

点击查看答案
第3题
[多选题] Which two database operations can be performed at the MOUNT stage of database startup？（）

A、renaming of data files  B、dropping the database user  C、renaming of control files  D、multiplexing of control files  E、configuring the database in ARCHIVELOG mode  

点击查看答案
第4题
[多选题] In which two environments would intra-partition parallelism be used? （）

A、Single database partition, single processor    B、Single database partition, multiple processors    C、Multiple database partitions, single processor    D、Multiple database partitions, multiple processors  

点击查看答案
第5题
[单选题] Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

A、Shut down the database, restore the two data files and then start up the database.   B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.   C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open.   D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.  

点击查看答案
第6题
[多选题] Which two are valid locking levels that are used by transactions in an Oracle database？（）

A、row level  B、block level  C、object level  D、schema level  E、database level  

点击查看答案
第7题
[多选题] Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

A、adding a new user to the database  B、dropping a user from the database  C、dropping a table from the database  D、dropping a data file from a tablespace  E、adding a new tablespace to the database  

点击查看答案
第8题
[多选题] Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

A、The database opens normally.  B、The database prompts for a database recovery.  C、The database writer writes to a trace file， indicating that the temporary file is not found.  D、The database gets mounted and throws an error indicating that the temporary file requires recovery.  

点击查看答案
第9题
[多选题] Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A、 The database writer writes to a trace file， indicating that the temporary file is not found.  B、 The database prompts for a database recovery.  C、 The database opens normally.  D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.  

点击查看答案
第10题
[] Which two changes and their effect on the system can be tested by using the Database Replay feature？（）

A、A. multiplexing of the control file  B、B. adding the redo log member to the database  C、C. database and operating system upgrades  D、D. changing the database storage to ASM-managed storage  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服