A table can be created with or without data
With SQL, how do you select all the columns from a table named...
You can add and drop columns from a table using the ALTER TABLE...
A table can be created with or without data.
Which keyword is used to provide an alias to a column?
What does SQL stand for?
You can add and drop columns from a table using the ALTER TABLE...
With SQL, how do you select all the records from a table named...
Which of the following is a concatenation operator?
Which SQL keyword is used to sort the result-set?
Which keyword is used to provide an alias to a column?
Queries containing set operators are called ______ .
With SQL, how can you return the number of records in the...
Transaction control determines when data manipulation becomes...
What will be the result of the following SQL statement? (SYSDATE is a...
With SQL, how do you select a column named "FirstName" from...
Which of the following is a concatenation operator?
Transaction control determines when data manipulation becomes...
What is the most common type of join?
By default, the foreign key restricts deletes of any parent row has a...
Privileges, roles, and synonyms are all used to implement security in...
Which symbol do you use if you need to choose all the columns from the...
Which SQL statement is used to update data in a database?
Which SQL statement is used to insert new data in a database?
Queries containing set operators are called __________ .
The OR operator displays a record if ANY conditions listed are true....
Queries containing set operators are called __________ .
You can add to and drop columns from a table using the ALTER TABLE...
The NUMBER data types is usually the best choice for a primary key.
Which of the following is the correct order of keywords for SQL SELECT...
A table can be created with or without data
Privileges, roles, and synonyms are all used to implement security in...
Which operator is used to select values within a range?
Queries containing set operators are called __________ .
Which keyword is used to eliminate duplicate rows in the result?
The result of a SQL SELECT statement is a(n) ________ .
Which SQL statement is used to extract data from a database?
With SQL, how do you select all the records from a table named...
The TRUNCATE command removes all data permanently from a table.
By default, the foreign key restricts deletes of any parent row has a...
Which command is used to view the structure of the table LOCATIONS?
What will be the result of the following query?SELECT ROUND (63.548,...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
Queries containing set operators are called ______ .
The TRUNCATE command removes all data permanently from a table.
What will be the result of the following query?SELECT ROUND (63.548,...
Which of the following are the five built-in functions provided by...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
Which command is used to view the structure of the table LOCATIONS?
The data dictionary view USER_TAB_PRIVS_MADE lists details of table...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
With SQL, how can you return all the records from a table named...
What will be the result of the following SQL statement? (SYSDATE is a...
By default, the foreign key restricts deletes of any parent row that...
Which command is used to view the structure of the table LOCATIONS?
The ______ constraint defines a condition that each row must satisfy.
To remove duplicate rows from the results of an SQL SELECT statement,...
With SQL, how do you select all the records from a table named...
Which SQL statement is used to return only different values?
With SQL, how can you insert a new record into the "Persons"...
With SQL, how can you insert "Olsen" as the...
Which operator is used to search for a specified pattern in a column?\
A SELECT statement that is embedded in a clause of another SELECT...
DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock...
Use the _____ operator to return all rows from multiple tables and...
Consider the following SQL statement. What will be the result? SELECT...
The NOT NULL constraint enforces a column to not accept null values
Use the _______ operator to return all rows from multiple tables and...
Both object and system privileges can be granted through a single role...
Which of the following is the original purpose of SQL?
Transaction control determines when data manipulates becomes permanent...
The ______ constraint defines a condition that each row must satisfy.
You can rename a table with the RENAME or the ALTER TABLE command.
When using LIKE condition which symbol is used to denote one...
You can update only a single column at time in a table.
You can place the subquery in a number of SQL clauses, including the...
Queries that return only one row from the inner SELECT statement are...
Which symbol is used to create a substitution variable
With SQL, how do you select all the records from a table named...
What will be the result of the following SQL statement?SELECT...
You can update only a single column at a time in a table.
Constraints always have a name.
Write SQL statement for display the names of the employees who are...
Use the _____ operator to return all rows from multiple tables and...
When executed, this statement cannot be rolled back
What will be the result of the following SQL statement? (SYSDATE is a...
Which of the following statements is NOT true?
When using LIKE conditions which symbol is used to denote zero or many...
When using LIKE condition which symbol is used to denote one...
Consider the EMPLOYEES table. Which of the following conditions in the...
A parent table referenced by a child table may not be dropped.
It is possible to combine from two tables that do not have a primary...
What will be the result of the following SQL statement?SELECT SUBSTR...
You can add a row using SQL in database with which of the following?
A subquery must be enclosed in _________ .
The command to eliminate a table from a database is:
Any user can grant or revoke ant type of system privileges to or from...
Consider the EMPLOYEES table. Which of the following SQL statements is...
Consider the EMPLOYEES table. When condition in the WHERE clause limit...
Delete the zip codes 02199 and 43011 from the ZIPCODE table. Make the...
You cannot drop a user if objects exist in the user's schema.
You cannot drop a user if objects exist in the user's schema.
Consider the EMPLOYEES table. Which condition in the WHERE clause...
The UNION and UNION ALL set operator have the opposite effect...
You can nor selectively delete rows a table.
Consider the EMPLOYEES table. Which of the following SQL statements is...
If there are schemas named USERA and USERB, and both have an EMPLOYEES...
Which SQL statement is used to create a table in a database?
Consider the EMPLOYEES table. Which of the following conditions in the...
You can nor selectively delete rows a table.
Which is right of the following clauses?
The subquery generally executes ______ , and its output is used to...
Any user can grant or revoke any type of system privilege to or from...
Comparison conditions fall into two classes:
Consider the SQL statement. Which of the following clauses does not...
Which of the following functions is not single-row function?
How can you change "Hansen" into "Nilsen" in the...
Queries that return more than one row from the inner SELECT statement...
Write SQL statement for increase salary of all managers by 10%
The data of a temporary table is visible to all session.
To obtain a last names thet student and instructors share, you use the...
Which of the following functions joins two strings together?
The command to remove rows from a table 'CUSTOMER' is:
The data of a temporary table is visible to all session.
What will be the result of the following SQL statement?SELECT...
Which SQL statement is used to create a database?
Consider the EMPLOYEES table. Which of the following statements...
When inserting data into a table form another table, the table names...
The ____ operator compares a value to EACH value returned by a...
______ clause can be used and is required in the subquery to perform...
Which of the following functions finds the numeric position of a named...
Consider the SQL statement. Which of the following clauses does not...
Consider the EMPLOYEES table. Which of the following statements count...
The ____ operator returns all rows that are selected by either query
Consider the EMPLOYEES table. Which condition in the WHERE clause...
The ______ operator compares a value to every value returned by...
You cannot order the results of a set operation.
The SQL WHERE clause:
The wildcard in a WHERE clause is useful when?
Which of the following clauses is used to limit the rows that are...
You can not order the results of a set operation
A DISTINCT must always be user in the top-most SELECT statement of a...
Write SQL statement for display the department numbers with more than...
Which of the following SQL statements will generate an error?
The TRANCATE command and the TRUNC function can be used...
Which of the following statements about aliases is NOT true?
Consider the EMPLOYEES table. Which of the following displays the...
Which statement discards all pending data changes
Which of the following statements about aliases is NOT true?
The condition INSERT FIRST command evaluates the WHEN condition in...