导图社区 OCP记忆要点
- 35
- 0
- 0
- 举报
OCP记忆要点
MySQL OCP是Oracle推出的认证，考试报名需要在Oracle官网。体验确实不太友好。这里列举几点注意事项。a.选择正确的科目代号；b.购买考试券（需要用国外能支持的卡，visa等，没有的话可以找朋友帮忙); c.注册考试输入考试券代码就行。
编辑于2023-03-06 20:12:31 四川省- mysql
- OCP
- 相似推荐
- 大纲
OCP记忆归纳
&&
阻止展示hire date
96
DEFINE+scrip script/执行的不要，use选define &&不要
97.Choose two Examine this query: SELECT employee_id,first_name,salary FROM employees WHERE hire_date > '&1'; Which two methods should you use to prevent prompting for a hire date value when this query is executed? A. Use the DEFINE command before executing the query. B. Store the query in a script and pass the substitution value to the script when executing it. C. Replace '&1' with '&&1' in the query. D. Execute the SET VERIFY OFF command before executing the query. E. Use the UNDEFINE command before executing the query. F. Execute the SET VERIFY ON command before executing the query.
97.Choose two Examine this query: SELECT employee_id,first_name,salary FROM employees WHERE hire_date > '&1'; Which two methods should you use to prevent prompting for a hire date value when this query is executed? A. Use the DEFINE command before executing the query. B. Store the query in a script and pass the substitution value to the script when executing it. C. Replace '&1' with '&&1' in the query. D. Execute the SET VERIFY OFF command before executing the query. E. Use the UNDEFINE command before executing the query. F. Execute the SET VERIFY ON command before executing the query.
选项有&&没有 DEFINE
37
prefixed with &&+子句clause
37. Which two statements are true about substitution variables? A.A substitution variable used to prompt for a column name must be enclosed in double quotation marks. B.A substitution variable prefixed with s always prompts only once for a value in a session C.A substitution variable used to prompt for a column name must be enclosed in single quotation marks D.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session E.A substitution variable can be used only in a SELECT statement F.A substitution variable can be used with any clause in a select statement
37.Which two statements are true about substitution variables? A.A substitution variable used to prompt for a column name must be enclosed in double quotation marks. B.A substitution variable prefixed with s always prompts only once for a value in a session C.A substitution variable used to prompt for a column name must be enclosed in single quotation marks D.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session E.A substitution variable can be used only in a SELECT statement F.A substitution variable can be used with any clause in a select statement
选项有&& 有 DEFINE
31
有&&的 display 选DEFINE+can be used SQL两个
31. Which two statements are true about the SET VERIPY ON command? A.It displays values for variables prefixed with && B.It displays values for variables created by the DEFINE command C.It can be used in SQL Developer and SQL*Plus D. It can be used only in SQL*Plus E. It displays values for variables used only in the WHERE clause of a query
31. Which two statements are true about the SET VERIPY ON command? A.It displays values for variables prefixed with && B.It displays values for variables created by the DEFINE command C.It can be used in SQL Developer and SQL*Plus D. It can be used only in SQL*Plus E. It displays values for variables used only in the WHERE clause of a query
TO-CHAR
73
题干 计算到1月1日的时间 选项：SYSDATE-TO_DATE
73. You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR Which two queries give the required output? A.SELECT ROUND(SYSDATE-TO_DATE('01/JANUARY/2019'))FROM DUAL B.SELECT SYSDATE-TO_DATE('01-JANUARY-2019') FROM DUAL; C.SELECT ROUND(SYSDATE-'01-JAN-2019') FROM DUAL; D.SELECT TO_DATE(SYSDATE, DD/MONTH/YYYY")-'01/JANUARY/2019' FROM DUALI E.SELECT TO_CHAR(SYSDATE, DD-MON-YYYY)-'01-JAN-2019' FROM DUAL;
73.You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR Which two queries give the required output? A.SELECT ROUND(SYSDATE-TO_DATE('01/JANUARY/2019'))FROM DUAL B.SELECT SYSDATE-TO_DATE('01-JANUARY-2019') FROM DUAL; C.SELECT ROUND(SYSDATE-'01-JAN-2019') FROM DUAL; D.SELECT TO_DATE(SYSDATE, DD/MONTH/YYYY")-'01/JANUARY/2019' FROM DUALI E.SELECT TO_CHAR(SYSDATE, DD-MON-YYYY)-'01-JAN-2019' FROM DUAL;
40
选项 to_CHAT+ >
40.The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR Which two WHERE conditions demonstrate the correct usage of conversion functions? A.WHERE order_date=TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY') B.WHERE TO_CHAR(order date, 'MON-DD-YYYY') = 'JAN 20 2019' C.WHERE order_date > TO_DATE('JUL 10 2018','MON DD YYYY') D.WHERE order_date=TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY) E.WHERE order_date IN (TO_DATE('oct 21 2018','MON-DD-YYYY '), TO_CHAR('Nov 21 2018', 'MON DD YYYY'))
40.The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR Which two WHERE conditions demonstrate the correct usage of conversion functions? A.WHERE order_date=TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY') B.WHERE TO_CHAR(order date, 'MON-DD-YYYY') = 'JAN 20 2019' C.WHERE order_date > TO_DATE('JUL 10 2018','MON DD YYYY') D.WHERE order_date=TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY) E.WHERE order_date IN (TO_DATE('oct 21 2018','MON-DD-YYYY '), TO_CHAR('Nov 21 2018', 'MON DD YYYY'))
undo
undo保留
39
active+3个相同 有unexpired √
1. Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION? A.Unexpired UNDO is always retained B.UNDO RETENTION specifies for how long Oracle attempts to keep unexpired UNDO C.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO. D.UNDO RETENTION specifies how long all types of UNDO are retained E.Active UNDO is always retained
39.Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION? A.Unexpired UNDO is always retained B.UNDO RETENTION specifies for how long Oracle attempts to keep unexpired UNDO C.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO. D.UNDO RETENTION specifies how long all types of UNDO are retained E.Active UNDO is always retained
题干 undo undo表空间
67
两个有only的√
67. Which two statements are true about UNDO and UNDO tablespaces? A.An UNDO tablespace may be owned by only one instance B.UNDO segments are owned by SYSBACKUP C.UNDO segments are owned by SYSTEM. D.There can be only one UNDO tablespace created in a database E.An instance will crash if the active undo tablespace is lost.
67. Which two statements are true about UNDO and UNDO tablespaces? A.An UNDO tablespace may be owned by only one instance B.UNDO segments are owned by SYSBACKUP C.UNDO segments are owned by SYSTEM. D.There can be only one UNDO tablespace created in a database E.An instance will crash if the active undo tablespace is lost.
NOMOUNT
题干in numount状态
75
后台进程+memory
75.You start your database instance in NOMOUNT state. Which two actions are performed? A. sys can access the database. B. All required background processes are started C.Memory is allocated for the SGA D.The consistency of the database is checked E.The control files are opened
75.You start your database instance in NOMOUNT state. Which two actions are performed? A. sys can access the database. B. All required background processes are started C.Memory is allocated for the SGA D.The consistency of the database is checked E.The control files are opened
题干 in mount状态+move to new file
44
$+展示新名字
109. While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened. Which two statements are true? A) V$DATAFILE displays the new names for the data files. B) DBA_DATA_FILES displays the original name for the data files. C) DBA_DATA_FILES must be resynchronized manually with the control file in order to have it display the new file names. D) DBA_DATA_FILES displays the new name for the data files. E) DBA_DATA_FILESdisplays both the new name and the old name for the data files.
109. While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened. Which two statements are true? A) V$DATAFILE displays the new names for the data files. B) DBA_DATA_FILES displays the original name for the data files. C) DBA_DATA_FILES must be resynchronized manually with the control file in order to have it display the new file names. D) DBA_DATA_FILES displays the new name for the data files. E) DBA_DATA_FILESdisplays both the new name and the old name for the data files.
default
EM
56
using EM Express结尾 start+default
56. Which two statements are true about Enterprise Manager(EM)Express? A.By default, EM Express is available for a database after database creation using DBCA B.You can shut down a database instance using EM Express. C.EM Express uses a separate repository database to store target database metadata D. You cannot start up a database instance using EM Express E.You can use a single instance of EM Express to manage multiple databases running on the same server
56. Which two statements are true about Enterprise Manager(EM)Express? A.By default, EM Express is available for a database after database creation using DBCA B.You can shut down a database instance using EM Express. C.EM Express uses a separate repository database to store target database metadata D. You cannot start up a database instance using EM Express E.You can use a single instance of EM Express to manage multiple databases running on the same server
延迟片段创建
19
延迟to立刻 x2+default
19. Which three statements are true about Deferred Segment Creation in Oracle databases? A.It is the default behavior for tables and indexes. B.It is supported for sys-owned tables contained in locally managed tablespaces C.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation. D. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table E. It is supported for Index Organized Tables(IOTs) contained in locally managed tablespaces.
19.Which three statements are true about Deferred Segment Creation in Oracle databases? A.It is the default behavior for tables and indexes. B.It is supported for sys-owned tables contained in locally managed tablespaces C.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation. D.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table E.It is supported for Index Organized Tables(IOTs) contained in locally managed tablespaces.
无限空间系统权限
89
default+user any任何
89. 1Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas? A.It allows a role to have unlimited space in any tablespace in the database B.It is overridden by a space quota specified for the user C.It allows a user to have unlimited space only in their default permanent tablespace. D.By default, users have no quota on their default permanent tablespace. E.It allows a user to have unlimited space in any tablespace in the database
89.Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas? A.It allows a role to have unlimited space in any tablespace in the database B.It is overridden by a space quota specified for the user C.It allows a user to have unlimited space only in their default permanent tablespace. D.By default, users have no quota on their default permanent tablespace. E.It allows a user to have unlimited space in any tablespace in the database
DML
题目V$TRANSACTION
4
尾巴两个by a DML statement √+select select
4.You currently have an active transaction in your session and have been granted select access to V$TRANSACTION  In which three situations will re-executing this query still return a row but with a different XID indicating a new transaction has started? A. after successfully executing a TRUNCATE statement followed by a DML statement B. after successfully executing a CREATE TABLE AS Select statement followed by a SELECT FOR UPDATE statement C. after successfully executing a CREATE TABLE statement followed by a CREATE INDEX statement D. after successfully executing a commit or ROLLBACK followed by a DML statement E.after successfully executing a DML statement following a failed DML statement F. after successfully executing a commit or ROLLBACK followed by a Select statement
4.You currently have an active transaction in your session and have been granted select access to V$TRANSACTION In which three situations will re-executing this query still return a row but with a different XID indicating a new transaction has started? A.after successfully executing a TRUNCATE statement followed by a DML statement B.after successfully executing a CREATE TABLE AS Select statement followed by a SELECT FOR UPDATE statement C.after successfully executing a CREATE TABLE statement followed by a CREATE INDEX statement D.after successfully executing a commit or ROLLBACK followed by a DML statement E.after successfully executing a DML statement following a failed DML statement F. after successfully executing a commit or ROLLBACK followed by a Select statement
题目 压缩空间 shrink space
29
The SHRINK开头 beginning+有DML
29. Examine this command SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true? A.Queries and DML statements are allowed on ORDERs while the SHRINK is executing B.Dependent indexes become UNUSABLE C.The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERs segment D.The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERs segment. E.Only queries are allowed on ORDERs while the SHRINK is executing F.The high-water mark(HWM)of ORDERs is adjusted
29. Examine this command SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true? A.Queries and DML statements are allowed on ORDERs while the SHRINK is executing B.Dependent indexes become UNUSABLE C.The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERs segment D.The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERs segment. E.Only queries are allowed on ORDERs while the SHRINK is executing F.The high-water mark(HWM)of ORDERs is adjusted
题干 index和索引管理
92
有大写词组的 除开有DML不要
92.Which three statements are true about indexes and their administration in an Oracle database? A) An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table. B) A descending index is a type of function-based index. C) An index can be created as part of a CREATE TABLE statement. D) If a query filters on an indexed column then it will always be used during execution of the query. E) A UNIQUE and non-unique index can be created on the same table column. F) A DROP INDEX statement always prevents updates to the table during the drop
92.Which three statements are true about indexes and their administration in an Oracle database? A) An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table. B) A descending index is a type of function-based index. C) An index can be created as part of a CREATE TABLE statement. D) If a query filters on an indexed column then it will always be used during execution of the query. E) A UNIQUE and non-unique index can be created on the same table column. F) A DROP INDEX statement always prevents updates to the table during the drop
空：NULL/non/none
题目alert log
77
两个error+Non-default
1. Which three activities are recorded in the database alert log? A.block corruption errors B.Data Definition Language(DDL)statements C.Non-default database parameters D.deadlock errors E.session logins and logouts
77.Which three activities are recorded in the database alert log? A.block corruption errors B.Data Definition Language(DDL)statements C.Non-default database parameters D.deadlock errors E.session logins and logouts
题干 DESCRIBE
48
display 有NULL+view+sql开发人员
48.Which three statements are true about the DESCRIBE command? A.It can be used from SQL Developer. B. It displays all constraints that are defined for each column C. It can be used only from SQL*Plus D. It displays the PRIMARY KEY constraint for any column or columns that have that constraint. E. It displays the NOT NULL constraint for any columns that have that constraint. F. It can be used to display the structure of an existing view
48.Which three statements are true about the DESCRIBE command? A.It can be used from SQL Developer. B. It displays all constraints that are defined for each column C. It can be used only from SQL*Plus D. It displays the PRIMARY KEY constraint for any column or columns that have that constraint. E. It displays the NOT NULL constraint for any columns that have that constraint. F. It can be used to display the structure of an existing view
选项in each select
24
题干：union union all 3个 in each select里面 number要，name can be+NULL
24. Which three statements are true regarding the UNION and UNION ALL operators? A.The number of columns selected by the first SELECT statement can be greater than the number selected in subsequent SELECT statements B.Duplicates are eliminated automatically by the UNION ALL operator C.The number of columns selected in each SELECT statement must be identical D.NULLS are not ignored during duplicate checking E.The names of columns selected in each SELECT statement must be identical F.The names of columns selected in each SELECT statement can be identical G.Duplicates can optionally be eliminated by the UNION operator
24. Which three statements are true regarding the UNION and UNION ALL operators? A.The number of columns selected by the first SELECT statement can be greater than the number selected in subsequent SELECT statements B.Duplicates are eliminated automatically by the UNION ALL operator C.The number of columns selected in each SELECT statement must be identical D.NULLS are not ignored during duplicate checking E.The names of columns selected in each SELECT statement must be identical F.The names of columns selected in each SELECT statement can be identical G.Duplicates can optionally be eliminated by the UNION operator
85
题干：交集 复合查询 in each select 要表名+return
84. Which two statements are true about the results of using the INTERSECT operator in compound queries? A.Reversing the order of the intersected tables can sometimes affect the output B.INTERSECT returns rows common to both sides of the compound query C.Column names in each SELECT in the compound query can be different. D.The number of columns in each SELECT in the compound query can be different E.INTERSECT ignores NULIS
84. Which two statements are true about the results of using the INTERSECT operator in compound queries? A.Reversing the order of the intersected tables can sometimes affect the output B.INTERSECT returns rows common to both sides of the compound query C.Column names in each SELECT in the compound query can be different. D.The number of columns in each SELECT in the compound query can be different E.INTERSECT ignores NULIS
join
内连接外连接
50
两个returns matched+外链接 multi
50.Which three statements are true about inner and outer joins? A.Outer joins can be used when there are multiple join conditions on two tables B.Outer joins can only be used between two tables per query C.A left or right outer join returns only unmatched rows D.A full outer join returns matched and unmatched rows E.An inner join returns matched rows F. A full outer join must use Oracle syntax
50.Which three statements are true about inner and outer joins? A.Outer joins can be used when there are multiple join conditions on two tables B.Outer joins can only be used between two tables per query C.A left or right outer join returns only unmatched rows D.A full outer join returns matched and unmatched rows E.An inner join returns matched rows F. A full outer join must use Oracle syntax
完全外连接
88
include 内连接+return match unmatched
88. Which two statements are true about a full outer join? A.It returns matched and unmatched rows from both tables being joined B.It returns only unmatched rows from both tables being joined C.It includes rows that are returned by a Cartesian product. D.The Oracle join operator (+)must be used on both sides of the join condition in the WHERE clause E.It includes rows that are returned by an inner join
88.Which two statements are true about a full outer join? A.It returns matched and unmatched rows from both tables being joined B.It returns only unmatched rows from both tables being joined C.It includes rows that are returned by a Cartesian product. D.The Oracle join operator (+)must be used on both sides of the join condition in the WHERE clause E.It includes rows that are returned by an inner join
Oracle连接 ansi连接
28
两个笛卡尔乘积 √
28. Which two statements are true about the Oracle join and ANSI join syntax? A.The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax. B.The Oracle join syntax lacks the ability to do outer joins C.The SQL: 1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables D.The Oracle join syntax supports creation of a Cartesian product of two tables E.The Oracle join syntax performs less well than the SQL: 1999 compliant ANSI join syntax
28.Which two statements are true about the Oracle join and ANSI join syntax? A.The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax. B.The Oracle join syntax lacks the ability to do outer joins C.The SQL: 1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables D.The Oracle join syntax supports creation of a Cartesian product of two tables E.The Oracle join syntax performs less well than the SQL: 1999 compliant ANSI join syntax
非等连语句
74
better than sql
1. What is true about non-equijoin statement performance? A.The join syntax used makes no difference to performance. B.The BETWEEN condition used with an non-equijoin sometimes performs better than using the >=and<= conditions C.The BETWEEN condition used with an non-equijoin always performs better than when using the>=and <= conditions D.The Oracle join syntax performs better than the sql: 1999 compliant ANSI join syntax E.The Oracle join syntax performs less well than the sql: 1999 compliant ANSI join syntax
74.What is true about non-equijoin statement performance? A.The join syntax used makes no difference to performance. B.The BETWEEN condition used with an non-equijoin sometimes performs better than using the >=and<= conditions C.The BETWEEN condition used with an non-equijoin always performs better than when using the>=and <= conditions D.The Oracle join syntax performs better than the sql: 1999 compliant ANSI join syntax E.The Oracle join syntax performs less well than the sql: 1999 compliant ANSI join syntax
/u02
选项/u02 题干 非标准块 有SIZE 100g
53
DB_CACHE_SIZE 3个不要，剩下3个没有大写的不要/ 大写32K SGA+/u02100g
53. You must create a tablespace of non-standard block size in a new file system and plan to use this command  The standard block size is 8k but other non-standard block sizes will also be used Which two are requirements for this command to succeed? A.DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA B.DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE C.DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE D.The operating system must use a 32k block size E.DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE F. The /u02 file system must have at least 100g space for the datafile
53.You must create a tablespace of non-standard block size in a new file system and plan to use this command The standard block size is 8k but other non-standard block sizes will also be used Which two are requirements for this command to succeed? A.DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA B.DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE C.DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE D.The operating system must use a 32k block size E.DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE F. The /u02 file system must have at least 100g space for the datafile
题干/u01 题干有SIZE 20g
112
两个datafile
112.You execute this command:  Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.) A. AUTOEXTEND is possible for the datafile B. It must be bigger than the largest SMALLFILE tablespace C. Additional data files may not be added D. It will be a dictionary-managed tablespace by default E. It will always have a 32K block size
112.You execute this command:  Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.) A. AUTOEXTEND is possible for the datafile B. It must be bigger than the largest SMALLFILE tablespace C. Additional data files may not be added D. It will be a dictionary-managed tablespace by default E. It will always have a 32K block size
选项/u02 题干没有SIZE
36
DML+extent
36  Examine this command Which two statements are true? A.DML may be performed on tables with one or more extents in this data file during the execution of this command B.It overwrites any existing file with the name SALES02.DBF in /u02 by default. C.Tables with one or more extents in this data file may be queried during the execution of this command D.Compressed objects in sales01.DBF will be uncompressed in SALES02.DBF after the move E.The "To" clause containing the new file name must be specified even if Oracle Managed Files (OMF)is used
36.Examine this command Which two statements are true? A.DML may be performed on tables with one or more extents in this data file during the execution of this command B.It overwrites any existing file with the name SALES02.DBF in /u02 by default. C.Tables with one or more extents in this data file may be queried during the execution of this command D.Compressed objects in sales01.DBF will be uncompressed in SALES02.DBF after the move E.The "To" clause containing the new file name must be specified even if Oracle Managed Files (OMF)is used
2个
2个writing开头
81
两个writing要+注册服务
1. Which three tasks are performed by background processes in an Oracle database instance? A.registering services with Oracle Net listeners B.writing dirty database block images from the buffer cache C.writing redo to log files D.reading database blocks into the buffer cache E.creating dedicated server connections
81.Which three tasks are performed by background processes in an Oracle database instance? A.registering services with Oracle Net listeners B.writing dirty database block images from the buffer cache C.writing redo to log files D.reading database blocks into the buffer cache E.creating dedicated server connections
题干逻辑、物理数据库结构
27
两个 A sequence开头 √
27. Which two statements are true concerning logical and physical database structures? A.A segment's blocks can be of different sizes. B.A segment might have only one extent C.All tablespaces may have one or more data files D.Segments can span multiple tablespaces E.A segment can span multiple data files in some tablespaces
27. Which two statements are true concerning logical and physical database structures? A.A segment's blocks can be of different sizes. B.A segment might have only one extent C.All tablespaces may have one or more data files D.Segments can span multiple tablespaces E.A segment can span multiple data files in some tablespaces
题干 动态性能视图
107
they开头两个 不要+剩下data display 要memory的+其他都要
107.Which three statements are true about dynamic performance views? A) They are owned by the SYSTEM user. B) V$FIXED_TABLE can be queried to display the name of all dynamic performance views. C) Data displayed by querying dynamic performance views is derived from metadata in the data dictionary. D) Data displayed by querying dynamic performance views is derived from memory structures. E) They can be queried only when the database is open. F) Read consistency is not guaranteed.
107.Which three statements are true about dynamic performance views? A) They are owned by the SYSTEM user. B) V$FIXED_TABLE can be queried to display the name of all dynamic performance views. C) Data displayed by querying dynamic performance views is derived from metadata in the data dictionary. D) Data displayed by querying dynamic performance views is derived from memory structures. E) They can be queried only when the database is open. F) Read consistency is not guaranteed.
题干 index 索引
68
两个update开头 √
68. Which two statements are true regarding indexes? A.An update to a table can result in updates to any or all of the table's indexes B.An update to a table can result in no updates to any of the table's indexes C.A non-unique index can be altered to be unique. D.A table belonging to one user cannot have an index that belongs to a different user E.The RECYCLE BIN never contains indexes
68.Which two statements are true regarding indexes? A.An update to a table can result in updates to any or all of the table's indexes B.An update to a table can result in no updates to any of the table's indexes C.A non-unique index can be altered to be unique. D.A table belonging to one user cannot have an index that belongs to a different user E.The RECYCLE BIN never contains indexes
3个
题目transactions
106
3个A开头，里面没有大写的不要
106.Choose two. Which two are true about transactions in the Oracle Database? A) An uncommitted transaction is automatically committed when the user exits SQL*Plus. B) A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction. C) DDL statements automatically commit only data dictionary updates caused by executing the DDL. D) A session can see uncommitted updates made by the same user in a different session. E) DML statements always start new transactions.
106.Choose two. Which two are true about transactions in the Oracle Database? A) An uncommitted transaction is automatically committed when the user exits SQL*Plus. B) A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction. C) DDL statements automatically commit only data dictionary updates caused by executing the DDL. D) A session can see uncommitted updates made by the same user in a different session. E) DML statements always start new transactions.
sequences 单实例数据库
76
3个 A sequence开头的 不要
76. Which three statements are true about sequences in a single instance Oracle database? A.A sequence number that was allocated can be rolled back if a transaction fails B.A sequence can only be dropped by a DBA C.Sequences can always have gaps D.A sequence can issue duplicate values. E.A sequence's unallocated cached values are lost if the instance shuts down F. Two or more tables cannot have keys generated from the same sequence
76.Which three statements are true about sequences in a single instance Oracle database? A.A sequence number that was allocated can be rolled back if a transaction fails B.A sequence can only be dropped by a DBA C.Sequences can always have gaps D.A sequence can issue duplicate values. E.A sequence's unallocated cached values are lost if the instance shuts down F. Two or more tables cannot have keys generated from the same sequence
题干问role
104
三个含有 grant的
104. Which three statements are true about roles? A)Roles must be password protected. B)Object privileges may not be granted to roles. C)The SET ROLE statement can disable one or more roles for a session. D)Roles may be granted to roles. E)All roles granted to a user are set on by default when the user logs in. F)The SET ROLE statement can enable one or more roles for a session.
104. Which three statements are true about roles? A)Roles must be password protected. B)Object privileges may not be granted to roles. C)The SET ROLE statement can disable one or more roles for a session. D)Roles may be granted to roles. E)All roles granted to a user are set on by default when the user logs in. F)The SET ROLE statement can enable one or more roles for a session.
题干DML+trigger 选项3个view
108
选项3个view开头 √
108.Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined? A. Insert statements can always be done on a table through a view. B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view. C. Delete statements can always be done on a table through a view. D. Views cannot be used to add rows to an underlying table If the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view. E. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the primary key columns are not referenced in the defining query of the view. F. Views cannot be used to add or modify rows in an underlying table If the defining query of the view contains the DISTINCT keyword.
108.Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined? A. Insert statements can always be done on a table through a view. B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view. C. Delete statements can always be done on a table through a view. D. Views cannot be used to add rows to an underlying table If the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view. E. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the primary key columns are not referenced in the defining query of the view. F. Views cannot be used to add or modify rows in an underlying table If the defining query of the view contains the DISTINCT keyword.
3个GLOBAL 题干 全局临时表空间
91
三个GLOBAL开头的，multi要，空间分配space allocation要
91.Which two statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. B) A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions. C) A TRUNCATE command issued in a session causes all rows in a GLOBAL TE MPORARY TABLE for the issuing session to be deleted. D) A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back. E) GLOBAL TEMPORARY TABLE space allocation occurs at session start.
91.Which two statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. B) A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions. C) A TRUNCATE command issued in a session causes all rows in a GLOBAL TE MPORARY TABLE for the issuing session to be deleted. D) A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back. E) GLOBAL TEMPORARY TABLE space allocation occurs at session start.
题干Q1 选项3个100M
69
3个选项有100M 有A大写词组的不要
69. In your data center, Oracle Managed Files(OMF)is used for all databases. All tablespaces are smallfile tablespaces SALE_Q1 is a permanent user-defined tablespace in the sales database Examine this command which is about to be issued by a DBA logged in to the sales database ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? A.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space B.Add the AUROEXREND on clause with NEXT set to 100M. C.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space D.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space E.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space
69.In your data center, Oracle Managed Files(OMF)is used for all databases. All tablespaces are smallfile tablespaces SALE_Q1 is a permanent user-defined tablespace in the sales database Examine this command which is about to be issued by a DBA logged in to the sales database ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? A.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space B.Add the AUROEXREND on clause with NEXT set to 100M. C.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space D.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space E.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space
选项3个must 题干单行子查询
33
3个有must的 ×
33. Which three statements are true regarding single row subqueries? A.They must be placed on the left side of the comparison operator or condition B.They must return a row to prevent errors in the SQL statement C.They can be used in the HAVING clause. D.A SQL statement may have multiple single row subquery blocks E.They can be used in the WHERE clause F.They must be placed on the right side of the comparison operator or condition
33. Which three statements are true regarding single row subqueries? A.They must be placed on the left side of the comparison operator or condition B.They must return a row to prevent errors in the SQL statement C.They can be used in the HAVING clause. D.A SQL statement may have multiple single row subquery blocks E.They can be used in the WHERE clause F.They must be placed on the right side of the comparison operator or condition
题干PTT
83
3个concurrent sessions里有different的不要，其他都要
83. Which three statements are true about Private Temporary Tables (PTTs)in an Oracle Database? A.Concurrent sessions may have PTTs with the same name but different column definitions B.Concurrent sessions may have PTTs with the same name and the same column definitions C.Creating a PTT is DDL and commits any active transaction for the session D.It is possible to preserve the private table definition but remove the rows when a session with a PTT issues a COMMIT E.Concurrent sessions may have PTTs with different names but same column definitions
83.Which three statements are true about Private Temporary Tables (PTTs)in an Oracle Database? A.Concurrent sessions may have PTTs with the same name but different column definitions B.Concurrent sessions may have PTTs with the same name and the same column definitions C.Creating a PTT is DDL and commits any active transaction for the session D.It is possible to preserve the private table definition but remove the rows when a session with a PTT issues a COMMIT E.Concurrent sessions may have PTTs with different names but same column definitions
特殊
EMP. DAT to EMP
71
append+log
70.Which two statements are true about the sqlldr execution? A. It overwrites the data for Alan and adds data for Curl and Bob B. It generates a sql script that it uses to load data from EMP. DAT to EMP C.It overwrites all data in EMP with data from EMP. DAT. D. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations E. It appends data from EMP. DAT to EMP.
71.Which two statements are true about the sqlldr execution? A. It overwrites the data for Alan and adds data for Curl and Bob B. It generates a sql script that it uses to load data from EMP. DAT to EMP C.It overwrites all data in EMP with data from EMP. DAT. D. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations E. It appends data from EMP. DAT to EMP.
题干 DUAL空表
47
两个有大写的
46. Which two statements are true about the DUAL table? A.It can display multiple rows and columns B. It can be accessed only by the sys user. C. It can display multiple rows but only a single column D. It can be used to display only constants or pseudo columns E. It can be accessed by any user who has the SELECT privilege in any schema F. It consists of a single row and single column of VARCHAR2 data type
46. Which two statements are true about the DUAL table? A.It can display multiple rows and columns B. It can be accessed only by the sys user. C. It can display multiple rows but only a single column D. It can be used to display only constants or pseudo columns E. It can be accessed by any user who has the SELECT privilege in any schema F. It consists of a single row and single column of VARCHAR2 data type
题干 SQL开发人员
95
两个java不要+must不要
95.Which four activities can be performed using SQL Developer? A) It can be used to back up and recover databases using RMAN. B) It can be used to debug PL/SQL programs. C) It must be configured to allow SQLcl to be used. D) It can be used to develop server-side java programs. E) It can be used to develop client-side java programs. F) It can run SQL statements and SQL scripts. G) It can be used to administer database security.
95.Which four activities can be performed using SQL Developer? A) It can be used to back up and recover databases using RMAN. B) It can be used to debug PL/SQL programs. C) It must be configured to allow SQLcl to be used. D) It can be used to develop server-side java programs. E) It can be used to develop client-side java programs. F) It can run SQL statements and SQL scripts. G) It can be used to administer database security.