Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
The user cannot set privileges on persistent lightweight jobs.
Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
The use of a template is mandatory to create persistent lightweight jobs.
第1题:
A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset.
E. The DMU can report columns that are not represented in the converted characterset.
第2题:
A. Tunnels are initiated by the LAC
B. Tunnels are initiated by the LNS
C. By default, subscriber authentication occurs on the LNS
D. By default, subscriber authentication occurs on the LAC
第3题:
Which of the following statements is true regarding the VERSIONS BETWEEN clause?()
第4题:
Which statement is true regarding the INTERSECT operator?()
第5题:
Which two statements are true about pool-based source NAT? ()(Choose two.)
第6题:
Examine the following statement that is used to modify the constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements are true regarding the above command()
第7题:
Which statements are true regarding the Query Result Cache? ()
第8题:
A user cannot set privileges on the persistent lightweight jobs
Persistent lightweight jobs generate a large amount of metadata
It is possible to create fully self-contained persistent lightweight jobs
The use of a template is mandatory to create persistent lightweight jobs
Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
第9题:
FGA is possible on SELECT statements only.
The audit trail for FGA is stored in the FGA_LOG$ table.
The audit trail for FGA is stored in the AUD_LOG$ table.
FGA enables a SQL predicate to define when to audit an event.
FGA audits DELETE statements only when audit columns are specified.
FGA includes the SQL statement used by the user as part of the audit event entry.
第10题:
Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
Amultiplerowsubquerycanbecomparedusingthe;>;;operator.
AsinglerowsubquerycanusetheINoperator.
Amultiplerowsubquerycanusethe;=;operator.
第11题:
A user cannot set privileges on the persistent lightweight jobs
Persistent lightweight jobs generate a large amount of metadata
It is possible to create fully self-contained persistent lightweight jobs
The use of a template is mandatory to create persistent lightweight jobs
Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
第12题:
The VERSIONS BETWEEN clause may be used in DML statements.
The VERSIONS BETWEEN clause may be used in DDL statements.
The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
第13题:
A. PAT is not supported.
B. PAT is enabled by default.
C. It supports the address-persistent configuration option.
D. It supports the junos-global configuration option.
第14题:
Which two statements are true regarding the USING clause in table joins?()
第15题:
Which three statements are true regarding persistent lightweight jobs?()
第16题:
Which two statements are true regarding L2TP? ()(Choose two.)
第17题:
Which three statements are true about persistent configuration?()
第18题:
Which three statements about subqueries are true? ()
第19题:
Enables easier loading of multinational data.
Uses a fixed-width Multibyte encoding sequence.
Asian characters are represented in three characters.
Used a variable-width Multibyte encoding sequence.
European characters are represented on one or two bytes.
第20题:
The constraint remains valid.
The index on the constraint is dropped.
It allows the loading of data into the table using SQL*Loader.
New data conforms to the constraint, but existing data is not checked
It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
第21题:
Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
The user cannot set privileges on persistent lightweight jobs.
Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
The use of a template is mandatory to create persistent lightweight jobs.
第22题:
It ignores NULL values
Reversing the order of the intersected tables alters the result
The names of columns in all SELECT statements must be identical
The number of columns and data types must be identical for all SELECT statements in the query
第23题:
Subqueries can contain GROUP BY and ORDER BY clauses
Main query and subquery can get data from different tables
Main query and subquery must get data from the same tables
Subqueries can contain ORDER BY but not the GROUP BY clause
Only one column or expression can be compared between the main query and subquery
Multiple columns or expressions can be compared between the main query and subquery
第24题:
Each segment contains one or more extents.
Multiple tablespaces can share single data file.
A data block is the smallest unit of I/O for data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one OS block.