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
fa4
| Question | Answer |
|---|---|
| Using figure 7.1, which among the following commands will you use to change the commission of the salesman? | update |
| adding new rows to a table is added one at a time. | f |
| 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’;. | t |
| Using figure 7.1, this statement is going to delete all the contents of the table: delete all from salesman; | f |
| Using figure 7.1, what is the SQL will change the city Paris to paris? | update salesman set city = ‘paris’ where city = ‘Paris’; |
| Which among the following will set an attribute of the table to a unique key? | pkey |
| 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 |
| 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. | t |
| To remove a row from a table you can use the delete statement | t |
| Which among the following is not considered a database transaction? | One data definition statement |
| The check option command in creating a view works only for updateable views. | t |
| 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. | t |
| A database transaction consists of one DDL statement. | t |
| Read consistency ensures that, on the same data, Writers wait for writers. | t |
| What does these SQL statements do? Delete from table1; rollback; | discard |
| What is the clause of the select statement where in it indicate categorization of result? | group |
| Read consistency ensures that, on the same data, Writers do not wait for writers. | f |
| In read consistency, changes made by one user do not conflict with the changes made by another user. | t |
| 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. | t |
| Read consistency ensures that, on the same data, Writers wait for readers. | f |
| 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; |
| What is a join in which rows that do not have matching values in common columns are nonetheless included in the result table | outer |
| What is a join that includes all columns from each table in the join, and an instance for each row of each table. | union |
| Limit the number of subqueries and try to make everything done in a single query if possible for query efficiency. | t |
| If data is to be used many times, create a synonym for query efficiency. | t |
| Which among the following is false for a non-correlated subquery? | it does not depend on the data from the outer query |
| 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 |
| Users require system privileges to gain access to the database. | t |
| Users require object privileges to manipulate the contents of the objects in the database. | f |
| system security allocates disk space to users. | t |
| A privilege is the right to execute particular SQL statements. | t |
| What is a type of privilege that can perform a particular action within the database? | system |
| The SQL statement: CREATE USER user IDENTIFIED BY password; , is statement that will create a user and assigns a password. | t |
| A schema is owned by a database user and has the same name as that user. | t |
| What is a type of privilege that can manipulate the contents of the database objects? | object privilege |
| An example of a system security is the use of username and password. | t |
| If users have multiple roles granted to them, they receive all the privileges associated with all the roles. | t |
| To remove a row from a table use the drop table statement. | f |
| 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 |
| These are SQL commands that maintain and query a database. | DML |
| Which symbol should be used to prompt for values? | & |
| 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’; |
| Which among the following codes will add one row in a table | insert into SampleTable (sampleid, samplename) values (12345,’The name’); |
| If the transaction is rolled back, the changes are undone, all users see the database as it existed before the transaction began. | t |
| Using figure 7.2, 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; |
| The previous state of data is restored when rollback statement is made. | t |
| Using figure 7.2, what SQL statement will show the city and the highest salary of the salesman when they are grouped based on their city. | select city, max(salary) from salesman group by city; |
| Read consistency ensures that, on the same data, readers wait for writers. | f |
| A database transaction consists of DML statements that constitute one consistent change to the data. | t |
| Read consistency guarantees a consistent view of the data at all times. | t |
| Understanding how indexes are used in query processing makes a better query design. | t |
| If data is to be used many times, make a separate query and store it as a view for query efficiency. | t |
| Which among the following is true for a correlated subquery | it does not depende on the data from the outer query |
| The left outer join returns all records from the outer table and the matching records returned from the joined table. | t |
| When we place a query inside another query, what is this called? | subquery |
| Use SELECT * instead of identify the specific attributes in the SELECT clause for query efficiency. | f |
| Multiple subqueries in a select statement is better for query efficiency. | f |
| 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. | f |
| 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. |
| Data security covers the system operations that the users can perform. | t |
| Which code will allow user A and B to make virtual tables? | GRANT CREATE VIEW TO A,B; |
| Users require system privileges to manipulate the contents of the objects in the database. | f |
| Oracle server database security can control database access. | t |
| A role is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges. | t |
| A system privilege is the right to perform a particular action, or to perform an action on any schema objects of a particular type. | t |
| It is a type of database security that covers access and use of the database at the system level. | system security |
| A user can have access to several roles, and several users can be assigned the same role. | t |
Created by:
user-1795747