资格证大类
You execute this command in MOUNT mode: ALTER DATABASE ARCHIVELOG; Where is the information that the database is now in ARCHIVELOG mode stored?()
A、SPFILE
B、archive log
C、control file
D、system tablespace
C
A System p administrator needs to run the annualreval.sh script, directing standard error to /var/log/reval.err, and appending standard out to /var/log/reval.log. How can this be accomplished ()
A、annualreval.sh 2>&1 /var/log/reval.log 2> /var/log/reval.err
B、annualreval.sh 1>/var/log/reval.log 2>/var/log/reval.err
C、annualreval.sh 2>>&1 /var/log/reval.log /var/log/reval.err
D、annualreval.sh 1>>/var/log/reval.log 2>/var/log/reval.err
D
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()
A、It updates the existing SQL profiles with current statistics
B、It makes the statistics information available to GATHER_STATS_JOB
C、It initiates the statistics collection process by running GATHER_STATS_JOB
D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually
B
What is the most likely problem with this script () VAR=1 ((VAR=$VAR+1)) while [ $VAR -It 10 ] do echo $VAR done
A、#!/bin/ksh line is missing
B、Variable name VAR is not properly initialized
C、Loop variable is not incremented inside the loop
D、Replace brackets with braces
C
Which three SELECT statements display 2000 in the format "$2,000.00"? ()
ASELECT TO_CHAR(2000, '$#,###.##') FROM dual;
BSELECT TO_CHAR(2000, '$0,000.00') FROM dual;
CSELECT TO_CHAR(2000, '$9,999.00') FROM dual;
DSELECT TO_CHAR(2000, '$9,999.99') FROM dual;
ESELECT TO_CHAR(2000, '$2,000.00') FROM dual;
FSELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
B,C,D