三?十四.Memory
97.?In your?database:
SGA_TARGET =270M PGA_AGGREGATE_TARGET =90M
The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not configured. You execute the command:
ALTER SYSTEM SET MEMORY_TARGET = 400M;
What is the outcome and?why?
A)?The?execution?fails?because?the?MEMORY_MAX_TARGET?parameter?must?be?configured?to?400M before configuring the MEMORY_TARGET?parameter.
B)?The?execution?fails?because?SGA_TARGET?and?PGA_AGGREGATE_TARGET?are?already configured.
C)?The execution is successful and automatic memory management is?enabled.
D)?The execution is successful but does not enable automatic memory management because?the MEMORY_MAX_TARGET paremeter must be configured to a value greater than?MEMORY_TARGET.
Answer：A（驗(yàn)證過(guò)）
ORA-02097:?paramet?er?cannot?be?modi?f?i?ed?because?speci?f?i?ed?val?ue?i?s?i?nvali?d?ORA-00837:?Speci?f?i?ed?val?ue?of?MEMORY_TARGET?great?er?t?han?MEMORY_MAX_TARGET
98.?Your?database is using Automatic Memory Management. Which two SGA components must be managed?manually?
A)?shared pool
B)?keep buffer?pool
C)?default buffer?cache
D)?large pool
E)?redo log?buffer
Answer：BE
?
?
99.?Examine these descriptions of Oracle metadata and?data:
1.?Metadata about schema objects being queried by SQL?statments.
2.?Private Cursor metadata?only
3.?Results of SQL queries and PL/SQL?functions
4.?Shared Cursor and Private Cursor?Data
5.?The Call?Stack
Which of these are always stored in the PGA?
A)?1 and?2
B)?1 and?2
C)?4 and?5
D)?2 and?5
E)?1 and?5
Answer：D
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
三?十五.Index
100.?Which is true about unusable indexes??
A)?Rebuilding an unusable index always requires at least twice the space of the original?index.
B)?Rebuilding an unusable index creates a new segment after dropping the unusable?index.
C)?Rebuilding an unusable index always allows DML statements on the index's table during the?rebuild.
D)?Rebuilding occurs automatically when an unusable index is chosen by the optimizer when creating an execution plan.
Answer：B
?
?
101.?Which three are true is true about unusable indexes??
A)?Rebuilding an unusable index creates a new?object.
B)?An index can be set unusable?manually.
C)?An unusable index can be bypassed by the optimizer when creating an execution?plan.
D)?An index can become unusable automatically due to actions performed on other?objects.
E)?Rebuilding an unusable index requires at least one row to exist in the indexed?table
F)?Rebuilding an unusable index reuses the space from the original index?segment.
Answer：ABC
?
?
?
102.?Which three statements are true regarding B-tree?indexes?
A)?A non-unique index uses the rownum to determine the collating sequence for duplicate?keys.
B)?A unique index used the rownum to determine the collating sequence for duplicate?keys.
C)?A non-unique index uses the rowid to determine the collating sequence for duplicate?keys.
D)?Leaf blocks are linked in a backward collating?sequence.
E)?A unique index uses the rowid to determine the collating sequence for duplicate?keys.
F)?Leaf blocks are linked in a forward collating?sequence.
Answer：CEF
unusable index（1）unusable index?是被優(yōu)化器所忽略肛跌，并且不被dml操作維護(hù)阐滩。但
是unusable index?可以改變批量加載的性能(2) 任何現(xiàn)有的索引變成unusable后郑现，索引段都會(huì)被刪除（3）由于unusable index?是不會(huì)被dml操作維護(hù)粗梭，索引變成unusable index后必須通
過(guò)rebuild index?或者drop index and create index（4）當(dāng)參數(shù)?SKIP_UNUSABLE_INDEXES
=true時(shí)invisible index ?（1）從11g開(kāi)始，就有了invisible index ?（2）invisible index會(huì)被優(yōu)化器所忽略，但是dml操作仍然會(huì)維護(hù)索引，批量提交數(shù)據(jù)不會(huì)提示性能（3）如果
在session或者system級(jí)別使用參數(shù)OPTIMIZER_USE_INVISIBLE_INDEXES=true，那么優(yōu)化器會(huì)考慮使用invisible index?（4）你可以使一個(gè)分區(qū)索引變成invisible index首懈，但是你不能使單個(gè)分區(qū)變成invisible index，而其他分區(qū)visible?（5）invisible index只是讓優(yōu)化器不可見(jiàn)谨敛，索引段中的數(shù)據(jù)還是存在的究履，并且dml操作維護(hù)索引，所以visible index后脸狸，不需要重建索引
三?十七.Roles
103.?Which two are true about?roles?
A)?Roles are owned by?SYSTEM.
B)?A secure application role can be set only by its associated PL/SQL?package.
C)?The CONNECT role is granted automatically to a user when it is?created.
D)?A role can be granted a combination of system and object privileges and other?roles.
E)?The RESOURCE role is granted the?CREATE?SESSION?privilege.
Answer：BD
?
?
104.?Which four are true about?roles?
A)?A single default role can be granted to a?user.
B)?roles must be protected by a?password.
C)?A role can be granted system?privileges.
D)?Multiple default roles can be granted to a?user.
E)?roles must be protected by a secure?application.
F)?A role can be granted object?privileges.
G)?A user can be granted to a?role.
Answer：ACDF
?
?
105.?Which two are true about?roles?
A)?A role can be?password-protected.
B)?Only one default role can be granted to a?user.
C)?A role can be granted only multiple system privileges not multiple object?privileges.
D)?A role can be granted to another?role.
E)?A role can be created only by a user with the SYSDBA?privilege.
Answer：AD
?
106.?Which three are true about?roles?
A)?Roles must be password?protected.
B)?Roles can be granted to?users.
C)?Users can be granted to?roles.
D)?Roles can be granted to?roles.
E)?Object privileges can be granted to?roles.
Answer：BDE
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
三?十?八.Dynamic performance views and Data?dictionary views
?
112.?Which three are true about dynamic performance?views?
A)?They display information that is not available in data dictionary?views.
B)?They can be queried only by SYS even when the database is open.
C)?They display selected data from data dictionary base?tables.
D)?Read consistency is not guaranteed for these?views.
E)?Some of them display data that is useful for SQL statement?tuning.
Answer：ADE
?
?
113.?Which two are true about data dictionary and dynamic performance views (V$?views)?
A)?All database users have access to ALL_*?views
B)?All database users have access to all V$?views
C)?The defining queries for Oracle supplied dynamic performance views are stored in the data dictionary
D)?All V$ views display output when queries, if the instance is in nomount?state
E)?Data dictionary view output is subject to read?consistency
Answer：AE?（正在測(cè)試）
114.?which three are true about data dictionary and dynamic performance views（V$?views）最仑？
A)?By default，all database users have access to all V$?views.
B)?All V$ views return data if queried炊甲，as soon as the instance has?started.
C)?By default泥彤，all database users have access to USER_*?views.
D)?By default，all database users have access to ALL_*?views.
E)?Only data dictionary views are subject to read?consistency.
F)?The definition of system-defined V$ views is stored in the data?dictionary.
Answer：CDF
?
?
115.?Which two are true about data dictionary?views?
A)?All data dictionary views are prefixed with DBA or ALL or?USER.
B)?A user may not necessarily be the owner of all objects that can be viewed by using the ALL?prefixed
views.
C)?ALL or USER prefixed views display output that are subsets of the output from the?DBA prefixed data views.
D)?A user can query the DBA prefixed views only if they have the SYSDBA?privilege.
E)?DBA prefixed views are accessible when a database is in mount?state.
Answer：BC
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
三?十九.Shutdown
116.?which is true when a database instance is shut?down?
A)?IMMEDIATE,TRANSACTIONAL, and NORMAL modes all result in a?checkpoint.
B)?Neither the IMMEDIATE nor the ABORT mode rolls back uncommitted?tracsctions.
C)?Only TRANSACTIONAL and NORMAL modes wait for all uncommitted transactions to COMMIT?or ROLLBACK and then close the database
D)?IMMEDIATE, TRANSACTOINAL, and NORMAL modes wait for all uncommitted transcatoins?either COMMIT or ROLLBACK and then close?the
Answer：A
?
?
117.?which three are true when a database instance is shut?down?
A)?STARTUP?FORCE performs a CHECKPOINT then ABORTS the database?instance.
B)?SHUTDOWN IMMEDIATE performs a?CHECKPOINT.
C)?SHUTDOWN TRANSACTIONAL rolls back uncommitted?transactions.
D)?SHUTDOWN IMMEDIATE rolls back uncommitted?transactions.
E)?SHUTDOWN TRANSACTIONAL preform a?CHECKPOINT.
F)?SHUTDOWN ABORT rolls back uncommitted?transactions.
Answer：BDE
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
四?十.Rman
?
118.?The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled.?TBS1 and TBS2 are the only user-defined tablespaces in?ORCL.
USER1.EMP is able in TBS1. Examine these commands:
$?rman?target/
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
RMAN> exit
$ sqlplus / as sysdba
SQL>?UPDATE?user1.empSET sal=10000 WHERE?eno=1;
1 row updated SQL> COMMIT; Commit complete.
SQL> ALTER TABLESPACE tbs1 READ ONLY;
Tablespace altered.
SQL> exit
$ rman target /
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
From which files are modified blocks backed up?
A)?SYSTEM and SYSAUX?only
B)?SYSTEM, SYSAUX, UNDO,?TEMP,?TBS1, and?TBS2
C)?SYSTEM, SYSAUX, and UNDO?only
D)?SYSTEM,?SYSAUX, UNDO,?and?TBS1 only?(在變成只讀之前沒(méi)有備份卿啡，而且數(shù)據(jù)發(fā)生變化）
E)?SYSTEM, SYSAUX, UNDO, and TBS2?only
Answer：D
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
120.?in which state can you back up a database in ARCHIVELOGMODE using?RMAN?
A)?MOUNT and OPEN?only
B)?NOMOUNT and MOUNT?only
C)?NOMOUNT,MOUNT,?and?OPEN
D)?OPEN RESTRICTED?only
E)?OPEN only
Answer：A
?
?
121.?Which two can be backed up by using RMAN when a database is open in ARCHIVELOG mode, so?that media recovery can be performed if?required?
A)?password file
B)?control files
C)?pfile
D)?flashback logs
E)?online redo logs
F)?data files
Answer：BF
?
?
121.?Which four can be backed up by using RMAN when a database is open in archivelog?mode?
A)?archived logs
B)?password files
C)?control files
D)?data files
E)?pfiles
F)?spflles
G)?block change tracking flies
Answer：ACDF
?
?
122.?Where is backup metadata stored for use by Recovery Manager?(RMAN)?
A)?in the SYSAUX tablespace
B)?in the diagnostic destination?files
C)?in the control file
D)?in the SYSTEM?tablespace
E)?in the?SPFILE
Answer：C
?
?
123.?In which two locations can Recovery Manager (rman) metadata be?stored?
A)?in the Fixed?SGA
B)?in the control file
C)?in the Data Guard broker configuration?files
D)?in the Flashback Logs
E)?in the?CATALOG?schema
Answer：BE
?
?
124.?For your ORCL?database.
1.?The instance is started using an?spfile.
2.?The database is opened.
3.?It is in ARCHIVELOG?mode.
4.?CONTROL FILE AUTOBACKUP IS?ON.
Examine this command:
RMAN > BACKUP AS COPY DATAFILE 'USERS01.DBF','EXAMPLE01.DBF';
Which four files are backed up ?
A)?SYSTEM01.DBF
B)?archivelogs
C)?EXAMPLE01.DBF
D)?spfile
E)?SYSAUX01.DBF
F)?USERS01.DBF
G)?UNDO01.DBF
H)?control file
Answer：CDFH
?
?
125.?Examine these components:
1.?Execution plan for a non-embedded SQL?statement
2.?Local, global, and package variables for a?session.
3.?Execution plan for a SQL statement contained in a PL/SQL program?unit.
4.?Results of executed queries and query?fragments.
5.?PL/SQL function result?sets.
Which of these are stored in the shared SQL area?
A)?1 and?3
B)1, 3, 4, and?5
C)?1 and?4
D)?1, 2, and?3
Answer：A
?
?
126.?The?ORCL?database?has?CONTROL?FILE?AUTOBACKUP?and?BACKUP?OPTIMIZATION?enabled. USER1.EMP is a table in tablespace?TBS1.
There are no existing backups of the database Examine these commands:
$ rman target /
RMAN >BACKUP DATABASE;
RMAN >exit;
$ sqlplus / as sysdba
SQL > UPDATE USER1.EMP set SAL = 5000 WHERE eno = 10;
1 row updated SQL> COMMIT; Commit complete. SQL> exit;
$ rman target /
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE tbs1; RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome ?
A)?It takes a level 1 incremental backup of ORCL without?TBS1.
B)?It takes a level 0 incremental backup of ORCL without?TBS1.
C)?It takes a level 1 incremental backup of ORCL with?TBS1.
D)?It takes a level 0 incremental backup of ORCL with?TBS1.
Answer: B
?
?
?
127.?In which two cases are inconsistent database backup?created?
A)?when the RMAN BACKUP command is used while the database is OPEN READ?ONLY
B)?when the RMAN BACKUP PROXY command is used while the database is?MOUNTED
C)?when the RMAN BACKUP command is used while the database is OPEN READ?WRITE
D)?when the RMAN BACKUP command is used while the database is?MOUNTED
E)?when the RMAN BACKUP AS COPY command is used while the database is?MOUNTED
Answer：DE
?
?
128.?In which three states can you back up a tablespace with RMAN when a database is in ARCHIVELOGMODE?
A)?MOUNT
B)?OPEN?READONLY
C)?Instance shut?down
D)?OPEN RESTRICTED
E)?NOMOUNT
Answer：ABD
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
四?十?一.Data Recovery Advisor
129.?A?database?instance?was?terminated?due?to?the?loss?of?the?CURRENT?online?redo?log?group?and?has?not been?restarted.
You wish to restore database availability by using the Data Recovery Advisor. Examine this list of RMAN commands;
1.?Startup
2.?List failure?all;
3.?Advise failure?all;
4.?Repair failure?noprompt;
5.?Alter database?open;
What are the minimum commands required and in what order must they be executed to achieve this? A)1,2,3,and?4
B)?1,3,and?4
C)?1 and?4
D)1,3,4,and?5
E)1,2,3,4,and?5
Answer：D
?
130.?A?database?instance?was?terminated?due?to?the?loss?of?the?CURRENT?online?redo?log?group?and?has?not been?restarted.
The database is configured with FLASHBACK mode on
You wish to restore database availability by using the Data Recovery Advisor. Examine this list of RMAN commands;
1.?Startup
2.?List failure?all;
3.?Advise failure?all;
4.?Repair failure?noprompt;
5.?Alter database?open;
What are the minimum commands required and in what order must they be executed to achieve this? A)1,2,3,and?4
B)?1,3,and?4
C)?1 and?4
D)1,3,4,and?5
E)1,2,3,4,and?5
Answer：D（驗(yàn)證過(guò)）
131.?A database instance was terminated duo to a lost data file and has not been?restarted?You?wish to restore database availability by using the Data Recovery Advisor Examine this list of RMAN?commands;
1.?Startup
2.?List failure?all;
3.?Advise failure all;
4.?Repair failure?noprompt;
5.?Alter database?open;
Which are the minimum required commands and in what order must they be executed to archive ??A)1,3,4 and?5
B)?1 and?4
C)?1,3 and?4
D)1,2,3,4 and?5
E)1,2,3, and?4
Answer：A（驗(yàn)證過(guò)）
132.?Which two are true about the Data Recovery Advisor??
A)?It can be used to validate database recovery?strategies.
B)?It provides intelligent database problem?analysis.
C)?It can be used when the database is?closed.
D)?It can be used only for databases with FLASHBACK?enabled.
E)?It can ben used only for databases that are running in ARCHVIELOG?mode.
F)?It can be used to validate database backup?strategies.
Answer: AB（驗(yàn)證過(guò)）
133.?Which two are true about the Data Recovery?Advisor?
A)?It can be used only with databases that are running in ARCHIVELOG?mode.
B)?It can repair only databases for which RMAN backups?exist.
C)?It can be used to validate RMAN?backups.
D)?It can be used to take RMAN?backups.
E)?It can be used when a database is?MOUNTED.
F)?It can be used when a database is?OPEN.
Answer：EF
?
?
134.?Which four are true about the Data Recovery?Advisor?
A)?It can be used to validate RMAN?backups.
B)?It can be used for databases running in ARCHIVELOG?mode.
C)?It can be used to validate RMAN image?copies.
D)?It can be used databases running in NOARCHIVELOG?mode.
E)?It can be used for an open?database.
F)?It can be used for a mounted?database.
G)?It can be used for an unmounted?database.
Answer：BDEF
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
四?十?二.EM
135.?Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench??
A)?gathering metadata from the Automatic Diagnostic?Repository(ADR)
B)?invoking the Data Recovery Advisor and SQL Repair?Advisor
C)?creating a service request with My Oracle?Support
D)?invoking the SQL?Test?Case?Builder
Answer: A
四?十三.Database Structures
136.?Which is true about logical and physical database?structures?
A)?An extent always consists of physically contiguous data blocks in?storage
B)?An undo tablespace has a temp file instead of a data?file
C)?A permanent tablespace can only contain tables segments and index?segments
D)?A tablespace can consist of data blocks of different?sizes.
E)?A segment can consist of extents of different?sizes.
Answer：E
?
?
137.?Which four are true about transaction, table, and row locks in an Oracle?Database?
A)?Transaction locks are released when that transaction executes a COMMIT?statement.
B)?DDL statements never lock the objects that they?modify.
C)?Transaction locks are released when that transaction executes a ROLLBACK?statement.
D)?DML statements lock modified rows in exclusive?mode.
E)?DML statements lock modified tables in exclusive?mode.
F)?SELECT statements are never blocked by row-level?locks.
G)?A table’s row-level locks escalate to table locks when a majority of rows in that table are locked?in exclusive mode.
Answer：ACDF
?
?
136.?Which three are true about transaction, table, and row locks in an Oracle?Database?
A)?dml statements lock modified tables in exclusive mode with tm?locks.
B)?Transaction locks are released when that transaction executes a ddl?command.
C)?select statements are blocked by table?locks.
D)?dml statements lock modified tables in shared mode with tm?locks.
E)?dml statements lock modified rows with row?locks.
F)?Row locks can escalate to table locks under heavy?load.
Answer：BDE
?
137.?Examine this list of Database?structures:
1.?Tablespaces
2.?Data files
3.?Segments
4.?Extents
5.?Oracle data blocks
6.?OS blocks
Which three are true regarding these?
A)?A segment with multiple extents can have space in different data?files.
B)?Segments always consist of more than one?extent.
C)?Extents always consist of Oracle data?blocks.
D)?A tablespace can have data files on different file?systems.
E)?A segment with multiple extents can have space in different?tablespaces.
F)?Tablespaces?always contain multiple segments.
G)?Oracle database blocks always consist of multiple OS?blocks.
Answer：CDG
四?十四.Startup Database
138.?Your?database instance is in the open state with uncommitted transactions.?You?plan to execute these?commands:
SHUTDOWN ABORT STARTUP
Which is true about the STARTUP command assuming that no errors occur?
A)?It opens the database in read-only?mode.
B)?It opens the database in read/write mode only if an spfile is?used.
C)?It performs an instance recovery and leaves the database instance in mount?state.
D)?It performs an instance recovery before opening the database in read/write?mode.
Answer：D
?
?
139.?One of your databases is open and there are currently some uncommitted?transactions.?You?execute these commands?successfully:
SHUTDOWN ABORT STARTUP
Which two are true about the effects of these commands?
A)?Instance recovery occurs before the database Is opened read?write.
B)?Media recovery occurs and the database is left in mount?state.
C)?Instance recovery occurs before the database is opened read?only
D)?The uncommitted transactions are rolled back during?startup
E)?Media recovery occurs before the database Is opened read?write
F)?The uncommitted transactions are rolled back before the Instance Is shut?down
Answer：AC
140.?Examine this LISTENER.ORA?life:
LISTENER = (DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=srvl.example.com)(PORT=1522)
))) SID_LIST_LISTENER =
(SID_DESC = (SID_DESC =
(GLOBAL_DBNAME = orcl.example.com)
(GLOBAL_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
（SID_NAME=orcl）
))
How should you configure an additional listener LISTENER2 that listens for the same SID?
A)?Add relevant details in SID_LIST_LISTENER under the existing LISTENER in?LISTENER.ORA
B)?Create another configuration file called LISTENER2.ORA with only LISTENER2 details in?it
C)?Add LISENER2 and its SID_LIST details separately under the name LISTENER2?in LISTENER.ORA
D)?Add relevant details in DESCRIPTION under the existing LISTENER with a different port number?in LISTENER.ORA.
Answer：C
?
?
141.?Examine this LISTENER.ORA?file.
LISTENER=
(DESCRIPTION_LIST= (DESCRIPTION=
(ADDRESS_LIST
(ADDRESS =(PROTOCOL= TCP)(HOST =srvl.example.com)(PORT=1522))
))) SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl.example.com)
(ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = orcl)
))
Which method can be used to configure an additional listener LISTENER2 that listens for the same service name?
A)?Add relevant details in DESCRIPTION under the existing LISTENER with a different port number?in
LISTENER.ORA.
B)?Create another file called LISTENER2.ORA with only LISTENER2 details using a?different port number than?LISTENER
C)?Create another file called LISTENER2.ORA with only LISTENER2 detaills using the same?port number used by?LISTENER
D)?Add LISTENER2 and its SID_LIST details with the same port number as LISTENER under?the name LISTENER2 in?LISTENER.ORA.
E)?Add LISTENER2 and its SID_LIST details with a different port number then LISTENER under?the name LISTENER2 in?LISTENER.ORA
Answer：E
四?十六.Patch
142.?Which two are true about the Enterprise Manager Patching?Wizard?
A)?It uses the opatch?utility.
B)?It applies only cumulative?patches.
C)?It applies patch releases only to the software residing in the Oracle home?directory.
D)?It can only download and stage a selected patch but not apply it?.
E)?IT invokes the patch Advisor to recommend patches for your system based only on feature?usage.
Answer: CE
四?十七.Trace
143.?Which two types of entries are contained in Oracle Database trace?files吟吝？
A)?application code bug related entries
B)?Database instance turning related?entries
C)?SQL statement turning related?entries
D)?Diagnostics related entries for server?process
E)?DDL action?logs
Answer：BD
四?十?八.Shrink
?
144.?USER1.EMP has a referential integrity constraint on?EMP.DNO?referencing?USER1.DEPT.DNO.?USER1 has a script containing these?commands
UPDATE dept SET loc='UK' where dno=1; UPDATE emp SET sal=1000 where eno=100; ALTER TABLE EMP shrink space;
What will be the outcome of running the script and why?
A)?It will fail because there is an uncommitted transaction on?USER1.DEPT.
B)?It will fail because a referential integrity constraint is defined on?USER1.EMP.
C)?It will execute?successfully.
D)?It will fail because there is an uncommitted transaction on?USER1.EMP.
Answer：C
四?十九.Constraint
?
145.?A?constraint?is?defined?as?INITIALLY?IMMEDIATE?but?is?DISABLED.?You?attempt to ENABLE?VALIDATE?the?constraint
Which two are true?
A)?DML is prevented while the constraint is being?enabled.
B)?The command does not validate existing?rows.
C)?The command fails if any table row violates the?constraint.
D)?The constraint is only enforced for rows inserted or updated after enabling the?constraint.
E)?Existing rows that violate the constraint are?permitted.
Answer：AC
