Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
InfoMan F4
| Question | Answer |
|---|---|
| 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? | update salesman set salary = 19000, commission = 0.15 where sname = ‘Cambrault’; |
| 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’; | True |
| A database transaction consists of DML statements that constitute one consistent change to the data. | True |
| Use SELECT * instead of identify the specific attributes in the SELECT clause for query efficiency. | False |
| select d.department_name,e.employee_id from departments d, cemployees e where d.department_id = e.department_id and e.commission_pct is null order by e.EMPLOYEE_ID; What does the statement do? Use the tables above for reference. | It will show the department name and the employee ids of the employees that has a null commission percentage. |
| A system privilege is the right to perform a particular action, or to perform an action on any schema objects of a particular type. | True |
| Which among the following commands will add a new record to the database? | INSERT INTO |
| Using figure 7.1, what is the SQL code to show the name of the salesman that has a salary greater than 10000 or less than 5000. | select sname from salesman where salary > 10000 or salary < 5000; |
| Which among the following code deletes all the contents of a table? | delete from sample_table; |
| A transaction consists of collection of data manipulation language statements that form a logical unit of work | True |
| ,the SQL statement: select email from certain_employees where commission_pct is null; will show the email of all employees with employee ids 101,102,114,122,200 and 201. | True |
| ,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. | False |
| Read consistency ensures that, on the same data, Writers wait for readers. \ | False |
| In figure 7.3, what SQL statement will show the unique region id of the countries table? | select region_id from countries group by region_id; |
| Read consistency ensures that, on the same data, readers wait for writers. | False |
| Instead of SELECT *, identify the specific attributes in the SELECT clause for query efficiency. | True |
| When we place a query inside another query, what is this called? | subquery |
| An __________ is a join in which the joining condition is based on equality between values in the common columns. Write in capital letters. | EQUI-JOIN |
| Roles are not typically created for a database application | False |
| Database administrators has a high-level system privileges for tasks such as creating a new user, removing users, removing tables and backing up tables. | True |
| Users require object privileges to gain access to the database. | False |
| Using the syntax to insert a row below:INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the value part | it is the corresponding value of the column |
| What does these SQL statements do? Delete from table1; rollback; | Deletes the table and then discards all pending changes of the transaction. |
| What is the clause of the select statement where in it indicates the conditions under which a row will be included in the result? | where |
| In read consistency, changes made by one user do not conflict with the changes made by another user. | True |
| What is a relational operation that causes two or more tables with a common domain to be combined into a single table or view. | JOIN |
| Don’t combine a query with itself like avoiding self-joins to have a better query design. | True |
| What SQL statement will show the last name and the department name of Payan Kaufling? | 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'; |
| What is a join in which rows that do not have matching values in common columns are nonetheless included in the result table | outer join |
| A privilege that is granted with the WITH GRANT OPTION clause can be passed on to other users and roles by the grantee | True |
| System security allocates disk space to users. | True |
| When updating values inside the table you can update the row one at the time. | True |
| Using figure 7.1, you are tasked to edit the name of the salesman Sully to Sally. The SQL statement to use is: UPDATE SALESMAN SET SALESMAN_ID = ‘Sally’ WHERE SNAME = ‘Sully’;. | False |
| Which symbol should be used to prompt for values? | & |
| In figure 7.1, which among the columns of the table will accepts a string with more than 15 characters? | sname |
| Using figure 7.1, this statement is going to delete all the contents of the table: delete all from salesman; | |
| The update statement modifies existing values in a table | True |
| 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. | False |
| You can add multiple rows to a table using a single insert statement. | False |
| What is the clause of the select statement that list the columns and expressions to be returned from the query? | select |
| In the rollback statement, it releases all locks of all affected rows. | True |
| Using figure 7.3, what SQL statement will show all the county names that starts with either A or E? | select country_name from countries where country_name like ‘E%’ or country_name like ‘A%’; |
| What is the clause of the select statement where in it indicates the conditions under which category will be included? | having |
| What is the clause of the select statement that sorts the result according to specified criteria? | order by |
| Read consistency ensures that, on the same data, readers do not wait for writers. | |
| What is the clause of the select statement where in it indicates the tables or views from which data will be obtained? | from |
| A database transaction consists of one DDL statement. | True |
| Read consistency ensures that, on the same data, Writers do not wait for readers. | True |
| Limit the number of subqueries and try to make everything done in a single query if possible for query efficiency. | |
| An ___________ join is a join that shows the rows that do not have matching values in common columns are nonetheless included in the result table. | OUTER |
| If data is to be used many times, make a separate query and store it as a view for query efficiency. | True |
| Fine tuning with group by and having clauses is needed in queries. | True |
| INNER JOIN clause is an alternative to WHERE clause, and is used to match primary and foreign keys. | True |
| What would be the output of the following code? select dept.department_name, e.employee_id from departments dept inner join cemployees e on dept.department_id = e.department_id and e.employee_id in (101,102);. Use figure 8.3 for this. | Department_name Employee_id Executive 101 Executive 102 |
| Using figure 8.2, what SQL statement will show the complete name of the employee and the date when the employee named Neena Kochhar resigned from the company? | select e.first_name, e.last_name, j.end_date from employees e, job_history j where e.first_name = ‘Neena’ and e.last_name=’Kochhar’; |
| Using figure 8.3 for this. Given the SQL statement below: select e.employee_id, m.last_name as ManagerName from cemployees e, cemployees m where e.manager_id = m.employee_id; What will the statement do? | The SQL statement will show the manager id and manager name of the employees. |
| The SQL statement: CREATE USER user IDENTIFIED BY password; , is statement that will create a user and assigns a password. | True |
| An object privilege provides the user the ability to perform a particular action on a specific schema object | True |
| Which among the following codes will create a user name Michelle_Admin with a password of MA_123 | Create user Michelle_Admin identified by MA_123; |
| What is a type of privilege that can perform a particular action within the database? | system privilege |
| Oracle server database security is unable give access to specific objects in the database. | False |
| Oracle server database security can confirm given and received privileges with Oracle data dictionary. | True |
| The database administrator (DBA) is a high-level user with the ability to create users and grant users access to the database and its objects. | True |
| Database security can be classified into two categories. They are object security and data security. | False |
| Object privileges granted with the WITH GRANT OPTION clause are revoked when the grantor’s privilege is revoked. | True |
| The SQL statement: insert into sample_table (sample_id) values (&sample_id)); , will update a new record in the table. | False |
| Using figure 7.1, which among the following commands will you use to change the commission of the salesman? | update |
| Which among the following will set an attribute of the table to a unique key? | primary key |
| Which among the following codes will add one row in a table | insert into SampleTable (sampleid, samplename) values (12345,’The name’); |
| adding new rows to a table is added one at a time. | True |
| Using figure 7.1, this statement is going to delete all the contents of the table: delete from salesman; | True |
| Which among the following will set an attribute of the table to a unique key of another table? | foreign key |
| The select statement is used for queries on single or multiple tables. | True |
| The read-consistent image is constructed from the committed data in the table and the old data that is being changed and is not yet committed from the undo segment. | |
| The Oracle server ensures data consistency based on transactions. | True |
| If the transaction is rolled back, the changes are undone, the original, older version of the data in the undo segment is written back to the table. | |
| Rollback to savepoint returns the transaction back to the marker. | True |
| 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. | True |
| In the commit statement, the previous state of data is restored. | False |
| Keep optimizer statistics up-to-date to have a better query design. | True |
| What is a join that includes all columns from each table in the join, and an instance for each row of each table. | Union Join |
| Which among the following is true for a correlated subquery | |
| 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. | True |
| Using figure 8.3, what SQL statement will show the department name and employee id of employee ids 101 and 102? | select dept.department_name, e.employee_id from departments dept inner join cemployees e on dept.department_id = e.department_id and e.employee_id in (101,102); |
| The DBA must create a role then the DBA can assign privileges to the role and assign the role to users. | True |
| Oracle server database security is unable control database access. | False |
| The SQL statement: CREATE USER user IDENTIFIED BY password; , is statement that will create a user and assigns a password after the user has been created. | False |
| Data security allocates disk space to users. | False |
| Data security covers access and use of database objects and the actions that the users can perform on the objects. | True |
| Users can also be given the privilege to grant additional privileges to other users or to roles, which are named groups of related privileges. | True |
| A privilege is the right to execute particular SQL statements. | True |
| Using figure 7.1, you are tasked to edit the name of the salesman Sully to Sally. The SQL statement to use is: UPDATE SALESMAN SET SNAME = ‘Sally’ WHERE SNAME = ‘Sully’;. | |
| Using the syntax to insert a row below:INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the table part? | |
| To remove a row from a table use the drop table statement. | False |
| The SQL statement: insert into sample_table (sample_id) values (&sample_id)); , will insert a new record wherein the value comes from the input of the user. | True |
| Using figure 7.1, this statement is going to change the commission of Tucker to 0.4: edit salesman set commission = 0.4 where sname = Tucker; | False |
| 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; | True |
| Using figure 7.1, what is the SQL code to insert a new record in the salesman table? | insert into salesman (salesman_id) values (6000); |
| When a DML statement is committed, the change made to the database becomes visible to anyone issuing a SELECT statement after the commit is done. The space occupied by the old data in the undo segment file is freed for reuse. | |
| 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 where commission_pct is null; will show the emai | False |
| Using figure 7.4, what SQL statement will show the first name, the last name, the email and the salary of the employee who has a salary between 7000 to 11000? It will also change the column name salary to AdvancedSalary. | select first_name, last_name, email,salary AdvancedSalary from employees where salary between 7000 and 11000; |
| Read consistency ensures that, on the same data, Writers wait for writers. | True |
| 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. | select sname, city from salesman where city like '%i%' or city like '%I%'; ? |
| Which among the SQL command that when executed all data changes are undone? | ROLLBACK |
| In the savepoint statement, all the locks of the affected rows are released. | |
| Understanding how indexes are used in query processing makes a better query design. | True |
| Which among the following is true for a non-correlated subquery? | it does not depend on the data from the outer query |
| An owner of a table can grant access to all users by using the PUBLIC keyword | |
| The DBA can then grant privileges to that user which determines what the user can do at the database level. | True |
| If there is a role name Chefs, which among the code will let the role able to make tables? | |
| Oracle server database security can control database access. | True |
| Which among the following is not considered a database transaction? | One data definition statement |
| To remove a row from a table you can use the delete statement | True |
| Using figure 7.1, the SQL code: insert into salesman values(161, ‘Garry’, ‘Paris’, 0.8, 10200); , will insert the new record successfully. | True |
| A database transaction consists of one DCL statement. | |
| When an insert, update, or delete operation is made on the database, the Oracle server takes a copy of the data before it is changed and writes it to an undo segment. | True |
| To create a marker in the current transaction, rollback is used. | False |
| Read consistency ensures that, on the same data, Writers do not wait for writers. | False |
| In the savepoint statement, all data changes are undone | False |
| Which among the following is false for a non-correlated subquery? | it does not depend on the data from the outer query |
| Using figure 8.1, what SQL statement will show the biggest salary of the salesman if grouped based on their salary. Show only the biggest salary that are more than 6500. Arrange the salary from biggest to smallest. | select max(salary) from salesman group by salary having max(salary)>6500 order by salary desc; |
| 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; will show the department name and the employee id | False |
| What is a kind of join that includes all columns from each table in the join, and an instance for each row of each table? | UNION JOIN |
| If data is to be used many times, create a synonym for query efficiency. | False |
| 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? | equi-join |
| A schema is owned by a database user and has the same name as that user. | True |
| Users require system privileges to gain access to the database. | True |
| If user A gave an administrative privilege to user B and user B gave also administrative privilege to user C, What will happen if user A revokes the privilege from user B? | |
| An example of a data security is the use of username and password. | |
| An example of a system security is the use of username and password. | True |
| If users have multiple roles granted to them, they receive all the privileges associated with all the roles. | True |
| Using the syntax to insert a row below: INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the column part? | it is the name of the column in the table to populated |
| Using figure 7.1, what SQL statement to increase the salary of Tucker and Olsen to 10% of their salary? | update salesman set salary = (salary * 1.10) where sname = ‘Tucker’ or sname = ‘Olsen’; |
| The check option command in creating a view works only for updateable views. | True |
| If the transaction is rolled back, the changes are undone, all users see the database as it existed before the transaction began. | True |
| A user can have access to several roles, and several users can be assigned the same role. | True |
| Oracle server database security can give access to specific objects in the database. | True |
| Users require object privileges to manipulate the contents of the objects in the database. | True |
| Given the SQL command: GRANT UPDATE (DEPTID, DEPTNAME) ON DEPARTMENTS TO CHEFS, COOKS; What will this SQL command do? | Grants privileges to update specific columns on table departments to roles. |
| Users require system privileges to manipulate the contents of the objects in the database. | False |
| Using figure 7.1, what is the SQL code to change the salesman name of the salesman to Kingster who has a name of King with an id of 156, regardless of the case of the name. | update salesman set sname = 'Kingster' where salesman_id = 156 and sname = ‘King’; (?) |
| Using the salesman table and given the SQL code: update salesman set city = ‘Manila’ where salesman_id = 152; , what does the statement do? | it changes the value of the city column assigned to Hall. (?) |
| the insert statement inserts only one row at a time. | True |
| Using figure 7.1, the SQL code: insert into salesman values(150, ‘Garry’, ‘Paris’, 0.8, 10200); , will insert the new record successfully. | False (?) |
| Transactions consist of DML statements that constitute one consistent change to the data. | True |
| 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. | True |
| Before the changes are committed to the database, only the user who is modifying the data sees the database with the alterations. | True (?) |
| What command to use when saving changes to the database that is irreversible? | COMMIT |
| Multiple subqueries in a select statement is better for query efficiency. | False (?) |
| The left outer join returns all records from the outer table and the matching records returned from the joined table. | True |
| What are collection of objects such as tables, views and sequences? | schemas |
| Oracle server database security cannot confirm given and received privileges with Oracle data dictionary. | False |
Created by:
pioneerxxXXxx