-
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? ()
A . SELECT COUNT (*) FROM employees WHERE last _name='smith';
B . SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
C . SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
D . SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
E . SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith'
-
Examine the description of the STUDENTS table:
https://assets.asklib.com/images/image2/2018080115032850512.jpg
Which two aggregate functions are valid on the START_DATE column?()
A . SUM(start_date)
B . AVG(start_date)
C . COUNT(start_date)
D . AVG(start_date, end_date)
E . MIN(start_date)
F . MAXIMUM(start_date)
-
Which of the following descriptions best identifies the operating principal of a flash-type evaporator?()
A . Sea water is heated to boiling temperature while under a vacuum
B . Sea water is passed over heated plates in a thin film
C . Heated sea water is injected into a vacuum chamber
D . Sea water is forced through a heated eductor
-
Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHARD2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column?()
A . SUM(start_date)
B . AVG(start_date)
C . COUNT(start_date)
D . AVG(start_date, end_date)
E . MIN(start_date)
F . MAXIMUM(start_date)
-
Examine the description of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080110341576486.jpg
Which statement produces the number of different departments that have employees with last name Smith?()
A . SELECT COUNT(*) FROM employees WHERE last_name='Smith';
B . SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
C . SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
D . SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
E . SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith'
-
What is the best description of serialization delay? ()
A . the time it takes for a Layer 3 switch or a router to switch a packet from an inbound interface to the queue of the outbound interface
B . the time it takes for a propagate from source to destination
C . the time it takes to place a frame on the physical medium for transport
D . the time a packet resides in the outbound queue of a router
-
Which three of the following descriptions are true about the firewall modes? ()
A . Transparent mode is layer 2.
B . Routed mode is layer 3.
C . Routed mode has 1 IP address.
D . Transparent mode has 1 IP address.
-
Examine the description of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080114592471196.jpg
Which statement shows the maximum salary paid in each job category of each department?()
A . SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);
B . SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;
C . SELECT dept_id, job_cat, MAX(salary) FROM employees;
D . SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
E . SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat, salary
-
Which three of the following descriptions are true about the firewall modes? ()
A . Transparent mode is layer 2.
B . Routed mode is layer 3.
C . Routed mode has 1 IP address.
D . Transparent mode has 1 IP address.
-
Please choose the right description about the language of two.
-
The part program contains a description of the _________.
-
Which one is not the description of medicine?
-
Which of the following is NOT included in the project descriptions of a proposal?
-
Which of the following statements are accurate descriptions of modern liability management?
-
Which of the following statements provides the best description of the marketing concept of positioning?
-
Which of the following is the right description about CRM?
-
What function does the description of the well play in Norwegian Forest?
-
The job description should state the tasks and responsibilities of the job position.
-
The description of Russians' love of memorizing poetry shows the author's ______.
A.interest in their language
B.appreciation of their efforts
C.admiration for their memory
D.contempt for their old-fashionedness
-
Which of the descriptions on “prepregs” is not true?()
A.A.A prepreg is the impregnated fiber reinforcement with a resin matrix.
B.B.The fiber reinforcement in a prepreg only exists in unidirectional forms
C.C.The fiber reinforcement in a prepreg can exist in unidirectional or fabric forms
D.D.The resins for a prepreg includes thermoset and thermoplastic resins
-
The author's description of Cro-Magnon paintings mentions which of the following?
A.Some are not very good.
B.It is unusual to see such paintings.
C.Many were drawn by children.
D.The artists were mostly right-hande
-
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' />
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' />
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
-
Which one is correct of the following descriptions about the transport mechanism of macromolecular substances()
A.Signal-regulated secretion requires the participation of clathrin, whereas continuous secretion is not required
B.The specificity of the transporter is regulated by clathrin and adaptin in the composition of the vesicles
C.Receptor-mediated transport needs protein or protein complex to associate with a specific receptor in the cell membrane
D.Insulin secretion is endocytosis
-
Examine the description of the STUDENTS table:STD_ID NUMBER(4)COURSE_ID VARCHAR2(10)START_DATE DATEEND_DATE DATEWhich two aggregate functions are valid on the START_DATE column? ()
A.SUM(start_date)
B.AVG(start_date)
C.COUNT(start_date)
D.AVG(start_date, end_date)
E.MIN(start_date)
F.MAXIMUM(start_date)