1Z0-052

多选题Which  statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn

题目
多选题
Which  statements regarding the server parameter file (SPFILE) are true()
A

An SPFILE is a binary file.

B

An SPFILE cannot reside on a client.

C

An SPFILE cannot contain static parameters.

D

An SPFILE can store changes persistently across instance restarts.

E

An SPFILE can be read by the database server, but it is not written to by the server.

F

An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which tow statements are most correct regarding opt-in models?()

  • A、A based opt-in model uses virtualized identifiers
  • B、A based opt-in model uses hardware values as identifiers
  • C、A logical server opt-in model uses virtualized identifiers
  • D、A logical server opt-in model uses hardware values as identifiers

正确答案:B,C

第2题:

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()

  • A、Displays only the list of default values
  • B、Displays only the list of all basic parameters
  • C、Displays the currently in effect parameter values
  • D、Displays only the list of all advanced parameters
  • E、Displays the list of all the parameter files of a database
  • F、Displays the current contents of the server parameter file.

正确答案:C

第3题:

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece


参考答案:B, C, E

第4题:

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()

  • A、 The backup contains data files, the server parameter file,and the control file even if the control file  autobackup is disabled.
  • B、 The KEEP option overrides the configured retention policy.
  • C、 The backup contains only data files and archived redo log files.
  • D、 The KEEP option is an attribute of an individual backup piece.

正确答案:A,B

第5题:

The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files()

  • A、It will be created on the local file system.
  • B、It will be created only in the Flash Recovery Area.
  • C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
  • D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

正确答案:A

第6题:

Which two statements are true regarding trace options on Junos devices?()

  • A、You can see the contents of the log file by entering the show log <filename> command
  • B、Trace options will send information to your screen automatically
  • C、Trace options are limited to one protocol at a time
  • D、The file name and set of flags may be specified when enabling trace options

正确答案:A,D

第7题:

You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()

  • A、 the alert log file
  • B、 the server parameter file
  • C、 the formatted name of a control file autobackup
  • D、 an RMAN session log file
  • E、 the trace file

正确答案:C,D

第8题:

You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB

B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually

C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively


参考答案:A, D

第9题:

What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()

  • A、It can contain parameters with distinct values for each distance.
  • B、It can contain only parameters with identical values for each instance.
  • C、It must contain an IFILE parameter for each instance’s individual parameter file.
  • D、It must be located in the default location for the primary instance’s parameter file.

正确答案:A

第10题:

You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)

  • A、The KEEP option overrides the configured retention policy
  • B、The KEEP option is an attribute of an individual backup piece
  • C、The backup contains only data files and archived redo log files
  • D、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

正确答案:A,D

更多相关问题