Only MEMORY is updated.
Only SPFILE values are updated.
Only init
Both init
第1题:
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?()
第2题:
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
第3题:
A. Column definitions cannot be altered to add DEFAULT values.
B. A change to the DEFAULT value affects only subsequent insertions to the table.
C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
第4题:
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?()
第5题:
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement: SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’; What will be the result of issuing the above statement?()
第6题:
What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()
第7题:
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
第8题:
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
第9题:
our database instance is started using the server parameter file (SPFILE). You executed a command tochange the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
第10题:
You create an Oracle 10g database and configure the SPFILE as follows: SGA_TARGET=2G DB_CACHE_SIZE=512M LOG_BUFFER=50M DB_KEEP_CACHE_SIZE=128M You modify the SGA_TARGET initialization parameter using the following statement: SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH; Which entity does this statement affect?()