多选题For which two constraints does the Oracle Server implicitly create a unique index? ()ANOT NULLBPRIMARY KEYCFOREIGN KEYDCHECKEUNIQUE

多选题
For which two constraints does the Oracle Server implicitly create a unique index? ()
A

NOT NULL

B

PRIMARY KEY

C

FOREIGN KEY

D

CHECK

E

UNIQUE


参考解析

解析: 暂无解析

相关考题:

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 correctly describes the tiers of the Oracle Workflow architecture?() A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tier

ABC Corp. is installing 11i Oracle Applications on two nodes A and B. On Node A, it hasinstalled the Forms server, Web server, and Administration server. On Node B, it has installed theConcurrent Processing server.By default, on which node would the Reports server be installed?()A.Node AB.Node BC.neither of the nodesD.both Node A and Node B

What is the new Oracle Shared Server?()A、An improved version of multithreaded server configuration. B、A connection pooling configuration where several clients are connected to the same server process. C、Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. D、A configuration of Real Application Cluster where the client connection is routed to the least busy instance.

You are configuring for Oracle Shared Server. Which service is required? ()A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service

You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

Which statement correctly describes SQL and /SQL*Plus?()A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

Which two items does the Cisco CRS 4.5 Installer always install on the system?()A、Cisco Unified CallManager  B、Cisco Unified CallManager BARS Utility  C、Java plug-in  D、SQL 2K Server

Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()A、 If you select a non-XA JDBC driver, you can use WebLogic AQ JMS in both local  global transactionsB、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSC、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerD、 If you select an XA JDBC driver, you can use WebLogic AQ JMS in both local and global transactions

Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ?()A、 Oracle WebLogic ServerB、 Oracle CoherenceC、 Oracle DatabaseD、 Oracle Real Time Operations Control

Which component of the Oracle networking architecture provides character set and data type conversion between different character sets on the client and server? ()A、SQL*PlusB、Oracle NetC、Two-Task Common (TTC)D、Oracle Protocol Support (OPS)

How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()A、Dialogue box that implicitly determines report execution. B、Message line that implicitly determines report execution. C、Message line that suppresses the default oracle message. D、Dialogue box that does not terminate report execution. E、Dialogue box that suppresses the default oracle message.

Which two functional areas does Oracle Application Grid provide ?()A、 Processing CapacityB、 Programming IDEC、 Management networkD、 Storage Capacity

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 creating constraints are true?()A、Constraint names must start with SYS_CB、All constraints must be defines at the column level.C、Constraints can be created after the table is created.D、Constraints can be created at the same time the table is created.E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

Which two statements about creating constraints are true?()A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

单选题ABC Corp. is installing 11i Oracle Applications on two nodes A and B. On Node A, it hasinstalled the Forms server, Web server, and Administration server. On Node B, it has installed theConcurrent Processing server. By default, on which node would the Reports server be installed?()ANode ABNode BCneither of the nodesDboth Node A and Node B

多选题Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()AIf you select a non-XA JDBC driver, you can use WebLogic AQ JMS in both local  global transactionsBOracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSCOracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerDIf you select an XA JDBC driver, you can use WebLogic AQ JMS in both local and global transactions

单选题How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()ADialogue box that implicitly determines report execution. BMessage line that implicitly determines report execution. CMessage line that suppresses the default oracle message. DDialogue box that does not terminate report execution. EDialogue box that suppresses the default oracle message.

多选题For which two constraints does the Oracle Server implicitly create a unique index? ()ANOT NULLBPRIMARY KEYCFOREIGN KEYDCHECKEUNIQUE

多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? ()(Choose two.)AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

多选题Which two items does the Cisco CRS 4.5 Installer always install on the system?()ACisco Unified CallManagerBCisco Unified CallManager BARS UtilityCJava plug-inDSQL 2K Server

多选题Which two statements are true about the Websense redirect Web filter solution? ()(Choose two.)AThe Websense redirect Web filter solution does not require a license on the SRX device.BThe Websense server provides the SRX device with a category for the URL and the SRX device then matches the category decides to permit or deny the URL.CThe Websense server provides the SRX device with a decision as to whether the SRX device permits or denies the URL.DWhen the Websense server does not know the category of the URL, it sends a request back to the SRX device SurfControl server in the cloud.

多选题Which two statements about creating constraints are true?()AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view

多选题Which two statements are true about constraints? ()AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.DThe NOT NULL constraint ensures that null values are not permitted for the column.

单选题Which statement correctly describes SQL and /SQL*Plus?()ABoth SQL and /SQL*plus allow manipulation of values in the database.B/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

多选题Which two statements about creating constraints are true?()AConstraint names must start with SYS_CBAll constraints must be defines at the column level.CConstraints can be created after the table is created.DConstraints can be created at the same time the table is created.EInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view.

多选题A web browser can connect directly to an Oracle server using which two?()AHTTPBIIOPCTCP/IPDNamed PipesETCP/IP with SSL