Which four are correct guidelines for naming database tables

题目
多选题
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.

参考答案和解析
正确答案: F,D
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

A frame with two,or sometimes four,arms through which are threaded the guidelines and which is used to keep the drill stem and bit in line with the center opening in the temporary guide base is the ______.

A.drill stem guide

B.guide frame

C.drill string frame

D.casing guide


正确答案:B

第2题:

Which two are correct steps in taking a binary backup of MyISAM tables?()

  • A、Always stop the server prior to the backup
  • B、Stop the server or lock the tables prior to the backup
  • C、Stop the server or lock the databases prior to the backup
  • D、Make a copy of the .frm, .myd, and the .myi files
  • E、Make a copy of the binary log and tablespace files

正确答案:B,D

第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 is the correct command to put the database in ARCHIVELOG mode?()  

  • A、 alter database archivelog
  • B、 alter system enable archivelog mode
  • C、 alter database enable archive
  • D、 alter database archivelog enable
  • E、 None of the above

正确答案:A

第5题:

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?()  

  • A、 backup database
  • B、 backup database and archivelogs
  • C、 backup database plus archivelogs
  • D、 backup database plus archivelog delete input
  • E、 backup database and archivelog delete input

正确答案:D

第6题:

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

第7题:

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()

  • A、 Enable Flashback Data Archive for the tables.
  • B、 Specify undo retention guarantee for the database.
  • C、 Enable supplemental logging for the database.
  • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
  • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

正确答案:A

第8题:

You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?()

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored.

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking


参考答案:D, E

第9题:

The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file.  Which naming method was configured?()

  • A、host naming method
  • B、local naming method
  • C、directory naming method
  • D、external naming method

正确答案:A

第10题:

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform?()

  • A、Move tempdb onto a faster disk volume.
  • B、Increase the initial size of tempdb to 1.5 GB
  • C、Increase the size of the data files in the Tracking database.
  • D、Decrease the file growth increment for tempdb to 25 MB
  • E、Use more local temporary tables and fewer global temporary tables in the Tracking database.

正确答案:A,B

更多相关问题