-
Which statements are true regarding classless routing protocols?()
A . The use of discontiguous subnets is not allowed
B . The use of variable length subnet masks is permitted
C . RIP v1 is a classless routing protocol
D . IGRP supports classless routing within the same autonomous system
E . RIP v2 supports classless routing
-
Which statement is true regarding the COALESCE function?()
A . It can have a maximum of five expressions in a list
B . It returns the highest NOT NULL value in the list for all rows
C . It requires that all expressions in the list must be of the same data type
D . It requires that at least one of the expressions in the list must have a NOT NULL value
-
Which two statements are true regarding views?()
A . A subquery that defines a view cannot include the GROUP BY clause
B . A view that is created with the subquery having the DISTINCT keyword can be updated
C . A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D . A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
-
Which statements are correct regarding indexes? ()
A . When a table is dropped, the corresponding indexes are automatically dropped.
B . For each DML operation performed, the corresponding indexes are automatically updated.
C . Indexes should be created on columns that are frequently referenced as part of an expression.
D . A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
-
Which statements are true regarding ISDN channels?()
A . Each B channel can transmit up to 64 kbps
B . The ISDN B channel carries voice or data
C . The ISDN D channel transmits control information.
D . The D channel transmission rate varies depending on the service used.
E . HDLC or PPP can be used to encapsulate D channel information.
-
Which statement is true regarding subqueries?()
A . The LIKE operator cannot be used with single-row subqueries
B . The NOT IN operator is equivalent to IS NULL with single-row subqueries
C . =ANY and =ALL operators have the same functionality in multiple-row subqueries
D . The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries&e
-
Which two statements are correct regarding Flex Links? ()
A . An interface can belong to multiple Flex Links.
B . Flex Links operate only over single pairs of links.
C . Flex Link pairs must be of the same interface type
D . Flex Links automatically disable STP so no BPDUs are propagated
E . Failover from active to standby on Flex Links takes less than a second
-
Which two statements are true regarding hot patching?()
A . It requires relinking of the Oracle binary.
B . It does not require database instance shutdown.
C . It can detect conflicts between two online patches.
D . It is available for installing all patches on all platforms.
E . It works only in a single database instance environment.
-
Which statement is true regarding virtual private catalogs?()
A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B . The virtual private catalog owner cannot create and modify the stored scripts.
C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database
-
Which three statements are true regarding subqueries?()
A . Subqueries can contain GROUP BY and ORDER BY clauses
B . Main query and subquery can get data from different tables
C . Main query and subquery must get data from the same tables
D . Subqueries can contain ORDER BY but not the GROUP BY clause
E . Only one column or expression can be compared between the main query and subquery
F . Multiple columns or expressions can be compared between the main query and subquery
-
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&e
-
Which statements are true regarding listeners()
A . Listeners use only the TCP/IP protocol.
B . Multiple listener processes can run simultaneously on a host.
C . Multiple database instances can be registered with a single listener.
D . The listener-related errors can be traced only at the administrative level.
E . Only one database instance can be registered with a single listener at any time
-
Which statement is true regarding virtual private catalogs? ()
A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B . The virtual private catalog owner cannot create and modify the stored scripts.
C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.&e
-
Which two statements are true regarding listeners()
A . Listeners use only the TCP/IP protocol.
B . Multiple listener processes can run simultaneously on a host.
C . Multiple database instances can be registered with a single listener.
D . The listener-related errors can be traced only at the administrative level.
E . Only one database instance can be registered with a single listener at any time.
-
Which two statements are true regarding undo tablespaces()
A . The database can have more than one undo tablespace.
B . The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C . Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
D . An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
-
Which statement is true regarding RMAN components?()
A . Each target database requires its own recover catalog.
B . RMAN scripts can be stored in the recovery catalog or the target control file.
C . A channel is a stream of data to a device type and corresponds to one server session.
D . The RMAN executable interprets sever session commands and establishes connections to the target database.
-
Which two statements are true regarding EIGRP?()
A . Passive routes are in the process of being calculated by DUAL.
B . EIGRP supports VLSM,route summarization,and routing update authentication.
C . EIGRP exchanges full routing table information with neighboring routers with every update.
D . If the feasible successor has a higher advertised distance than the successor route,it becomes theprimary route.
E . A query process is used to discover a replacement for a failed route if a feasible successor is not identified from the current routing information.
-
Which statement is true regarding Flashback Version Query? ()
A . It returns versions of rows only within a transaction.
B . It can be used in subqueries contained only in a SELECT statement.
C . It will return an error if the undo retention time is less than the lower bound time or SCN specified.
D . It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
-
Which two statements are true regarding subqueries? ()
A . A subquery can retrieve zero or more rows
B . Only two subqueries can be placed atone level
C . A subquery can be used only in SQL query statements
D . A subquery can appear on either side of a comparison operator
E . There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement&e
-
Which statement is true regarding synonyms?()
A . Synonyms can be created only for a table
B . Synonyms are used to reference only those tables that are owned by another user
C . A public synonym and a private synonym can exist with the same name for the same table
D . The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
-
Which statements are true regarding table compression?()
A . It saves disk space and reduces memory usage.
B . It saves disk space but has no effect on memory usage.
C . It incurs extra CPU overhead during DML as well as direct loading operations.
D . It incurs extra CPU overhead during DML but not direct loading operations.
E . It requires uncompress operation during I/O.
-
Which statement is true regarding this setting?()
A . It drops the connection after the specified number of login attempts fail for any user.
B . It is enforced only if the password profile is enabled for the user.
C . It locks the user account after the specified number of attempts.
D . It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
-
Which two statements are true regarding EIGRP?()
A . Passiveroutes are in the process of being calculated by DUAL.
B . EIGRP supports VLSM, route summarization, and routing update authentication.
C . EIGRP exchanges full routing table information with neighboring routers with every update.
D . If the feasible successor has a higher advertised distance than the successor route, it becomes the primary route.
E . A query process is used to discover a replacement for a failed route if a feasible successor is not identified from the current routing information.
-
Which statements are true regarding SecureFile LOBs?()
A . The amount of undo retained is user controlled.
B . SecureFile LOBs can be used only for nonpartitioned tables.
C . Fragmentation is minimized by using variable-sized chunks dynamically.
D . SecureFile encryption allows for random reads and writes of the encrypted data.
E . It automatically detects duplicate LOB data and conserves space by storing only one copy.