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
sa 2 info
| Question | Answer |
|---|---|
| Figure 5.1 Identify the parts of the SQL worksheet. What is number 5 on the figure 5. | Cancel |
| What is a data type that stores exact numbers with a predefined precision and scale of zero | numeric |
| In which year was the first available RDBMS system on DOS/VSE | 1981 |
| Figure 5.1 Identify the parts of the SQL worksheet. What is number 3 on the figure 5.1 | Commit |
| Figure 5.1 | 1. Execute statement 2. Run script 3. Commit 4. Rollback 5. Cancel 6. SQL History 7. Execute explain plan 8. Autotrace 9. Clear |
| To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button. | T |
| To execute a line of SQL statement, you can use either execute statement or run script provided it is only one SQL line. | T |
| The create command is one of the commands of data manipulation language. | F, DDL |
| Loading the database by inserting data, updating the database, and manipulating the database are parts of the implementation process during the database development process. | T |
| Some primary keys are composite keys. | T |
| What is a data type that has a base of 64 number system representing the unique address of a row in its table | ROW ID |
| Which among the following statements will create a table with two columns | CREATE TABLE STUDENT (Studentid numeric(4,2), studentfirstname varchar2(50)); |
| The syntax to create a table is CREATE TABLE [schema.]table (column datatype [DEFAULT expr] [column_constraint], ... [table_constraint][,...]);. | T |
| Constraints prevent the deletion of a table if there are dependencies | T |
| What is a statement that allows you to rename an existing column in an existing table in any schema | rename column |
| A table is a basic unit of storage which is composed of rows and columns | T |
| What data type has a variable length character data that is up to two GB | Long |
| Given the SQL statement: ALTER TABLE emp2 ADD CONSTRAINT emp_mgr_fk FOREIGN KEY(manager_id) REFERENCES emp2(employee_id);, the statement adds a new constraint to the table emp2 that sets the manager_id to foreign key of the emp2 table. | T |
| Productivity is one of the benefits of a standardized relational language. | T |
| What is the structure that contains descriptions of objects created by a user? | Schema |
| What is a database management system that manages data as a collection of tables in which all relationships are represented by a common values in related tables? | RDBMS |
| During the maintenance phase of the database development process the controlling of the database is found here, like grant add and revoked commands? | t |
| In 1988, ANSI first released the SQL standard. | f |
| Reduce dependence on single vendor is one of the benefits of a standardized relational language. | t |
| You can review the definitions of objects at a glance in the connections navigator of your SQL developer. | t |
| What is a foreign key constraint keyword the defines the column in the child table at table-constraint level? | foreign key |
| The table names and column names should have a duplicate name with other tables and other columns | f |
| What data type is a fixed length character data | car |
| In naming table names and column names,the name should not be an Oracle server reserved word. | t |
| What is a variable length numeric data kind of data type | num |
| When you drop a table from the database it moves the table to the recycle bin. | t |
| Defining constraint can be done at the column or at the table level | t |
| A user can name a constraint or Oracle server generates a name by using the SYS_CN format | t |
| Who is the person who developed the relational database concept? | Edgar F. Codd |
| Writing and executing SQL, PL/SQL an SQL *plus statements are done on notepad in SQL developer? T or F | F [SQL Worksheet] |
| In 1988, ANSI first released the SQL standard. T or F | F [1986] |
| What is a data type that stores exact numbers with a predefined precision and scale of zero | integer |
| The abbreviation of SQL is Structured Query Language. T or F | T |
| The rename and the update are both commands in data definition language. T or F | F |
| What is a database management system that manages data as a collection of tables in which all relationships are represented by a common values in related tables? | RDBMS |
| What is a data type the store's exact numbers with a defined precision and scale | numeric |
| Given the SQL statement: ALTER TABLE emp2 ADD CONSTRAINT emp_mgr_fk FOREIGN KEY(manager_id) REFERENCES emp2(employee_id);, the statement adds a new constraint to the table emp2 that sets the manager_id to foreign key of the emp2 table. T or F | T |
| You can define a constraint of the column level only | F |
| When you drop a table from the database it moves the table to the recycle bin. T or F | T |
| What data type has a variable length character data that is up to two GB | long |
| The drop table statement allows you to remove tables from your schema. T or F | T |
| You can view a constraint inside a table in the database | T |
| Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100), Valueid numeric(10), constraint sam_fk(valueid) references Value(valueid)); , which command sets an attribute to a foreign key? | references value |
| These enforces rules at the table level and prevents the deletion of a table if there are dependencies | REFERENCE |
| What data type is a fixed length character data | car [char] |
| Productivity is one of the benefits of a standardized relational language. T or F | T |
| One purpose why SQL was standardized was to define data structures and basic operations in SQL. T or F | T |
| To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button. | T |
| During the database development process the defining of the database is done in the physical design | T |
| IBM created the system R with sequel. | T |
| Which among the following statements will create a table with two columns | CREATE TABLE STUDENT (Studentid numeric(4,2), studentfirstname varchar2(50)); |
| What is a foreign key constraint keyword that deletes the dependent rows in the child table when a row in the parent table is deleted. | On delete cascade |
| What is the datatype that stores binary string values in hexadecimal format? | BLOB |
| What is the language that is standard for relational database management system | SQL |
| In 1986, ANSI first released the SQL standard. | t |
| Dependence on a single vendor is a benefit of a standardized relational language | f |
| Which of the following code will change the Sname column to not null in figure 6A and 6B? | alter table salesman modify sname varchar(30) not null; |
| Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100));, which command that makes an attribute not nullable | not null |
| Which of the following code will create the table salesman in figure 6A and 6B? | Create table salesman (salesman_id number(5) not null primary key, sname varchar2(30), city varchar2(15), commission number(5,2), salary number(11,2)); |
| What is a foreign key constraint keyword that converts dependent foreign key values to null. | On delete set null |
| What data type has a variable length character data | varchar2 |
| Given the SQL statement: Alter table sample1 drop column ID; , this statement deletes the table sample1. | false |
| Which of the following code will change the Sname column to not null in figure 6A and 6B? | alter table salesman modify sname varchar(30) not null; |
| What data type is a binary data stored in external file which is up to four GB | Bfile |
| What is a foreign key constraint keyword that converts dependent foreign key values to null. | On delete set null |
| In naming table names and column names,the name should not be an Oracle server reserved word. | T |
| What statement can you use to put the table into read mode which prevents DDL or DML changes during table maintenance? | Read only |
| What SQL statement will change the name of the column salesman_id to Sid? Use the figures 6A and 6B. | alter table salesman rename column salesman_id to SId; |
| 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 |
| A DML statement is executed when adding rows, modifying existing rows, and removing existing rows from a table. T or F | T |
| To remove a row from a table you can use the delete statement. T or F | T |
| 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; | F |
| 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 or F | T |
| Using figure 7.1, the SQL code: insert into salesman values(161, ‘Garry’, ‘Paris’, 0.8, 10200); , will insert the new record successfully. T or F | T |
| The SQL statement: insert into sample_table (sample_id) values (&sample_id)); , will update a new record in the table. T or F | F |
| 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’; |
| 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’;. | F [UPDATE SALESMAN SET SNAME = ‘Sally’ WHERE SNAME = ‘Sully’;] |
| Read consistency ensures that, on the same data, Writers wait for writers. | T |
| Read consistency guarantees a consistent view of the data at all times. | T |
| Read consistency ensures that, on the same data, Writers wait for readers. | F |
| Read consistency is an automatic implementation. It keeps a partial copy of the database in the undo segments. | T |
| 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%'; |
| 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. Group of answer choices True False | T |
| A database transaction consists of one DCL statement. | F |
| What is the clause of the select statement that list the columns and expressions to be returned from the query? | select |
| The union join returns all the records of the union | T |
| 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’; |
| 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 |
| 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 asc; |
| Which among the following is false for a non-correlated subquery? | it executes once for each row of the outer query |
| Instead of SELECT *, identify the specific attributes in the SELECT clause for query efficiency. | T |
| To create a marker in the current transaction, use savepoint stateme | T |
| The select command is one of the commands of data manipulation language. | T |
| In 1987, ANSI first released the SQL standard. | F |
| What is a foreign key constraint keyword that identifies the table and column in the parent table. | references |
| Naming table names and column names should not duplicate the name of another object owned by the same user. | T |
| What statement can you use to put the table back into a read or write mode from a read mode only table? | READ WRITE |
Created by:
user-1795747