Question 1

Which among the following will set an attribute of the table to a unique key of another table?

Accepted Answer

foreign key

Question 2

the insert statement inserts only one row at a time.

Accepted Answer

False

Question 3

Using figure 7.1, the SQL code: insert into salesman values(161, ‘Garry’, ‘Paris’, 0.8, 10200); , will insert the new record successfully.

Accepted Answer

True

Question 4

Using the syntax to insert a row below: INSERT INTO table [(column [, column...])] VALUES (value [, value...]); The statement values clause adds only one row at the time to a table.

Accepted Answer

True

Question 5

The SQL statement: insert into sample_table (sample_id) values (&sample_id)); , will update a new record in the table.

Accepted Answer

False

Question 6

Using figure 7.1, which among the following commands will you use to change the commission of the salesman?

Accepted Answer

update

Question 7

Using figure 7.1, this statement is going to delete all the contents of the table: delete from salesman;

Accepted Answer

True

Question 8

Using the syntax to insert a row below:INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the value part

Accepted Answer

it is the corresponding value of the column

Question 9

You can add multiple rows to a table using a single insert statement.

Accepted Answer

False

Question 10

Using figure 7.1, what is the SQL will change the city Paris to paris?

Accepted Answer

update salesman set city = ‘paris’ where city = ‘Paris’;

Question 11

Using figure 7.4 and given the statement: create view certain_employees as select * from employees where employee_id in (101,102,114,122,176,200,201); ,the SQL statement: select email from certain_employees

Accepted Answer

True(pt1)

Question 12

where commission_pct is null; will show the email of all employees with employee ids 101,102,114,122,200 and 201.

Accepted Answer

True(pt2)

Question 13

Read consistency ensures that, on the same data, Writers do not wait for readers.

Accepted Answer

True

Question 14

The select statement is used for queries on single or multiple tables.

Accepted Answer

True

Question 15

Transactions give you more flexibility and control when changing data, and they ensure data consistency in the event of user process failure or system failure.

Accepted Answer

True

Question 16

All readers, except the one who issued the change, see the database as it existed before the changes started; they view the undo segment’s “snapshot” of the data.

Accepted Answer

True

Question 17

Transactions consist of DML statements that constitute one consistent change to the data.

Accepted Answer

True

Question 18

What is the clause of the select statement where in it indicate categorization of result?

Accepted Answer

group by

Question 19

Before the changes are committed to the database, only the user who is modifying the data sees the database with the alterations.

Accepted Answer

True

Question 20

Read consistency is an automatic implementation. It keeps a partial copy of the database in the undo segments.

Accepted Answer

True

Question 21

To create a marker in the current transaction, use savepoint statement.

Accepted Answer

True

Question 22

The left outer join returns all records from the outer table and the matching records returned from the joined table.

Accepted Answer

True

Question 23

INNER JOIN clause is an alternative to WHERE clause, and is used to match primary and foreign keys.

Accepted Answer

True

Question 24

What is a join in which the joining condition is based on equality between values in the common columns; common columns appear redundantly in the result table?

Accepted Answer

equi-join

Question 25

What is a relational operation that causes two or more tables with a common domain to be combined into a single table or view.

Accepted Answer

JOIN

Question 26

If data is to be used many times, make a separate query and store it as a view for query efficiency.

Accepted Answer

True

Question 27

Keep optimizer statistics up-to-date to have a better query design.

Accepted Answer

True

Question 28

Use the tables above for this question.

What SQL statement are you going to write to show the number of people in a job_id that has 5 or more employees?

Accepted Answer

select count(job_id), job_id from cemployees where count(job_id) > 5 group by job_id having count(job_id) >5;

Question 29

Using figure 8.3, the SQL statement: select d.department_name,e.employee_id from departments d, cemployees e where d.department_id = e.department_id and e.commission_pct is not null order by e.EMPLOYEE_ID;

Accepted Answer

False(pt1)

Question 30

will show the department name and the employee ids of the employees that has a null commission percentage.

Accepted Answer

False
(pt2)

Question 31

What SQL statement will show the last name and the department name of Payan Kaufling?

Accepted Answer

SELECT C.Last_name, D.Department_name

FROM DEPARTMENTS D INNER JOIN CEMPLOYEES C

WHERE D.DEPARTMENT_ID = C.DEPARTMENT_ID AND

C.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';

Question 32

Fine tuning with group by and having clauses is needed in queries.

Accepted Answer

True

Question 33

If there is a role name Chefs, which among the code will let the role able to make tables?

Accepted Answer

GRANT CREATE TABLE TO CHEFS;

Question 34

An example of a data security is the use of username and password.

Accepted Answer

False

Question 35

Data security covers access and use of database objects and the actions that the users can perform on the objects.

Accepted Answer

True

Question 36

Which code will allow user A and B to make virtual tables?

Accepted Answer

GRANT CREATE VIEW TO A,B;

Question 37

What is a type of privilege that can perform a particular action within the database?

Accepted Answer

system privilege

Question 38

Data security covers the system operations that the users can perform.

Accepted Answer

False

Question 39

The DBA must create a role then the DBA can assign privileges to the role and assign the role to users.

Accepted Answer

True

Question 40

System security covers access and use of database objects and the actions that the users can perform on the objects.

Accepted Answer

False

Question 41

Users require object privileges to gain access to the database.

Accepted Answer

False

Question 42

An owner of a table can grant access to all users by using the PUBLIC keyword

Accepted Answer

True

Question 43

To remove a row from a table use the drop table statement.

Accepted Answer

False

Question 44

The SQL statement: insert into sample_table (sample_id) values (&sample_id)); , will insert a new record wherein the value of sample_id is &sample_id.

Accepted Answer

False

Question 45

Using figure 7.1, which among the SQL statement is going to change the salary to 19000 and commission to 0.15 of the salesman named Cambrault?

Accepted Answer

update salesman set salary = 19000, commission = 0.15 where sname = ‘Cambrault’;

Question 46

Using figure 7.1, what is the SQL code to insert a new record in the salesman table?

Accepted Answer

insert into salesman (salesman_id) values (6000);

Question 47

To remove a row from a table you can use the delete statement

Accepted Answer

True

Question 48

In SQL, which of the following is not a data Manipulation Language Commands?

Accepted Answer

Truncate

Question 49

Using figure 7.1, the SQL code: update salesman set commission = 0.25 where city = 5700; , will change all the commission of the city that is empty or null.

Accepted Answer

False

Question 50

Using figure 7.1, this statement is going to change the commission of Tucker to 0.4: update salesman set commission = 0.4 where sname = ‘Tucker’;

Accepted Answer

True

Question 51

What does these SQL statements do?

 

Delete from table1;

rollback;

Accepted Answer

Deletes the table and then discards all pending changes of the transaction.

Question 52

Read consistency ensures that, on the same data, readers do not wait for writers.

Accepted Answer

True

Question 53

In read consistency, changes made by one user do not conflict with the changes made by another user.

Accepted Answer

True

Question 54

Using figure 7.4 and given the statement: create view certain_employees as select * from employees where employee_id in (101,102,114,122,176,200,201);

Accepted Answer

False(pt1)

Question 55

,the SQL statement: select email from certain_employees where commission_pct is null; will show the email of all of the employee with an employee_id 176.

Accepted Answer

False(pt2)

Question 56

What is the clause of the select statement that sorts the result according to specified criteria?

Accepted Answer

order by

Question 57

The check option command in creating a view works only for updateable views.

Accepted Answer

True

Question 58

Using figure 7.2, what SQL statement will show the name of the salesman and city whose city has an ‘I’ letter in between, capital letter or not.

Accepted Answer

select sname, city from salesman where city like '%i%' or city like '%I%';

Question 59

Use SELECT * instead of identify the specific attributes in the SELECT clause for query efficiency.

Accepted Answer

False

Question 60

What is an equi-join in which one of the duplicate columns is eliminated in the result table?

Accepted Answer

natural join

Question 61

An __________ is a join in which the joining condition is based on equality between values in the common columns.

Accepted Answer

EQUI-JOIN

Question 62

Which among the following is false for a non-correlated subquery?

Accepted Answer

it executes once for each row of the outer query

Question 63

Which among the following is true for a non-correlated subquery?

Accepted Answer

it does not depend on the data from the outer query

Question 64

The common columns in joined tables are usually the primary key of the dominant table and the foreign key of the dependent table in 1:M relationships.

Accepted Answer

True

"Know" box contains:
Time elapsed:
Retries:

Info Man F4