You can join a maximum of two tables through an equijoin.
You can join a maximum of two columns through an equijoin.
You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
第1题:
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.
You want to minimize changes to your security model and to your database applications. How should you modify the database?
A.Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.
B.Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.
C.Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.
D.Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
第2题:
What is true about joining tables through an equijoin?()
第3题:
Which two are true about aggregate functions? ()
第4题:
What is necessary for your query on an existing view to execute successfully? ()
第5题:
What is true about updates through a view? ()
第6题:
Which two statements are true regarding the usage of the SQL*Loader utility()
第7题:
Which two statements are true regarding the Oracle Data Pump export and import operations()
第8题:
You have two computers named Computer1 and Computer2 that run Windows 7. You need to ensure thatyou can remotely execute commands on Computer2 from Computer1. What should you do?()
第9题:
Run Winrm quickconfig on Computer1.
Run Winrm quickconfig on Computer2.
Enable Windows Remote Management (WinRM) through Windows Firewall on Computer1.
Enable Windows Remote Management (WinRM) through Windows Firewall on Computer2.
第10题:
You want to create a nonequijoin.
The tables to be joined have multiple NULL columns.
The tables to be joined have columns of the same name and different data types.
The tables to be joined have columns with the same name and compatible data types.
You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
第11题:
The tables being joined have NOT NULL columns.
The tables being joined have only matched data.
The columns being joined have NULL values.
The tables being joined have only unmatched data.
The tables being joined have both matched and unmatched data.
Only when the tables have a primary key-foreign key relationship.
第12题:
You can join a maximum of two tables through an equijoin.
You can join a maximum of two columns through an equijoin.
You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
第13题:
Which two statements are true regarding the USING clause in table joins?()
第14题:
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()
第15题:
Which two statements are true regarding the ORDER BY clause? ()
第16题:
What are two reasons to create synonyms? ()
第17题:
Which two statements about views are true?()
第18题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第19题:
In which two cases would you use an outer join? ()
第20题:
It can be used to join a maximum of three tables
It can be used to restrict the number of columns used in a NATURAL join
It can be used to access data from tables through equijoins as well as nonequijoins
It can be used to join tables that have columns with the same name and compatible data types
第21题:
Both USING and ON clauses can be used for equijoins and nonequijoins
Amaximum of one pair of columns can be joined between two tables using the ON clause
The ON clause can be used to join tables on columns that have different names but compatible data types
The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
第22题:
You cannot update a view with group functions.
When you update a view group functions are automatically computed.
When you update a view only the constraints on the underlying table will be in effect.
When you update a view the constraints on the views always override the constraints on the underlying tables.
第23题:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第24题: