OCP prepare 20140626

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.