26.Which is the valid CREATE TABLE statement?
来源:互联网 发布:阿里云幕布拍照要求 编辑:程序博客网 时间:2024/06/10 09:35
26.Which is the valid CREATE TABLE statement?
A.CREATE TABLE emp9$# (emp_no NUMBER (4));
B.CREATE TABLE 9emp$# (emp_no NUMBER(4));
C.CREATE TABLE emp*123 (emp_no NUMBER(4));
D.CREATE TABLE emp9$# (emp_no NUMBER(4),date DATE);
答案:A
解析:
B:不能以数字开头
C:不能有*
D:date 是sql保留字
命名规则
2:名字必须字母开头
3:在第一个字母之后,可以使用 $ _ #这三个特殊字符
4.不区分大小写
注:如果加上双引号那么除了第一条外,其他都可以不遵守
A.CREATE TABLE emp9$# (emp_no NUMBER (4));
B.CREATE TABLE 9emp$# (emp_no NUMBER(4));
C.CREATE TABLE emp*123 (emp_no NUMBER(4));
D.CREATE TABLE emp9$# (emp_no NUMBER(4),date DATE);
答案:A
解析:
B:不能以数字开头
C:不能有*
D:date 是sql保留字
命名规则
1:长度不能超过30个字符
SQL> desc user_tab_columns;Name Type Nullable Default Comments -------------------- ------------- -------- ------- -------------------------------------------------------------------- TABLE_NAME VARCHAR2(30) Table, view or cluster name COLUMN_NAME VARCHAR2(30) Column name这里表和列都是30
2:名字必须字母开头
3:在第一个字母之后,可以使用 $ _ #这三个特殊字符
4.不区分大小写
注:如果加上双引号那么除了第一条外,其他都可以不遵守
0 0
- 26.Which is the valid CREATE TABLE statement?
- 32.Which CREATE TABLE statement is valid?
- 166.View the Exhibit and examine the setting for a table. Which statement is true about the PCTFR
- Sybase数据库提示The 'CREATE TABLE' command is not allowed within a multi-statement
- 47 You want to use RMAN to create compressed backups. Which statement is true about the compression
- 9.Which statement is true regarding the INTERSECT operator?
- 98.Which statement is true regarding the COALESCE function?
- 152.Which statement is true regarding the UNION operator?
- JDBC(Statement)--Create Table
- SQl Create Table has error=>is not valid...
- 31.Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enable
- Which SQL statement is the trump card to the senior software developer
- 68.Which statement is true regarding the default behavior of the ORDER BY clause?
- 45.Which statement is true about the Manageability Monitor (MMON) background process?
- 67.The instance abnormally terminates because of a power outage. Which statement is true about redo
- 97.Which statement is true about loading data using the conventional path of SQL*Loader?
- 1Z0-051 9.Which statement is true regarding the INTERSECT operator?
- 53 Which statement about using RMAN stored scripts is true? A. To create and execute an RMA
- Uncaught SyntaxError: Unexpected token < view1
- Redis学习笔记~Redis提供的五种数据结构
- 7个经典小故事给在职场困倦的你打打气
- 5. URN schema validation
- field 'int android.view.View.mViewFlags' on a null object reference
- 26.Which is the valid CREATE TABLE statement?
- 跳转到应用市场代码片段
- Qt学习笔记(QAction,QString格式化输出)
- 自定义View执行invalidate()方法
- 最最简单又实用的ftp安装以及使用
- [java web]java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
- Canvas 的绘制图表的基本用法
- Django知识点总结(四)
- iOS调试lldb命令