多选题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-Z

题目
多选题
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
解析: 暂无解析
更多“多选题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-Z”相关问题
  • 第1题:

    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

  • 第2题:

    下面哪个选项可以表示文件abCD.ef()。

    • A、a[a-z][A-F]?.*
    • B、*.e?
    • C、*[A-Z].ef
    • D、[a-zA-Z0-9].*

    正确答案:A,B,C

  • 第3题:

    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

  • 第4题:

    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

  • 第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题:

    单选题
    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
    解析: 暂无解析

  • 第11题:

    判断题
    递增递减运算符还支持纯字母(a-z和A-Z)字符的递增递减运算。
    A

    B


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

  • 第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 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

  • 第14题:

    数字卫星接收机修改节目参数时,对节目名称的修改只支持A-Z,a-z,0-9和空格共63个字符。()


    正确答案:正确

  • 第15题:

    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

  • 第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题:

    递增递减运算符还支持纯字母(a-z和A-Z)字符的递增递减运算。


    正确答案:错误

  • 第20题:

    多选题
    下面哪个选项可以表示文件abCD.ef()。
    A

    a[a-z][A-F]?.*

    B

    *.e?

    C

    *[A-Z].ef

    D

    [a-zA-Z0-9].*


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

  • 第21题:

    多选题
    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
    解析: 暂无解析

  • 第22题:

    多选题
    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
    解析: 暂无解析

  • 第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
    解析: 暂无解析