更多"You need to create a table named OR"的相关试题:
[单项选择] You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）
A. CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
B. CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
C. CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
D. CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
E. CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
F. CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
[多项选择] You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
A. Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D. Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E. Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
[单项选择]You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
A. ALTER TABLE students ADD PRIMARY KEY student_id;
B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
[多项选择] You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
A. Each extra column in the copy with more columns must not have a default value
B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C. The slave database cannot have more columns than the master. Only the master database can have more columns
D. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
[单项选择] You have a server named Server1. You install Windows Server Update Services (WSUS) 3.0 on Server1. You configure Server1 to download all updates from Microsoft Update. Two weeks later, you notice that Server1 has not downloaded all updates. You need to ensure that Server1 downloads all updates. What should you do? （）
A. From the command prompt, run WSUSUTIL /Reset.
B. From the command prompt, run wuauclt.exe /detectnow.
C. From IIS Manager, right-click WSUSPOOL, and then click Recycle.
D. From the Update Services console, configure Server1 to use SSL when it synchronizes update information.
[单项选择]You just purchased a refurbished router that contains a configuration from a previous deployment. What should you do, before entering a new configuration into the router?（）
A. RAM should be erased and the router restarted.
B. Flash should be erased and the router restarted.
C. NVRAM should be erased and the router restarted.
D. The new configuration should be entered and saved.
[单项选择]Which is the telephone number you need when you intend to book a double room at Ramada Inn
A. 1-800-667-8868 or (250) 374-4788.
B. 1-800-575-7322 or (250) 851-0111.
C. 1-800-726-3626 or (250) 374-1218.
D. 14100-663-2832 or (260) 374-0358.
[单项选择] Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation
[单项选择] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure.
D. You get an error because the statement is not syntactically correct.
[单项选择] You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）
A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.
