Final exam

Final exam - Question 1 0 out of 15 points A PRIMARY KEY...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Question 1 0 out of 15 points A PRIMARY KEY constraint creates a _________ key for the table. __________ primary key can be created for the table Answer Selected Answer: Correct Answer: Question 2 0 out of 15 points A scalar sub-query is a sub-query that returns exactly ____________ column value from one row. __________ column sub- queries that are written to compare two or more columns, using a compound WHERE clause and logical operators, do not qualify as scalar sub queries. Answer Selected Answer: Correct Answer:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Question 3 0 out of 15 points A typical DBA user such as sys has the following typical privileges: _________ user _________ user ________ any table ________ any table ________ any table ________ any table. Answer Selected Answer: Correct Answer: Question 4 0 out of 15 points By executing the following code: Select LPAD(last_name, LENGTH(last_na me)+ (LEVEL*2)- 2, '_') As Org_chart from employees start with last_name = 'King' connect by prior employee_id = manager_id;
Background image of page 2
gives King ___ pad ( means underscore that stands for levels) and gives Kochar as 1 pad gives Davies ____ pads. Answer Selected Answer: Correct Answer: Question 5 0 out of 15 points Code: CREATE TABLE countries_2 ( country2_id CHAR(2) CONSTRAINT country1_id NOT NULL , country_name VARCHAR2(40) , region_id NUMBER , CONSTRAINT country2_pk PRIMARY KEY (country2_id) ); creates the ___________ column as PRIMARY KEY for the table
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
___________. Answer Selected Answer: Correct Answer: Question 6 0 out of 15 points Database privileges are the _________ to _______________ particular ____________ statements. Answer
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/17/2012 for the course CIS 276 taught by Professor Brown during the Winter '11 term at Strayer.

Page1 / 15

Final exam - Question 1 0 out of 15 points A PRIMARY KEY...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online