更多"Users in your produc"的相关试题:
[多项选择]Which four are correct guidelines for naming database tables?（）
A. Must begin with either a number or a letter.
B. Must be 1-30 characters long.
C. Should not be an Oracle Server reserved word.
D. Must contain only A-Z, a-z, 0-+, _, *, and #.
E. Must contain only A-Z, a-z, 0-9, _, $, and #.
F. Must begin with a letter.
[单项选择]A new storage array must be configured for a database server. This array will store transaction logs that are always being written. Which of the following RAID solutions would provide fault tolerance and fast write operations without the use of parity?（）
A. RAID 0
B. RAID 3
C. RAID 6
D. RAID 10
[单项选择]What does the LSP Holdtime field in an IS-IS database indicate?（）
A. the LSP age
B. the LSP refresh interval
C. the LSP elapsed lifetime
D. the LSP remaining lifetime
[单项选择] You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace： RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M； Which statement is true about executing this command？（）
A. The command generates an error.
B. The command backs up the tablespace and creates a backup set of size 200 MB
C. The command backs up the tablespace and creates two backup sets of size 100 MB each.
D. The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
[多项选择] Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
A. drop and recreate the index
B. coalesce the ORDERS_IND index
C. coalesce the INDEXES tablespace
D. drop and recreate the ORDERS table
E. rebuild the index online and move it to another tablespace
[单项选择] You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
A. by using the RMAN utility
B. by using the export/import utility
C. by using the ALTER DATABASE command
D. by enabling the change tracking feature
[单项选择]You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
A. user managed complete recovery
B. user managed incomplete recovery
C. RMAN-based complete recovery
D. RMAN-based incomplete recovery
[单项选择]You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number （SCN）.
[简答题]在当前数据段（DS），偏移地址为DATAB开始的顺序80个单元中，存放着某班80个同学某门考试成绩。按如下要求编写程序：编写程序统计≥90分；80分～89分；70分～79分；60分～69分，＜60分的人数各为多少，并将结果放在同一数据段、偏移地址为BTRX开始的顺序单元中。
