Concentrate Son(C-SON)
Distributor Son(D-Son)
intellegence Son(I-Son)
Hybrid Son(H-SON)
第1题:
Given a web application in which the cookie userName is expected to contain the name of the user. Which EL expression evaluates to that user name?()
第2题:
Which one is a system privilege?()
第3题:
You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string?()
第4题:
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()
第5题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第6题:
Concentrate Son(C-SON)
Distributor Son(D-Son)
intellegence Son(I-Son)
Hybrid Son(H-SON)
第7题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第8题:
a table name which has 100s of records
a table name which has 10s of records
a table name which has empty records
a table name which has 1000s of records
never use a table name
第9题:
the one provided in a dictionary
the one which best fits the context
the central or core meaning of the item
the one which is assumed to he correct
第10题:
The code will be executed successfully.
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
第11题:
mydb is a service name.
test.us.oracle.com is a database name.
1521 is the listener port number.
mydb is a host name.
test.us.oracle.com is a net service name.
hr is a username.
test.us.oracle.com is an instance name.
第12题:
SYSTEM tablespace
SYSAUX tablespace
Undo tablespace
The tablespace of the Index Organized Table (IOT)
第13题:
You executed the following code: SQL> CERATE TABLE COUNTRY (COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_nn NOT NULL, COUNTRY_NAME VARCHAR2(20), CURRENCY_NAME VARCHAR2(20), CONSTRAINT COUNTRY_ID_PK PRIMARY KEY (COUNTRY_ID)) ORGANIZATION INDEX; Which types of tables will be created automatically?()
第14题:
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?()
第15题:
You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME => ’JOB_A’, ATTRIBUTE => ’JOB_PRIORITY’, VALUE => 7); END; / After analyzing the above code, what conclusion will you draw?()
第16题:
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()
第17题:
journal table
clustered table
mapping table
partitioned table
第18题:
It is executed first in the query execution
It must be the last clause in the SELECT statement
It cannot be used in a SELECT statement containing a HAVING clause
You cannot specify a column name followed by an expression in this clause
You can specify a combination of numeric positions and column names in this clause
第19题:
The FLASHBACK TABLE statement will not be written to the alert log file.
The changes made to the EMP table since the specified time will be undone.
The EMP table that was dropped by mistake from the database will be restored.
The FLASHBACK TABLE statement will be executed within a single transaction.
The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
The list of transactions that have modified the EMP table since the specified time will be displayed.
第20题:
Kerberos
Domain Name Server
Secure Sockets Layer
Resource Monitoring and Control
第21题:
log_file_name_convert
convert_log_file_name
file_name_convert_log
redo_log_file_name_convert
logfile_convert_directory
第22题:
It would return information regarding only the last committed transaction.
It would return only the active transactions in all the undo segments in the database.
It would return only the committed transactions in all the undo segments in the database.
It would return both active and committed transactions in all the undo segments in the database.
It would return information regarding the transactions that began and were committed in the last 30 minutes.
第23题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第24题:
satellite
galaxy
planet
meteor