v13.02专题
OCP-1Z0-053-V13.02-632题
632.Note the following parameter settings: Which setting is NOT allowed? A. ALTER SYSTEM SET DB_CACHE_SIZE=50M; B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M; C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M
OCP-1Z0-053-V13.02-570题
570.What methods of point-in-time recovery are available? (Choose all that apply.) A. Change-based B. Cancel-based C. Time-based D. Sequence number-based E. Transaction number-based Answer: ABCD
OCP-1Z0-053-V13.02-325题
325.Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.) A. until time B. until change C. until sequence D. until SCN
OCP-1Z0-053-V13.02-358题
358.What command is used to reset a database to a previous incarnation? A. reset incarnation B. incarnation reset C. reset database to incarnation D. reset database incarnation E. reset databs
OCP-1Z0-053-V13.02-182题
182.Which of the following files cannot be backed up by RMAN? (Choose all that apply.) A. Database datafiles B. Control files C. Online redo logs D. Database pfiles E. Archived redo logs Answer:
OCP-1Z0-053-V13.02-491题
491.Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by de
OCP-1Z0-053-V13.02-450题
450.Which of the following are valid program types for a lightweight job? (Choose all that apply.) A. PLSQL_BLOCK B. EXECUTABLE C. JAVA_STORED_PROCEDURE D. STORED_PROCEDURE E. EXTERNAL Answer: A
OCP-1Z0-053-V13.02-538题
538.Which type of database file is spread across all disks in a disk group? A. All types of files are spread across all disks in the disk group. B. Datafiles C. Redo log files D. Archived redo log
OCP-1Z0-053-V13.02-477题
477.Which of the following is not a valid linguistic sort element? A. Accent expansion B. Canonical equivalence C. Reverse secondary sorting D. Ignorable characters E. Character rearrangement An
OCP-1Z0-053-V13.02-473题
473.How many different calendars does Oracle 11g support? A. 22 B. 7 C. 6 D. 15 E. 2 Answer: B 答案解析： 参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215
OCP-1Z0-053-V13.02-458题
458.Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature? A. RSTLNE B. NLSRTL C. LISTENER D. NLSSORT E. Linguistic sorts An
OCP-1Z0-053-V13.02-404题
404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values? A. Filter versions B. Filter loads C.
OCP-1Z0-053-V13.02-67题
67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.) A. fixed tables B. heap tables C. external tables D. temporary tables E. Index-
OCP-1Z0-053-V13.02-698题
698. In your production database, you: -Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals -Set the control file autobackup to “on” -Are