第一学期はACCESSを学んで、第二学期はSQL SERVER を学びます。2000から後先生からOracle
が悪くないことを聞いて、Oracleの存在を知っていることを始めます、SQL SERVERの基礎があって、とても簡単だと感じて、第3学期の末まで、学部はOracleの認証を重視し始めて、そして強力に学友達にOracle認証試験を受けることを支えられる上に10日の無料の育成訓練があります。そこで、私は申し込んで参加して、10日の育成訓練を始めました。
この時間は本当に0からOracleを学びます。Oracle認証は3つの等級を分けて、OCAとOCPとOCMです。OCAは技師補佐で、OCPはデータベースの専門家で、OCMは先輩の専門家です。10日のOracle1z0-047を育成訓練した後に、まあまあ良いと感じて、そんなに難しくなくて、ずっと家にいって勉強し始めます。2ヶ月努力して、ついに試験場に着きました。成績単がプリントして47題正しく答えました、やっと合格しました。第4学期も授業をサボってOracle管理の課程を勉強しに行きます
夏休みIT LIBの実験ビデオ教程をもう一回見て、KILLTEST問題集を読み始めます、KILLTEST問題集は205題があって、大部分は単項選択問題で、多項選択題は1/3占めて、KILLTEST問題集を読みながら分からないところにめーもを取ります。びっくりさせたのは1Z0-042試験でKILLTEST問題集はたくさん出題されました。私この喜びをみんなと分かち合いたいです
これは1Z0-050 の問題集で一緒に勉強しましょう
4.Which statement describes the effect of table redefinition on the triggers attached to the table?
A.All triggers on the table remain valid.
B.All triggers on the table are invalidated and are automatically revalidated with the next DML execution
on the table.
C.All triggers on the table are invalidated and must be manually recompiled before the next DML
execution on the table.
D.Only triggers that are affected by the changes to the structure of the table are invalidated and
automatically revalidated with the next DML execution on the table.
Correct:B
5.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to
convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.
Which methods would you use to achieve this? (Choose all that apply.)
A.Use Data Pump to transfer the existing data to a new encrypted tablespace.
B.Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
C.Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
D.Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt
the tablespace.
E.Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in
the tablespace is automatically encrypted.
Correct:A B C
6.Evaluate the following block of code: BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl
=> 'mycompany-com-permissions.xml', principal => 'ACCT_MGR', is_grant => TRUE, privilege =>
'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl =>
'mycompany-com-permissions.xml', host => '*.mycompany.com'); END; What is the outcome of
the above code?
A.It produces an error because a fully qualified host name needs to be specified.
B.It produces an error because the range of ports associated with the hosts has not been specified.
C.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and
RESOLVE privileges.
D.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but
not the RESOLVE privilege.
Correct:C
7.Which steps are mandatory to enable Direct NFS? 1. Mount all required file systems using the
kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be
accessed using Direct NFS. 3. Replace the ODM library libodm11.so_stub with libodm11.so.
A.2 and 3
B.1 and 3
C.1 and 2
D.1, 2 and 3
Correct:B
8.Which statements are true regarding the concept of problems and incidents in the fault
diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)
A.The problem key is the same as the incident number.
B.Every problem has a problem key, which is a text string that describes the problem.
C.The database makes an entry into the alert log file when problems and incidents occur.
D.The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
E.Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
Correct:B C D
9.You are managing an Oracle Database 11g database. You want to take a backup on tape drives
of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB
each. To accomplish the backup, you issued the following RMAN command: RMAN>BACKUP
SECTION SIZE 300M TABLESPACE users; What configuration should be effected to accomplish
faster and optimized backups by using the above command?
A.The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.
B.The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
C.The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D.The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
Correct:B