1z1-072 試験問題を無料オンラインアクセス

Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

• A.Users granted either SYSDBA or SYSOPER can query data in all user schemas.
• B.Only users granted SYSDBA can query or update tables in all user schemas.
• C.Only users granted SYSDBA can take a complete backup of a database.
• D.Users granted either SYSDBA or SYSOPER can mount or open a database.
• E.Only users granted SYSDBA can start up and shut down a database instance.
• F.Users granted either SYSDBA or SYSOPER connect to an instance as SYS.

Which two are true about the AL32UTF8 character set? (Choose two.)

• A.It is used to store PL/SQL source code.
• B.It uses less space than other character sets, for all data types.
• C.It improves the I/O performance of a database compared to other character sets.
• D.It supports multilingual databases.
• E.It is used to encode data for columns of any data type.

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

Which two actions are performed? (Choose two.)

• A.The control file is read.
• B.The Oracle background processes are started.
• C.The alert log records the execution details.
• D.The initialization parameter file is read.
• E.The online data files are opened.
• F.The online redo logs are opened.

Which three failures do not require intervention for recovery? (Choose three.)

• A.media failure
• B.user process failure
• C.network interface card (NIC) failure
• D.statement failure
• E.transaction failure

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.It is read-only by default.
• B.The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
• C.It is offline by default.
• D.It uses the default blocksize used at database creation.
• E.DML operations performed on objects in this tablespace are not logged by default.
• F.It is a locally managed tablespace.