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 7,8,9
| Question | Answer |
|---|---|
| When updating values inside the table you can update the row one at the time. | TRUE |
| A database transaction consists of one DCL statement. | TRUE |
| Oracle server database security is unable give access to specific objects in the database. | FALSE |
| Instead of SELECT *, identify the specific attributes in the SELECT clause for query efficiency. | TRUE |
| Data security allocates disk space to users. | FALSE |
| Users require system privileges to manipulate the contents of the objects in the database. Group of answer choices | TRUE |
| If data is to be used many times, create a synonym for query efficiency. | FALSE |
| 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. | FALSE |
| The SQL statement: CREATE USER user IDENTIFIED BY password; , is statement that will create a user and assigns a password. | TRUE |
| A user can have access to several roles, and several users can be assigned the same role. | TRUE |
| INNER JOIN clause is an alternative to WHERE clause, and is used to match primary and foreign keys. | TRUE |
| Which among the following is false for a non-correlated subquery? | It makes use of the data from the outer query |
| Instead of SELECT *, identify the specific attributes in the SELECT clause for query efficiency. | TRUE |
| Users require object privileges to gain access to the database. | 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 |
| 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 |
| Data security allocates disk space to users. | FALSE |
| Oracle server database security can control database access. | TRUE |
| Multiple subqueries in a select statement is better for query efficiency. | FALSE |
| 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 |
| 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 |
| Oracle server database security can give access to specific objects in the database. | TRUE |
| An owner of a table can grant access to all users by using the PUBLIC keyword | TRUE |
| 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 |
| 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; |
| Users require system privileges to gain access to the database. | TRUE |
| What is a type of privilege that can perform a particular action within the database? | System privilage |
| Keep optimizer statistics up-to-date to have a better query design. | TRUE |
| Data security covers access and use of the database at the system level. | FALSE |
| Before the changes are committed to the database, only the user who is modifying the data sees the database with the alterations. | TRUE |
| A view is based on a SELECT statement | TRUE |
| 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 |
| What does these SQL statements do? Delete from table1; rollback; | Deletes the table and then discards all pending changes of the transaction. |
| Using the syntax to insert a row below:INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the table part? | It is the name of the table |
| What is the clause of the select statement where in it indicates the conditions under which category will be included? | Having |
| Read consistency ensures that, on the same data, Writers do not wait for readers. | TRUE |
| Read consistency is an automatic implementation. It keeps a partial copy of the database in the undo segments. | TRUE |
| Which among the following will delete one row in a table? | DELETE FROM SampleTable WHERE columnId 1000; |
| If the transaction is rolled back, the changes are undone, all users see the database as it existed before the transaction began. | TRUE |
| What is the clause of the select statement where in it indicate categorization of result? | Group by |
| 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. | 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 |
| What is the clause of the select statement that sorts the result according to specified criteria? | Order by |
| Read consistency guarantees a consistent view of the data at all times. | TRUE |
| The Oracle server ensures data consistency based on transactions. | TRUE |
| System security allocates disk space to users. | TRUE |
| An object privilege provides the user the ability to perform a particular action on a specific schema object | TRUE |
| System security covers access and use of the database at the system level. | TRUE |
| An example of a system security is the use of username and password. | TRUE |
| These are SQL commands that maintain and query a database. | DML (Data Manipulation Language) |
| The update statement modifies existing values in a table | TRUE |
| Which command displays the structure of the table? | Describe |
| To remove a row from a table use the drop table statement. | FALSE |
| In SQL, which of the following is not a data Manipulation Language Commands? | Truncate |
| In the savepoint statement, all the locks of the affected rows are released. | FALSE |
| The select statement is used for queries on single or multiple tables. | TRUE |
| 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. |
| Which symbol should be used to prompt for values? | & |
| Database security can be classified into two categories. They are object security and data security. | TRUE |
| If users have multiple roles granted to them, they receive all the privileges associated with all the roles. | TRUE |
| A schema is owned by a database user and has the same name as that user. | TRUE |
| System security covers access and use of the database at the system level. | TRUE |
| An example of a system security is the use of username and password. | TRUE |
| What are collection of objects such as tables, views and sequences? | Schemas |
| The union join returns all the records of the union. | TRUE |
| If there is a role name Chefs, which among the code will let the role able to make tables? | GRANT CREATE TABLE TO CHEFS; |
| 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 |
| 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 |
| Understanding how indexes are used in query processing makes a better query design. | TRUE |
Created by:
user-1835460