Oracle Database 12c Essentials - 1z1-497 模擬練習
Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?
正解: C
Which tablespace contains the data dictionary, being automatically created at database creation?
正解: C
解説: (PassTest メンバーにのみ表示されます)
Your customer is looking for a solution to address these downtime needs:
-Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
-Dynamically add or remove clustered nodes without disrupting the database or applications.
-Automate the sizing and distribution of shared memory.
-Add a column with a default value without disrupting the database or applications.
-Perform rolling patch upgrades.
Which four would you recommend to address those needs?
-Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
-Dynamically add or remove clustered nodes without disrupting the database or applications.
-Automate the sizing and distribution of shared memory.
-Add a column with a default value without disrupting the database or applications.
-Perform rolling patch upgrades.
Which four would you recommend to address those needs?
正解: A,D,E,F
Which three components are always part of System Global Area?
正解: A,D,E
解説: (PassTest メンバーにのみ表示されます)
Your database is down. You log in as the SYS user and issue this command:
SQL> STARTUP
What happens after the instance is started?
SQL> STARTUP
What happens after the instance is started?
正解: D
解説: (PassTest メンバーにのみ表示されます)
Which statement about the Oracle Advanced Security Data Redaction feature is true?
正解: B
解説: (PassTest メンバーにのみ表示されます)
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
正解: B,C,D
解説: (PassTest メンバーにのみ表示されます)
When executing shutdown abort in a pluggable database (PDB), you ____________.
正解: D
You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.
Which statement is true in this situation?
Which statement is true in this situation?
正解: D
Examine the table: Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?
正解: D,E