多选题Which four are correct guidelines for naming database tables? ()AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-

题目
多选题
Which four are correct guidelines for naming database tables? ()
A

Must begin with either a number or a letter.

B

Must be 1-30 characters long.

C

Should not be an Oracle Server reserved word.

D

Must contain only A-Z, a-z, 0-+, _, *, and #.

E

Must contain only A-Z, a-z, 0-9, _, $, and #.

F

Must begin with a letter.


相似考题
更多“多选题Which four are correct guidelines for naming database tables? ()AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-”相关问题
  • 第1题:

    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

    正确答案:A,B,E

  • 第2题:

    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation, which of the following are true about the staging server?()

    • A、The database has a subset of the tables in the production server database.
    • B、The database has a copy of selected data from the production database
    • C、The database logs changes for later propagation.
    • D、The database is accessed as read-only to prevent data corruption.
    • E、The database includes all user and order data for offline processing.

    正确答案:B,C

  • 第3题:

    Which four are correct guidelines for naming database tables?()

    • A、Must begin with either a number or a letter.
    • B、Must be 1-30 characters long.
    • C、Should not be an Oracle Server reserved word.
    • D、Must contain only A-Z, a-z, 0-+, _, *, and #.
    • E、Must contain only A-Z, a-z, 0-9, _, $, and #.
    • F、Must begin with a letter.

    正确答案:B,C,E,F

  • 第4题:

    Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g?()  

    • A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
    • B、 The problem key is the same as the incident number.
    • C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
    • D、 Every problem has a problem key, which is a text string that describes the problem.
    • E、 The database makes an entry into the alert log file when problems and incidents occur.

    正确答案:C,D,E

  • 第5题:

    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()

    • A、The backup will consist of used data blocks only.
    • B、The database must be shut down to accomplish the backup.
    • C、The backup can be accomplished without shutting down the database.
    • D、The backup will contain all database files that have never been backed up.

    正确答案:B

  • 第6题:

    You are connecting to an Oracle database server from a client by using the following connect string:   SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb   Which naming method is being used in this case?()

    • A、Local Naming
    • B、Easy Connect
    • C、External Naming
    • D、Directory Naming

    正确答案:B

  • 第7题:

    You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()

    • A、Only host
    • B、Only local
    • C、Either host or local
    • D、Both host and local

    正确答案:A

  • 第8题:

    单选题
    What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()
    A

    It can contain parameters with distinct values for each distance.

    B

    It can contain only parameters with identical values for each instance.

    C

    It must contain an IFILE parameter for each instance’s individual parameter file.

    D

    It must be located in the default location for the primary instance’s parameter file.


    正确答案: C
    解析: 暂无解析

  • 第9题:

    多选题
    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation, which of the following are true about the staging server?()
    A

    The database has a subset of the tables in the production server database.

    B

    The database has a copy of selected data from the production database

    C

    The database logs changes for later propagation.

    D

    The database is accessed as read-only to prevent data corruption.

    E

    The database includes all user and order data for offline processing.


    正确答案: A,C
    解析: 暂无解析

  • 第10题:

    多选题
    Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?()
    A

    Database operations will be monitored only when they consume a significant amount of resource.

    B

    Database operations for all sessions will be monitored.

    C

    Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.

    D

    Only DML and DDL statements will be monitored for the session.

    E

    All subsequent statements in the session will be treated as one database operation and will be monitored.


    正确答案: C,D
    解析: 暂无解析

  • 第11题:

    多选题
    Choose the two correct statements regarding Oracle WebLogic Server()
    A

    a server instance can be associated with multiple machines

    B

    a machine can be associated with multiple server instance

    C

    a server instance can be associated with only a single machine

    D

    a machine can be associated with only one server instance


    正确答案: B,C
    解析: 暂无解析

  • 第12题:

    单选题
    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()
    A

    The backup will consist of used data blocks only.

    B

    The database must be shut down to accomplish the backup.

    C

    The backup can be accomplished without shutting down the database.

    D

    The backup will contain all database files that have never been backed up.


    正确答案: B
    解析: 暂无解析

  • 第13题:

    Which of these is a correct description of Stateful Switchover?()

    • A、 It will only become active after a software failure
    • B、 It will only become active after a hardware failure
    • C、 It requires that Cisco N3F· be enabled in order to work successfully
    • D、 It synchronizes the MAC·, FIB·, and adjacency tables between Active and Standby Route Processors

    正确答案:D

  • 第14题:

    Which two statements are correct about routing tables in JUNOS?()

    • A、There are separate tables for IPv4 and IPv6 called inet.0 and inet6.0 respectively.
    • B、They only contain the best possible route to each destination.
    • C、All running protocols can populate the routing tables at the same time.
    • D、Routes with the highest preference value are placed as active routes in the routing table.

    正确答案:A,C

  • 第15题:

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?()

    • A、The Oracle database will perform block checking for the index blocks only 
    • B、The Oracle database will not perform block checking for any of the data blocks 
    • C、The Oracle database will perform block checking for the default permanent tablespace only 
    • D、The Oracle database will perform block checking for the data blocks in all user tablespaces 
    • E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle

    正确答案:E

  • 第16题:

    What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()

    • A、It can contain parameters with distinct values for each distance.
    • B、It can contain only parameters with identical values for each instance.
    • C、It must contain an IFILE parameter for each instance’s individual parameter file.
    • D、It must be located in the default location for the primary instance’s parameter file.

    正确答案:A

  • 第17题:

    Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?()

    • A、Database operations will be monitored only when they consume a significant amount of resource.
    • B、Database operations for all sessions will be monitored.
    • C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
    • D、Only DML and DDL statements will be monitored for the session.
    • E、All subsequent statements in the session will be treated as one database operation and will be monitored.

    正确答案:C,E

  • 第18题:

    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()

    • A、One tablespace has only one datafile
    • B、Many tablespaces can share one datafile
    • C、One tablespace can have many datafiles
    • D、One datafile can contain many tablespaces

    正确答案:C

  • 第19题:

    单选题
    You have forgotten the root user account password. You decide to reset the password and execute the following: Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?()
    A

    –skip-networking, to prohibit access from remote locations

    B

    –reset-grant-tables, to start the server with only the mysql database accessible

    C

    –read-only,to set all data to read-only except for super users

    D

    –old-passwords, to start Mysql to use the old password format while running without the grant tables


    正确答案: D
    解析: 暂无解析

  • 第20题:

    多选题
    Which four of these statements are restrictions for Frame Relay PVC bundles with QoS support for IP and MPLS? ()
    A

    A PVC bundle will not come up unless all the precedence, DSCP, and EXP levels are configured in thebundle.

    B

    A PVC bundle can perform precedence and DSCP matching at the same time

    C

    A PVC bundle may contain no more than sixteen PVCs

    D

    A PVC can be in only one PVC bundle

    E

    A PVC bundle cannot perform precedence and DSCP matching at the same time.

    F

    A PVC bundle may contain no more than eight PVCs.


    正确答案: A,B
    解析: 暂无解析

  • 第21题:

    单选题
    What are the four steps, in their correct order, to mitigate a worm attack?()
    A

    contain,inoculate,quarantine,and treat

    B

    inoculate,contain,quarantine,and treat

    C

    quarantine,contain,inoculate,and treat

    D

    preparation,identification,traceback,and postmortem

    E

    preparation,classification,reaction,and treat

    F

    identification,inoculation,postmortem,and reaction


    正确答案: E
    解析: 暂无解析

  • 第22题:

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?()
    A

    The Oracle database will perform block checking for the index blocks only 

    B

    The Oracle database will not perform block checking for any of the data blocks 

    C

    The Oracle database will perform block checking for the default permanent tablespace only 

    D

    The Oracle database will perform block checking for the data blocks in all user tablespaces 

    E

    The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle


    正确答案: D
    解析: 暂无解析

  • 第23题:

    多选题
    Which two statements are correct about routing tables in JUNOS?()
    A

    There are separate tables for IPv4 and IPv6 called inet.0 and inet6.0 respectively.

    B

    They only contain the best possible route to each destination.

    C

    All running protocols can populate the routing tables at the same time.

    D

    Routes with the highest preference value are placed as active routes in the routing table.


    正确答案: D,A
    解析: 暂无解析

  • 第24题:

    多选题
    Which four are correct guidelines for naming database tables?()
    A

    Must begin with either a number or a letter.

    B

    Must be 1-30 characters long.

    C

    Should not be an Oracle Server reserved word.

    D

    Must contain only A-Z, a-z, 0-+, _, *, and #.

    E

    Must contain only A-Z, a-z, 0-9, _, $, and #.

    F

    Must begin with a letter.


    正确答案: D,B
    解析: 暂无解析