单选题 Your database is configured in ARCHIVELOG mode.Examine the RMAN configuration parameters：CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET ; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default Examine the command：RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; What is the outcome?
A、 It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
B、 It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.
C、 It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.
D、 It fails because the DELETE INPUToption can be used only with the BACKUP AS COPY command.
单选题 Which statement is ture about profile?
A、 A user can exist without any profile
B、 A profile can be assigned only to one user
C、 Password management using profiles is always enabled
D、 Resource limits specified in a profile assigned to a user are always enabled
单选题 Which task is performed by a background process in a database instance?
A、 executing PL/SQL code
B、 create dedicated server connections
C、 connecting between a client process and a dispatcher
D、 copying online redo log files to offline storage
单选题 Examine the details of the uncompressed, non-partitioned heap table CITIES.Name Null TypeCITYIDNOT NULL NUMBER(4.CITYNAME VARCHAR2(50.Examine the command：SQL>ALTER TABLE cities SHRINK SPACE COMPACT; What must you do nefore executing it?
A、
Disbale all indexes on the table
B、
Enable row movement is enabled
C、
ensure there are no pending transactions on the table
D、
Ensure free space that is approximately equal to the space used by the table should be availabel
单选题 The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.Eaxmine these command： conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING ‘orcl12’;What is the outcome of executing these commands in the ORCL1 database?
A、 ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database
B、 ORCL2 database link creation fails
C、 ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database
D、 ORCL2 is created as a publice link to connect a single session to the SALES schema in the ORCL2 database
单选题 What is the outcome of the SHUTDOWN ABORT command?
A、 Uncommitted transations are rolled back
B、 Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files repectively
C、 Instance recovery must be requested by the DBA at the next startup
D、 Pending transactions are committed and the database is closed
单选题 Your database is in NOARCHIVELOG mode. You want to enable archiving for database. Examine the steps：
A、 4,2,5,1,6
B、 1,2,3,4,6
C、 2,3,1,6
D、 2,5,1,6
单选题 Examine the command：SQL> CREATE TABLESPACE test1 DATAFILE ‘/u01/app/oracle/oradata/orcl/test01.dbf’ size 5M AUTOEXTEND ON UNIFORM;Which statement is true?
A、 The data file , TEST01.DBF, can be auto extented to a maximum size of 5M
B、 The table space, TEST1, can contain a maximum of one data file
C、 Allocated and free extents are tracked using bitmaps
D、 Segment free space is tracked in the data dictionary
2020-11-30
共49道
