Which two are true regarding external tables? ()

A . External tables can be updated.  B . External tables are read-only tables.  C . Indexes can be created on external tables.  D . Indexes cannot be created on external tables.

时间:2022-10-08 07:54:40 所属题库:1Z0-032题库

相似题目

  • Which two statements about SCSI are true? ()

    A .  The bus is limited to 32 devices B .  It is a full duplex serial standard C .  It is a half-duplex serial standard D .  It allows up to 320 MB/s of shared channel bandwidth

  • Which two about WAR files are true?()

    A . WAR files must be located in the web application library directory. B . WAR files must contain the web application deployment descriptor. C . WAR files must be created by using archive tools designed specifically for that purpose. D . The web container must serve the content of any META-INF directory located in a WAR file. E . The web container must allow access to resources in JARs in the web application library directory.

  • Which two statements about subqueries are true? ()

    A . A single row subquery can retrieve data from only one table. B . A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause. C . A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause. D . A single row subquery can retrieve data from more than one table. E . A single row subquery cannot be used in a condition where the LIKE operator is used for comparison. F . A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

  • 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 two statements about WRED are true? ()

    A . WRED can selectively discard lower priority traffic when the interface becomes congested and can provide differentiated performance characteristics for different classes of service. B . Resource Reservation Protocol (RSVP) and WRED cannot be configured on the same interface. C . WRED will throttle back voice traffic only as a last resort. D . If the average queue length is greater than the minimum threshold but less than the maximum threshold, then based on the drop probability, WRED will either queue the packet or perform a random drop. E . WRED statistically drops more packets from low-bandwidth users than high-bandwidth users. Therefore, traffic sources that generate the least traffic are more likely to be slowed down than traffic sources that generate the most traffic. F .  WRED treats non-IP traffic as precedence 4.

  • Which two are true about authentication?()

    A . Form-based logins should NOT be used with HTTPS. B . When using Basic Authentication the target server is NOT authenticated. C . J2EE compliant web containers are NOT required to support the HTTPS protocol. D . Web containers are required to support unauthenticated access to unprotected web resources.

  • Which two statements are true about alerts()

    A . Clearing an alert sends the alert to the alert history. B . Response actions cannot be specified with server-generated alerts. C . The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view. D . Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.

  • Which two statements are true about checkpointing()

    A . The checkpoint frequency decreases with the smaller redo log file size. B . It ensures that all committed data is written to the data files during normal shutdown. C . The frequent full checkpoint in a database can cause the overall degradation of the database performance. D . It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

  • 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 about constraints? ()

    A . The UNIQUE constraint does not permit a null value for the column. B . A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C . The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D . The NOT NULL constraint ensures that null values are not permitted for the column.

  • Which two statements about sequences are true? ()

    A . You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value. B . You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. C . You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. D . You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column. E . If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence. F . You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

  • Which two statements are true?()

    A . It is possible for more than two threads to deadlock at once. B . The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state. C . Deadlocked threads release once their sleep() method’s sleep duration has expired. D . Deadlocking can occur only when the wait(), notify(), and notifyAll() methods are used incorrectly. E . It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly. F . If a piece of code is capable of deadlocking, you cannot eliminate the possibility ofdeadlocking by insertinginvocations of Thread.yield().

  • Which two WLAN implementation statements are true?()

    A . An autonomous wireless solution includes lightweight APs and WLAN controllers. The APs and the WLAN controllers are managed by a WLAN solution engine (WLSE/WLSM). B . An autonomous wireless solution includes lightweight APs and WLAN controllers. The APs and the WLAN controllers are managed by the Cisco Wireless Control System (WCS). C . A lightweight wireless solution includes lightweight APs and WLAN controllers. The APs and the WLAN controllers are managed by a WLAN solution engine (WLSE/WLSM). D . A lightweight wireless solution consists of autonomous access points (APs), which are managed by a WLAN solution engine (WLSE/WLSM). E . A lightweight wireless solution includes lightweight APs and WLAN controllers. The APs and the WLAN controllers are managed by the Cisco Wireless Control System (WCS).

  • Which two are true about aggregate functions?()

    A . You can use aggregate functions in any clause of a SELECT statement. B . You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement. C . You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. D . You can pass column names, expressions, constants, or functions as parameter to an aggregate function. E . You can use aggregate functions on a table, only by grouping the whole table as one single group. F . You cannot group the rows of a table by more than one column while using aggregate functions.

  • Which two wireless security statements are true?()

    A . A TACACS+ server is required to implement 802.1x. B . MIC protects against man-in-the-middle and replay attacks. C . The 802.1x standard provides encryption services for wireless clients. D . The AES (symmetric block cipher) is specified in the IEEE 802.11i specification. E . The IEEE 802.11i specification uses RC4 as its encryption mechanism. F . WPA requires TKIP and AES as encryption methods.

  • 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 two characteristics are true of IVRs? ()

    A . They are known as fabric routing. B . They cannot span multiple switches. C . Their connectivity is supported by Layer 2. D . They enable devices in different VSAN fabrics to communicate. E . They require that multiple switch fabrics be merged before they can function.

  • Which two multicast protocol statements are true? (Choose two.)  ()

    A .  Dense mode multicast requires explicit join messages from their members. B .  Dense mode multicast uses a push model to flood traffic throughout the network and then prunes the  unwanted traffic. C .  Sparse mode multicast uses a pull model to send multicast traffic to where it is requested.   D .  Sparse mode uses reverse path forwarding (RPF) to prune off redundant flows. E .  The primary use of sparse mode multicast is for test labs and router performance testing.

  • Which two are true?()

    A .  An encapsulated, public class promotes re-use. B .  Classes that share the same interface are always tightly encapsulated. C .  An encapsulated class allows subclasses to overload methods, but does NOT allow overriding methods. D .  An encapsulated class allows a programmer to change an implementation without affecting outside code.

  • Which two statemets are true?()

    A . DPT/RPR uses a bi-directional ring consisting of two symmetric counter rotating fibre rings. B . DPT/RPR is defined in the IEEE 802.17 standard and it uses Token Bucket system to avoid collisions on the fiber. C . In DPT/RPR rings, data packets can be sent in one direction (downstream) and the corresponding control packets in the opposite direction (upstream),thus using both fibres concurrently to maximise bandwidth. D . DPT/RPR can be deployed in the Core of the SP networks where point-to-point POS links are used tomake best use of the Bandwidth.

  • Which two statements are true?()

    A . It is possible for more than two threads to deadlock at once. B . The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state. C . Deadlocked threads release once their sleep() method's sleep duration has expired. D . Deadlocking can occur only when the wait(), notify(), and notifyAll() methods are used incorrectly. E . It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly. F . If a piece of code is capable of deadlocking, you cannot eliminate the possibility of deadlocking by inserting invocations of Thread.yield().

  • Which two are true?()

    A . A finalizer may NOT be invoked explicitly. B . The finalize method declared in class Object takes no action. C . super.finalize()is called implicitly by any over riding finalize method. D . The finalize method for a given objec twill be called no more than once by the garbage collector. E . The order in which finalize will be called on two objects is based on the order in which the two objects became finalizable.

  • Which two of statements are true?()

    A . It is possible to synchronize static methods. B . When a thread has yielded as a result of yield(), it releases its locks. C . When a thread is sleeping as a result of sleep(), it releases its locks. D . The Object.wait() method can be invoked only from a synchronized context. E . The Thread.sleep() method can be invoked only from a synchronized context. F . When the thread scheduler receives a notify() request, and notifies a thread, that thread immediately releases its lock.