1 and 3
2, 3, and 5
1, 2, and 3
2, 3, 4, and 5
第1题:
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()
第2题:
Which statements are true regarding the Query Result Cache?()
第3题:
Which two statements about bigfile tablespaces are true? ()
第4题:
Which three statements are true about Automatic Workload Repository (AWR)?()
第5题:
Note the points about data dictionary views and dynamic performance views: 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views()
第6题:
These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done()
第7题:
1 and 3
2,3,and 5
1,2,and 3
2,3,4,and 5
第8题:
1 and 3
2, 3, and 5
1, 2, and 3
2, 3, 4, and 5
第9题:
Use the DESCRIBE command in the EMP_DEPT VU view.
Use the DEFINE VIEW command on the EMP_DEPT VU view.
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
第10题:
A role can be granted to itself.
Roles are owned by the SYS user.
Roles can be granted to other roles.
A role cannot be assigned external authentication.
A role can contain both system and object privileges.
第11题:
The bigfile tablespace have only one data file.
The segment space management is automatic.
The extent management is dictionary managed.
The database can have only one bigfile tablespace.
The bigfile tablespace can be converted to a smallfile tablespace.
第12题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks
第13题:
Which statements listed below describe the data dictionary views() 1) These are stored in the SYSTEM tablespace. 2) These are the based on the virtual tables. 3) These are owned by the SYS user. 4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5) The V$FIXED_TABLE view can be queried to list the names of these views.
第14题:
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
第15题:
Which two statements are true about simple views?()
第16题:
Which three statements are correct about temporary tables?()
第17题:
Which two statements are true about the roles in the Oracle database?()
第18题:
Which two statements are true regarding single row functions?()
第19题:
It contains only SQL profiles generated by SQL Tuning Advisor.
It stores plans generated by the optimizer using a stored outline.
It is part of the data dictionary and stored in the SYSAUX tablespace.
It is part of the data dictionary and stored in the SYSTEM tablespace.
It contains the statement log, the plan history, plan baselines, and SQL profiles.
第20题:
Indexes and views can be created on temporary tables.
Both the data and the structure of temporary tables can be exported.
Temporary tables are always created in a user’s temporary tablespace.
The data inserted into a temporary table in a session is available to other sessions.
Data manipulation language (DML) locks are never acquired on the data of temporary tables.
第21题:
SQL statements that are part of the AWR baseline only
SQL statements based on the AWR top SQL identification
SQL statements that are part of the available SQL Tuning Set (STS) only
SQL statements that are available in the cursor cache and executed by a user other than SYS
第22题:
It can be set at the system, session, or table level.
It is used only across statements in the same session.
It can store the results from normal as well as flashback queries.
It can store the results of queries based on normal,temporary,and dictionary tables.
第23题:
1 and 2
2 and 5
1,3,and 4
3,4,and 5
1,2,3,and 4
第24题:
1 and 3
2, 3, and 5
1, 2, and 3
2, 3, 4, and 5