网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three statements are true regarding the logical structure of the Oracle database？（）
A
Each segment contains one or more extents.
B
Multiple tablespaces can share single data file.
C
A data block is the smallest unit of I/O for data files.
D
It is possible to have tablespaces of different block sizes in a database.
E
Each data block in the database always corresponds to one OS block.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three statements are true regarding the logical structure of the Oracle database？（）AEach segment contains one or more extents.BMultiple tablespaces can share single data file.CA data block is the smallest unit of I/O for data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one OS block.” 相关考题
考题
Which two statements are true about hierarchical architecture? ()(Choose two.)
A. You can assign a logical interface to multiple zones.B. You cannot assign a logical interface to multiple zones.C. You can assign a logical interface to multiple routing instances.D. You cannot assign a logical interface to multiple routing instances.
考题
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
考题
Which tow statements are most correct regarding opt-in models?（）A、A based opt-in model uses virtualized identifiersB、A based opt-in model uses hardware values as identifiersC、A logical server opt-in model uses virtualized identifiersD、A logical server opt-in model uses hardware values as identifiers
考题
Which three statements about OSPF areas are true?（）A、Areas introduce a boundary on the link - state updates.B、Areas are logical definitions specific to any given router.C、All routers within an area have the exact link - state database.D、The calculation of the Dijkstra algorithm on a router is limited to changes within an area.E、The area designated router will always have a priority of 0.
考题
Which three statements about the secure domain router are true？（）A、The logical router can span across chassis.B、The fabric and system controller module are shared by all logical routers.C、Each logical router has a distinct fabric and system controller moduleD、The logical router can share a route processorE、The logical router cannot share a route processor
考题
Which of the following statements is true regarding the VERSIONS BETWEEN clause？（） A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
考题
Which statement is true regarding the INTERSECT operator?（）A、It ignores NULL values B、Reversing the order of the intersected tables alters the result C、The names of columns in all SELECT statements must be identical D、The number of columns and data types must be identical for all SELECT statements in the query
考题
Which of the following a true statements regarding the use of VLANs to segment anetwork? （）A、They increase the size of collision domainsB、They allow logical grouping of users by function.C、They can enhance network security.D、They increase the size of the broadcast domain while decreasing the number of collision domains.E、They increase the number of broadcast domains while decreasing the size of the broadcast domains.F、They simplify switch administration.
考题
Which two statements are true regarding L2TP? （）(Choose two.)A、Tunnels are initiated by the LACB、Tunnels are initiated by the LNSC、By default, subscriber authentication occurs on the LNSD、By default, subscriber authentication occurs on the LAC
考题
Which two statements are true regarding B-tree indexs（）A、The leaf blocks in the index are doubly linked.B、The leaf node stores a bitmap for each key value.C、The rows with NULL value in key columns also have entries in the index.D、The deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
考题
Which of the following statements are true regarding the Recycle Bin？（）A、 The Recycle Bin is a physical storage area for dropped objects.B、 The Recycle Bin is a logical container for dropped objects.C、 The Recycle Bin stores the results of a Flashback Drop operation.D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
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（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
Which three statements are true regarding the logical structure of the Oracle database？（）A、Each segment contains one or more extents.B、Multiple tablespaces can share single data file.C、A data block is the smallest unit of I/O for data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one OS block.
考题
多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte encoding sequence.EEuropean characters are represented on one or two bytes.
考题
多选题Which two statements are true about hierarchical architecture? （）(Choose two.)AYou can assign a logical interface to multiple zones.BYou cannot assign a logical interface to multiple zones.CYou can assign a logical interface to multiple routing instances.DYou cannot assign a logical interface to multiple routing instances.
考题
多选题Which three statements about the secure domain router are true？（）AThe logical router can span across chassis.BThe fabric and system controller module are shared by all logical routers.CEach logical router has a distinct fabric and system controller moduleDThe logical router can share a route processorEThe logical router cannot share a route processor
考题
多选题Which three statements about OSPF areas are true?（）AAreas introduce a boundary on the link - state updates.BAreas are logical definitions specific to any given router.CAll routers within an area have the exact link - state database.DThe calculation of the Dijkstra algorithm on a router is limited to changes within an area.EThe area designated router will always have a priority of 0.
考题
多选题Which three logical expressions evaluate to true？（）A（a = = c）B（d = = c）C（b = = d）D（a = = b）E（b = = c）F（d == 10.0）
考题
多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
多选题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（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
多选题Which two statements are true regarding B-tree indexs（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
考题
多选题Which three statements are true regarding the fine-grained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
考题
多选题Which tow statements are most correct regarding opt-in models?（）AA based opt-in model uses virtualized identifiersBA based opt-in model uses hardware values as identifiersCA logical server opt-in model uses virtualized identifiersDA logical server opt-in model uses hardware values as identifiers
考题
多选题Which three statements about subqueries are true? （）AAsinglerowsubquerycanretrieveonlyonecolumnandonerow.BAsinglerowsubquerycanretrieveonlyonerowbutmanycolumns.CAmultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.DAmultiplerowsubquerycanbecomparedusingthe；；；operator.EAsinglerowsubquerycanusetheINoperator.FAmultiplerowsubquerycanusethe；=；operator.
考题
单选题Which statement is true regarding the INTERSECT operator?（）A
It ignores NULL values B
Reversing the order of the intersected tables alters the result C
The names of columns in all SELECT statements must be identical D
The number of columns and data types must be identical for all SELECT statements in the query
考题
多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery
考题
多选题Which of the following a true statements regarding the use of VLANs to segment anetwork? （）AThey increase the size of collision domainsBThey allow logical grouping of users by function.CThey can enhance network security.DThey increase the size of the broadcast domain while decreasing the number of collision domains.EThey increase the number of broadcast domains while decreasing the size of the broadcast domains.FThey simplify switch administration.
热门标签
最新试卷
