Which two statements are true about v$asm – views in cl…

Which two statements are true about v$asm – views in clustered environment?

A.
They exist both in ASM and RDBMS instances, and display the same output.

B.
Their names can be seen in dict when connected to an ASM instance.

C.
Their names can be seen in v$fixed_table when connected to an instance of any type that is started.

D.
They exist in both in ASM and RDBSM instances, but they can display different outputs depending on he instance type.

E.
gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

Show Hint

← Previous question

Next question →

Leave a Reply 16

godo77

D and E correct

ziad abuqasem

C and D correct

C: when you connect to ASM instance or RDBMS instance and reun the following commnad it will show the V$ASM_ views
select name from v$fixed_table where name like ‘%ASM%’;

D: some asm views will not show data when you connect to RDBMS instance and will show data when you connect to ASM instance

E: wrong gv$asm_attribute cannot display ASM_POWER_LIMIT
B: wrong DICT not exist when you connect to ASM instance

Rayder

Agree, I have tested.

WGCM

I think that “C”, “D” and “E” is correct!

WGCM

Ok! Ziad is right! “C” and “D”, not “E”!

Views Containing Oracle ASM “Disk Group Information”

V$ASM_ATTRIBUTE – Displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically. Attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.

See: http://asmsupportguy.blogspot.com.br/2012/01/asm-file-number-9.html

Hi when I sit for exam I got separate Q’s – at least 30 different questions. I also think there are many wrong answers here.

ALEX

Hi MM, Have you passed the exam ??

Eva

The dumps from TestKing have 158 questions now.

158 Questions & Answers with Testing Engine
“Oracle Database 12c: RAC and Grid Infrastructure Administration Exam”, also known as 1z0-068 exam, is a Oracle certification exam.

Lobo43

Hi Eva,

Have you passed the exam with TestKing test?
Thank you very much.
Regards

amitst01

Hello Everyone,

I have few more questions to clarify.

Could I share those questions here to discuss and solve?

Please let me know.

Thanks for your time and help.

Regards,
Amit

E-Mail: [email protected]

amitst01

All,

Please let me know what could be the answer to the below question:

QUESTION NO: 1

Examine this command:

SQL> ALTER TABLESPACE TBS1 ADD DATAFILE
‘+DATA(newtemplate)/ORCL/USERS/mytab.dbf’ SIZE 100M;
Which two statements are required for this command to succeed? (Choose two.)

A. The DB_CREATE_FILE_DEST parameter must be set to+DATA(newtemplate).
B. newtemplatemust be defined for the+DATAdisk group.
C. Existing datales inTBS1must also use the same template.
D. The +DATA disk group should not be part of Flex ASM.
E. User-defined subdirectoriesORCLandUSERSmust already exist.

NTH

In my opinion, I think B and E.

Lobo43

Hi Amit,

This test question is new, do you have a new test with new questions?

Thank you very much.
Regards

Aunkut

Hi amitst01,

Pass your q’s here. I am very sure. within two weeks you will get right answers.

Cheers

srks

A – Output differs
B – can’t view in mount state
E – its a parameter not an attribute

goszczu

C,D

select name from v$fixed_table where name like ‘V$ASM%’;

NAME
————————————————————
V$ASM_TEMPLATE
V$ASM_ALIAS
V$ASM_FILE
..

V$ASM_FILE
n an Automatic Storage Management instance, V$ASM_FILE displays one row for every Automatic Storage Management file in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_FILE displays no rows.