-
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 MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id)
-
You have a computer that runs Windows 7. The Encrypting File System (EFS) key is compromised. Youneed to create a new EFS key. Which command should you run?()
A . Certutil -getkey
B . Cipher.exe /k
C . Icacls.exe /r
D . Syskey.exe
-
Which of the following is a key advantage of AIX v5.3 over AIX v5.2?()
A . Dynamic LPAR
B . Micro-Partitioning
C . Small Memory Real Mode
D . Capacity Upgrade on demand for memory
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?()
A . UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
B . UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
C . UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
D . UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180
-
Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements aretrue regarding the above command()
A . The constraint remains valid.
B . The index on the constraint is dropped.
C . It allows the loading of data into the table using SQL *Loader.
D . New data conforms to the constraint, but existing data is not checked.
E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
-
What is a key characteristic of the Cisco Business Ready Teleworker solution which is different from traditional software-client based Teleworker solutions?()
A . all traffic is encrypted using IPSec and the Triple-DES algorithm
B . full support for all Enterprise applications, including data, voice, and video
C . thousands of Teleworker VPN tunnels can be aggregated to a headquarters location
D . the VPN tunnel is an always on site-to-site VPN connection
E . portability for use while traveling
F . used with broadband Cable/DSL subscriptio
-
A customer is debating whether to use Shared Ethernet versus Virtual Ethernet. Which of the following best describes a key difference between Shared and Virtual Ethernet?()
A . Shared Ethernet runs on POWER4 systems
B . Virtual Ethernet runs on POWER4 systems
C . Shared Ethernet requires a Virtual I/O server and Advanced Power Virtualization
D . Virtual Ethernet requires a Virtual I/O server and Advanced Power Virtualizatio
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? ()
A . UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B . UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C . UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D . UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180
-
Examine the command that is used to create a table: SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users; Which two statements are true about the effect of the above command) ()
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
-
The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116294948484.jpg
The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? ()
A . SELECT TOTAL(*) FROM customers;
B . SELECT COUNT(*) FROM customers;
C . SELECT TOTAL(customer_id) FROM customers;
D . SELECT COUNT(customer_id) FROM customers;
E . SELECT COUNT(customers) FROM customers;
F . SELECT TOTAL(customer_name) FROM customer
-
Examine the command that is used to create a table: SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users; Which two statements are true about the effect of the above command()
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
-
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? ()
A . INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
B . INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
C . INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
D . INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01')
-
Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER (6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2 (15)); Which statement is true regarding the PROD_ID_PK constraint?()
A . It would be created only if a unique index is manually created first.
B . It would be created and would use an automatically created unique index.
C . It would be created and would use an automatically created nonunique index.
D . It would be created and remains in a disabled state because no index is specified in the command.
-
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 _ 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)
-
Which one is not the key aspect of Chinese culture?( )
-
Which of the following enzymes can hydrolyze proteins?( )
-
Which of the following enzymes can hydrolyze proteins?( )
-
According to the author, which of the following is the key measure to revive Greece's economy?
A.To punish those who do not pay taxes.
B.To control the country's deficit.
C.To increase people's wages.
D.To cut people's spendin
-
When it comes to successful overseas investments that can yield high profits, the key is which country you should put your capital in
-
The simple circular-flow diagram is a model that includes only some key players in the real economy. Which of the following key players are omitted from the simple circular-flow model?
A.Households.
B.Firms.
C.Government.
D.MarketsforFactorsofProduction.
-
Uplink/downlink balancing is a key point in the network planning. Suppose there is a cell with the downlink coverage radius 8km and the uplink coverage radius 5km. Which of the following measures can be used in order to keep the uplink and downlink balanced? ()
A.Increase the transmitter power of BTS
B.Decrease the transmitter power of BTS
C.Use a tower amplifier for BTS
D.Use an antenna with a low gain
-
What is the marker enzyme of the mitochondrial membrane()
A.One of its characteristics is that the mitochondrial outer membrane contains cardiolipin
B.The enzyme system of tricarboxylic acid cycle is mainly distributed in the mitochondrial matrix
C.The mitochondrial granular is essentially an ATP synthase complex
D.Most of the mitochondria in human embryonic cells come from fertilized eggs
-
Which field selection key is used in combination with a document category in SAP Materials Management? Please choose the correct answer.()
A.Document type
B.Item category
C.Release status
D.Activity category