本帖子已过去太久远了，不再提供回复功能。查看: 2738|回复: 2
求助几个问题，就几个选择题呀，急用，跪谢
论坛徽章:0
1. Examine the structure of the EMPLOYEES table:
& && &EMPLOYEE_ID NUMBER& & Primary Key
& && &FIRST_NAME VARCHAR2(25)
& && &LAST_NAME VARCHAR2(25)
&&Which three statements insert a row into the table?(Choose three)
& && && && &&&A.INSERT INTO employees
& && && &&&VALUES(NULL,'John','Smith');
& && && && &&&B.INSERT INTO employees(first_name ,last_name)
& && && && && & VALUES('John','Smith');
& && && && &&&C.INSERT INTO employees
& && && && && & VALUES('1000','John',NULL);
& && & D,INSERT INTO employees (first_name,last_name,employee_id)
& && && && && & VALUES(1000,'John','Smith');
& && && && &&&E.INSERT INTO employees(employee_id)
& && && && && & VALUES(1000);
& && && && &&&F.INSERT INTO employees(employee_id,first_name.last_namer)
& && && && && & VALUES(1000.'John','&&');
Which three statements are true regarding the logical structure of the Oracle
database?(Choose three)
& && && & A.Each segment contains one or more extents.
& && && & B.Multiple tablespaces can share single data file.
& && && & C.A data block is the smallest unit of I/O for data files
& && && & D,It is possible to have tablespaces of different block sizes in a database.
& && && & E.Each data block in the database always corresponds to one OS block
Evaluate the SQL staement:
ROUND(45.953,-1). TRUNC(45.936,2)
Which values are displayed?
A.46 and 45
B.46 and 45.93
C.50 and 45.93
D.50 and 45.9
E.45 and 45.93
F.45.95 and 45.93
4. Which are DML statements?(Choose all that apply.)
5.Evaluate the set of SQL
CREATE TABLE dept
(deptno NUMBER(2)
Dname VARCHAR2(14).
VARCHAR2(13));
DESCRIBE DEPT
What is true about the set?
The DESCRIBE DEPT statement displays the structure of the DEPT table
The ROLLBACK statement frees the storage space occupide by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043;object DEPT does not exist.
DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introuduce before the ROLLBACK statement
6.Evaluate this SQL statement
SELECT ename.sal.12*sal+100
The SAL column stores the monthly salary of the employee.Which change must be made to the above syntax to calculate the annual compensation as *monthly salary plus a monthly bonus of $100,multiplied by 12*?
No change a required to achieve the desired results.
SELECT ename.sal.12*(sal+100)
SELECT ename.sal.(12*sal)+100
SELECT ename.sal+100.*12
7.Evaluate this SQL statement
SELECT e.EMPLOYEE_ID,e.LAST_NAM,e.DEPARTMENT_ID,d.DEPARTMENT_NAME
FROM EMPLOYEES e.DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement,which capabillities of a SELECT statement are performed?
selection,projection,join
difference,projection,join
selection,intersection,join
intersection,projection,join
difference,projection,product
8.You need to nodify the STUDENTS table to add a primary key on the STUDENT_ID column.
The table is currently empty.Which statement accomplishes this task?
ALTER TABLE students
ADD PRIMARY KEY student_
ALTER TABLE students
ADD CONSTRAINT PRIMARY KEY (student_id);
ALTER TABLE students
ADD CONSTRAINT stud_id_pk PRIMATY KEY student_
ALTER TABLE students
ADD CONSTRAINT stud_id_pk PRIMATY KEY (student_id);
ALTER TABLE students
MODIFY CONSTRAINT stud_id_pk PRIMARY KEY(student_id);
9.Which three are DATETIME data types that can be used when specifying column definitions?(Choose three)
A.TIMESTAMP
B.INTERVAL MONTH TO DAY
C.INTERVAL DAY TO SECOND
D.INTERVAL YEAR TO MONTH
E.TIMESTAMP WITH DATABASE TIMEZONE
10.Evaluate the SQL statement
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement?(Choose three.)
It releases the storage space used by the table.
It does not release the storage space used by the table.
You can roll back the deletion of rows after the statement executes.
You can NOT roll back the deletion of rows after the statement executes.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
11.The EMP table co
EMPLOYEE_ID NUMBER(4)
VARCHAR2(25)
NUMBER(9,2)
You query the database with this SQL statement
SELECT empname,hire_date HIREDATE,salary
ORDER BY hire_
How will the results be sorted?
ascending by date
descending by date
ascending alphabetically
descending alphabetically
12. A subquery can be used to _____.
A.create groups of data
B.sort data in a specific order
C.convert data to a different format
D.retrieve data based on an unknown condition
13.Which three statements are true about the stages of database startup?(Choose three)
A.data files and redo log files can be renamed at the MOUNT stage.
B.Control files are read at the OPEN stage for the location of data files.
C.Control files are required to bring the database to the NOMOUNT stage.
D.data files and redo log files are made available to users at the OPEN stage.
E.Data files and online redo log files are checked for consistency while opening the database.
论坛徽章:0
Answer of Question 1 to 5 as following:
论坛徽章:0
谢谢啦，还有那个大哥大姐帮做下剩下的8个题，小弟在这里万分感谢了，
也祝愿各位端午节快了
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号}