When altering a table, you can decrease the width of a column if …(Choose 3)

The decrease in column width is not less than the existing values in that column

The column contains only null values

The column contains numeric values

What does the following statement do: ALTER TABLE DEPT_TEST ADD CONSTRAINT unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME);

It alters the DEPT_TEST table to add a composite unique key comprising of the DEPT_ID and DEPARTMENT_NAME.

It alters the DEPT_TEST table to add a the DEPT_ID and DEPARTMENT_NAME columns.

It alters the DEPT_TEST table to add a composite foreign key comprising of the DEPT_ID and DEPARTMENT_NAME.

It alters the DEPT_TEST table to add a composite primary key comprising of the DEPT_ID and DEPARTMENT_NAME.

Which statements will execute successfully? (Choose 2)

SELECT employee_id, last_name, job_id, department_id, hire_date FROM employees ORDER BY 3;

SELECT first_name, last_name, first_name||last_name fullname FROM employees ORDER BY fullname;

SELECT first_name, last_name FROM employees ORDER BY employee_id DES;

SELECT employee_id, first_name, last_name FROM employees ORDER BY employee_id DESCEND;

Which statements are not true? (Choose 2)

You cannot sort query results by more than one column.

You cannot use a column alias in the ORDER BY clause.

You can sort by a column that is not in the SELECT list.

You can sort query results by specifying the numeric position of the column in the SELECT clause.

Which column alias will cause an error?

SELECT last_name AS Last Name FROM employees;

SELECT last_name "Last Name" FROM employees;

SELECT last_name AS lname FROM employees;

SELECT last_name lname FROM employees;

Which of the following statements is syntactically correct?

Both statements are syntactically correct.

SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id) AND e.manager_id = 149;

SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id) WHERE e.manager_id = 149;

Neither statement is syntactically correct.

Why will the following statement result in an error? SELECT l.city, d.department_name FROM locations l JOIN departments d USING (location_id) WHERE d.location_id = 1400;

The field in the USING clause cannot have a qualifier.

There is nothing wrong - this will run correctly.

Syntax of the USING clause is incorrect.

WHERE clause cannot be used in a query with USING.

Which of the following will delete all employees who work in the Sales department?

DELETE FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales');

DELETE (SELECT department_id FROM departments WHERE department_name = 'Sales') FROM employees;

DELETE FROM employees WHERE department_id = SELECT department_id FROM departments WHERE department_name = 'Sales';

DELETE FROM employees e, departments d WHERE e.department_id = d.department_id AND department_name = 'Sales';

What are the characteristics of a PL/SQL stored subprogram? (Choose two.)

Do not exist after they are executed

What will be displayed when the following code is executed? DECLARE x VARCHAR2(6) := 'Chang'; BEGIN DECLARE x VARCHAR2(12) := 'Susan'; BEGIN x := x || x; END; DBMS_OUTPUT.PUT_LINE(x); END;

The code will fail with an error

The following anonymous block of code is run: BEGIN INSERT INTO countries (id, name) VALUES ('XA', 'Xanadu'); INSERT INTO countries (id, name) VALUES ('NV','Neverland'); COMMIT; COMMIT; ROLLBACK; END; What happens when the block of code finishes?

You have the two new rows added.

You get an error; you cannot COMMIT twice in a row.

You have nothing new; the last ROLLBACK undid the INSERTs.

You have the rows added twice; there are four new rows.

Which of the following use an implicit cursor?

DML statements and SELECT statements which return a single row.

COMMIT and ROLLBACK statements only.

A variable is declared as: DECLARE v_holdit employees.last_name%TYPE; BEGIN ... Which of the following is a correct use of the INTO clause?

SELECT last_name INTO v_holdit FROM employees WHERE employee_id=100;

SELECT last_name INTO v_holdit FROM employees;

SELECT * INTO v_holdit FROM employees;

SELECT salary INTO v_holdit FROM employees WHERE employee_id=100;

What is wrong with the following trivial IF statement: IF (v_job='President') THEN v_salary := 10000;

IF and THEN must be on the same line: IF (v_job='President') THEN ...

The condition should be coded: IF (v_job := 'President')

Which one of the following explicit cursor declarations is NOT valid?

CURSOR country_curs IS SELECT country_name INTO v_country_name FROM wf_countries;

CURSOR country_curs IS SELECT country_name FROM wf_countries ORDER BY population DESC;

CURSOR country_curs IS SELECT country_name FROM wf_countries WHERE region_id IN (SELECT region_id FROM wf_world_regions WHERE LOWER(region_name) LIKE '%asia%');

CURSOR country_curs IS SELECT country_name, region_name FROM wf_countries c, wf_world_regions r WHERE c.region_id = r.region_id;

Which of these exceptions can be handled by an EXCEPTION section in a PL/SQL block?

An attempt is made to divide by zero

A SELECT statement returns no rows

Any other kind of exception that can occur within the block

The following code fragment shows a cursor FOR loop: FOR emp_record IN emp_cursor LOOP ...... Which of the following do NOT need to be coded explicitly? (Choose three.)

FETCH emp_cursor INTO emp_record;

DECLARE CURSOR emp_cursor IS ...

must return one and only one value.

must have at least one IN parameter.

cannot be called in a SQL statement.

is called as a standalone executable statement.

What is wrong with the following code? CREATE FUNCTION annual_comp (sal employees.salary%TYPE, comm_pct IN employees.commission%TYPE) RETURN NUMBER(5,2) IS BEGIN RETURN (sal*12) + NVL(comm_pct,0)*12*sal; END annual_comp;

The RETURN NUMBER has a scale and precision.

The END; statement should not include the function name.

The sal parameter should specify the IN keyword.

There should be parentheses () around the expression: NVL(comm_pct,0)*12*sal

Which of the following are characteristics of PL/SQL subprograms but not of anonymous PL/SQL blocks? (Choose three.)

Can begin with the keyword DECLARE

Are compiled every time they are executed

Which of the following can NOT be used as the datatype of a procedure parameter?

A non-SQL datatype such as BOOLEAN

A large object datatype such as CLOB

A PLSQL record defined using %ROWTYPE

What is wrong with the following code? CREATE OR REPLACE TRIGGER emp_dml_trigg BEFORE UPDATE OF salary ON employees FOR EACH ROW DECLARE v_max_sal employees.salary%TYPE; BEGIN SELECT max(sal) INTO v_max_sal FROM employees; END;

The trigger body is reading the same table (employees) that the triggering event is updating.

You cannot use a DECLARE statement in a trigger.

Nothing is wrong, the trigger will execute correctly.

You must use RAISE_APPLICATION_ERROR in a BEFORE trigger.

You can never use SELECT inside a DML trigger.

PBD_Q_2

Authored by Pantjawati Sudarmaningtyas

Computers

University

Used 17+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which software is used to manage reading and manipulating a relational database?

Flat file software

ERD software

Spreadsheet software

DBMS software

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a relationship type?

Some to None

One to One

One to Many

Many to Many

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The advantages of an object-oriented data model are:

Reduced Maintenance

Real-World Modeling

Reduced Maintenance and Real-World Modeling

Neither statement is correct.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The customer and order tables are often used in joins, thereby resulting in complex queries. To simplify the writing of queries, you must create:

Table

View

Synonym

Sequence

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Schema objects can be created and manipulated with SQL and include the following types of objects, except:

Constraints

Sequences

Tables

Views

Roles

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Functions of SQL are:

Inserting, updating, and deleting rows in a table

Querying data stored in the database

Both of the options are functions of SQL

Neither of the options are functions of SQL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the wildcard used for any number of characters in SQL?

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Technical Quiz 2022-23

Quiz

•

University

50 questions

Application Software Quiz

Quiz

•

12th Grade - University

45 questions

อจ.ฉี

Quiz

•

University

46 questions

98-366 Lesson 3 Wired and Wireless Networks

Quiz

•

10th Grade - University

50 questions

XIRPL2_PASQUIZZ

Quiz

•

1st Grade - Professio...

53 questions

Electronics #2: Operational Amplifier & Power Amplifier

Quiz

•

University

50 questions

IP Address

Quiz

•

University

50 questions

Grade 10 Computer Systems Quiz

Quiz

•

10th Grade - University

Popular Resources on Wayground

10 questions

HCS SCI 03 Summer School Review 4

Quiz

•

3rd Grade

11 questions

HSMS - Standard Response Protocol

Quiz

•

6th - 8th Grade

16 questions

1.1-1.2 Quiz Review

Quiz

•

9th - 12th Grade

12 questions

Exponent Expressions

Quiz

•

6th Grade

20 questions

Adding and Subtracting Integers

Quiz

•

6th - 7th Grade

11 questions

Northeast States

Quiz

•

3rd - 4th Grade

10 questions

Characterization

Quiz

•

3rd - 7th Grade

10 questions

Common Denominators

Quiz

•

5th Grade

PBD_Q_2

Which software is used to manage reading and manipulating a relational database?

Which of the following is NOT a relationship type?

The advantages of an object-oriented data model are:

The customer and order tables are often used in joins, thereby resulting in complex queries. To simplify the writing of queries, you must create:

Schema objects can be created and manipulated with SQL and include the following types of objects, except:

Functions of SQL are:

Which of the following is the wildcard used for any number of characters in SQL?

The ______ operator requires either of the component conditions to be true.

Character strings and dates in the WHERE clause must be enclosed with single quotation marks (' ').

A foreign key value must match an existing primary key value otherwise, it must be null.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground