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

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

• A.You have to copy the seed data files yourself,
• B.The seed pluggable database does not require data files.
• C.The seed pluggable database can be dropped.
• D.The seed pluggable database is not required.
• E.You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.
• F.The seed pluggable database is not a container.
• G.The seed pluggable database is always kept in READ ONLY mode.

Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?

• A.The instance is started.
• B.The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.
• C.The PDBs are mounted.
• D.The CDB control files are opened for the instance.
• E.The root is opened.
• F.The PDBs are mounted, and the seed is opened in READ ONLY mode.
• G.The root is mounted.

Which normalization level is adopted in real-world database systems?

• A.BCNF
• B.2NF
• C.1NF
• D.3NF

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

• A.You can perform incomplete recovery by using the command:
  RESTORE DATABASE;
  FROM TAG "consistent_whole_backup";
  RECOVER DATABASE NOREDO;
• B.Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
• C.You can perform complete recovery by using the command:
  RESTORE DATABASE
  FROM TAG"consistent_whole_backup";
  RECOVER DATABASE;
• D.Media recovery is possible in most cases.

Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?

• A.The ORDERS table is the only object created in the USERS tablespace.
• B.The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.
• C.A CHECK constraint is created on the OID column.
• D.A NOT NULL constraint is created on the OID column.
• E.The ORDERS table and a unique index are created in the USERS tablespace.