Oracle认证 - 自考题库

出自:Oracle认证

What is the result？（）
A:23
B:234
C:235
D:Compilation fails.

Which code, inserted at line 14, allows the Sprite class to compile?（）
A:Direction d = NORTH;
B:Nav.Direction d = NORTH;
C:Direction d = Direction.NORTH;
D:Nav.Direction d = Nav.Direction.NORTH;

Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery（）
A:Speeds up subsequent media recover actions.
B:Writes any uncorrupted block to disk during the test recovery.
C:Can be invoked by adding the TEST option to any RECOVER command.
D:Allows the Administrator to determine how many blocks are affected by corruption.
E:Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.

You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files（）
A:Archiving will be disabled because the destination for the redo log files is missing.
B:The database instance will shut down and the error details will be logged in the alert log file.
C:Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
D:Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

Which three activities are supported by the Data Recovery Advisor?（）
A:Advising on block checksum failures
B:Advising on inaccessible control files
C:Advising on inaccessible block change tracking files
D:Advising on empty password files
E:Advising on invalid block header field values

Which two statements are true regarding partitioning in Mysql?（）
A:Tables with BLOB and TEXT columns cannot be partitioned
B:Partitioning allows easier management of smaller data sets for certain queries
C:Partitioning allows different columns to be stored in separate files
D:The partitioning expression is an integer or function that returns an integer value or NULL value
E:Partitioning is only available for those storage engines that implements it natively

You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）
A:Oracle WebLogic Domain Upgrade tool
B:Smart Update
C:Smart Upgrade
D:No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.
E:JDeveloper

Note the output of the following query； SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（）
A: The table uses the default Flashback Data Archive.
B: The Flashback Data Archive Is created In the SYSAUX tablespace.
C: The Flashback Data Archive is created in the same tablespace where the tables are stored.
D: The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

用来插入数据记录的工具是（）。
A:SQLPLUS
B:DBCA
C:SYSCONFIG
D:DBMS

Given:

What is the result?（）
A:Compilation fails because of an error in line 7.
B:Compilation fails because of an error in line 9.
C:If you define D e = new E(), then e.bMethod() invokes the version of bMethod() defined in Line 5.
D:If you define D e = (D)(new E()), then e.bMethod() invokes the version of bMethod() defined in Line 5.
E:If you define D e = (D)(new E()), then e.bMethod() invokes the version of bMethod() defined in Line 9.

While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
A:A primary key must have been created.
B:A mapping table must have been created.
C:An overflow tablespace must have been specified.
D:The PCTTHRESHOLD option must have been specified.

写出三种以上常用的数据类型。

Given：

What is the result？（）
A:Exception
B:A NullPointerException is thrown at runtime.
C:Compilation fails because of an error in line 20.
D:Compilation fails because of an error in line 14.

Identify the two optional WebLogic security providers in an Oracle WebLogic security realm（）
A: Authentication Provider
B: Adjudication Provider
C: Authorization Provider
D: Auditing Provider

You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files. How would you recover the database from this situation？（）

A:A
B:B
C:C
D:D
E:E

By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.
A: Flashback Table
B: Flashback Database
C: Flashback Version Query
D: The RMAN REPORT command
E: The DBA_PENDING_TRANSACTIONS view

You executed the following PL/SQL block successfully:

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.（）
A:with the CPU Usage finding if it is less than 90
B:without the CPU Usage finding if it is less than 90
C:with the CPU Usage finding for snapshots below 90
D:with the CPU Usage finding for snapshots not between 150 and 162

You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
A: back up the control file to trace
B: bring database to the MOUNT state
C: open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D: set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. What happens to the new DML operations in this scenario（）

A:The DML commands will fail.
B:The undo data generated by the DML is stored in one of the two other undo tablespaces.
C:The undo data generated by the DML will overwrite the extents that contain committed undo data.
D:The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
A:Oracle Data Pump.
B:An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
C:An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
D:Online Table Redefinition.
E:Edition-Based Table Redefinition.

Given:

Which three methods, inserted individually at line 14, will correctly complete class Two?（）
A:int foo() { }
B:void foo() { }
C:public void foo() { }
D:private void foo() { }
E:protected void foo() { }

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）
A:A list of SQL statements and recommendations for tuning
B:A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C:Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D:All of the above

You issued the following commands to configure setting in RMAN;

Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
A:The backup will terminate because the FORMAT clause was not configured for the channel
B:It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C:It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D:It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？（）
A: PUBLIC should be replaced with specific usernames.
B: ALL should be replaced with a list of specific privileges.
C: WITH GRANT OPTION should be added to the statement.
D: Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

Which is a restriction on a list partitioned table？（）
A:You cannot create global range partitioned indexes on the table.
B:The optimizer will not execute partition wise joins on the table’s partitions.
C:You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL.
D:Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

A snapshot of the /export/project file system has been taken. Prior to backing up the file system， you need to check to see if certain files are on the snapshot. The snapshot needs to be mounted to check for these files. Which command will mount the snapshot？（）
A: mount -F ufs -o ro /dev/fssnap/0 /check
B: mount -F ufs -o rw /dev/fssnap/0 /check
C: mount -F ufs -o ro /export/project /check
D: mount -F ufs -o rw /export/project /check

Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
A:The constraint remains valid.
B:The index on the constraint is dropped.
C:It allows the loading of data into the table using SQL *Loader.
D:New data conforms to the constraint， but existing data is not checked.
E:It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

Which statements are true regarding SecureFile LOBs？（）
A: The amount of undo retained is user controlled.
B: SecureFile LOBs can be used only for nonpartitioned tables.
C: Fragmentation is minimized by using variable-sized chunks dynamically.
D: SecureFile encryption allows for random reads and writes of the encrypted data.
E: It automatically detects duplicate LOB data and conserves space by storing only one copy.

在Oracle中，在以下情形建立位图索引可以获得较好的性能（）。
A:在列值唯一的列上建立
B:在列值相差很小的列上建立
C:在列值频繁重复的列上建立
D:在用于保存位图的列上建立

Which of the following calendaring syntax expressions would evaluate to the last day of every month？（）
A: FREQ = MONTHLY； BYMONTHDAY = 31
B: FREQ = MONTHLY； BYMONTHDAY = -1
C: FREQ = DAILY； BYDAY = -1
D: FREQ = MONTHLY； BYDAY = 31
E: FREQ = DAILY； BYMONTHDAY = LAST_DAY

首页 <上一页 86 87 88 89 90 下一页> 尾页