单项选择题Under the Oracle Shared Server architecture, client-user processes ultimately connect to a()

A.service
B.listener
C.dispatcher
D.shared server process


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two are true regarding direct-path exports?()

A.Direct-path export is typically faster.
B.Direct-path export can be invoked interactively.
C.Direct-path export is character set independent.
D.Direct-path export bypasses the SQL-command processing layer.
E.Direct-path export can be used to export rows containing LOBs and BFILEs.

2.单项选择题The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.

A.large pool
B.shared pool
C.data buffer cache
D.redo log buffer
E.data dictionary cache

3.单项选择题When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()

A.RMAN keeps a list of archive logs in a text file.
B.The DBA must manually tell RMAN which archive logs to backup.
C.RMAN has access to target control file and/or catalog information.
D.RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

4.单项选择题What is the purpose of importing from an export,and specifying that no rows be imported and that the output goes to a log file?()

A.To verify space requirements in the target database before importing.
B.To generate the SQL for the DDL operations that would occur during import.
C.To check character set compatibility between the export file and the target database.
D.To check for integrity constraint violations that would occur in the target database.

5.多项选择题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()

A.data files
B.backup sets
C.control files
D.archived redo log files

6.单项选择题Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

A.A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
B.During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
C.After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
D.At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

10.单项选择题Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()

A.user-managed backups.
B.partial database backups.
C.consistent database backups.
D.inconsistent database backups.

最新试题

SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario?()

题型:单项选择题

Which of the following commands must be issued to remove a stored script from the recovery catalog?()

题型:单项选择题

Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users?()

题型:单项选择题

Which Oracle background process frees SGA resources that were allocated to a user process that failed?()

题型:单项选择题

Which of the following roles must be granted to a user to perform a full database import?()

题型:单项选择题

If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available, what would the status of this backup piece be in the RMAN repository?()

题型:单项选择题

You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()

题型:单项选择题

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()

题型:单项选择题

Which of the following environment variables specifies a non-default location for the listener configuration file?()

题型:单项选择题

Which of the following parameters must be specified to define the number of dispatchers that need to be started?()

题型:单项选择题