The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
第1题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()
A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT
第2题:
You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()
第3题:
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
第4题:
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?()
第5题:
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?()
第6题:
to enable operating system authentication for a remote client
to restrict the scope of administration to identical operating systems
to allow the start up and shut down of the database from a remote client
to enable the administration of the operating system from a remote client
to disable the administration of the operating system from a remote client
第7题:
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
第8题:
Only 1
Only 2
Only 3
3 and 1
1 and 2
第9题:
System privileges apply only to the PDB in which they are used.
Local users cannot use local system privileges on the schema of a common user.
The granter of system privileges must possess the set container privilege.
Common users connected to a PDB can exercise privileges across other PDBs.
System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
第10题:
Set DYNAMIC_SAMPLING to level 4
Set the STATISTICS_LEVEL parameter to BASIC
Set the INCREMENTAL value to TRUE for the partition table
Increase the value of STALE_PERCENT for the partition table
第11题:
Data files that belong to only the root container
Data files that belong to the root container and all the pluggable databases (PDBs)
Data files that belong to only the root container and PDB$SEED
Data files that belong to the root container and all the PDBs excluding PDB$SEED
第12题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it
第13题:
To make audit information more productive, the DBA executes the following command before startingan audit operation: SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()
第14题:
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors, such as erroneously dropping users, tables, and important data, to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database, you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors, you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running?()
第15题:
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
第16题:
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
第17题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?()
第18题:
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
第19题:
Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
The command will, create a common user whose description is contained in the root and each pdb.
The schema for the common user C # # A_ADMIN can be different in each container.
The command will create a user in the root container only because the container clause is not used
第20题:
Set MEMORY_TARGET to zero
Set the STATISTICS_LEVEL parameter to BASIC
Set the WORKAREA_SIZE_POLICY parameter to MANUAL
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第21题:
Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
第22题:
It succeeds because the PDB_ADMIN user has the required privileges.
It fails because common users are unable to use the SET CONTAINER statement.
It fails because local users are unable to use the SET CONTAINER statement.
If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
第23题:
ALL
PFILE
BOTH
NONE
SPFILE
MEMORY
INSTANCE
DATABASE
第24题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it.