1. the query result is not displayed if the null value is <>.
If you want to query, use is not null.
Question No.: 135
View the exhibit and examine the data in the products table. You need to display product
Names from the products table that belong to the 'Software/other1 category with minimum
Prices as either $2000 or $4000 and no unit of measure. You issue theJ following query:
Which statement is true regarding the above query?
A. It executes successfully but returns no result.
B. It executes successfully and returns the required result.
C. It generates an error because the condition specified for prod_unit_of_measure is not
Valid.
D. It generates an error because the condition specified for the prod_category column is not
Valid.
2. Multi-field sorting
Order by is followed by multiple fields cola, colb desc ----> indicates cola ASC, and the default ASC of colb desc is omitted.
3. db_ultra_safe
The db_ultra_safe parameter integrates the db_block_checking, db_block_checksum, and db_lost_write_protect parameters.
Http://www.linuxidc.com/Linux/2012-12/76118p2.htm
4. Block change tracking
Http://blog.csdn.net/tianlesoftware/article/details/6997647
5. RMAN backup expired
Expired indicates that the control file has a record, but it cannot be found in the corresponding directory, that is, it has been deleted or removed.
6.
Question No: 20
You are managing an Oracle Database 11g database with the ASM storage. The database is
Having big file tablespaces. You want files to open faster and less memory to be used in
Shared Pool to manage the extent maps.
What configuration wocould you effect to achieve your objective? (Choose all that apply .)
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the compatible initialization parameter for the ASM instance to 11.1.0.
D. Set the compatible initialization parameter for the database instance to 11.1.0.
7. Data Pump Import
User remap_user
8.